help
QUESTION 6 Question 6 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 analyst's 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 information that may be relevant to your assessment: Save A Click Save and Submit to save and submit. Click Save All Answers to save all answers. W de 8868451 Remaining Time: 2 hours, 26 minutes, 01 second. Question Completion Status: Other information 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 Gross Rent/m2 PGI Floor area m2 1 Newsagent 45 $625 $28,125 2 Bank 258 $525 $135,450 3 Bank 600 $300 $180,000 4 Bank 600 $300 $180,000 $350 $91,000 U 260 Professionals $375 6 325 $121,875 Vacant 600 $325 $195,000 7 Legal firm 7 $325 $195,000 600 8 Legal firm 300 $375 $112,500 9 Vacant Click Save and Submit to save and submit. Click Save All Answers to save all answers. Rental income Tenants Floor area Gross Rent/m2 PGI 1 Newsagent 45 $625 $28,125 N Bank 258 $525 $135,450 3 Bank 600 $300 $180,000 4 Bank 600 $300 $180,000 Professionals 260 $350 $91,000 6 Vacant 325 $375 $121,875 7 Legal firm 600 $325 $195,000 8 600 $325 $195,000 Legal firm 300 $375 $112,500 9 Vacant 285 $375 $106,875 10 ABC Marketing Total NLA 3,873 $1,345,825 Potential Gross Income (PGI) Vacancy Bad Debt Allowance $111,896 VDBA (* see additional input tabl data to follow for details) Gumit to me and suhmit. Click Save All Answers to save all answers. 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 $4.48 $17,351 Air Conditioning Building supervision $2.20 $8,521 Total energy $12.64 $48,955 $1.05 $4,067 Fire protection Lifts & escalators $4.20 $16,267 $3.80 $14,717 Repairs & maintenance Security $2.60 $10,070 $0.35 $1,356 Garbage All other Operating Expenses $3.55 $13,749 $3.40 $13,168 General fees Wher Expenses 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 Replacement reserves $0 Net Operating Income $864,329 (year 1) Input data and additional information for multi-year operating statement Assume a five-year holding.period Other Income (OI) = zero Year 1 VBDA = 6 months vacancy in tenancy 6, and 4 months vacancy in tenancy 9, plus a provision for collection losss @ 1% 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 applicable rent escalation rate across the holding period is estimated @ 4.25% p.a. Renlacement Reserves (RRY of $50 000 in vear 5 are nroiected to nartialhe renlace the oldest 450 000 Near 5 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Assume a five-year holding period Other Income (OI) = zero Year 1 VBDA = 6 months vacancy in tenancy 6, and 4 months vacancy in tenancy 9, plus a provision for collection losses @ 1% of PGI. VBDA for the remainder of the holding period will be in line with market forecasts @ Rent is at market level and annual CPI rent reviews are in place for all tenancies. The applicable rent escalation rate across the holding period is estimated @ 4.75% P.a. 4.25% 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 @ The terminal capitalisation rate is estimated @ Risk Free Rate (based on 5-year Government Bond yield) 4.00% p.a. 8.50% Risk Premium 4.7596 Acquisition costs 4.25% Sales costs 3.00% 4.00% DCF VALUATION FOR SUBJECT PROPERTY Year 7 2 3 4 5 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Question Completion Status: DCF VALUATION FOR SUBJECT PROPERTY Year 1 2 3 4 5 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 Subtotal $72,429 $75,507 $1,233,929 $1,336,379 $1,393,175 $1,452,385 $1,514,111 Expenses OPEX -$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 Income $864,329 $951,995 $993,415 $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 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Question Completion Status: VBDA $111,896 $66,644 $69,476 Subtotal $72,429 $75,507 $1,233,929 $1,336,379 $1,393,175 $1,452,385 Expenses $1,514,111 OPEX -$369,600 -$384,384 $399,760 -$415,750 -$432,380 RR (Replacement Reserves) $0 $0 $0 $0 $0 $369,600 $384,384 -$399,760 Total Expenses Net Operating Income $415,750 -$432,380 $864,329 $951,995 $993,415 $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 $12,100,000 Maximum recommended purchase price Attach File Browse My Computer QUESTION 6 Question 6 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 analyst's 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 information that may be relevant to your assessment: Save A Click Save and Submit to save and submit. Click Save All Answers to save all answers. W de 8868451 Remaining Time: 2 hours, 26 minutes, 01 second. Question Completion Status: Other information 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 Gross Rent/m2 PGI Floor area m2 1 Newsagent 45 $625 $28,125 2 Bank 258 $525 $135,450 3 Bank 600 $300 $180,000 4 Bank 600 $300 $180,000 $350 $91,000 U 260 Professionals $375 6 325 $121,875 Vacant 600 $325 $195,000 7 Legal firm 7 $325 $195,000 600 8 Legal firm 300 $375 $112,500 9 Vacant Click Save and Submit to save and submit. Click Save All Answers to save all answers. Rental income Tenants Floor area Gross Rent/m2 PGI 1 Newsagent 45 $625 $28,125 N Bank 258 $525 $135,450 3 Bank 600 $300 $180,000 4 Bank 600 $300 $180,000 Professionals 260 $350 $91,000 6 Vacant 325 $375 $121,875 7 Legal firm 600 $325 $195,000 8 600 $325 $195,000 Legal firm 300 $375 $112,500 9 Vacant 285 $375 $106,875 10 ABC Marketing Total NLA 3,873 $1,345,825 Potential Gross Income (PGI) Vacancy Bad Debt Allowance $111,896 VDBA (* see additional input tabl data to follow for details) Gumit to me and suhmit. Click Save All Answers to save all answers. 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 $4.48 $17,351 Air Conditioning Building supervision $2.20 $8,521 Total energy $12.64 $48,955 $1.05 $4,067 Fire protection Lifts & escalators $4.20 $16,267 $3.80 $14,717 Repairs & maintenance Security $2.60 $10,070 $0.35 $1,356 Garbage All other Operating Expenses $3.55 $13,749 $3.40 $13,168 General fees Wher Expenses 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 Replacement reserves $0 Net Operating Income $864,329 (year 1) Input data and additional information for multi-year operating statement Assume a five-year holding.period Other Income (OI) = zero Year 1 VBDA = 6 months vacancy in tenancy 6, and 4 months vacancy in tenancy 9, plus a provision for collection losss @ 1% 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 applicable rent escalation rate across the holding period is estimated @ 4.25% p.a. Renlacement Reserves (RRY of $50 000 in vear 5 are nroiected to nartialhe renlace the oldest 450 000 Near 5 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Assume a five-year holding period Other Income (OI) = zero Year 1 VBDA = 6 months vacancy in tenancy 6, and 4 months vacancy in tenancy 9, plus a provision for collection losses @ 1% of PGI. VBDA for the remainder of the holding period will be in line with market forecasts @ Rent is at market level and annual CPI rent reviews are in place for all tenancies. The applicable rent escalation rate across the holding period is estimated @ 4.75% P.a. 4.25% 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 @ The terminal capitalisation rate is estimated @ Risk Free Rate (based on 5-year Government Bond yield) 4.00% p.a. 8.50% Risk Premium 4.7596 Acquisition costs 4.25% Sales costs 3.00% 4.00% DCF VALUATION FOR SUBJECT PROPERTY Year 7 2 3 4 5 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Question Completion Status: DCF VALUATION FOR SUBJECT PROPERTY Year 1 2 3 4 5 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 Subtotal $72,429 $75,507 $1,233,929 $1,336,379 $1,393,175 $1,452,385 $1,514,111 Expenses OPEX -$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 Income $864,329 $951,995 $993,415 $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 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Question Completion Status: VBDA $111,896 $66,644 $69,476 Subtotal $72,429 $75,507 $1,233,929 $1,336,379 $1,393,175 $1,452,385 Expenses $1,514,111 OPEX -$369,600 -$384,384 $399,760 -$415,750 -$432,380 RR (Replacement Reserves) $0 $0 $0 $0 $0 $369,600 $384,384 -$399,760 Total Expenses Net Operating Income $415,750 -$432,380 $864,329 $951,995 $993,415 $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 $12,100,000 Maximum recommended purchase price Attach File Browse My Computer
