PowerPoint Presentation

Published on
Scene 1 (0s)

CIC3020 CASES IN FINANCE (SEM 2, SESSION 2020/2021)

Presenters: GROUP 1, TEAM 2 Siew Min Ann 17116250 Vinie Ng 17077230 Sau Jean Ying 17122710 Kartik A/L Kunasegaran 17156508

Case 3: Paying Off That Dream House

Loan Amortization

Lecturer: Dr Rozaimah Zainudin

Scene 2 (17s)

Story Line

Mortgage

Economic Condition

Refinancing Decision

A couple: Jacqueline & Keith Sommers Decided to buy a two-story house in Midwest Price: $ 300,000

Decided to refinance their mortgage at a 2.75%, 15-year rate To reduce financing cost

01

03

02

04

5 Years Ago

Current

Background

2 options: 30-year, 6.75% (Lower monthly payment) 15-year, 5.25% Downpayment: 20%

Worsening Mortgage rate had come down significantly

Scene 3 (1m 44s)

Question 1

What is Jacqueline & Keith’s monthly mortgage payment prior to the refinancing?

PMT

I

N

PV

$240,000.00

30 years x 12 mths = 360

6.75% / 12 mths = 0.5625%

$1,556.64

Scene 4 (2m 19s)

Question 2

The total payment paid in the first 5 years which includes the down payment made and the PMT paid for the first 5 years is $153,398.40

During the first five years of owning their dream house, how much money has the couple paid towards the mortgage? What proportion of this has been applied towards interest ?

30-year at 6.75% First 5 years

The proportion of interest paid in the first 5 years is 84.26%

Scene 5 (4m 5s)

Question 3

Difference between the monthly payment of 15-year at 5.25% and 30-year at 6.75% = $1,929.31 - $ 1,556.64 = $372.67

Monthly payment of 15-year at 5.25% is higher by $372.67

Had the couple opted for the original 15-year mortgage proposal (15 years, 5.25%), how much higher would their monthly payment have been?

15-year at 5.25%

30-year at 6.75%

Scene 6 (4m 59s)

How much of total interest would have been paid over the life of the loan?

15-years at 5.25%

30-years at 6.75%

Question 4

Total interest payments = $107,275.17

Total interest payments = $320,388.76

Scene 7 (5m 39s)

Total interest paid on 30-year, 6.75% mortgage is almost 3 times more than total interest paid on 15-year, 5.25% mortgage.

Question 4 (cont'd)

Scene 8 (5m 59s)

Tax shelter loss is $5,549.43

If the Sommers had chosen the original 15-year, 5.25% mortgage proposal, how much tax shelter would they have lost (over the last 5 years) as compared to the 30-year, 6.75% mortgage?

Question 5

*Assume Tax Rate is 24% (Source: IRS, 2021)

Scene 9 (7m 6s)

The excess available equity due to refinancing is $94,198.30

If the house currently worth $355,000 and most lenders are willing to lend up to 90% of home value, how much excess equity can sommers cash out?

Question 6

Scene 10 (8m 44s)

No,they should not cash out the excess equity as the yield after tax < cost of fund after tax However this case can be changed if they could invest in a risk free investment that yields more than 2.09% after tax.

Should Jacqueline and Keith cash out the excess equity that they have built up? Assume money market rates are 2.15%

Question 7

*Assume Tax Rate is 24% (Source: IRS, 2021)

Scene 11 (10m 14s)

$216,074.19

Initial monthly payment

If the Sommers had increased each payment by one-twelfth (since the beginning of the loan), what would their current loan balance amount to?

Question 8

= $1,556.64

New monthly payment

= $1,556.64 x (13/12) = $1,686.36

Current Loan Balance

01

02

03

04

Construct Amortization Schedule using new monthly payment

Scene 12 (11m 29s)

Question 9

Using the assumption in question 8 , how many total years would it take for the Sommers to pay off the existing loan ? Demonstrate your answer with an amortization schedule.

Number of month = 288 months

Number of year = 288/ 12 = 24 years

With assumption in question 8, It takes 24 years for the couple to pay off the existing loan

Scene 13 (12m 36s)

Question 10

Should Jacqueline and Keith close the 2.75%, 15-year mortgage? Explain your answer with suitable calculations.

Without Refinance Refinance PMT $1,556.64 $2,168.20 Year of Installment 25 15 Annual Interest Rate 6.75% 2.75% Total Interest Paid $320,388.76 $70,775.30 Tax Shield $76,893.30 $16,986.07

Without Refinance

PV = $240k N = 30 x 12 I = 6.75% / 12

PV = $319k N = 15 x 12 I = 2.75% / 12

Refinance

Nominal PV Interest Saved $249,613.45 $166,027.34 Loss in Tax Shield $59,907.23 $49,953.89 Difference $189,706.22 $116,073.45

Couple should refinance their mortgage loan @ 2.75% for 15 years

Scene 14 (14m 32s)

Thank You!

That’s all from us.