FIN704 Real Estates & Property Analysis

Your company is considering the acquisition of the newly constructed 28-storey building in McGregor Road, Suva. The company aims to take possession of the property on 01/01/2021. You have been given the responsible to carry out a feasibility analysis and report your findings to the Board in form of a report. The purchase price of the property is $100 million. The current rent roll is provided in Exhibit 1. In addition to rental income, the property produces $80/month for each of 250 garage spaces and $40/month for each of 250 car park spaces. The laundry facility on the property produces $25/unit/month. Themarket vacancy rate is 8% and the property loses 1.5% in collection losses annually. The property's current expenses related to the apartment units are provided in Exhibit 2. The Property also has three commercial tenants, details provided in Exhibit 3.

Assume that income and expenses will increase at the expected rate of inflation, 3.5% per year, for the duration of a six-year holding period. The acquisition will be financed with a 75 percent loan to value ratio, 9% annual interest rate, 25 year, fixed monthly payment mortgage. The loan has a 3% fee and a 5% prepayment penalty.

You estimate future selling price by capitalizing future NOI at 12%. In addition, the owner will have to pay a 1.5% sales commission when the property is sold in six years. For tax purposes, assume land value is 20 percent of the purchase price. The property will be depreciated using straight line-depreciation over 50 years. The investor's ordinary income is taxed at 25% and capital gains are taxed at the prevailingrate.

NB:

i.Leases are "Gross lease" with service charge for common areas (recoverable from tenants) being the same for next 10 years

ii.Estimated Annual CPI Rates: 2021(3%), 2022 (2.5%), 2023 (3.50%) 2024(2.75%)

2025(2.15%) 2026(3.15%) 2027(4.00%)

iii.Tax: Assess balancing charge/deduction at year of disposition. For capital gains use Fiji rate.

Based on the information provided:

a)Prepare the full DCF for the 6 year term.

b)Calculate the property's value using the DCF approach assuming discount rate at property level is 20%.

c)Calculate the after-tax net-present value (NPV) and internal rate of return (IRR).