Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help on the third pic, cell B5. Please show any functions used, cells referenced, and all work please. 1 Canhow Analvis 2 Unievered
I need help on the third pic, cell B5. Please show any functions used, cells referenced, and all work please.
1 Canhow Analvis 2 Unievered Aefore Tax Cosh How 8 Property Information 9 Property Name Broadmore Apartments 10 Purchase Price $5,750,000 11 12 Unit Mix 13 Unit Type 14 1BR/1BA 152BR/1.5BA 163BR/2BA 17 Total 18 Annual Rent (PGI) \# Monthly Rent 19 20 Operating Information 21 Monthly Other Income Per Unit 22 Annual Other Income 23 Annual Rent/Income Increase \% 40 $675 24 Vacancy and Collection Loss \% 40 $895 25 OPEX \% of EGI 25 $950 26 27 Investor Criteria 28 Target Yield (Discount Rate) 12.00% 29 Holding Period 30 Terminal OAR 5 70 9.25% 71 72 73 74 75 \begin{tabular}{ll|r|} & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } \\ \hline 1 & Reversion & \\ 2 & Unlevered Before Tax Reversion & \\ 3 & NOI & $937,467 \\ 4 & Terminal OAR & 9.25% \\ \hline 5 & Anticipated Sale Price & \\ \hline 6 & Less: Cost of Sale (4\%) & \\ 7 & Net Proceeds from Sale & $10,134,774 \\ \hline 55 & & \end{tabular} Step 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