Part A

Your task is to build a standard Discounted Cash Flow model.

Replace all blue cells with formulas to make your model automated$/$dynamic$.$

Your model should calculate the correct cash flows for the assumptions specified in the yellow input cells.

Part B

Build a two$-$way data table for NPV$,$ with discount rate and cap rate as your variables.

$\backslash$table$[[$Assumptions$],[$Year I Net Operating Income $($NOI$),900,000],[$Going$-$In Yield,$9\mathrm{.}50\%$