Use a 3-year holding period to decide whether or not this is a financially feasible investment....

  

Transcribed Image Text:

Use a 3-year holding period to decide whether or not this is a financially feasible investment. Compute the before-tax NPV and IRR. Comment on your final on your calculations as to whether the investment is worthwhile. Please do all your calculations, including NPV and IRR in Excel. You cannot do your calculations using a financial calculator and input your answers in Excel. BEFORE TAX INVESTMENT ANALYSIS OF AN APARTMENT BUILDING Use a 3 year holding period to decide whether or not this is a financially feasible investment. INPUTS NUMBER OF UNITS RENT RENT GROWTH VACANCY RATE FIXED EXPENSES VARIABLE EXPENSES RESERVES FOR REPLACEMENT FIXED EXPENSE GROWTH VARIABLE EXPENSE GROWTH RESERVE ACCOUNT 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 5 $900 3.50% 6.00% $4,500.00 $6,000.00 $4,000.00 3.00% 3.00% 3.50% 14.00% $350,000 75% $262,500 6.00% 30 Years 15.00% 5% 3 Use a 3-year holding period to decide whether or not this is a financially feasible investment. Compute the before-tax NPV and IRR. Comment on your final on your calculations as to whether the investment is worthwhile. Please do all your calculations, including NPV and IRR in Excel. You cannot do your calculations using a financial calculator and input your answers in Excel. BEFORE TAX INVESTMENT ANALYSIS OF AN APARTMENT BUILDING Use a 3 year holding period to decide whether or not this is a financially feasible investment. INPUTS NUMBER OF UNITS RENT RENT GROWTH VACANCY RATE FIXED EXPENSES VARIABLE EXPENSES RESERVES FOR REPLACEMENT FIXED EXPENSE GROWTH VARIABLE EXPENSE GROWTH RESERVE ACCOUNT 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 5 $900 3.50% 6.00% $4,500.00 $6,000.00 $4,000.00 3.00% 3.00% 3.50% 14.00% $350,000 75% $262,500 6.00% 30 Years 15.00% 5% 3

Answer rating: 100% (QA)

To calculate the beforetax NPV and IRR we will need to calculate the cash inflows and outflows of th... View the full answer