Question: please help me with the 3 part problem! shown in excel 8. What is the payment in month 13 on a CAM loan for $150,000
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 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 Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount 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 1 Interest Rate 2 Constant Amortization Amount 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
