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

3. What is the monthly payment on a loan for which the accrual rate equals the pay rate if the loan amount is $800,000, the term is 30 years, and the interest rate is 6.4%? (Use the syntax described on Page 11 of the Module 4 reading assignment.) Answer $5,004.05 Loan Amount Years Periods Per Year Interest Rate $800,000.00 30 12 6.40% 4. What is the amount of the required balloon payment at maturity for the loan in the previous question? Answer $0