Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This needs to be on an excel sheet! and this is considered as 1 whole question, I checked. Also, can you explain how you got
This needs to be on an excel sheet! and this is considered as 1 whole question, I checked.
Also, can you explain how you got the NOI and why did you put it in that order? Because I have to cell reference all of the information. THANK YOU SO SO MUCH
Financial Model Group Assignment A real estate broker is offering an apartment building for sale that has the following characteristics: a. The asking price is $3.5M, with land valued at $500,000. b. The 160 apartment units rent for $450 per month with rent expected to increase by 4% per year starting at year 2. C. Vacancy and bad debt allowance is 6% of the potential gross income. d. Operating expenses are expected to be 32% of effective gross income. e. The real estate agent estimates that the value of the property, net of selling expenses, will be $4.4M at the end of a five-year investment horizon. f. A 12%, 20-year mortgage for $2M is available with monthly payments. g. The cost recovery allowance recapture rate is 25%. h. The investor's ordinary income tax rate is 28%. i. The investor's capital gain tax rate is 15%. j. The appropriate discount rate for this investment (required return) is 18%. Calculate the relevant cash flows for this investment and apply the NPV and IRR rules to decide whether to pursue this project. Financial Model Group Assignment A real estate broker is offering an apartment building for sale that has the following characteristics: a. The asking price is $3.5M, with land valued at $500,000. b. The 160 apartment units rent for $450 per month with rent expected to increase by 4% per year starting at year 2. C. Vacancy and bad debt allowance is 6% of the potential gross income. d. Operating expenses are expected to be 32% of effective gross income. e. The real estate agent estimates that the value of the property, net of selling expenses, will be $4.4M at the end of a five-year investment horizon. f. A 12%, 20-year mortgage for $2M is available with monthly payments. g. The cost recovery allowance recapture rate is 25%. h. The investor's ordinary income tax rate is 28%. i. The investor's capital gain tax rate is 15%. j. The appropriate discount rate for this investment (required return) is 18%. Calculate the relevant cash flows for this investment and apply the NPV and IRR rules to decide whether to pursue this projectStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started