You borrow $50,000 for 5 years. This is an amortized load, meaning that payments are the same each month, and the loan is fully paid off with final payment. The quoted interest rate (or APR) is 12% per year. What are the beginning balance, Payment, Interest, Principal and Ending Balance in months 10 and 25 ? Enter all the necessary information in an Excel spreadsheet as the example in class, by entering the right formulas in each column. Do not email me the spreadsheet, but copy and paste the final table from Excel in a word document, and attach it with your answer. Question 2 One year ago, Sondra opened an investment account paying 7.65 percent annually. She made an initial deposit of $3,000. Her goal is to have $5,000 in the account three years from today. This afternoon, she realized that she may not have deposited sufficient funds to reach her goal. How much more, if any, should she deposit into her account to ensure that she reaches her goal in three more years? Question 3 On the day you entered college you borrowed $25,000 from your local bank. The terms of the loan include an interest rate of 4.75 percent. The terms stipulate that the principal is due in full one year after you graduate. Interest is to be paid annually at the end of each year. Assume that you complete college in four years. How much total interest will you pay on this loan? Question 4 Using an 8% discount rate, what is the present value of a perpetuity of $975 a year starting at time 5 ? Question 5 You borrow \$75,000 for three years. This is an amortized loan. Payments are the same each month. The loan is fully paid off with the final payment. The quoted interest rate (or APR) is 9% per year with monthly compounding. Assuming you make all of your payments on time, what is the outstanding balance on the loan right after you have made your 31st payment (i.e., with 5 payments remaining). Note: Do not email me the spreadsheet. You can solve without using spreadsheets, only formulas or calculator. You borrow $50,000 for 5 years. This is an amortized load, meaning that payments are the same each month, and the loan is fully paid off with final payment. The quoted interest rate (or APR) is 12% per year. What are the beginning balance, Payment, Interest, Principal and Ending Balance in months 10 and 25 ? Enter all the necessary information in an Excel spreadsheet as the example in class, by entering the right formulas in each column. Do not email me the spreadsheet, but copy and paste the final table from Excel in a word document, and attach it with your answer. Question 2 One year ago, Sondra opened an investment account paying 7.65 percent annually. She made an initial deposit of $3,000. Her goal is to have $5,000 in the account three years from today. This afternoon, she realized that she may not have deposited sufficient funds to reach her goal. How much more, if any, should she deposit into her account to ensure that she reaches her goal in three more years? Question 3 On the day you entered college you borrowed $25,000 from your local bank. The terms of the loan include an interest rate of 4.75 percent. The terms stipulate that the principal is due in full one year after you graduate. Interest is to be paid annually at the end of each year. Assume that you complete college in four years. How much total interest will you pay on this loan? Question 4 Using an 8% discount rate, what is the present value of a perpetuity of $975 a year starting at time 5 ? Question 5 You borrow \$75,000 for three years. This is an amortized loan. Payments are the same each month. The loan is fully paid off with the final payment. The quoted interest rate (or APR) is 9% per year with monthly compounding. Assuming you make all of your payments on time, what is the outstanding balance on the loan right after you have made your 31st payment (i.e., with 5 payments remaining). Note: Do not email me the spreadsheet. You can solve without using spreadsheets, only formulas or calculator