Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Mrs  Johnson has just moved to London with her new job, in which she received a significant salary increase

Mrs  Johnson has just moved to London with her new job, in which she received a significant salary increase

Finance

Mrs  Johnson has just moved to London with her new job, in which she received a significant salary increase. Being new to the city, she is now trying to decide whether she should rent an apartment or buy one. She has spent the first weekend looking at different options and has shortlisted two options.

Option 1: Rent an apartment, which would cost her a total of 2,000£ per month including everything. Every year the rent is due to increase by 2.5%. The contract is perpetual meaning she could theoretically stay there forever if she wanted.

Option 2: Buy an apartment, which costs 900,000£ with an initial down payment of 100,000£ and a 30-year loan for the remaining 800,000£. The loan would carry an interest of 1.5%. After 30 years she would own the apartment 100% .

Assumptions

1. She will buy or rent the apartment on the 1st of January

2. Payments happen at the end of each period

Question.1

a. In case Mrs. Johnson chooses option 2, how much will she have to pay each month for her loan?

b. In option 1, Mrs. Johnson is unsure how much rent she will have to pay in the future. Show the monthly rent per year from year 1-10

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Part (a)

Her payment each month can be calculated using the PMT function of excel or financial calculator. Inputs are:

Rate = interest rate per month = 1.5% / 12 = 0.125%

Nper = number of months in years to matuity = 12 x 30 = 360

PV = - Loan amount = - 800,000

FV = future value = 0

Hence, the amount she will have to pay each month for her loan

= PMT (Rate, Nper, PV, FV) = PMT (0.125%, 360, - 800000, 0) = 2,760.96

Part (b)

Monthly rent in year n = Monthly rent in year (n-1) x (1 + annual increase) = Monthly rate in year (n-1) x (1 + 2.5%)

Monthly rent in year 1 = 2,000

Hence, we can construct the following table of year wise monthly rent as shown below:

Year Monthly rent
1 2,000
2 2,050
3 2,101
4 2,154
5 2,208
6 2,263
7 2,319
8 2,377
9 2,437
10 2,498