Question: Submit your spreadsheet file here. You should use the template in the attached file. There are two scenarios, so you should submit one excel file

Submit your spreadsheet file here. You should use the template in the attached file. There are two scenarios, so you should submit one excel file with two taba one tab for each scenario. Scenario 1: You buy a car and borrow $18,000, with interest at 7.5% per year, to be repaid over 48 months (4 years). Scenario 2: the same as before, except that the interest rate is 12% per year. Answer the questions on the Questions tab. Answer the following questions in the space provided below. 1 How much did the payment increase when the interest rate was increased? Original payment New payment Difference 2 How is the "applied to interest" amount in period 3 computed? Show the calculation using the actual amounts from the original data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
