You are considering the purchase of a small apartment complex, The following assumptions are made: - The purchase price is $1 million. - Potential gross income ( PG) for the first year of operations is projected to be $171,000. - PGlis expected to increase 4 percent per year. - No vacancies are expectod. - Operating expenses are estimoted at 35 percent of effective gross income. Ignore capital expenclitures. - The market value of the investment is expected to increase to $1,169,859 ot the end of 4 years. - Selling expenses will bo 4 percent. - The holding period is four years. - The appropriate unlevered rote of return to discount projected NOS and the projected NSP is 12 percent. - The required levered rate of return is 14 percent. - 70 percent of the acquisition price can be borrowed with a 30 -year, monthly payment mortgago - The onnual interest rate on the mortgage will be 8 percent. - Financing costs wit equal 2 percent of the loan amount. - There are no prepayment penalties. Required: a. Colculate net operating income (NO) for each of the four yeors. Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. a. Calculate net operating income (NO) for each of the four years. Note: Enter your answers in doltars, rather than in miltions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. b. Caiculate the net sale proceeds from the sale of the property. Note: Enter your answers in dollars, rather than in millions of dollars, Do not round intermediate calculations and round your final answer to nearest whole dollsr amount: c. Calculate the net present value of this investment, assuming no mortgage debt. Should you purchase? Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. d. Calculate the unlevered internal rate of roturn of this investment, assuming no debt. Should you purchase? Note: Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (i.e. 0,1234 should be entered as 12.34 ). Calculate the monthly mortgage payment. What is the total per year? Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations. Round your monthly payment answer to two decimal places and the annual payment answer to nearest whole dollar amount. r. Calculate the loan batance at the end of years 1,2,3, and 4 . (Note. The unpaid mortgoge balance ot any time is equal to the present volue of the remaining payments, discounted at the contract rate of interest.) Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. 9. Calculate the amount of principal reduction achieved during each of the four years. Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. h. Calculate the total interest paid during each of the four years. (Remember Debt Service = Principal + Interest.) Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. 1. Calculate the (levered) required initial equity investment. Note: Enter your answers in dollars, rather than in millions of dollars. Round your "Loan amount" answer to 2 decimal places. 3. Calculate the before tax cosh flow (BrCA for each of the four years. Note: Do not round intermediate calculations and round your final answer to nearest whole dollar amount. k. Calculate the before-tax equity reversion (BTER) from the sale of the property. Note: Do not round intermediate calculations and round your final answer to nearest whole dollar amount. 1. Calculate the (levered) net present value of this investment, Should you purchase? Note: Do not round intermediate calculations and round your final answer to nearest whole dollar amount. m. Calculate the (levered) internal rate of return of this investment. Should you purchase? Note: Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (i.e. 0.1234 should be entered as 12,34). n. Calculate, for the first year of operations, the (1) Overall (cap) rate of return. (2) Cosh-on cosh return. (3) Effective gross income multiplier. (4) Debt coverage ratio. Note: Do not round intermediate calculations. Round your final answers to two decimal places. You are considering the purchase of a small apartment complex, The following assumptions are made: - The purchase price is $1 million. - Potential gross income ( PG) for the first year of operations is projected to be $171,000. - PGlis expected to increase 4 percent per year. - No vacancies are expectod. - Operating expenses are estimoted at 35 percent of effective gross income. Ignore capital expenclitures. - The market value of the investment is expected to increase to $1,169,859 ot the end of 4 years. - Selling expenses will bo 4 percent. - The holding period is four years. - The appropriate unlevered rote of return to discount projected NOS and the projected NSP is 12 percent. - The required levered rate of return is 14 percent. - 70 percent of the acquisition price can be borrowed with a 30 -year, monthly payment mortgago - The onnual interest rate on the mortgage will be 8 percent. - Financing costs wit equal 2 percent of the loan amount. - There are no prepayment penalties. Required: a. Colculate net operating income (NO) for each of the four yeors. Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. a. Calculate net operating income (NO) for each of the four years. Note: Enter your answers in doltars, rather than in miltions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. b. Caiculate the net sale proceeds from the sale of the property. Note: Enter your answers in dollars, rather than in millions of dollars, Do not round intermediate calculations and round your final answer to nearest whole dollsr amount: c. Calculate the net present value of this investment, assuming no mortgage debt. Should you purchase? Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. d. Calculate the unlevered internal rate of roturn of this investment, assuming no debt. Should you purchase? Note: Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (i.e. 0,1234 should be entered as 12.34 ). Calculate the monthly mortgage payment. What is the total per year? Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations. Round your monthly payment answer to two decimal places and the annual payment answer to nearest whole dollar amount. r. Calculate the loan batance at the end of years 1,2,3, and 4 . (Note. The unpaid mortgoge balance ot any time is equal to the present volue of the remaining payments, discounted at the contract rate of interest.) Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. 9. Calculate the amount of principal reduction achieved during each of the four years. Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. h. Calculate the total interest paid during each of the four years. (Remember Debt Service = Principal + Interest.) Note: Enter your answers in dollars, rather than in millions of dollars. Do not round intermediate calculations and round your final answer to nearest whole dollar amount. 1. Calculate the (levered) required initial equity investment. Note: Enter your answers in dollars, rather than in millions of dollars. Round your "Loan amount" answer to 2 decimal places. 3. Calculate the before tax cosh flow (BrCA for each of the four years. Note: Do not round intermediate calculations and round your final answer to nearest whole dollar amount. k. Calculate the before-tax equity reversion (BTER) from the sale of the property. Note: Do not round intermediate calculations and round your final answer to nearest whole dollar amount. 1. Calculate the (levered) net present value of this investment, Should you purchase? Note: Do not round intermediate calculations and round your final answer to nearest whole dollar amount. m. Calculate the (levered) internal rate of return of this investment. Should you purchase? Note: Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (i.e. 0.1234 should be entered as 12,34). n. Calculate, for the first year of operations, the (1) Overall (cap) rate of return. (2) Cosh-on cosh return. (3) Effective gross income multiplier. (4) Debt coverage ratio. Note: Do not round intermediate calculations. Round your final answers to two decimal places