Hi,

I need help with these questions, I keep getting the wrong answer.

please provide an excel function for the answer hint(the answer is on cell highlight with red)

undefined

5. What is the payment in month 336 on a 30-year loan for $925,000 at 4.85% that requires interest only payments for the first eight years and fully amortizing payments for the remaining years of the loan? Answer Loan Amount Periods Per Year Interest Rate Payment in First Five Years Total Amortization Years $925,000.00 12 4.85% 6. What is the payment in month 234 on a 30-year loan for $925,000 at 4.85% that requires no payments during the first five years and fully amortizing payments for the remaining years of the loan? $925,000 Answer $22.756.30 30 Loan Amount Years Periods Per Year Interest Rate Balance at EOM 60 Total Amortization Years 12 4.85% $3.951,542.64 25