Please Help!

Task 1 ( 30 points): Construct the cash flow proforma statement for the following project by filling out the white cells of the following table. - A 2-year levered equity investment between t=0 and t=2. - The first NOI is 10 at t=1, and NOI grows at 3%/yr. - The cap rate is 5% (going-in) at t=0 and increases by 0.5%/yr to 6% (going-out) at t=2. - Capital Expenditures are 10\% of NOI. - The investment is levered with a two-year, annual-payment CPM at a 4% interest rate with the face value of 80 ( 1 .e., the initial loan amount is 80 ). Cash flow pro forma statement