Calculation of monthly mortgage payment

Assignment Help Finance Basics
Reference no: EM133116253

Rebecca after being graduated with an MBA secured employment in investment banking which denotes that she has got into a relevant profession indicating a stable income source. Simultaneously, she rented a two-bedroom condominium for the cost of $3,000 per month (parking cost included and utilities excluded). After 2 months, she saw a place next door identical to her rented place for $620,000 which she thought of getting in $600,000. This place was sufficient for her for the next 5 years before she could think of the bigger place. So, now she can either make a decision to purchase this new place or continue renting the one in which she was staying.  She wanted to analyze the buy vs rent decision from a quantitative point of view in order to provide some context for the qualitative considerations that would be a major part of her decision.

FINANCIAL DETAILS

If Young purchased the new condominium, she would pay monthly condo fees of $1,055 per month, plus property taxes of $300 per month on the unit. Unlike when renting, she would also be responsible for repairs and general maintenance, which she estimated would average $600 per year.

If she decided to purchase the new unit, Young intended to provide a cash down payment of 20 percent of the purchase price. There was also a local deed-transfer tax of approximately 1.5 percent of the purchase price, and a provincial deed-transfer tax of 1.5 percent, both due on the purchase date. (For simplicity, Young planned to initially ignore any other tax considerations throughout her analysis.) Other closing fees were estimated to be around $2,000.

In order to finance the remaining 80 percent of the purchase price, Young contacted several lenders and found that she would be able to obtain a mortgage at a 2.80 APR Semiannual compounding that would be locked in for a 10-year term and that she would amortize the mortgage over 25 years, with monthly payments. The money that Young was planning to use for her down payment and closing costs was presently invested and was earning the same effective monthly rate of return as she would be paying on her mortgage. Young assumed that if she were to sell the condominium - say, in the next two to 10 years - she would pay 5 percent of the selling price to realtor fees plus $2,000 in other closing fees.

SCENARIO ANALYSIS

In order to complete a financial analysis of the buy-versus-rent decision, Young realized that her first task would be to determine the required monthly mortgage payments. Next, she wanted to determine the opportunity cost (on a monthly basis) of using the lump-sum required funds for the condominium purchase rather than leaving those funds invested and earning the effective monthly rate, assumed to be equivalent to the mortgage rate. She would then be able to determine additional monthly payments required to buy the condominium compared to renting, including the opportunity cost.

Young wanted to consider what might happen if she chose to sell the condominium at a future date. She was confident that any re-sell would not happen for at least two years, but it could certainly happen in five or 10 years' time. She needed to model the amount of the outstanding principal at various points in the future - two, five or 10 years from now. She then wanted to determine the net future gain or loss after two, five and 10 years under the following scenarios, which she had determined were possible after some due diligence regarding future real-estate prices in the Toronto condo market: (a) The condo price remains unchanged; (b) The condo price drops 10 percent over the next two years, then increases back to its purchase price by the end of five years, then increases by a total of 10 percent from the original purchase price by the end of 10 years; (c) The condo price increases annually by the annual rate of inflation of 2 percent per year over the next 10 years; and (d) The condo price increases annually by an annual rate of 5 percent per year over the next10 years.

FINAL CONSIDERATIONS

Young realized she had a tough decision ahead of her, but she was well trained to make these types of decisions. She also recognized that her decision would not be based on quantitative factors alone; it would need to be based on any qualitative considerations as well. She knew she needed to act soon because condominiums were selling fairly quickly, and she would need to arrange to finance and contact a lawyer to assist in any paperwork if she decided to buy.

Need answer for below questions

1. Findings and Assumptions

  • Facts from the case, the expectation of future real estate prices(rent/buy), cost of borrowing, opportunity costs, cost of buying/selling, economy, etc.
  • The case was prepared in 2015. What would be your findings of the market situation in 2021/22?
  • Describe your assumptions, if any.

2. Analysis

  • Calculation of monthly mortgage payment, outstanding mortgage balance.
  • Costs to be considered in buy decisions. rent decision.
  • Scenario analysis (Condo prices, potential interest rate changes, etc.)
  • Qualitative considerations, in addition to quantitative analysis performed above.

3. Recommendation

  • What recommendation(s) would you suggest to Rebecca Young and why? Rent or buy?

Reference no: EM133116253

Questions Cloud

What is the geometric average return on the stock : If the return on your stock equals the expected return indicated by the CAPM next year, What is the geometric average return on the stock
KIT502 Web Development Assignment : KIT502 Web Development Assignment Help and Solution, University of Tasmania - Assessment Writing Service
Prepare a lease payment schedule for Amaton Ltd : Prepare a lease payment schedule for Amaton Ltd, showing the division of the lease payment into interest and principal components for the life of the lease
What is the bond anticipated yield : What is the bond's anticipated yield? Use Appendix B and Appendix D to answer the question. Round your answer to the nearest whole number.
Calculation of monthly mortgage payment : Rebecca after being graduated with an MBA secured employment in investment banking which denotes that she has got into a relevant profession indicating a stable
About chad pregracke inspiring story : Read this article about Chad Pregracke's inspiring story on the difference a single individual can make by Enabling Others to Act.
Calculate the deferred tax liability and deferred tax asset : Calculate the deferred tax liability and deferred tax asset on 30 June 2022 and prepare the journal entry to record the deferred tax amounts
What is the forward price today for delivering : a) What is the forward price today for delivering at date t2 = 6m a zcb with face value $100,000 maturing at t4 = 1y?
What is the forward price today for delivering : a) What is the forward price today for delivering at date t2 = 6m a zcb with face value $100,000 maturing at t4 = 1y?

Reviews

Write a Review

Finance Basics Questions & Answers

  Explain the difference in boiling points

Methane and Ammonia have the same number of electrons. Explain the difference in their boiling points.

  Create an all-new entity

Enterprise Insurance acquired State Insurance. As part of this transaction, both firms ceased to exist in their prior form and combined to create an all-new ent

  What are the potential benefits of applying cvp analysis

What are the potential benefits of applying CVP analysis to business decision making? Compute the annual breakeven number of meals and sales revenue for the restaurant.

  What is the effective annual rate

How much money do you need to have in the bank to pay for a 4 year college degree if tuition is $15,000 per year and your bank gives you 1.5% interest. What is the effective annual rate on a 18% APR loan if interest is compounded monthly?

  Work out the standard deviation of returns

Work out the standard deviation of returns on an equally weighted portfolio of 6 identical stocks, each of which is expected to yield a return

  Balance sheet statements to generate the financial ratios

Financial Management Principles Project - Pick one business corporation (not Bank) of your choice anywhere in the world and generate its financial ratios

  What is the stock estimated growth rate

A stock has a required return of 13%, and a retention rate of 40%. The stock's price-earnings multiple (P/E) is 14. What is the stock's estimated growth rate?

  What are the capital structure weights

Common shares of App Invent Inc. have a beta of 0.9.The market risk premium is 8 percent, and T-bills are currently yielding 1 percent.

  Calculate point elasticity of demand

For the demand schedule P = 24 - 0.125Q, calculate point elasticity of demand when price is £5 (b) £10 (c) £15.

  Difference between ebit and taxable income

The difference between EBIT and taxable income must be interest expense. Use this same procedure to complete similar problems.] Write out your answer completely

  What is the stock price today

What is the stock price today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  Find the present value on june

Find the present value on June 1, 2014 of a non-interest-bearing note for $950 issued February 2, 2014, for 21 0 days if money is worth 8.31%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd