Question: Please list the excel functions used Payment Calculation Instruction: Calculate Loan Payment using PMT Function. All cells must contain formulas (i.e., typing the number directly
Please list the excel functions used
Payment Calculation Instruction: Calculate Loan Payment using PMT Function. All cells must contain formulas (i.e., typing the number directly into the cells will be graded as incorrect answers). 1.1 Susan purchases a Mazda 6 for $22,000. To pay for the car, she will make monthly payments over 4 years, annual $509.14 interest rate = 5.25%. What are the monthly payments? Put the formula for the claculation in the cell A6. $24,438.70 1.2 What is the total amount (interest and principal) that Susan will have to pay for the car? 1.3 How much interest will Susan pay? 2.1 Ryan purchases a house for $120,000 to be paid for over 30 years at an interest rate of 6.25% per year. What are the monthly payments? 12.2 What is the total amount (interest and principal) that Ryan pay for the house? 2.3 How much interest does Ryan pay
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
