Reference no: EM131908753

You have an opportunity to purchase investment real estate for $675,000. You need to make a down payment of $70,000 (and you have enough in savings to make this down payment). The remaining purchase price would be borrowed at 4.25% annual rate of interest for 20 years with equal annual payments (that is, a payment once a year). Prepare a table that shows the annual payment, the amount of interest paid each year, and the remaining principal owed after each payment. HINTS -- This loan is a total of 20 payments so the principal owed after the 20th payment must be $0. Develop your calculations in a spreadsheet, then copy and paste the spreadsheet into your Word file as a table. Alternative scenario A: If you had an opportunity to make extra payments (that is, a pre-payment) of $14,600 after making the 9th and 13th scheduled annual payments, how many annual payments would you eliminate from the scheduled 20 payments? HINT – use your spreadsheet to answer this question. Alternative scenario B: Rather than two extra payments, you are able to pay an addition $3,200 each year, how many annual payments would you eliminate from the scheduled 20 payments? HINT – again, use your spreadsheet to answer this question. HINT -- in answering the questions for the alternative scenarios, you do NOT need to include additional tables. Simply state your answers in one or two professional sentences.