Show theme settings Shopping cart Download trialFree Trial
Verdana
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Lease vs Buy Calculator

H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Make & Model:
LEASE
BUY
Suggested retail price
$12,170
Suggested retail price
$12,170
Tax, title, etc.
$250
Tax, title, etc.
$250
Refundable security deposit
$150
First month's payment
$200
Capital cost reduction payment
$100
Down payment
$2,000
Last month payment in advance?
Yes
Payment (if yes)
$200
Selling price at end of lease
$7,500
Resale value
$7,500
Monthly lease payment
$225
Monthly loan payment
$2,059
Lease term
5
Term of loan
5
Chevrolet Spark
Lease vs. Buy Car
Discount for present value
5.00%
Loan rate
5.00%
Future value of last payment
$204
Present value of resale
$7,346
Initial costs
$900
Initial costs
$2,250
Financing costs
$891
Financing costs
$10,170
Present value of refund
($147)
Present value of total costs
$1,644
Present value of total costs
$5,074
DIFFERENCE
$3,431
Note: Positive value favors leasing.
TAXATION
Tax bracket
25.00%
Business use percentage
6.50%
Sales tax percentage
9.50%
TAXATION
LEASE
TAXATION
BUY
Title
$150
Title
$150
Fees
$150
Fees
$150
Sales tax
$1,156
Sales tax
$1,156
Potential financing deduction
$1,125
Interest deduction
$127
Total potential deductions
$2,581
Total potential deductions
$1,584
Potential tax savings
$126
Potential tax savings
$77
Note: Depreciation deductions may be available that could change the results of this analysis.
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK


The DevExpress ASP.NET MVC Spreadsheet can load a wide variety of formatted Excel documents. The spreadsheet documents used in this demo section are based on popular Microsoft Excel templates that you can download from Microsoft's Templates for Excel page.

In this demo, the Spreadsheet programmatically opens an XLSX document representing a simple form which performs advanced calculations on the data entered. Enter the terms of the vehicle purchase and the vehicle lease to compare, and determine which is better. Try modifying data within the white fields and notice how the grey fields are calculated automatically.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos