Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please explain using a financial calculator Anne Hathaway has just bought the Shakespeare Apartments in the growing community of Far Away, Wy. The

image text in transcribed

image text in transcribed

can you please explain using a financial calculator

Anne Hathaway has just bought the Shakespeare Apartments in the growing community of Far Away, Wy. The price was $600,000 or $15,000 per unit. Ms. Hathaway assumed the original mortgage. The performance of the property over the past three years has averaged each year: Rent Revenue (PGI) Less Vacancy & Collection Loss (3%) EGI Less: Operating Expenses NOI $100,000 (3.000) $97,000 (41,560) $55,440 After analyzing the rents of the Essex House and The Raleigh rental properties nearby, Ms. Hathaway feels she can raise the unit rents by $10 per month; however, this will increase the vacancies to 5%. She will then be able to refinance the property and withdraw $140,126.73 of tax-free (actually tax-deferred) monies. (She has a marginal tax rate of 30%.). The mortgage she assumed on purchase was originally $540,000 at 7.5% annual interest payable in level monthly installments over 21 years. The mortgage was eight years old at the time of Ms. Hathaway's purchase. The new mortgage would be for 25 years at 8.5% annual interest payable in level monthly installments, Answer the following questions - showing all steps and calculations - on the Excel spreadsheet numbering each of your answers to relate to the question being answered. Round your answers to two (2) decimal places where appropriate. 12. What was Ms. Hathaway's down payment at time of purchase? 13. What is the net operating income after raising the rents? 14. What is the amount of the new mortgage she could get if she withdraws the money she wants to withdraw? 15. What is the loan-to-value ratio on the new mortgage? 16. What is the increased before tax cash flow under the new mortgage? 17. What is the amount of Ms. Hathaway's equity investment with the new mortgage? 18. What do you believe Ms. Hathaway's equity yield will be (approximately) with the new mortgage? 19. If she refinances, will Ms. Hathaway enjoy positive or negative leverage - explain? 20. Do you think Ms. Hathaway should proceed to refinance the property or wait, why? Anne Hathaway has just bought the Shakespeare Apartments in the growing community of Far Away, Wy. The price was $600,000 or $15,000 per unit. Ms. Hathaway assumed the original mortgage. The performance of the property over the past three years has averaged each year: Rent Revenue (PGI) Less Vacancy & Collection Loss (3%) EGI Less: Operating Expenses NOI $100,000 (3.000) $97,000 (41,560) $55,440 After analyzing the rents of the Essex House and The Raleigh rental properties nearby, Ms. Hathaway feels she can raise the unit rents by $10 per month; however, this will increase the vacancies to 5%. She will then be able to refinance the property and withdraw $140,126.73 of tax-free (actually tax-deferred) monies. (She has a marginal tax rate of 30%.). The mortgage she assumed on purchase was originally $540,000 at 7.5% annual interest payable in level monthly installments over 21 years. The mortgage was eight years old at the time of Ms. Hathaway's purchase. The new mortgage would be for 25 years at 8.5% annual interest payable in level monthly installments, Answer the following questions - showing all steps and calculations - on the Excel spreadsheet numbering each of your answers to relate to the question being answered. Round your answers to two (2) decimal places where appropriate. 12. What was Ms. Hathaway's down payment at time of purchase? 13. What is the net operating income after raising the rents? 14. What is the amount of the new mortgage she could get if she withdraws the money she wants to withdraw? 15. What is the loan-to-value ratio on the new mortgage? 16. What is the increased before tax cash flow under the new mortgage? 17. What is the amount of Ms. Hathaway's equity investment with the new mortgage? 18. What do you believe Ms. Hathaway's equity yield will be (approximately) with the new mortgage? 19. If she refinances, will Ms. Hathaway enjoy positive or negative leverage - explain? 20. Do you think Ms. Hathaway should proceed to refinance the property or wait, why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mergers Acquisitions And Other Restructuring Activities

Authors: Donald DePamphilis

11th Edition

012819782X, 978-0128197820

More Books

Students also viewed these Finance questions

Question

What are the key differences?

Answered: 1 week ago