Question
In: Finance
Sarah would like to purchase a condo in Vancouver. She currently rents an apartment for $4,500...
Sarah would like to purchase a condo in Vancouver. She currently rents an apartment for $4,500 per month. The condo she is looking at costs $1,600,000. She intends to put $300,000 down. The condo has monthly condo fees of $300/month, property taxes of $200/month and repairs of $100/month. She can obtain a 30-year mortgage for 3% per year compounded monthly.
There are the following closing costs at purchase:
Land transfer tax $20,000
Legal fees $1,500
There are the following closing costs when selling:
Real estate commission of 3% of selling price
Legal fees $2,000
(a) What is the principal outstanding for the loan after 10 years? (Calculate the value at year 10 of the remaining 20 years of mortgage payments)
(b) Compute the cost (NPV) under buying and renting over the next 10 years assuming the unit is sold in 10 years for $1,800,000 and rent stays constant. Is it better to rent or buy? Upon sale, you will need to pay off the outstanding loan balance (see part a).
Solutions
Expert Solution
Using equated monthly installement formula
EMI= [P x R x (1+R)^N]/[(1+R)^N-1]
a)Hence, Monthly EMI=$5,481 and principal at the end of 10th year=$9,88,258
| Calculation of schedule for loan | |||||
| Year | Principal | Interest | Total Payment | Balance | Loan Paid To Date |
| Principal | Interest | (A + B) | |||
| 2020 | $18,004 | $25,843 | $43,847 | $12,81,996 | 1.38% |
| 2021 | $27,689 | $38,081 | $65,770 | $12,54,307 | 3.51% |
| 2022 | $28,531 | $37,239 | $65,770 | $12,25,776 | 5.71% |
| 2023 | $29,399 | $36,371 | $65,770 | $11,96,377 | 7.97% |
| 2024 | $30,293 | $35,477 | $65,770 | $11,66,084 | 10.30% |
| 2025 | $31,215 | $34,556 | $65,770 | $11,34,869 | 12.70% |
| 2026 | $32,164 | $33,606 | $65,770 | $11,02,705 | 15.18% |
| 2027 | $33,142 | $32,628 | $65,770 | $10,69,563 | 17.73% |
| 2028 | $34,150 | $31,620 | $65,770 | $10,35,413 | 20.35% |
| 2029 | $35,189 | $30,581 | $65,770 | $10,00,223 | 23.06% |
| 2030 | $36,259 | $29,511 | $65,770 | $9,63,964 | 25.85% |
|
Jan |
$2,980 | $2,501 | $5,481 | $9,97,243 | 23.29% |
| Feb | $2,988 | $2,493 | $5,481 | $9,94,255 | 23.52% |
| Mar | $2,995 | $2,486 | $5,481 | $9,91,260 | 23.75% |
| Apr | $3,003 | $2,478 | $5,481 | $9,88,258 | 23.98% |
| May | $3,010 | $2,471 | $5,481 | $9,85,247 | 24.21% |
b) Calculation of cash outflows under buy option
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Ouflows under buy option | 300000 | Monthly ouflow of $600 for all months for condo fees, property tax and repairs+5481 as monthly EMI's | |||||||||
| Land transfer tax | 20000 | ||||||||||
| Legal fees | 1500 | ||||||||||
| Selling price | -1800000 | ||||||||||
| Legal fees | 2000 | ||||||||||
| Real estate commission(3%) | 54000 | ||||||||||
| Oustanding loan | 988258 |
Present cash value of cash outflows is $-390,164.38
| Calculation of cash outflows under rent option | |||||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Monthly outflow of $5100 each month for 10 years | |||||||||||
| Present value of cash outflows is $-529,178.40 |
Buying option is more profitable since it has a better NPV of $(390164.38) over rent option which has NPV of $(529178.40)
jeff jeffy answered 1 year agoRelated Solutions
Sarah would like to purchase a condo in Vancouver. She currently rents an apartment for $4,500...
Sarah would like to purchase a condo in Vancouver. She currently
rents an apartment for $4,500 per month. The condo she is looking
at costs $1,600,000. She intends to put $300,000 down. The condo
has monthly condo fees of $300/month, property taxes of $200/month
and repairs of $100/month. She can obtain a 30-year mortgage for 3%
per year compounded monthly.
There are the following closing costs at purchase:
Land transfer tax $20,000
Legal fees $1,500
There are the following closing...
An investor would like to purchase a new apartment property that costs $2 million with an...
An investor would like to purchase a new apartment property that
costs $2 million with an initial year NOI of $190,000, and an
expected growth rate of 3% per year (in income and value).
The building and improvements represent 80% of value and will be
depreciated over (1 ÷ 27.5 per year). Assume a 36% tax bracket for
all income and capital gains taxes. The investor faces the decision
of whether to use 70% or 80% financing.
The 70% loan...
Monica rents a one-bedroom apartment. Because she does not own the property, does this mean she...
Monica rents a one-bedroom apartment. Because she does not own
the property, does this mean she is not liable for any injuries
that might occur in her home? Give an example of a situation where
she would be responsible. How should she cover her potential
liability as a renter? (home insurance for renters, HO-4)
11. Sherry wants to rent an apartment. Although rents are below what she is willing to...
11. Sherry wants to rent an apartment. Although rents are below
what she is willing to pay, she cannot find an apartment. Then
after a month of searching, she finds an apartment but she has to
pay an additional $1,000 to have the locks changed. Sherry has just
experienced the effects of ________. A) a rent floor with a black
market B) inelastic demand C) a market working efficiently D) a
rent ceiling 12. A price floor A) always results...
An investor would like to purchase a $2,000,000 new apartment house and has two financing options...
An investor would like to purchase a $2,000,000 new apartment
house and has two financing options under consideration:
Option 1 includes a 70% loan to value mortgage for 15 years at
6.5% interat and 3% closing costs.
Option 2 includes an 80% loan to value mortgage for 15 years at
7.5% interest and 4% closing costs.
Compute the APR for each mortgage option and the incremental
cost of borrowing the additional amount if option 2 is
selected.
Assume that a risk manager would like to purchase property insurance on a building. She is...
Assume that a risk manager would like to purchase property
insurance on a building. She is analyzing two insurance coverage
bids. The bids are from comparable insurance companies, and the
coverage amounts are the same. The premiums and deductibles,
however, differ. Insurer A’s coverage requires an annual premium of
$70,000 with a $3000 per-claim deductible.
Insurer B’s coverage requires an annual premium of $25,000 with a
$9,000 per-claim deductible. The risk manager wonders whether the
additional $55,000 in premiums is...
Assume that a risk manager would like to purchase property insurance on a building. She is...
Assume that a risk manager would like to purchase property
insurance on a building. She is analyzing two insurance coverage
bids. The bids are from comparable insurance companies, and the
coverage amounts are the same. The premiums and deductibles,
however, differ. Insurer A’s coverage requires an annual premium of
$70,000 with a $3000 per-claim deductible.
Insurer B’s coverage requires an annual premium of $25,000 with
a $9,000 per-claim deductible. The risk manager wonders whether the
additional $55,000 in premiums is...
Sarah wants to invest $2M. Based on her income she is currently in the 28% tax...
Sarah wants to invest $2M. Based on her income she is currently
in the 28% tax brackets for ordinary income and in the 15% bracket
for Long term capital gains. Her tax bracket for state income tax
purposes are 5% and 0% on long term capital gains. Requirements:
for each of the four situations below, determine NPV of after tax
cash flows:
SItuation 1 situation 2 situation 3 situation 4
Type: Corporate bonds municipal bonds corporate stocks municipal
bonds
Time...
Sarah wants to purchase a new car that lists for $30,000. The manufacturer currently offers two...
Sarah wants to purchase a new car that lists for $30,000. The
manufacturer currently offers two incentive programs. She may
finance the full price of the car through the manufacturer at 0%
for 5 years. Alternatively, she may arrange his own financing and
receive a $3,000 discount off the price of the car.
Sarah’s bank will finance the car at
4.5 percent for 5 years.
Which financing option should she
choose? Justify your answer.
Joan moves into her new apartment and wants to purchase a new couch. She wants to...
Joan moves into her new apartment and wants to purchase a new
couch. She wants to determine if the average cost of couches at
Store 1 is cheaper than Store 2. At Store 1 the average cost of 20
couches is $650 with a standard deviation of $61. At Store 2 the
average cost of 22 couches is $730 with a standard deviation of
$78. At alpha = .05, what are the results if you want to determine
that Store...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Consider the group G = {1, −1, i, −i, j, −j, k, −k} under multiplication. Here...
- Determine the magnitude of the gravitational force Mars would exert on man if he was on...
- In 2012, the General Social Survey asked a random sample of adults, "Compared to most people,...
- 1. Explain the difference between linear, radial, and angular acceleration and identify which "G" force vector...
- 1- Your firm is has equity of $2,460,000.00 and debt of $1,480,000.00 and the cost of...
- C++. Write a program that asks the user to enter a single word and outputs the...
- On August 1, 2019, United Corporation issued $9.50 million of 6% bonds at 104. The bonds...
ADVERTISEMENT