In: Finance
LOAN AMORTIZATION
Jan sold her house on December 31 and took a $25,000 mortgage as part of the payment. The 10-year mortgage has a 9% nominal interest rate, but it calls for semiannual payments beginning next June 30. Next year Jan must report on Schedule B of her IRS Form 1040 the amount of interest that was included in the two payments she received during the year.
a. What is the dollar amount of each payment Jan receives? Round
your answer to the nearest cent.
$
b. How much interest was included in the first payment? Round
your answer to the nearest cent.
$
How much repayment of principal was included? Round your answer
to the nearest cent.
$
How do these values change for the second payment?
-Select-IIIIIIIVV
c. How much interest must Jan report on Schedule B for the first
year? Round your answer to the nearest cent.
$
Will her interest income be the same next year?
-Select-Her interest income will increase in each successive
year.Her interest income will remain the same in each successive
year.She will not receive interest income, only a return of
capital.Her interest income will decline in each successive
year.She will receive interest only when the mortgage is paid off
in 10 years.
d. If the payments are constant, why does the amount of interest income change over time?
-Select-IIIIIIIVV
Please explain how to do using financial calculator functions.
1.
N=10*2
I/Y=9%/2
PV=25000
FV=0
CPT PMT=-1921.90
2.
=25000*9%/2=1125
3.
=1921.90-1125=796.90
4.
The portion of the payment that is applied to interest declines,
while the portion of the payment that is applied to principal
increases.
5.
2214.14
6.
Her interest income will decline in each successive year
7.
As the loan is amortized (paid off), the beginning balance, hence
the interest charge, declines and the repayment of principal
increases.
Payment | Loan beginning balance | Payment | Interest payment | Principal payment | Loan ending balance |
1 | 25000 | $1,921.90 | $1,125.00 | $796.90 | $24,203.10 |
2 | $24,203.10 | $1,921.90 | $1,089.14 | $832.76 | $23,370.33 |
3 | $23,370.33 | $1,921.90 | $1,051.66 | $870.24 | $22,500.09 |
4 | $22,500.09 | $1,921.90 | $1,012.50 | $909.40 | $21,590.69 |
5 | $21,590.69 | $1,921.90 | $971.58 | $950.32 | $20,640.37 |
6 | $20,640.37 | $1,921.90 | $928.82 | $993.09 | $19,647.28 |
7 | $19,647.28 | $1,921.90 | $884.13 | $1,037.78 | $18,609.51 |
8 | $18,609.51 | $1,921.90 | $837.43 | $1,084.48 | $17,525.03 |
9 | $17,525.03 | $1,921.90 | $788.63 | $1,133.28 | $16,391.76 |
10 | $16,391.76 | $1,921.90 | $737.63 | $1,184.27 | $15,207.48 |
11 | $15,207.48 | $1,921.90 | $684.34 | $1,237.57 | $13,969.91 |
12 | $13,969.91 | $1,921.90 | $628.65 | $1,293.26 | $12,676.66 |
13 | $12,676.66 | $1,921.90 | $570.45 | $1,351.45 | $11,325.20 |
14 | $11,325.20 | $1,921.90 | $509.63 | $1,412.27 | $9,912.93 |
15 | $9,912.93 | $1,921.90 | $446.08 | $1,475.82 | $8,437.11 |
16 | $8,437.11 | $1,921.90 | $379.67 | $1,542.23 | $6,894.88 |
17 | $6,894.88 | $1,921.90 | $310.27 | $1,611.63 | $5,283.24 |
18 | $5,283.24 | $1,921.90 | $237.75 | $1,684.16 | $3,599.09 |
19 | $3,599.09 | $1,921.90 | $161.96 | $1,759.94 | $1,839.14 |
20 | $1,839.14 | $1,921.90 | $82.76 | $1,839.14 | $0.00 |