Excel Project (TVM) -- Fall 2019 - Protected View - Saved to this PC References Mailings Review View Help Search internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing dy to be installed, but first we need to close some apps. Update now Part II: Loan Amortation Use the appropriate moration function (whom applicable) to solve the following questions A AC Eterprise t o a loan is the amount of $1.2 milhos Beguest round edate wers and appropriate (1.) to indicate now to use the most appropriate Excel fraction when applicable to find the following 1. Assume the loan has a APR of 43% compounded monthly, and a term of 5 years as your starting values. Using a two-way datatable, determine the monthly payment required as the loan for the following sea combinations, ming a balance at the end of the respective owner APR: 4.5% to 996 in 25% increments Loan Term: 3 years to 20 years in 5 year increments 2. What happens to the payment as the interest rate and time to maturity change? Asume a los amount of $1.3 million amortized over 15 year with an APR of 5.254, compounded moothly for all questions forward(Que 3 - 15) 3. How much will ACE be required to pay each month for the loan to be fully amortiring 4 FACE pamet scheduled how in total will they repay 5. Ortale t how much is meest 6. How chwil ACE as principal on the first a t test 7. IRACE Scheduled a s year 2 by how much will the principal de After paying on the loan for a bow much wal ACE is principal 9. Now, asume that ACE pays to pay of the loan in full additional ST50 per month on the loan. How many will it take the 10. How we will ACE ay is interest r ate of the loan pay the additional $150 per month Email - FINC 3132. h cold mail.pub . Book1 - Excel Project 1 - Temp. w Excel Preject (TVM). Excel Project (TVM) -- Fall 2019 - Protected View - Saved to this PC References Mailings Review View Help Search internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing dy to be installed, but first we need to close some apps. Update now Part II: Loan Amortation Use the appropriate moration function (whom applicable) to solve the following questions A AC Eterprise t o a loan is the amount of $1.2 milhos Beguest round edate wers and appropriate (1.) to indicate now to use the most appropriate Excel fraction when applicable to find the following 1. Assume the loan has a APR of 43% compounded monthly, and a term of 5 years as your starting values. Using a two-way datatable, determine the monthly payment required as the loan for the following sea combinations, ming a balance at the end of the respective owner APR: 4.5% to 996 in 25% increments Loan Term: 3 years to 20 years in 5 year increments 2. What happens to the payment as the interest rate and time to maturity change? Asume a los amount of $1.3 million amortized over 15 year with an APR of 5.254, compounded moothly for all questions forward(Que 3 - 15) 3. How much will ACE be required to pay each month for the loan to be fully amortiring 4 FACE pamet scheduled how in total will they repay 5. Ortale t how much is meest 6. How chwil ACE as principal on the first a t test 7. IRACE Scheduled a s year 2 by how much will the principal de After paying on the loan for a bow much wal ACE is principal 9. Now, asume that ACE pays to pay of the loan in full additional ST50 per month on the loan. How many will it take the 10. How we will ACE ay is interest r ate of the loan pay the additional $150 per month Email - FINC 3132. h cold mail.pub . Book1 - Excel Project 1 - Temp. w Excel Preject (TVM)