please show formulas s0 i can check my work

A B C D E F G H 1 Rate of increase Year 2 Year 3 Year 4 Year 5 5% 15.75 18.23 2 3 Parameters 4 Cost/ft? 5 Estate size 6 Rent / ft? 7 Operating expense / ft? 8 Vacancy rate 9 Percent financed 10 Mortgage rate 11 Sale multiple 12 Cost of capital 13 14 Cash Flow 6% -4% Year 1 1 $90.00 200,000 $15.00 $1.20 30% 85% 12% 12 10% 1.27 0.26 16.54 1.35 0.22 17.36 1.43 0.18 1.51 0.14 Year 1 Year 2 Year 3 Year 3 Year Year 4 Year 5 Years 15 16 17 18 Gross income Operating expense Net operating income Interest cost Before-tax cash flow 19 Down payment (at time 0) Sale price 20 21 22 23 24 25 26 Net Present Value (NPV) 27 Mortgage cost End of year cash flows