Complete the Cashflow Analysis and Dashboard tab to understand the returns from a particular investment.




Once the data has been filled in the Cashflow analysis, fill in the Sensitivity Analysis of Net Sale Proceeds by Hold Period and Exit Cap Rates. Show 2 +/- 10 months and 2 +/- 1% rate from the base case with the base case in the middle row and column.


USe those foumal. IF

EOMONTH

DATE

YEAR

INT

MONTH

TODAY

SUMIF

Data>What-If Analysis>Data Table


Bonus

IRR

MI