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 $12,000.00 $6,000.00 3.00% 3.00% 3.50% 6.00% $1,200,000 80% 3.50% 30 YEARS 15.00% 6% 3