13. Consider the following fixed-rate, level-payment mortgage: · maturity = 360 months · amount borrowed = $100,000 · annual mortgage rate = 10% a)Construct an amortization schedule for the first 10...

1 answer below »

View more »
Answered Same DayDec 07, 2021

Answer To: 13. Consider the following fixed-rate, level-payment mortgage: · maturity = 360 months · amount...

Tanmoy answered on Dec 07 2021
131 Votes
Finance
13.
a. Loan Amount (PV) = $100000
No. of monthly payments (n) = 360
Annual interest rate = 10%
Monthly interest rate (r) = 10%/12 = 0.833%
According to the formula, the
monthly payment = PV/ (1-(1+r) ^-n) ÷ r
= 100000 ÷ (1-(1+0.833) ^-360) ÷ 0.00833
= 100000 ÷ (1-1.833) ^-360) ÷ 0.00833
= 100000/ (1-0.05040983) ÷ 0.0083
= 100000/ (0.94959 ÷ 0.0083)
= 100000/ 113.95081
= 877.57
    Months
    Beginning Mortgage Balance
    Monthly Interest
    Scheduled Principal Payment
    Ending Mortgage Balance
    1
    100000.00
    833.33
    44.24
    99955.76
    2
    99955.76
    832.96
    44.61
    99911.15
    3
    99911.15
    832.59
    44.98
    99866.18
    4
    99866.18
    832.22
    45.35
    99820.82
    5
    99820.82
    831.84
    45.73
    99775.09
    6
    99775.09
    831.46
    46.11
    99728.98
    7
    99728.98
    831.07
    46.5
    99682.48
    8
    99682.48
    830.69
    46.88
    99635.60
    9
    99635.60
    830.30
    47.27
    99588.32
    10
    99588.32
    829.90
    47.67
    99540.65
Hence, the Monthly payment = $877.57
b. Balance after 360 months in case the payment is not made = $1983739.94
Loan amount (PV) = $100000
Number of monthly payments (n) = 360
Annual interest rate = 10%
Monthly interest rate (r) = 10%/12 = 0.833%
As per the formula, Balance after 360 months = PV*(1+r) ^n
= 100000*(1+0.0083) ^360
= 100000*1.00833^360
= 100000*19.837399
= 1983739.94
Therefore, the balance after 360 months if there is no payment done = $1983739.94. This gives the MBt = $0
c. Repeating the whole equation which is illustrated for t = 12, now we are using t = 270, we get Mortgage balance (MBt)= $55409.50
d. The scheduled principal payment at the end of the month 270 assuming there are no prepayments (and using the SPt formula as illustrated previously for when period t = 12 and using t = 270, MBt = $412.39.
14.
a Since the ultimate goal is to...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30