Question

In: Finance

Consider a loan of $225,000 at nominal interest rate of 6.25% for 15 years. How much...

Consider a loan of $225,000 at nominal interest rate of 6.25% for 15 years. How much of the payment during the first year goes towards interest? Assume monthly payments.

$19,929

$13,509

$13,987

$13,798

Solutions

Expert Solution

$13,798

Working:

Step-1:Calculation of monthly payment
Monthly payment = Loan amount /Present value of annuity of 1
= $       2,25,000 / 116.631532
= $       1,929.15
Working;
Present value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.005208)^-180)/0.005208 i 6.25%/12 = 0.005208
= 116.6315322 n 15*12 = 180
Step-2:Preparation of first year amortization
Months Beginning loan Monthly payment Monthly interest Reduction in principal Ending Loan amount
a b c=a*6.25%*1/12 d=b-c e=a-d
1 $       2,25,000 $         1,929 $         1,172 $           757 $ 2,24,242.72
2           2,24,243              1,929              1,168               761           2,23,482
3           2,23,482              1,929              1,164               765           2,22,716
4           2,22,716              1,929              1,160               769           2,21,947
5           2,21,947              1,929              1,156               773           2,21,174
6           2,21,174              1,929              1,152               777           2,20,397
7           2,20,397              1,929              1,148               781           2,19,616
8           2,19,616              1,929              1,144               785           2,18,830
9           2,18,830              1,929              1,140               789           2,18,041
10           2,18,041              1,929              1,136               794           2,17,247
11           2,17,247              1,929              1,131               798           2,16,450
12           2,16,450              1,929              1,127               802           2,15,648
Total           23,150           13,798           9,352
Thus,
Total interest payment in the year 1 is $     13,798

Related Solutions

A loan will be repaid in 5 years with monthly payments at a nominal interest rate...
A loan will be repaid in 5 years with monthly payments at a nominal interest rate of 9% monthly convertible. The first payment is $1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 2% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
How much interest will you pay during the last six years of a 15-year $300,000 loan...
How much interest will you pay during the last six years of a 15-year $300,000 loan with an APR of 3.15% assuming you only make the minimum required monthly payments? A. $13,915 B. $18,223 C. $18,641 D. $13,551
A loan is amortized over five years with monthly payments at an annual nominal interest rate...
A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
How much must you invest now to have 350,000 in 15 years if the interest rate...
How much must you invest now to have 350,000 in 15 years if the interest rate is 10% and compounds continuously? $65,457.33 $66,666.67 $63,848.93 $56,666.67 None of these
Define the nominal interest rate. How is the nominal interest related to the real interest rate?...
Define the nominal interest rate. How is the nominal interest related to the real interest rate? Why can we think of 1+ rt , where rt is the real interest rate, as the relative price of consumption today in terms of consumption in the future?
Initially, a mortgage loan of $225,000 with an interest rate of 5.75% and amortised over 25...
Initially, a mortgage loan of $225,000 with an interest rate of 5.75% and amortised over 25 years with a 5-year term was taken out. At the renewal time, the interest rate was reduced to 4.50%. If your client opts for a 3 year term this time, what will the balance at the end of this new term be?
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?
you obtain a 265,000, 15 year fixed rate mortgage. The annua interest rate is 6.25%. In...
you obtain a 265,000, 15 year fixed rate mortgage. The annua interest rate is 6.25%. In addition to the principle and interest paid, you must pay 275 a month into a escrow account for insurance and taxes. What is the total monthly payment(to the nearest dollar)?
A property costs $225,000. A borrower can obtain an 80% loan with an 10% interest rate...
A property costs $225,000. A borrower can obtain an 80% loan with an 10% interest rate and monthly payments. The loan is to be fully amortized over 20 years. Alternatively he could obtain a 90% loan at an 10.25% interest rate with the same loan term. The borrower plans to own the property for the entire loan term. What is the incremental cost of borrowing the additional funds?
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT