jagomart
digital resources
picture1_Spreadsheet Calculator 46111 | Car Lease Calculator


 199x       Filetype XLS       File size 0.03 MB       Source: cdn.moneyzine.com


File: Spreadsheet Calculator 46111 | Car Lease Calculator
car lease calculator notes msrp 32 000 this is the manufacturer s suggested retail price also called the sticker price of the car base cap cost 30 000 this is ...

icon picture XLS Filetype Excel XLS | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
                          Car Lease Calculator
                                                                                                                                         Notes
                          MSRP                                       $             32,000  This is the Manufacturer's Suggested Retail Price, also called the sticker price of the car.
                          Base Cap Cost                              $             30,000  This is the negotiated price of the car, which is usually less than the MSRP or sticker price
                          Additional Lease Costs
                            Dealer Acquisition Fee                   $                  750  Acquisition fees usually range from $250 to $750.  This fee is included in every lease agreement.
                            Extended Warranties                      $               2,000  Additional costs associated with any other features outside of the lease, such as an extended warranty.
                          Gross Capitalized Cost                     $             32,750 
                          Capitalized Cost Reductions
                            Down Payments                            $               3,200  Includes cash or other allowances that pay down the capitalized cost of the car.
                            Trade In Allowances                      $               3,000  Any trade in allowance the dealer might offer you for an existing vehicle.
                          Net Capitalized Cost                       $             26,550  The net capitalized cost associated with the car lease.
                          Lease Terms and Taxes
                            Residual Value                           $             19,200  If you know the actual residual value, then enter that number here or else the sheet will calculate a value.
                            Money Factor                                     0.00292 There is a relationship between the money factor and the APR, as explained in the instructions.
                            APR                                                 7.0% Effective APR on the lease.
                            Term of Lease                                                  24  The term must be 24, 36 or 48 months.
                            Sales Tax                                           6.0% State sales tax (if any) in your state.
                          Calculation of Lease Cost
                            Depreciation                             $          7,350.00  Total depreciation on the car, which is the net capitalized cost minus the residual value.
                            Finance or Rent Charge                   $          3,206.16  The rent charged on the money borrowed over the term of the lease.
                            Sales Tax on Lease                       $             633.37  State sales tax due on the lease.
                          Total of All Payments                      $        11,189.53  Total of all money due on the lease, excluding upfront money such as capitalized cost reductions.
                            Total Lease Payment                      $        19,560.47  Total costs associated with the lease itself.
                            Sales Tax Due on Down Payment            $               12.00 
                          Calculation of Monthly Lease Payment
                            Monthly Lease Payment                    $             439.84  Monthly payment associated with the lease.
                            Sales Tax on Lease Payment               $               26.39  Sales tax on the monthly lease payment.
                          Total Monthly Lease Payment                $             466.23  Your total monthly lease payments over the term of the lease.
                          All Rights Reserved - Copyright © Money-Zine.com 2017
                08/17/2022 17:31:03                                                                                                                                                   car_lease_calculator.xls
The words contained in this file might help you see if this file matches what you are looking for:

...Car lease calculator notes msrp this is the manufacturer s suggested retail price also called sticker of base cap cost negotiated which usually less than or additional costs dealer acquisition fee fees range from to included in every agreement extended warranties associated with any other features outside such as an warranty gross capitalized reductions down payments includes cash allowances that pay trade allowance might offer you for existing vehicle net terms and taxes residual value if know actual then enter number here else sheet will calculate a money factor there relationship between apr explained instructions effective on term must be months sales tax state your calculation depreciation total minus finance rent charge charged borrowed over due all excluding upfront payment itself monthly rights reserved copyright moneyzinecom calculatorxls...

no reviews yet
Please Login to review.