please show formulas so i can check my work thanks!!!

D E F G H 1 Year 1 Year 2 Year 2 Year 3 Year 3 Year 4 Year 5 $90.00 200,000 $15.00 $1.20 30% 85% 12% 12 10% Year 1 Year 2 Year 3 Year 4 Year 5 A B 1 Is it worth investing in a real estate? 2 3 Parameters Rate of increase 4 Cost / ft 5 Estate size 6 Rent/ft? 5% 7 Operating expense / ft? 6% 8 Vacancy rate -4% 9 Percent financed 10 Mortgage rate 11 Sale multiple 12 Cost of capital 13 14 Cash Flow 15 Gross income 16 Operating expense 17 Net operating income 18 Interest cost 19 Before-tax cash flow 20 21 Down payment (at time 0) 22 Sale price 23 Mortgage cost 24 End of year cash flows 25 26 Net Present Value (NPV) 27 28 29 20 Template Ready