Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
image text in transcribed
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

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

Finance And Financial Intermediation

Authors: Harold L. Cole

1st Edition

0190941707, 978-0190941703

More Books

Students also viewed these Finance questions