Question

In: Finance

Jan sold her house on December 31 and took a $45,000 mortgage as part of the...

Jan sold her house on December 31 and took a $45,000 mortgage as part of the payment. The 10-year mortgage has a 7% 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? The portion of the payment that is applied to interest declines, while the portion of the payment that is applied to principal increases. The portion of the payment that is applied to interest increases, while the portion of the payment that is applied to principal decreases. The portion of the payment that is applied to interest and the portion of the payment that is applied to principal remains the same throughout the life of the loan. The portion of the payment that is applied to interest declines, while the portion of the payment that is applied to principal also declines. The portion of the payment that is applied to interest increases, while the portion of the payment that is applied to principal also increases.

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? d. If the payments are constant, why does the amount of interest income change over time? As the loan is amortized (paid off), the beginning balance, hence the interest charge, increases and the repayment of principal increases. As the loan is amortized (paid off), the beginning balance, hence the interest charge, declines and the repayment of principal increases. As the loan is amortized (paid off), the beginning balance, hence the interest charge, declines and the repayment of principal declines. As the loan is amortized (paid off), the beginning balance, hence the interest charge, increases and the repayment of principal declines. As the loan is amortized (paid off), the beginning balance declines, but the interest charge and the repayment of principal remain the same.

Solutions

Expert Solution

Principal (P) 45000
Interest Rate (r') 7%
No of years 10
m 2
Payment (P)= r/m*(PV)/(1-(1+r/m)^-n*m)
= ((0.07/2)*45000)/(1-((1+(0.07/2))^(-10*2))
= 3166.25
a) the dollar amount that Jan receives every pament is $3166.25
b) Interest included in first payment is $1575
Principal repayment in first payment was $1591.25
For the second payment interest is $1519.31 and principal is $1646.94
The portion of the payment that is applied to interest declines, while the portion of the payment that is applied to principal increases.
c) Interest for the 1st year= 1575+1519.31
= 3094.31
Jan must report $3094.31 as the interest for the year in Schedule B
Her interest income will be less than the income interest income for this year
d) As the loan is amortized (paid off), the beginning balance, hence the interest charge, declines and the repayment of principal increases
Amortization Table
PmtNo. Beginning Balance Scheduled Payment Interest Principal Ending Balance
A B = previous year F C D= B*7%/2 E=C-D F=B-E
1 $               45,000.00 $                     3,166.25 $ 1,575.00 $ 1,591.25 $        43,408.75
2 43,408.75 3,166.25 1,519.31 1,646.94 41,761.81
3 41,761.81 3,166.25 1,461.66 1,704.59 40,057.22
4 40,057.22 3,166.25 1,402.00 1,764.25 38,292.98
5 38,292.98 3,166.25 1,340.25 1,825.99 36,466.98
6 36,466.98 3,166.25 1,276.34 1,889.90 34,577.08
7 34,577.08 3,166.25 1,210.20 1,956.05 32,621.03
8 32,621.03 3,166.25 1,141.74 2,024.51 30,596.52
9 30,596.52 3,166.25 1,070.88 2,095.37 28,501.15
10 28,501.15 3,166.25 997.54 2,168.71 26,332.44
11 26,332.44 3,166.25 921.64 2,244.61 24,087.83
12 24,087.83 3,166.25 843.07 2,323.17 21,764.65
13 21,764.65 3,166.25 761.76 2,404.49 19,360.17
14 19,360.17 3,166.25 677.61 2,488.64 16,871.52
15 16,871.52 3,166.25 590.50 2,575.75 14,295.78
16 14,295.78 3,166.25 500.35 2,665.90 11,629.88
17 11,629.88 3,166.25 407.05 2,759.20 8,870.68
18 8,870.68 3,166.25 310.47 2,855.77 6,014.90
19 6,014.90 3,166.25 210.52 2,955.73 3,059.18
20 3,059.18 3,166.25 107.07 2,952.11 0.00

Related Solutions

Jan sold her house on December 31 and took a $30,000 mortgage as part of the...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the payment. The 10-year mortgage has a 6% 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...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the payment. The 10-year mortgage has a 6% 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. (Please show the excel function to find this) 1) How would I find the dollar...
Jan sold her house on December 31 and took a $10,000 mortgage as part of the...
Jan sold her house on December 31 and took a $10,000 mortgage as part of the payment. The 10-year mortgage has a 11% 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...
Jan sold her house on December 31 and took a $25,000 mortgage as part of the...
Jan sold her house on December 31 and took a $25,000 mortgage as part of the payment. The 10-year mortgage has an 8% 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...
jan sold her house on December 31 and took a $40,000 mortgage as part of the...
jan sold her house on December 31 and took a $40,000 mortgage as part of the payment. The 10-year mortgage has a 10% 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...
Jan sold her house on December 31 and took a $15,000 mortgage as part of the...
Jan sold her house on December 31 and took a $15,000 mortgage as part of the payment. The 10-year mortgage has a 7% 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...
Jan sold her house on December 31 and took a $20,000 mortgage as part of the...
Jan sold her house on December 31 and took a $20,000 mortgage as part of the payment. The 10-year mortgage has a 12% 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...
Jan sold her house on December 31 and took a $15,000 mortgage as part of the...
Jan sold her house on December 31 and took a $15,000 mortgage as part of the payment. The 10-year mortgage has a 12% 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...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the payment. The 10-year mortgage has an 11% 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. What is the dollar amount of each payment Jan receives? Round your answer to the...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the...
Jan sold her house on December 31 and took a $30,000 mortgage as part of the payment. The 10-year mortgage has a 6% 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT