Question

In: Accounting

This mini-case takes us back to b-school grads Sally and Dave. You’ll perhaps recall that they’re...

This mini-case takes us back to b-school grads Sally and Dave. You’ll perhaps recall that they’re thinking of buying a condo which will cost $100,000. In Chapter 4, Sally and Dave were planning to finance the condo purchase without borrowing. In this case we consider the case where they take out a mortgage to finance the investment.

The point of this case is to get you to think about the effect of financing on returns. It should also lead to a discussion of the relation between financing and risk.

Case facts

Here are the facts:

  • Sally and Dave intend to take a 10-year mortgage for $50,000. The mortgage has interest rate of 8%, compounded annually. Repayment of the mortgage is in equal annual payments of interest and principal.
  • Sally and Dave can rent out the condo for $2,000 per month. They’ll have to pay property taxes of $1,500 annually and they’re figuring on additional miscellaneous expenses of $1,000 per year.
  • All the income from the condo has to be reported on their annual tax return. Currently Sally & Dave have a tax rate of 30%, and they think this rate will continue for the foreseeable future.
  • The full cost of the condo can be depreciated over 25 years on a straight-line basis.
  • To calculate the return from owning the condo, Sally and Dave assume that they will sell the condo at the end of 10 years for $100,000. Any gain over book value on the sale is, of course, taxable.
  1. Use the template for this case to calculate Sally and Dave’s IRR on their equity investment. (Terminology: Since the cost of the condo is $100,000 and since they’re borrowing $50,000, the equity investment is $50,000.) Remember that for income tax purposes depreciation and interest on the mortgage are expenses, but that repayment of mortgage principal is not an expense. Use Excel’s IPMT and PPMT functions (see explanation below).
  2. Suppose that Sally and Dave take a $50,000 mortgage with a 25-year term. They still plan to sell the apartment at the end of year 10. At this date they will repay the remaining mortgage principal with a 2% penalty for early repayment. Calculate the equity IRR.
  3. How much is the mortgage interest payment in year 2
  4. How much is the mortgage interest payment in year 3
  5. How much is the total mortgage payment annually?
  6. How much is the terminal value in year 10
  7. How much is IRR?
  8. If term is 25 years for mortgage how much is the IRR?

Solutions

Expert Solution


Related Solutions

Sally & Dave’s Condo Project: Financing with a Mortgage Overview This mini-case takes us back to...
Sally & Dave’s Condo Project: Financing with a Mortgage Overview This mini-case takes us back to b-school grads Sally and Dave. You’ll perhaps recall from PFE Chapter 4 that   they’re   thinking   of   buying   a   condo.   In Chapter 4, Sally and Dave were planning to finance the condo purchase without borrowing. In this case we consider the case where they take out a mortgage to finance the investment. The point of this case is to get you to think about the...
Mini-Case D: (3 marks) Sally skipped a few years in high school as she was always...
Mini-Case D: Sally skipped a few years in high school as she was always the smartest in the class. Everyone knew she would be successful, and her friends were excited for her when they found out that she would be making an offer on a condo. She was waiting for the bank to get back to her as she just submitted her application for a mortgage. Her gross annual income is $100,000 and has been the same for the last...
Mini-Case B (6 marks) The Simpsons, owners of a spa on the island of Montreal, have...
Mini-Case B The Simpsons, owners of a spa on the island of Montreal, have been hard-hit by the pandemic. Before they were forced to close their spa, their take home income, after taxes but before living expenses, was $7,000 a month. The Simpsons spent all of their take-home cash flow and even more, by borrowing on a line of credit (LOC). The day their spa was closed the balance on their LOC was $8,520. Normally they use the LOC to...
Going back to the Savary case (TC Summary 2010-150) where Savary , a US citizen, was...
Going back to the Savary case (TC Summary 2010-150) where Savary , a US citizen, was a flight attendant that lived and worked in Paris. The Tax Court reviewing Art 24 (Relief from Double Taxation) in the US-France DTC, concluded that France should give a credit for the US taxes on Savary's wages. Since France had already declined to provide a credit for the US tax, Savary was subject to double taxation by both contracting states on USD 23,321 (the...
Assessment item 3 back to top Case B - Report Value: 20% Due Date: 16-Sep-2018 Return...
Assessment item 3 back to top Case B - Report Value: 20% Due Date: 16-Sep-2018 Return Date: 05-Oct-2018 Length: 3000 words Submission method options: Alternative submission method Task back to top Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s...
ssessment item 3 back to top Case B - Report Value: 20% Due Date: 16-Sep-2018 Return...
ssessment item 3 back to top Case B - Report Value: 20% Due Date: 16-Sep-2018 Return Date: 05-Oct-2018 Length: 3000 words Submission method options: Alternative submission method Task back to top Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s...
Assessment item 3 back to top Case B - Report Value: 20% Due Date: 16-Sep-2018 Return...
Assessment item 3 back to top Case B - Report Value: 20% Due Date: 16-Sep-2018 Return Date: 05-Oct-2018 Length: 3000 words Submission method options: Alternative submission method Task back to top Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s...
CASE B: Steps Toward Cultural Competence Three students are about to graduate from Temple Dental School...
CASE B: Steps Toward Cultural Competence Three students are about to graduate from Temple Dental School in a few months, and they are about to open their own practice upon graduation.  They hire your consulting company to help them design a culturally competent practice.  You receive the following email from one of the students: Dear __________, I understand that you provide consultation services for healthcare organizations who want to be more culturally competent.  My friends and I are joining together...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT