Question: 3 Use the Excel file/Google Sheets link posted to the Moodle page to answer the following questions. Use the second sheet titled Adjusted Monthly Schedule.

3 Use the Excel file/Google Sheets link posted to the Moodle page to answer the following questions. Use the second sheet titled "Adjusted Monthly Schedule". (a) Suppose you would like to purchase a home which costs $300,000. You will be making a 15% down payment. What is the loan amount? (b) You will have a 30 year mortgage with an annual interest rate at 4.5%. You will make monthly payments. What is the monthly payment and the total interest paid on the loan if you make no additional payment each cycle? (c) Suppose you are able to pay an extra $50 each month. i What is the percent increase in your monthly payments? ii What is the percent decrease in your total interest paid? iii How many payments are eliminated by adding the extra $50 each month? (d) Suppose you have a budget surplus at the end of the first few years and would like to put that money towards your mortgage. Assume you are not making the extra $50 payments each month. i If you pay an extra $1,000 in month 12, how much money do you save on the total interest? ii If you pay an extra $1,000 in months 12 and 24, how much money do you save on the total interest? iii If you pay an extra $1,000 in months 12, 24, and 36, how much money do you save on the total interest
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
