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)

8. What is the payment in month 13 on a CAM loan for $150,000 with a maturity of 15 years at 5.85%? Answer $1,253.66 Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount $150,000 15 12 13 5.85% $1,254 9. What is the interest paid in month 14 on the loan in the previous question? Answer $694.44 Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount $150,000 15 12 14 5.85% $694 10. What is the balance at EOM 34 of the loan in the previous question? Answer Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount $150,000 15 12 14 5.85% $694