{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Car Loan"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Car Loan","index":0,"n_rows":41,"n_cols":7,"rows_kept":41,"merged":[[0,0,0,9],[2,2,3,6],[40,2,42,6]],"flags":["formulas_cached_only"]}
["Car Loan Worksheet"]
[]
[null,null,"This worksheet can help you estimate how much it might cost to purchase and maintain a new car. Enter values into the yellow boxes. Results will be shown in the green boxes."]
[]
[]
[]
[null,null,"1. Purchasing"]
[]
[null,null,"Cost of vehicle",{"$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 financed 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 car payment",{"$nulls":3},{"v":417.7624763394496,"d":"$417.76"}]
[]
[]
[null,null,"2. Licensing and parking"]
[]
[null,null,"Annual license fee",null,{"v":400,"d":"$400.00"},"/ 12",{"v":33.333333333333336,"d":"$33.33"}]
[null,null,"Annual parking permit, if required",null,{"v":100,"d":"$100.00"},"/ 12",{"v":8.333333333333334,"d":"$8.33"}]
[null,null,"Monthly parking costs",{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
[null,null,"Monthly licensing and parking cost",{"$nulls":3},{"v":41.66666666666667,"d":"$41.67"}]
[]
[]
[]
[null,null,"3. Monthly Fuel and maintenance"]
[]
[null,null,"Fuel",{"$nulls":3},{"v":50,"d":"$50.00"}]
[null,null,"Oil and other fluids",{"$nulls":3},{"v":5,"d":"$5.00"}]
[null,null,"Car wash, detailing, etc.",{"$nulls":3},{"v":25,"d":"$25.00"}]
[null,null,"Repairs, maintenance",{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
[null,null,"Monthly fuel and maintenance cost",{"$nulls":3},{"v":80,"d":"$80.00"}]
[]
[]
[{"$nulls":4},"Total cost of ownership (per month):",null,{"v":539.4291430061163,"d":"$539.43"}]
[]
[]
[null,null,"This worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password."]