Determine the principal outstanding on the mortgage

Assignment Help Finance Basics
Reference no: EM131997168

Question: In May 2013, Rebecca Young completed her MBA and moved to Toronto for a new job in investment banking. There, she rented a spacious, two-bedroom condominium for $3,000 per month, which included parking but not utilities or cable television. In July 2014, the virtually identical unit next door became available for sale with an asking price of $620,000, and Young believed she could purchase it for $600,000. She realized she was facing the classic buy-versus-rent decision. It was time for her to apply some of the analytical tools she had acquired in business school - including "time value of money" concepts - to her personal life. While Young really liked the condominium unit she was renting, as well as the condominium building itself, she felt that it would be inadequate for her long-term needs, as she planned to move to a house or even to a larger penthouse condominium within five to 10 years - even sooner if her job continued to work out well. Friends and family had given Young a variety of mixed opinions concerning the buy-versus-rent debate, ranging from "you're throwing your money away on rent" to "it's better to keep things as cheap and flexible as possible until you are ready to settle in for good." She realized that both sides presented good arguments, but she wanted to analyze the buy-versus-rent decision from a quantitative point of view in order to provide some context for the qualitative considerations that would ultimately be a major part of her decision.

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 per cent of the purchase price. There was also a local deed-transfer tax of approximately 1.5 per cent of the purchase price, and a provincial

deed-transfer tax of 1.5 per cent, 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 per cent of the purchase price, Young contacted several lenders and found that she would be able to obtain a mortgage at a 4 per cent "quoted" annual rate 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 per cent of the selling price to realtor fees plus $2,000 in other closing fees.

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 fiveor 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 per cent 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 per cent 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 per cent per year over the next 10 years; and

(d) The condo price increases annually by an annual rate of 5 per cent per year over the next 10 years.

In Canada, quoted mortgage rates are based on semi-annual compounding, compared with personal loans and most U.S. mortgage based on montyly xompounding.

1. Determine the required monthly payments for the mortgage.

2. Determine the "opportunity" costs, on a monthly basis, of using the required funds for closing (i.e., down payment plus all closing costs), rather than leaving funds invested and earning the monthly effective rate determined in part (1) above.

3. Determine the monthly additional payments required to buy versus rent (include the monthly opportunity costs determined in part (2) above).

4. Determine the principal outstanding on the mortgage after:

a. Two years

b. Five years

c. 10 years

5. Determine the "net" future gain or loss after 10 years under the following scenarios, which Rebecca Young has determined are possible after some "due diligence" regarding future real-estate prices in the Toronto condo market (note that she will sell the condo after 10 years):

a. The condo price remains unchanged.

b. The condo price increases by a total of 10% 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% per year over the next 10 years.

d. The condo price increases annually by an annual rate of 5% per year over the next 10 years.

6. As Rebecca Young, what decision would you make? Describe any qualitative or other quantitative considerations that could factor into your decision.

Reference no: EM131997168

Questions Cloud

Ideas specific to complex project management : PPMP 20014 Complex Project Management - Cq university - A discussion of the tools and techniques to aid a project manager manage complex projects
Prepare the journal entries to record the issuance of bonds : On May 1, 2017, Bulverde Inc. issues $300,000 of 6% bonds that were dated on January 1 at par, plus accrued interest. These bonds pay interest on July 1.
Research design prompt : Is this a workable hypothesis for the following Research Design prompt?
Compute the net present value for each project : Sanchez Corporation is considering three long-term capital investment proposals. Compute the net present value for each project
Determine the principal outstanding on the mortgage : Determine the monthly additional payments required to buy versus rent (include the monthly opportunity costs determined in part (2) above).
Identify ways that the organization can maintain its risk : Identify the organization's exposure to internal and external threats. Identify ways that the organization can maintain its risk.
Should wilbert assign to equipment as an initial cost : Wilbert's Inc. paid $90,000, in cash, for a piece of equipment three years ago. Last year, the company spent $50,000 to update the equipment.
Provide a description of the problem domain : Provide your opinion as to whether the extension from the article makes it easier or harder to build models compared to using plain UML. Provide a rationale.
How are general long-term liabilities distinguished : Long Term Liabilities and Noncollectable Accounts: How are general long-term liabilities distinguished from other long-term liabilities of the government

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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