please make sure to add the formula in put in excel to get the correct answer. thanks

BEFORE TAX INVESTMENT ANALYSIS OF AN APARTMENT BUILDING Complete before tax investment analysis by filling out the cells highlighted in green. Determine whether this is a financially feasible investment by computing the IRR and NPV of this investment Comment on your reasons why this investment is/is not worthwhile. INPUTS NUMBER OF UNITS RENT RENT GROWTH VACANCY RATE FIXED EXPENSES VARIABLE EXPENSES RESERVES FOR REPLACEMENT FIXED EXPENSE GROWTH VARIABLE EXPENSE GROWTH RESERVES GROWTH APPRECIATION (TOTAL FOR HOLDING PERIOD) ACQUISITION PRICE LOAN TO VALUE RATIO LOAN AMOUNT MORTGAGE INTEREST RATE LOAN PAYMENT - MONTHLY LOAN TERM INVESTOR'S REQUIRED RATE OF RETURN SELLING COST HOLDING PERIOD - YEARS 10 $900 3.50% 6.00% $9.500.00 S12.000.00 S6,000.00 3.00% 3.00% 3.50% 6.00% $1.200.000 80% 3.50% 30 YEARS 15.00% 6% 3 Before Tax Investment Analysis Complete before tax investment analysis for the project for which the investment data is given. Determine whether this is a financially feasible investment by computing the IRR and NPV of this investment. Comment on your reasons why this investment is/is not worthwhile. Do all your calculations, including NPV and IRR, in Excel. No point will be awarded if you use a financial calculator and copy over your answers from calculators to Excel