Answered

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



Answer :

Other Questions