Upload your response as a word or pdf file using the 'Browse My Computer' button below....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Upload your response as a word or pdf file using the 'Browse My Computer' button below. You manage an investment portfolio which has an acquisition mandate. For any new acquisitions to meet board approval, they will have to meet strict internal return benchmarks. Your fund has the following investment objectives: • Office sector, with a focus on CBD fringe buildings on the East Coast of Australia. • Achieve total returns in excess of 10% per annum. A new investment analyst has prepared the attached DCF for a property that his friend currently has listed. His accompanying report is recommending the fund to buy this property at a price of $12.1m. The boss has asked you to go over this cash flow and tell her if you agree with the recommendation given. You have already checked that the tenancy details and OPEX are correct and you agree with the analysts treatment of vacancy, however you have a number of concerns with the cash flow and recommendation provided. Your task is to: (a) Identify 5.key errors in this cash flow and explain why you do not agree with the methodology/assumptions adopted. (15 marks) (b) Recalculate the cash flow based on your findings in (a). (15 marks) (C) Based on your findings.from (b), what NPV and IRR would this property achieve if the first analyst's purchase price is used? (6 marks) (d) Make a recommendation to your boss based on your findings in (a), (b) and (c) above. (4 marks) Other intormation that may be relevant to your assessment: • The fund makes all its acquisition assessments before finance and taxation. • The fund maintains a 60% LVR with a long-term facility locked in at 8%. • The analyst did not get his degree from QUT. • Show all workings or relevant steps in your answers. Be sure to state any assumptions made. A typical office building Rental income Tenants Floor Gross Rent/m² PGI area Newsagent 45 $625 $28,125 Bank 258 $525 $135,450 3 Bănk 600 $300 $180,000 600 $300 $180,000 4 Bank 260 $350 $91,000 Professionals 325 $375 $121,875 6 Vacant $325 $195,000 600 7 Legal firm to $325 $195,000 600 Legal firm $375 $112,500 300 Vacant 2. Potential Gross Income (PGI) $1,345,825 Vacancy Bad Debt Allowance VDBA (* see additional input table data to follow for details) $111,896 Estimated Gross Income (EGI) $1,233,929 Expenditures year 1 OPEX Unit Rate $m2 Total Insurance $3.89 $15,066 Air Conditioning $4.48 $17,351 Building supervision $2.20 $8,521 Total energy $12.64 $48,955 Fire protection $1.05 $4,067 Lifts & escalators $4.20 $16,267 $14,717 Repairs & maintenance $3.80 $2.60 $10,070 Security Garbage $0.35 $1,356 $3.55 $13,749 All other Operating Expenses $3.40 $13,168 General fees Other Expeenses Car parking $1.25 $4,841 Cleaning $12.95 $50,155 Statutory Charges Municipal rates $11.25 $43,571 Water rates $14.40 $55,771 Land tax $13.42 $51,976 Total OPEX $369,600 0$ $864,329 Replacement reserves Net Operating Income (year 1) Assume a five-year holding period Other Income (Ol) = zero Year 1 VBDA = 6 months vacancy in tenancy 6, and 4 months vacancy in tenancy 9, plus a provision for collection losses @ 19% of PGI. VBDA for the remainder of the holding period will be in line with market forecasts @ 4.75% p.a. Rent is at market level and annual CPI rent reviews are in place for all tenancies. The 4.25% applicable rent escalation rate across the holding period is estimated @ p.a. Replacement Reserves (RR) of $50,000 in year 5 are projected to partially replace the oldest portion of the roof. $50,000 year 5 The applicable OPEX escalation rate across the holding period is forecast @ 4.00% p.a. The terminal capitalisation rate is estimated @ 8.50% Risk Free Rate (based on 5-year Government Bond yield) 4.75% Risk Premium 4.25% 3.00% Acquisition costs 4.00% Sales costs DCF VALUATION FOR SUBJECT PROPERTY Year 2 4. Gross Income $1,345,825 $1,403,023 $1,462,651 $1,524,814 $1,589,618 OI (Other Income) $0 $0 $0 $0 $0 VBDA $111.896 $66.644 $69,476 $72.429 $75.507 Subtotal $1,233,929 $1,336,379 $1,393,175 $1,452,385 $1,514,111 Expenses ОРЕХ -$369,600 -$384,384 -$399,760 -$415,750 $432,380 $0 s0 RR (Replacement Reserves) $0 $0 Total Expenses -$369,600 -$384,384 -$399.760 -$415.750 -$432,380 $993,415 Net Operating Income $864,329 $951,995 $1.036,635 $1,081,731 Net Sale Price $12,726,250 Total Net Income $864,329 $951,995 $993,415 $1,036,635 $13,807,981 PV of Cash Flow = $12.069.954 VBDA $111,896 $66.644 $69.476 $72.429 $75.507 Subtotal $1,233,929 $1,336,379 $1,393,175 $1,452,385 $1,514,111 Expenses ОРЕХ $369,600 -$384,384 -$399,760 -$415,750 -$432,380 RR (Replacement Reserves) $0 $0 $0 $0 $0 Total Expenses -$369,600 -$384,384 -$399,760 $415.750 $432.380 Net Operating $864,329 $951,995 $993,415 $1,036,635 $1,081,731 Income Net Sale Price $12,726,250 Total Net Income $864,329 $951,995 $993,415 $1,036,635 $13,807,981 PV of Cash Flow = $12,069,954 Maximum recommended $12,100,000 purchase price = Upload your response as a word or pdf file using the 'Browse My Computer' button below. You manage an investment portfolio which has an acquisition mandate. For any new acquisitions to meet board approval, they will have to meet strict internal return benchmarks. Your fund has the following investment objectives: • Office sector, with a focus on CBD fringe buildings on the East Coast of Australia. • Achieve total returns in excess of 10% per annum. A new investment analyst has prepared the attached DCF for a property that his friend currently has listed. His accompanying report is recommending the fund to buy this property at a price of $12.1m. The boss has asked you to go over this cash flow and tell her if you agree with the recommendation given. You have already checked that the tenancy details and OPEX are correct and you agree with the analysts treatment of vacancy, however you have a number of concerns with the cash flow and recommendation provided. Your task is to: (a) Identify 5.key errors in this cash flow and explain why you do not agree with the methodology/assumptions adopted. (15 marks) (b) Recalculate the cash flow based on your findings in (a). (15 marks) (C) Based on your findings.from (b), what NPV and IRR would this property achieve if the first analyst's purchase price is used? (6 marks) (d) Make a recommendation to your boss based on your findings in (a), (b) and (c) above. (4 marks) Other intormation that may be relevant to your assessment: • The fund makes all its acquisition assessments before finance and taxation. • The fund maintains a 60% LVR with a long-term facility locked in at 8%. • The analyst did not get his degree from QUT. • Show all workings or relevant steps in your answers. Be sure to state any assumptions made. A typical office building Rental income Tenants Floor Gross Rent/m² PGI area Newsagent 45 $625 $28,125 Bank 258 $525 $135,450 3 Bănk 600 $300 $180,000 600 $300 $180,000 4 Bank 260 $350 $91,000 Professionals 325 $375 $121,875 6 Vacant $325 $195,000 600 7 Legal firm to $325 $195,000 600 Legal firm $375 $112,500 300 Vacant 2. Potential Gross Income (PGI) $1,345,825 Vacancy Bad Debt Allowance VDBA (* see additional input table data to follow for details) $111,896 Estimated Gross Income (EGI) $1,233,929 Expenditures year 1 OPEX Unit Rate $m2 Total Insurance $3.89 $15,066 Air Conditioning $4.48 $17,351 Building supervision $2.20 $8,521 Total energy $12.64 $48,955 Fire protection $1.05 $4,067 Lifts & escalators $4.20 $16,267 $14,717 Repairs & maintenance $3.80 $2.60 $10,070 Security Garbage $0.35 $1,356 $3.55 $13,749 All other Operating Expenses $3.40 $13,168 General fees Other Expeenses Car parking $1.25 $4,841 Cleaning $12.95 $50,155 Statutory Charges Municipal rates $11.25 $43,571 Water rates $14.40 $55,771 Land tax $13.42 $51,976 Total OPEX $369,600 0$ $864,329 Replacement reserves Net Operating Income (year 1) Assume a five-year holding period Other Income (Ol) = zero Year 1 VBDA = 6 months vacancy in tenancy 6, and 4 months vacancy in tenancy 9, plus a provision for collection losses @ 19% of PGI. VBDA for the remainder of the holding period will be in line with market forecasts @ 4.75% p.a. Rent is at market level and annual CPI rent reviews are in place for all tenancies. The 4.25% applicable rent escalation rate across the holding period is estimated @ p.a. Replacement Reserves (RR) of $50,000 in year 5 are projected to partially replace the oldest portion of the roof. $50,000 year 5 The applicable OPEX escalation rate across the holding period is forecast @ 4.00% p.a. The terminal capitalisation rate is estimated @ 8.50% Risk Free Rate (based on 5-year Government Bond yield) 4.75% Risk Premium 4.25% 3.00% Acquisition costs 4.00% Sales costs DCF VALUATION FOR SUBJECT PROPERTY Year 2 4. Gross Income $1,345,825 $1,403,023 $1,462,651 $1,524,814 $1,589,618 OI (Other Income) $0 $0 $0 $0 $0 VBDA $111.896 $66.644 $69,476 $72.429 $75.507 Subtotal $1,233,929 $1,336,379 $1,393,175 $1,452,385 $1,514,111 Expenses ОРЕХ -$369,600 -$384,384 -$399,760 -$415,750 $432,380 $0 s0 RR (Replacement Reserves) $0 $0 Total Expenses -$369,600 -$384,384 -$399.760 -$415.750 -$432,380 $993,415 Net Operating Income $864,329 $951,995 $1.036,635 $1,081,731 Net Sale Price $12,726,250 Total Net Income $864,329 $951,995 $993,415 $1,036,635 $13,807,981 PV of Cash Flow = $12.069.954 VBDA $111,896 $66.644 $69.476 $72.429 $75.507 Subtotal $1,233,929 $1,336,379 $1,393,175 $1,452,385 $1,514,111 Expenses ОРЕХ $369,600 -$384,384 -$399,760 -$415,750 -$432,380 RR (Replacement Reserves) $0 $0 $0 $0 $0 Total Expenses -$369,600 -$384,384 -$399,760 $415.750 $432.380 Net Operating $864,329 $951,995 $993,415 $1,036,635 $1,081,731 Income Net Sale Price $12,726,250 Total Net Income $864,329 $951,995 $993,415 $1,036,635 $13,807,981 PV of Cash Flow = $12,069,954 Maximum recommended $12,100,000 purchase price =
Expert Answer:
Answer rating: 100% (QA)
Here are the full calculations with workings a Key errors identified 15 points explained above b Rec... View the full answer
Related Book For
Financial Accounting Information For Decisions
ISBN: 978-0324672701
6th Edition
Authors: Robert w Ingram, Thomas L Albright
Posted Date:
Students also viewed these accounting questions
-
You are an analyst for an investment fund that invests in initial public offerings (IPOs). You are looking at the financial statements of two companies, Clark Company and Durfee Company, that plan to...
-
You are an analyst for an investment fund that invests in initial public offerings (IPOs). You are looking at the financial statements of two companies, Clark Company and Durfee Company, that plan to...
-
Your boss has asked you to analyze and report on your division's sales for the first nine months of this year. Using the following data from company invoices, calculate the mean for each quarter and...
-
For nearly 50 years, Loganville Window Treatments (LWT) of Loganville, Georgia, has made interior shutters that are sold through decorating centers. Figure 3.20 shows some of the various styles of...
-
Should gains and losses on a fair value hedge be recorded as they occur, or should they be recorded to coincide with losses and gains on the item being hedged?
-
Calculate the stagnation temperature and pressure for the following substances flowing through a duct: (a) Helium at 0.25 MPa, 500C, and 240 m/s; (b) Nitrogen at 0.15 MPa, 500C, and 300 m/s; and (c)...
-
You are processing halibut livers that contain approximately \(25.2 \mathrm{wt} \%\) fish oil and \(74.8 \mathrm{wt} \%\) insoluble solids. The following data for leaching fish oil from halibut...
-
BigBoy Equipment Inc. sells heavy- duty forklit trucks. Model 217A has a stand- alone price of $ 140,000. BigBoy offers to sell the 217A inclusive of a three- year service contract for $ 180,000....
-
read from the following journal article (only sections 5.2-5.4): Yu Gong, Yan Jiang & Fu Jia (2021): Multiple multi-tier sustainable supply chain management: a social system theory perspective,...
-
Letang Company has three divisions (R, S, and T), organized as decentralized profit centers. Division R produces the basic chemical Ranbax (in multiples of 1,000 pounds) and transfers it to Divisions...
-
An aluminum wire of unknown length has a diameter of 0.28 cm and a resistance of 0.193 ohm. By several successive passes through drawing dies the radius of the wire is reduced to 0.078 cm. Assuming...
-
Muntjac Corporation's WACC is 14% and its tax rate is 40%. Muntjac's pre-tax cost of debt is 15% and it's debt-equity ratio is 1:2. If the risk-free rate is 9% and the market rate of return is 12%,...
-
14. What is meant by maturity intermediation? (LG 1-6)
-
Find the linear approximation to, about k=64. f(k) = 120k/3
-
Assume a bank has agreed to lend Milly and Martin McDonald $150,000 to purchase an apartment. The period of the mortgage is 20 years and the current interest rate is 6.5 percent. How much will their...
-
Case study. The establishment of CSE and its subsequent development is in line with national policy and strategy, defined by the Swedish agency NUTEK. Its activities are now incorporated into...
-
Manipulators without parameters are part of the --------header file. O iostream O iomanip O Lfstream O pmanip
-
On July 1, 2011, Flashlight Corporation sold equipment it had recently purchased to an unaffiliated company for $480,000. The equipment had a book value on Flashlights books of $390,000 and a...
-
How do we account for operating activities? This chapter considered the estimation and reporting of revenues and expenses. A companys income statement is affected by estimates of sales returns,...
-
The Book Wermz purchases books for all of its stores through a central purchasing department. Books are then shipped to different stores for sale. One of the companys largest selling items is an...
-
How is it possible that profits can increase by 40% when sales increase by a much smaller amount?
-
Sand Corporation has the following shares outstanding: 10,000 shares of \(\$ 40\) par value, ten percent preferred stock and 50,000 shares of \(\$ 2\) par value common stock. The company has \(\$...
-
The Crystal Company had \(100,000,000\) shares of \(\$ 0.10\) par value common stock outstanding which had been sold for an aggregate amount of \(\$ 500,000,000\). The company's shares are traded on...
-
Mammoth Corporation has 100,000 shares of \(\$ 10\) par value common stock outstanding. At year-end, the company declares a five percent stock dividend. The market price of the stock on the...
Study smarter with the SolutionInn App