Question

In: Finance

A borrower and lender agree that a 9,000,000 loan made at 12% interest for 30years will...

A borrower and lender agree that a 9,000,000 loan made at 12% interest for 30years will have a 600,000 balance on the maturity date if the loan will be on constant amortization mortgage (CAM) terms. Determine how much will be paid monthly and prepare a loan payment schedule for the first 4 months.

Solutions

Expert Solution

Loan amount          9,000,000
Loan Balance after 30year              600,000
Total principal payment          8,400,000 (9000000-600000)
Number of months of payment 360 (30*12)
Constant amortization per month          23,333.33 (8400000/360)
Monthly interest =(12/12)=1%
LOAN AMORTIZATION SCHEDULE
A B=A*1% C D E=A-C
Month Beginning Balance Interest Principal Total Payment Ending Balance
1          9,000,000      90,000    23,333.33    113,333.33    8,976,666.67
2    8,976,666.67      89,767    23,333.33    113,100.00    8,953,333.33
3    8,953,333.33      89,533    23,333.33    112,866.67    8,930,000.00
4    8,930,000.00      89,300    23,333.33    112,633.33    8,906,666.67

Related Solutions

Suppose that a borrower and a lender agree on the nominal interest rate to be paid...
Suppose that a borrower and a lender agree on the nominal interest rate to be paid on a loan. Then inflation turns out to be lower than they both expected. Is the real interest rate on this loan higher or lower than expected? Use your own “made-up” figures for nominal interest rate, expected inflation rate and actual inflation rate to explain your answer in part “a”? Does the lender gain or lose from this unexpectedly low inflation? Does the borrower...
Consider a loan contract signed between a lender (e.g., a bank) and a borrower. Would the...
Consider a loan contract signed between a lender (e.g., a bank) and a borrower. Would the lender benefit or lose from inflation in the country? Explain your reasoning in a few sentences.
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded...
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded monthly. The loan is to be repaid by 36 monthly payments of 367.21 over 37 months, starting one month after the loan is made, there being a payment at the end of every month but one. At the end of which month is the missing payment? For your reference, the answer is at the 17th month.
The main type of mortgage loans that shift interest-rate risk from the lender to the borrower...
The main type of mortgage loans that shift interest-rate risk from the lender to the borrower is the A) FHA mortgage B) bi-weekly mortgage. C) adjustable-rate mortgage. D) conventional mortgage.
A borrower is offered a mortgage loan for $100,000 with an interest rate of 10% and...
A borrower is offered a mortgage loan for $100,000 with an interest rate of 10% and a 30-year amortization period with monthly payments. The origination fee is 1% of the loan and the lender charges two discount points. What is the effective interest rate? 10%, 9%, 10.37%, or 10.24%?
A loan of $100,000 is made today. The borrower will make equal repayments of $918 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $918 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios (EXCEL HIGHLY REGARDED), calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places. (a) The loan is fully repaid exactly...
A loan of $100,000 is made today. The borrower will make equal repayments of $2791.92 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $2791.92 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate in percentage: (b) The term of the loan is unknown but it is known that the loan outstanding 2 years later equals...
A loan of $100,000 is made today. The borrower will make equal repayments of $975 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $975 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places. (a) The loan is fully repaid exactly after 180 monthly...
A loan of $100,000 is made today. The borrower will make equal repayments of $1357 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $1357 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate in percentage. Give your answer as a percentage to 2 decimal places. (b) The term of the loan is unknown but it...
A loan of $100,000 is made today. The borrower will make equal repayments of $898 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $898 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places. (a) The loan is fully repaid exactly after 180 monthly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT