XLS Regulation M Lease Spreadsheet

Lease Payment CalculatorBased on Federal Consumer Leasing Act (Regulation M)Version 2.0 Last Update 7/20/2013Enter Money Factor Here:Enter # of Months in Your Lease:Sales Tax Rate:Negotiated Selling Price of Vehicle:0Dealer Acquisition Fee:0Unpaid prior lease/loan amounts:00.003333360.06Other:……………………………………0APR Equivalent:=(money_factor)*2400/100Gross Capitalized Cost=selling_price_of_vehicle+acquisition_fee+prior_loan_balance+other_cap_costsAmount Due at Lease Signing:Your 1st Monthly Payment of:=total_monthly_paymentOther Charges: Leasing agents charge disposition fees if you don't buy car at the end.Total of Payments: (The amount you'll pay if you DON'T buy at lease end)is due,followed by the remaining=number_of_months-1 payments of:=total_monthly_payment(Calculated from below)dueof each month.Disposition Fee:0=number_of_months*total_monthly_payment+Amount_due_at_lease_signing-first_months_payment-security_deposit+end_of_lease_fees+mileage_penalty=Amount_due_at_lease_signingTotal of Your Monthly Payments:=total_monthly_payment*number_of_months0Total of Payments: (if you DO buy at lease end)Purchase Option Fee:0Other Fees:0TOTAL:=disposition_fee+excess_wear+purchase_option_fee+other_fee=total_all_monthly_payments+residual_value-mileage_penaltyAmount Due At Lease Signing (Itemized expenses for closing a lease)How "Amount Due at Lease Signing" will be paidCapitalized Cost Reduction (Your cash down and any rebates)0Credit For Net Trade-In Allowance:Sales Tax on capitalized cost reduction+=cash_down*tax_rateYear______Make_________________0More Cap Cost Reduction (Credit For Net Trade-In Allowance)+=net_tradein_allowanceRebates:+0Sales/Use Tax on Credit for Net Trade-In Allowance+=G23*tax_rateNoncash Credits:+0Advance First Monthly Payment (paid up front)+0Amount Paid By Others:+0Refundable Security Deposit (paid up front)+0Amount to be Paid in Cash:+0Initial Title Fees+Initial Registration Fees+TOTAL:=L22+L23+L24+L25+L26+L27Other:+This tells you how the amount calculated in the section to the left will be paid. It may be cash, Trade-In value, rebates, credits, other forms. However you decide to divide these inception costs, they all add up to the total above. The above total must match the total on left.Other:+TOTAL AMOUNT DUE AT LEASE SIGNING:=SUM(G21:G30)Gross Capitalized Cost=gross_cap_costSum of the negotiated vehicle price:=selling_price_of_vehicle,plus any items you pay for over the Lease Term (service contracts, insurance, rustproofing, taxes, dealer acquisition fees, bank fees, outstanding prior loan or lease balances). Some dealers may require your fees to be paid at inception instead of working them into the lease.Capitalized Cost Reduction-=cash_down+net_tradein_allowance+rebate+noncash_creditThe amount of net Trade-In allowance, rebate, Noncash credit, or cash down you pay that reduces the gross capitalized cost. These add together to reduce your cap cost.Adjusted Capitalized Cost==gross_capitalized_cost-capitalized_cost_reductionThis final cap cost amount will be used to calculate your base monthly payment.Residual Value-0The estimated value of vehicle at the end of the lease. This is also used to calculate your depreciation and monthly payments. This amount is given to you by the dealer.Depreciation and any amortized amounts.==adjusted_capitalized_cost-residual_valueThis is a combination of the amount charged for the vehicle's decline in value through normal use, plus other items that will be paid over the lease term like fees, insurance, warranties, etc. The formula for depreciation is (Adjusted capitalized Cost - Residual Value)Rent Charge+=(adjusted_capitalized_cost+residual_value)*money_factor*Lease_TermTotal "finance charge" during lease, NOT calculated same way as loan interest. The formula is (Adjusted Cap Cost + Residual Value) * Money Factor * Lease TermTotal of all Your Base Monthly Payments==rent_charge+depreciationThe total of all your monthly payments, not including tax. This is depreciation, rent charge, items like fees, warranties, etc. Formula is (Depreciation + Rent Charge)Lease Term (Months)==number_of_monthsThe number of months in your lease. Beware of 39 month leases on a vehicle with a 36 month warranty. In months 37-39, repairs are NOT covered by warranty, and are paid by PONENTS OF YOUR MONTHLY PAYMENT:Base Monthly Payment==total_base_monthly_payments/Lease_TermFirst two components of your monthly payment: 1) Depreciation and any amortized amounts, and then 2) Rent Charge. The formula is (Depreciation + Rent Charge)/Number MonthsMonthly Sales/Use Tax+=base_monthly_payment*tax_rateThe 3rd of 3 components making up your monthly payment: Tax on the Base Monthly Payment. The formula is (Base Monthly Payment * Tax Rate for your state)Other:+0Any other dealer fees, taxes, fudge factors, etc. Edit label and enter this amount manually.Other:+0Any other miscellaneous fees or taxes. Enter this amount manually.Total Monthly Payment:+=base_monthly_payment+monthly_tax_payment+other1+other2This is the amount of the payment you will send to the leasing company every month.EARLY TERMINATION: You may have to pay a substantial charge if you end this lease early. This charge may be several thousand dollars. The actual charge will depend on when the lease is terminated. The earlier you end the lease, the greater this charge is likely to be.EXCESSIVE WEAR AND USE: You may be charged for excessive wear based on our standards for normal use and for mileage in excess ofof12000miles per year at the rate of15cents per mile.How many miles over the limit are you?0Your Penalty is:=excess_miles*cents_per_mile/100Copyright © 1999-2013 ConsumerNet, Inc. All Rights Reserved. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download