{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":91,"n_cols":11,"rows_kept":91,"merged":[[0,0,0,11],[2,1,5,10],[7,1,8,10],[10,1,12,10],[14,1,14,10],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,4],[27,2,27,4],[27,9,28,10],[28,2,28,4],[29,2,29,4],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[36,1,45,10],[47,3,47,6],[48,3,48,6],[49,3,49,6],[51,2,53,9],[54,1,54,10],[55,1,55,10],[56,1,57,10],[60,2,61,6],[60,8,61,9],[62,2,62,5],[63,2,63,5],[64,2,64,5],[65,2,65,5],[66,2,66,5],[67,2,67,5],[68,2,68,5],[69,2,69,5],[70,2,70,5],[71,2,71,5],[72,2,72,5],[73,2,73,3],[74,2,74,5],[76,6,76,8],[77,6,77,8],[79,2,79,4],[81,2,82,5],[81,8,82,9],[84,2,84,5],[85,2,85,5],[86,2,86,5],[90,1,112,10]],"flags":["formulas_cached_only"]}
["Leasing Versus Purchasing"]
[]
[null,"The following worksheets can help you estimate how much it might cost to lease a vehicle and compare that to the cost of purchasing the same item and paying for it with a loan. The worksheets are based on a simple leasing arrangement and do not take into account some of the variables that enter into many leasing agreements. (See \"Other Considerations,\" below.)"]
[]
[]
[]
[]
[null,"Type into yellow cells, changing the sample values. Type all percent figures without using % signs. Examples: 25 or 9.5. Do not type in green cells. Excel will automatically add data to shaded cells."]
[]
[]
[null,"Important: These worksheets provide rough estimates, and the forms are not intended for commercial use. Please note that the legal and financial conditions of leasing and purchasing vary from place to place and often depend on the commodity in question.  "]
[]
[]
[]
[null,"Leasing Worksheet"]
[]
[]
[null,null,"Figures do not include taxes",{"$nulls":5},"Terms of Lease"]
[]
[null,null,"Retail price, MSRP*, or sticker price",{"$nulls":5},{"v":17500,"d":"$17,500.00"}]
[null,null,"Monthly rental fee",{"$nulls":5},{"v":229,"d":"$229.00"}]
[null,null,"Capitalized or negotiated cost (the price if you paid cash)",{"$nulls":5},{"v":19000,"d":"$19,000.00"}]
[null,null,"Refundable deposit, if any (security deposit)",{"$nulls":5},{"v":500,"d":"$500.00"}]
[null,null,"Term (leasing period), in months",{"$nulls":5},36]
[]
[null,null,"Residual value [Enter one figure below]"]
[]
[null,null,"•    expressed as a percentage (e.g., 50)",{"$nulls":3},{"v":0.5,"d":"50%"},null,null,""]
[null,null,"•    Or expressed in dollar terms",{"$nulls":5},{"v":8750,"d":"$8,750.00"}]
[]
[null,null,"First month payment in advance",{"$nulls":5},{"v":229,"d":"$229.00"}]
[null,null,"Last month payment in advance (if required)",{"$nulls":5},{"v":229,"d":"$229.00"}]
[]
[null,null,"* MSRP: manufacturer's suggested retail price"]
[]
[]
[null,"Other considerations\n\n1.  You may be able to negotiate one or more of the lease terms, such as the monthly rental and the residual value. (\"Residual value\" is what you agree the vehicle will be worth at the end of the leasing period.) If you think you might want to buy the item at the end of the leasing period, be sure to discuss the residual value when you negotiate the lease.\n\n2.  Many automobile leases include a clause adding a charge per mile or kilometer driven above a specified yearly or total maximum. You can use the following cells to make a rough estimate: "]
{"$rows_empty":10}
[{"$nulls":3},"Number of extra miles or kilometers per year",{"$nulls":4},{"v":1000,"d":"1,000.00"}]
[{"$nulls":3},"Cost per mile or km (e.g., 0.10)",{"$nulls":4},{"v":0.1,"d":"$0.10"}]
[{"$nulls":3},"Total mileage or km cost",{"$nulls":4},{"v":100,"d":"$100.00"},"Entire period ",{"v":300,"d":"$300.00"}]
[]
[null,null,"Be aware that extra mileage or kilometer charges can substantially affect the figures on the Comparisons Worksheet (following page)."]
[]
[]
[null,"Comparisons Worksheet"]
[]
[null,"The following worksheet may help you compare the costs of leasing and purchasing. For notes on factors not taken into account here, see \"Other Considerations,\" below."]
[]
[]
[]
[null,null,"1. Calculate the cost of purchasing the same vehicle and taking out a loan to pay for it:",{"$nulls":5},"2. Compare the cost to lease with option to buy:"]
[]
[]
[null,null,"Cost of vehicle (MSRP or negotiated price)",{"$nulls":3},{"v":17500,"d":"$17,500.00"}]
[null,null,"Down payment and/or trade-in allowance",{"$nulls":3},{"v":5000,"d":"$5,000.00"}]
[null,null,"Additional costs, if any",{"$nulls":3},{"v":400,"d":"$400.00"}]
[null,null,"Annual interest on loan (e.g., 10.25)",{"$nulls":3},{"v":0.1025,"d":"10.25%"}]
[null,null,"Duration of loan (in years)",{"$nulls":3},3]
[]
[null,null,"Monthly payment",{"$nulls":3},{"v":417.7624763394496,"d":"$417.76"},null,"Payment ",{"v":229,"d":"$229.00"}]
[null,null,"Total number of payments (years x 12)",{"$nulls":3},36,null,"No. of pmts. ",36]
[]
[null,null,"Total principal + interest (P+I)",{"$nulls":3},{"v":15039.449148220187,"d":"$15,039.45"}]
[null,null,"Total finance charges",null,{"v":2139.4491482201865,"d":"$2,139.45"}]
[null,null,"Total cash outflow (P+I + down pmt./trade-in)",{"$nulls":3},{"v":20039.449148220185,"d":"$20,039.45"},null,"Cash outflow ",{"v":8244,"d":"$8,244.00"}]
[]
[{"$nulls":6},"Net (present value) cost to lease ",null,null,{"v":7203.121200274826,"d":"$7,203.12"}]
[{"$nulls":6},"Net (present) residual value ",null,null,{"v":6442.132061624905,"d":"$6,442.13"}]
[]
[null,null,"Net (present value) cost to own",{"$nulls":3},{"v":17900,"d":"$17,900.00"},null,"Net cost ",{"v":13645.253261899732,"d":"$13,645.25"}]
[{"$nulls":8},"to own"]
[null,null,"3. What if you sell the item for its residual value just after you pay off the loan?",{"$nulls":5},"4. Compare the cost to lease without purchasing:"]
[]
[]
[null,null,"Net cost to own",{"$nulls":3},{"v":17900,"d":"$17,900.00"}]
[null,null,"Less sale proceeds (=net residual value)",{"$nulls":3},{"v":6442.132061624905,"d":"$6,442.13"}]
[null,null,"Net cost to own and sell",{"$nulls":3},{"v":11457.867938375095,"d":"$11,457.87"},null,"Cost to lease ",{"v":7203.121200274826,"d":"$7,203.12"}]
[]
[]
[{"$nulls":6},{"v":131.87816790714828,"d":"$131.88"},null,{"v":11.921510710831381,"d":"11.92151"},{"v":208.62643743954916,"d":"208.62644"}]
[null,"Other considerations \n \n1. All calculations assume regular monthly payments. If you make loan payments on a bi-weekly or semi-monthly schedule, your total finance charges and net cost to own will likely be lower than the figures shown. Similarly, if you make extra payments against the loan principal, your total finance charges and net cost to own will be lower.\n \n2. Maintenance costs are another possible factor. If routine maintenance services (for example, lubrication and oil changes for a car) are included in leasing fees, you will save some of the normal expenses you would incur if you owned the car.\n \n3. The \"Net cost to own\" comparison will differ if, at the end of a leasing period, you opt to buy the item and pay for it with a loan. In this case, finance charges will increase the cost to own.\n \n4. The \"Cash outflow,\" \"Net cost to lease,\" \"Net cost to own,\" and \"Cost to lease\" figures will all be higher if you are charged for extra miles or kilometers. (See page 1, \"Other Considerations,\" No. 2.)\n \n5. If you use the vehicle for business purposes, the tax ramifications will differ between leasing and purchasing. Generally, you will be able to claim higher deductible expenses by owning the vehicle -- but \nconsult your tax adviser for details."]