As an analyst working for Bunhill Investment Ltd, you are asked to assess the viability of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As an analyst working for Bunhill Investment Ltd, you are asked to assess the viability of the purchase of The Geary Office Park, which is for sale with an asking price of 32,150,000. You have been presented with the partially completed cashflow below: Growth Vacancy PGI Vacancy & Collection EGI Opex Year 0 Net Operating Income Capital -32,150,000 Before Debt Net CF -32,150,000 Year 1 Year 2 Year 3 Year 4 1.00% 4.00% 1.00% 4.00% 2.00% 4.00% 2.00% 4.00% 2,444,100 2,468,541 2,493,226 -139,875 -98,742 -99,729 2,304,225 2,369,799 2,393,497 -305,513 -308,568 -311,653 1,998,713 2,061,232 2,081,844 1,998,713 2,061,232 2,081,844 Using a 4 year investment time horizon and assuming that income growth and vacancy continue at the rates indicated and that Opex continues at the same percentage rate as year 3, complete the currently blank before debt net cash flow for year 4. For the capital value at sale, you may assume the asset is sold at a yield of 5.75% based on the year 4 net operating income. Assuming initial market yields for this type of property in this location are 6.50%, is this asset at purchase, underpriced, overpriced or priced about right? (Ignore purchasers' costs and sales costs) Assuming you can obtain a bank loan from a senior lender, which has a full amortisation period of 25 years, an all in interest rate of 5.10% (which includes the credit margin), with a debt service cover ratio covenant in year 1 of 1.50x net operating income and no arrangement fees. Use the before debt net cashflow line for years 0 to 4 (which includes your answer from part a, for year 4) as your starting point to: produce a 4 year after debt net cash flow from year 0 to the end of year 4. calculate the mortgage constant, an initial loan to value (LTV) in year 0 and exit loan to value (LTV) at the end of year 4. Using the information provided and your completed ungeared and geared cashflows together with any further assumptions you deem necessary, calculate the following metrics for this property and discuss the implications of each of your solutions and who might be interested in each metric and why? Bank Exit Ratio Cash on Cash Return year 1 Breakeven Ratio in year 1 As an analyst working for Bunhill Investment Ltd, you are asked to assess the viability of the purchase of The Geary Office Park, which is for sale with an asking price of 32,150,000. You have been presented with the partially completed cashflow below: Growth Vacancy PGI Vacancy & Collection EGI Opex Year 0 Net Operating Income Capital -32,150,000 Before Debt Net CF -32,150,000 Year 1 Year 2 Year 3 Year 4 1.00% 4.00% 1.00% 4.00% 2.00% 4.00% 2.00% 4.00% 2,444,100 2,468,541 2,493,226 -139,875 -98,742 -99,729 2,304,225 2,369,799 2,393,497 -305,513 -308,568 -311,653 1,998,713 2,061,232 2,081,844 1,998,713 2,061,232 2,081,844 Using a 4 year investment time horizon and assuming that income growth and vacancy continue at the rates indicated and that Opex continues at the same percentage rate as year 3, complete the currently blank before debt net cash flow for year 4. For the capital value at sale, you may assume the asset is sold at a yield of 5.75% based on the year 4 net operating income. Assuming initial market yields for this type of property in this location are 6.50%, is this asset at purchase, underpriced, overpriced or priced about right? (Ignore purchasers' costs and sales costs) Assuming you can obtain a bank loan from a senior lender, which has a full amortisation period of 25 years, an all in interest rate of 5.10% (which includes the credit margin), with a debt service cover ratio covenant in year 1 of 1.50x net operating income and no arrangement fees. Use the before debt net cashflow line for years 0 to 4 (which includes your answer from part a, for year 4) as your starting point to: produce a 4 year after debt net cash flow from year 0 to the end of year 4. calculate the mortgage constant, an initial loan to value (LTV) in year 0 and exit loan to value (LTV) at the end of year 4. Using the information provided and your completed ungeared and geared cashflows together with any further assumptions you deem necessary, calculate the following metrics for this property and discuss the implications of each of your solutions and who might be interested in each metric and why? Bank Exit Ratio Cash on Cash Return year 1 Breakeven Ratio in year 1
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
hi, please help me complete and show all necessary steps, calculations and explanations. thanks, will upvote! P8-6 (Algo) Defining and Analyzing Changes in Current Liabilities LO8-1 International...
-
7) The second financial statement to prepare is the statement of retained eamings. To determine the ending balance of retained earnings you need to start with the opening balance as reported in the...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Assume that a grower of flower bulbs sells its annual output of bulbs to an Internet retailer for $70,000. The retailer, in turn, brings in $160,000 from selling the bulbs directly to final...
-
How is market pull R&D different from technological push R&D?
-
What is the heat effect when 150(lbm) of H2SO4 is mixed with 350(lbm) of an aqueous solution containing 25-wt-% H2SO4 in an isothermal process at 100(F)?
-
Bradley, Inc., considers importing its supplies from either Canada (denominated in C$) or Mexico (denominated in pesos) on a monthly basis. The quality is the same for both sources. Once the firm...
-
Use the information in RES-7. Calculate Uncle Butchs Hunting Supply Shops ending inventory' using the retail inventory method under the lower of average cost or market assumption. Round the...
-
A curve is defined by the parametric equations x(t)=2cos(t)-2 and y(t)=-4sin(-t). Draw this graph by using the draggable points.
-
Describe and Explain two practical examples of supply chain strategy ?
-
Creighton Company reported the following on its income statement for the year: Line Item Description Amount Interest expense $ 6 0 0 , 0 0 0 Income before income tax expense 2 , 2 0 0 , 0 0 0 What is...
-
Learning is enhanced when you take time to reflect on the process. a one-page reflection that answers the questions given. APA is recommended but not required. The process of preparing and writing a...
-
Shandra Corporation (a U.S.-based company) expects to order goods from a foreign supplier at a price of 105,000 pounds, with delivery and payment to be made on June 15. On April 15, when the spot...
-
A slug with a mass of m = 13.5 g is fired out of a gun that has length L = 0.72 m. The slug spends t = 0.11 s in the barrel. (a) Write an expression, in terms of the given quantities, for the...
-
3. Ginger is an economics graduate student who has only Php 100 stipend a month. Suppose that Ginger decides to stick to a diet by eating only apples and bananas in the fixed ratio of 2 quantities of...
-
Write an essay on decision biases. Discuss any THREE (3) decision biases that you have committed. How did you commit these biases? ow have the biases affect you. How could you avoid these biases in...
-
In a nonmagnetic medium, E = 50 cos (10 9 t 8x) a y + 40 sin (10 9 t 8x) a z V/m find the dielectric constant r and the corresponding H.
-
Identify the issues related to performance evaluation using DCF models.
-
Identify relevant cash flows for DCF analyses.
-
Andrea Boss, Inc. is interested in using its activity-based costing system to improve its operating efficiency and its profit margins by applying activity-based management techniques. As part of this...
Study smarter with the SolutionInn App