1. A fully amortizing CPM mortgage loan is made for $100,000 at 6 percent interest for a 30 year term.  Determine payments for each of the periods below if interest accrues:

 

1. Monthly
2. Quarterly
3. Annually
4. Weekly
5. A fully amortizing mortgage is made for $100,000 at 6.5% interest.  If the monthly payments are $1000 per month, then when will the loan be repaid?
6. A partially amortizing mortgage loan is made for $60,000 for a term of 10 years.  The borrower and lender agree that a balance of $20,000 will remain and be repaid as a lump sum at that time.
   1. If the interest rate is 7%, what must monthly payments be over the 10 year term?
   2. If the borrower chooses to repay the loan after five years instead of at the end of year 10, then what will the loan balance be at the end of year 5?
7. A fully amortizing CAM loan is made for $125,000 at 11 percent interest for 20 years.
   1. What will be the monthly payments and remaining loan balances for the first six months?
   2. What would monthly payments be if the loan were CPM instead?
   3. If both loans (the CAM and CPM) are repaid at the end of year 5, would the lender earn a higher rate of interest on either loan? Which one and why? Use Excel.
8. A $100,000 CPM fully amortizing loan is made, at a 3% interest rate compounded monthly, for a 15 year term.  Loan comes with a charge of 3 points.  What is the effective annual rate on the loan?

I NEED an actual excel/ google doc sheet attached. It cannot be copied and pasted form excel. Please attach an actual file where I will be able to open in excel. It should not be hardcoded. Thanks I will leave. a great review

Answer rating: 100% (QA)

Solving for Mortgage Loan Payments Heres how to solve for the loan payments in each scenario 1 Fully Amortizing CPM Mortgage Loan We can use the Loan ... View the full answer