excel formulas

Input Variables Price Subsidy Rebate 4-year Loan Interest Rate Downpayment Expected Annual Milesage Average Gas Mileage Expected average gas price/gallon Expected Life Expected Annual Maintainence cost Expected Investment Return Tesla Models Audi A7 -0% Option Audi A7 - Rebate Opti $ 76,000 $ 64,000 $ 64,000 $ $ $ $ $ $ 3,500 0.00% 0.00% 3.60% 20.00% 20% 20% 12,000.00 12,000.00 12,000.00 111 24 24 2.50 $ 2.50 $ 2.50 10 10 $ 300 $ 900 $ 900 6% 6% 6% $ 10 $ Loan Amount Monthly Loan Payment Annual Gas Cost Annual Maintainnece Cost Annual Fuel and Maintainance cost PV of Loan Payment PV of Annual Fuel and Main. Costs Downpayment Total Cost of Ownership