Excel Spreadsheet

Automobile Payment Calculator

You must be logged in to download this document
Reviews
Shared by: Pastor Gallo
Stats
views:
77
rating:
not rated
reviews:
0
posted:
10/29/2008
language:
English
pages:
0
Car Lease Calculator MSRP Base Cap Cost Additional Lease Costs Dealer Acquisition Fee Extended Warranties Gross Capitalized Cost Capitalized Cost Reductions Down Payments Trade In Allowances Net Capitalized Cost Lease Terms and Taxes Residual Value Money Factor APR Term of Lease Sales Tax Calculation of Lease Cost Depreciation Finance or Rent Charge Sales Tax on Lease Total of All Payments Total Lease Payment Sales Tax Due on Down Payment $ $ $ $ $ Notes 32,000 This is the Manufacturers Suggested Retail Price, also called the sticker price of the car. 30,000 This is the negotiated price of the car. Usually less than the MSRP or sticker price 750 Acquisition fees usually range from $250 to $750. This fee is included in every lease agreement. 2,000 Additional costs associated with any other features outside of the lease, such as an extended warranty. 32,750 $ $ $ 3,200 Includes cash or other allowances that pay down the capitalized cost of the car. 3,000 Any trade in allowance the dealer might offer you for an existing vehicle. 26,550 The net capitalized cost associated with the car lease. $ 19,200 0.00292 7.0% 24 6.0% If you know the actual residual value, then enter than number here or else the sheet will calculate a value. There is a relationship between the money factor and the APR, as explained in the instructions. Effective APR on the lease. The term must be 24, 36 or 48 months. State sales tax (if any) in your state. $ $ $ $ $ $ 7,350.00 3,206.16 633.37 11,189.53 Total depreciation on the car, which is the net capitalized cost minus the residual value. The rent charged on the money borrowed over the term of the lease. State sales tax due on the lease. Total of all money due on the lease, excluding upfront money such as capitalized cost reductions. 19,560.47 Total costs associated with the lease itself. 12.00 Calculation of Monthly Lease Payment Monthly Lease Payment $ Sales Tax on Lease Payment $ Total Monthly Lease Payment $ 439.84 Monthly payment associated with the lease itself. 26.39 Sales tax on the monthly lease payment. 466.23 Your total monthly lease payments over the term of the lease. 10/29/2008 7:31 PM 736566a3-a956-475b-9073-7eb571fbce1e.xls

Related docs
calculator automobile
Views: 107  |  Downloads: 4
Automobile Loan Calculator
Views: 89  |  Downloads: 7
automobile lease calculator
Views: 42  |  Downloads: 2
payment calculator car
Views: 29  |  Downloads: 0
New Automobile Depreciation Calculator
Views: 5  |  Downloads: 0
automobile loan
Views: 49  |  Downloads: 3
home mortgage payment calculator
Views: 19  |  Downloads: 0
Car Down Payment Calculator
Views: 155  |  Downloads: 2
A Car Payment Calculator Can Save You Money
Views: 23  |  Downloads: 0
lease calculator
Views: 631  |  Downloads: 5
home equity loan payment calculator
Views: 39  |  Downloads: 1
Loan Payment Calculator Car
Views: 96  |  Downloads: 0
Automobile Payment Plan
Views: 355  |  Downloads: 19
buy automobile
Views: 83  |  Downloads: 5
premium docs
Other docs by Pastor Gallo
Application Service Provider
Views: 406  |  Downloads: 9
Michigan Child Custody Lawyer
Views: 449  |  Downloads: 2
LLC in Nevada
Views: 441  |  Downloads: 13
Lemon Law Lawyers Los Angeles
Views: 171  |  Downloads: 0
Lease Agreement Printable
Views: 3766  |  Downloads: 79
Law Enforcement News
Views: 101  |  Downloads: 0
Job Interview Sample Questions
Views: 759  |  Downloads: 11
Insurer Failed to Pay Life Insurance Claim
Views: 171  |  Downloads: 0
Insurance Claim Dispute
Views: 207  |  Downloads: 3
How to Become an Entrepreneur
Views: 243  |  Downloads: 9
Government Grant to Start a Business
Views: 271  |  Downloads: 1
Free Printable Rental Agreements
Views: 4368  |  Downloads: 55
Free Printable Purchase Agreement
Views: 4039  |  Downloads: 33
Florida Personal Injury Law
Views: 168  |  Downloads: 2
First Time Buyers Grants
Views: 219  |  Downloads: 0