show formulas in excel

3. Amortized Car Loan You want to buy a car for 30,000 and you plan to finance the car at 5.4% over 5 years (monthly payments). You can make a 4,000 down payment. a) What will be your monthly payment (end of month)? b) Set up an amortization schedule AutoSave OP H 2 Spreadsheet 2 Advanced TVM 2020 (1) (version 1) - File Home Insert Page Layout Formulas Data Review View Help Power F 10 d A B D E G Periods per year 12 Interest rate (*) Cost Downpayment Loan (dollar Period (years) Compounting 60 5 monthly Number of periods Interest per period Monthly Payments Beg Amount Mormy Payments Mont-end Interest Repayment of Principal Total Interest Pad Remaning Balance Penog 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 Retirement 1 Retirement 2 Car Armortization House Armortization Growing Ann dy Type here to search O 99+