pls answer 5& 6. Show work through excel if possible. Tahnk you
Project Assignment No. 1 PROBLEM 3 - Franco obtained a 30-year $100,000 floating rate mortgage with annual rate adjustments. The initial interest rate is 12%. However, because of Franco's personal income, he and the lender negotiated and agreed to a $800 monthly mortgage loan payment. (You may use your financial calculator for these questions, but show your key stroke inputs.) 5. Despite Franco's agreement with the lender, what should the monthly mortgage loan payment be for the first year? Given the agreed upon monthly payment of $800, what will the mortgage loan balance be after five years if this were a fixed rate mortgage? After 30 years? 6. Assume that the all-in interest rate increase to 13% at the beginning of year 2. How much interest will be accrued (negative amortization) to the mortgage loan principal balance in the first year if the monthly mortgage loan payment remains at $800? 5 QUESTION 5 2 . Keystrokes: 350 12% 100.000 30 PV PV PMT 62 -1.032.35 14 Loan Balance at the end of year five is 15 Keystrokes: 300 12% 75.957 27 PV PMT 20 PV 21 22 Loan Balance at the end of year 30 23 Keystrokes 0.00 25 26 27 PV PMT PV O 12% 0.00 800.00 0.00 29 30 Solution: 32 33 34 35 36 37 30 39 PV PMT FV QUESTION 6 42 43 Year: Balance at the beginning of year 5: 45 46 07 PMT PV 50 Interest due during first month of year 5: Negative Amortation during your : 52 53 54 55 56 PV PMT Project Assignment No. 1 PROBLEM 3 - Franco obtained a 30-year $100,000 floating rate mortgage with annual rate adjustments. The initial interest rate is 12%. However, because of Franco's personal income, he and the lender negotiated and agreed to a $800 monthly mortgage loan payment. (You may use your financial calculator for these questions, but show your key stroke inputs.) 5. Despite Franco's agreement with the lender, what should the monthly mortgage loan payment be for the first year? Given the agreed upon monthly payment of $800, what will the mortgage loan balance be after five years if this were a fixed rate mortgage? After 30 years? 6. Assume that the all-in interest rate increase to 13% at the beginning of year 2. How much interest will be accrued (negative amortization) to the mortgage loan principal balance in the first year if the monthly mortgage loan payment remains at $800? 5 QUESTION 5 2 . Keystrokes: 350 12% 100.000 30 PV PV PMT 62 -1.032.35 14 Loan Balance at the end of year five is 15 Keystrokes: 300 12% 75.957 27 PV PMT 20 PV 21 22 Loan Balance at the end of year 30 23 Keystrokes 0.00 25 26 27 PV PMT PV O 12% 0.00 800.00 0.00 29 30 Solution: 32 33 34 35 36 37 30 39 PV PMT FV QUESTION 6 42 43 Year: Balance at the beginning of year 5: 45 46 07 PMT PV 50 Interest due during first month of year 5: Negative Amortation during your : 52 53 54 55 56 PV PMT
