Excel Question
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →REIT Investment Summary Portfolio Cap Rate Calculation Distribution Northeast South East South Mid West West California Total Price Analysis NOI or SF 0 0 0 0 0 0 0 % of Total #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Applicable Cap Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Net Asset Value (NAV) Calculation 2023 2022 2021 NAV #DIV/0! #DIV/0! #DIV/0! NAV Per Share #DIV/0! #DIV/0! #DIV/0! *Use your portfolio cap rate for each respective year’s NOI Historical Performance Land & Cons $0 $0 $0 Debt & Pref Shares $0 $0 $0 NOI Analysis Revenues $0 $0 $0 -Operating Expenses $0 $0 $0 -Real Estate Taxes $0 $0 $0 Total Exp $0 $0 $0 NOI (excl. fee inc.) $0 $0 $0 y-o-y NOI Growth #DIV/0! #DIV/0! Shares outstanding 0 *Shares outstanding should be weighted average number of common shares outstanding Weighted Avg #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Price Shares outstanding Equity Market Cap Debt Preferreds Enterprise Value Recent $0.00 0 $0 $0 0 $0 Debt/Equity Low $0 0.00% $0 #DIV/0! #DIV/0! $0 #DIV/0! #DIV/0! 20% Base $0 10.00% $0 #DIV/0! #DIV/0! $0 #DIV/0! #DIV/0! 50% NAV PS (weighted) #DIV/0! #DIV/0! #DIV/0! (Equity/EV) (inverse of above) GAV/NAV 2023 NOI Forward NOI Growth 2024 NOI Cap Rate GAV Debt & Other NAV NAV PS WEIGHT Implied Cap Rate 2024 NOI EV Implied Cap Rate $0 $0 #DIV/0! High $0 15.00% $0 #DIV/0! #DIV/0! $0 #DIV/0! #DIV/0! 30%
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds
