XYZ's balance sheet (in million dollars) at the end of year 0 (when acquisition is completed)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
XYZ's balance sheet (in million dollars) at the end of year 0 (when acquisition is completed) will be: Assets Liabilities and equity NWC Revolver paying 7.5% interest Net fixed assets Bank loan paying 8.0% interest Other assets Subordinated debt paying 9.5% interest Total debt Equity Total liabilities and equity Total assets EBIT Taxes @ 34% + Depreciation - Ch.NWC Waldo expects to sell XYZ for an EV/EBITDA multiple of 8 at the end of year 5. The company is not traded but a similar company is: It has no debt and an estimated cost of equity of 13.5%. Waldo has forecasted the following free cash flows (in millions of dollars) over the next 5 years: - 60.0 121.0 26.0 - CAPX = FCF 207.0 Year 0 Year 1 22.7 7.7 21.5 -12.3 10.7 38.1 Year 2 29.8 10.1 13.5 1.9 10.1 21.2 Year 3 37.1 12.6 11.5 4.2 10.4 21.4 Year 4 40.1 13.6 12.1 5.2 11.5 21.9 13.0 80.0 70.0 163.0 44.0 207.0 Year 5 42.1 14.3 12.7 6.1 13.1 21.3 Produce a debt repayment model for the company above over the next 5 years, assuming that (i) the bank loan needs to be repaid in four installments of $20m at the end of year 2, 3, 4, and 5; (ii) the rest of the debt does not need to be repaid over the next 5 years; and (iii) no payment (dividend or share repurchases) can be made to shareholders over the next 5 years. 1 2 EBIT 3 - Taxes @ 34% + Depreciation - Ch.NWC 4 5 6 - CAPX FCF 7 8 9 Debt Repayment model 10 Revolver @ 7.5% 11 Interest payment 12 Tax shield 13 Repayment 14 Year end 15 Bank loan @ 8% 16 Interest payment 17 Tax shield 18 Repayment 19 Year end 20 Sub @ 9.5% 21 Interest payment 22 Tax shield 23 Repayment 24 Year end Year 0 25 26 Cash flow available for debt repayments 27 28 B Year 1 C 22.7 7.7 21.5 -12.3 10.7 38.1 13 80 70 Year 2 D 29.8 10.1 13.5 1.9 10.1 21.2 Year 3 E 37.1 12.6 11.5 4.2 10.4 21.4 Year 4 F 40.1 13.6 12.1 5.2 11.5 21.9 Year 5 G 42.1 14.3 12.7 6.1 13.1 21.3 Question 3 Building on your answers in Question 2: A. Produce a valuation with CCF for the company. State clearly any assumptions you need to make B. Compute the IRR for equity investors 1234 EBIT - Taxes @ 34% + Depreciation 5 - Ch.NWC 6 - CAPX FCF A 7 8 9 CCF 10 EXIT EV (8x EBITDA) 11 Discount rate: A 12 PV(CCF; TA) 13 PV (TV; TA) 14 EV 15 16 ENTRY Equity 17 EXIT Debt 18 EXIT EV 19 EXIT Equity 20 Cash multiple 21 IRR 22 23 Year 0 B 44 ADINE Year 1 C 22.7 7.7 21.5 -12.3 10.7 38.1 Year 2 D 29.8 10.1 13.5 1.9 10.1 21.2 Year 3 E 37.1 12.6 11.5 4.2 10.4 21.4 Year 4 F 40.1 13.6 12.1 5.2 11.5 21.9 G Year 5 42.1 14.3 12.7 6.1 13.1 21.3 H XYZ's balance sheet (in million dollars) at the end of year 0 (when acquisition is completed) will be: Assets Liabilities and equity NWC Revolver paying 7.5% interest Net fixed assets Bank loan paying 8.0% interest Other assets Subordinated debt paying 9.5% interest Total debt Equity Total liabilities and equity Total assets EBIT Taxes @ 34% + Depreciation - Ch.NWC Waldo expects to sell XYZ for an EV/EBITDA multiple of 8 at the end of year 5. The company is not traded but a similar company is: It has no debt and an estimated cost of equity of 13.5%. Waldo has forecasted the following free cash flows (in millions of dollars) over the next 5 years: - 60.0 121.0 26.0 - CAPX = FCF 207.0 Year 0 Year 1 22.7 7.7 21.5 -12.3 10.7 38.1 Year 2 29.8 10.1 13.5 1.9 10.1 21.2 Year 3 37.1 12.6 11.5 4.2 10.4 21.4 Year 4 40.1 13.6 12.1 5.2 11.5 21.9 13.0 80.0 70.0 163.0 44.0 207.0 Year 5 42.1 14.3 12.7 6.1 13.1 21.3 Produce a debt repayment model for the company above over the next 5 years, assuming that (i) the bank loan needs to be repaid in four installments of $20m at the end of year 2, 3, 4, and 5; (ii) the rest of the debt does not need to be repaid over the next 5 years; and (iii) no payment (dividend or share repurchases) can be made to shareholders over the next 5 years. 1 2 EBIT 3 - Taxes @ 34% + Depreciation - Ch.NWC 4 5 6 - CAPX FCF 7 8 9 Debt Repayment model 10 Revolver @ 7.5% 11 Interest payment 12 Tax shield 13 Repayment 14 Year end 15 Bank loan @ 8% 16 Interest payment 17 Tax shield 18 Repayment 19 Year end 20 Sub @ 9.5% 21 Interest payment 22 Tax shield 23 Repayment 24 Year end Year 0 25 26 Cash flow available for debt repayments 27 28 B Year 1 C 22.7 7.7 21.5 -12.3 10.7 38.1 13 80 70 Year 2 D 29.8 10.1 13.5 1.9 10.1 21.2 Year 3 E 37.1 12.6 11.5 4.2 10.4 21.4 Year 4 F 40.1 13.6 12.1 5.2 11.5 21.9 Year 5 G 42.1 14.3 12.7 6.1 13.1 21.3 Question 3 Building on your answers in Question 2: A. Produce a valuation with CCF for the company. State clearly any assumptions you need to make B. Compute the IRR for equity investors 1234 EBIT - Taxes @ 34% + Depreciation 5 - Ch.NWC 6 - CAPX FCF A 7 8 9 CCF 10 EXIT EV (8x EBITDA) 11 Discount rate: A 12 PV(CCF; TA) 13 PV (TV; TA) 14 EV 15 16 ENTRY Equity 17 EXIT Debt 18 EXIT EV 19 EXIT Equity 20 Cash multiple 21 IRR 22 23 Year 0 B 44 ADINE Year 1 C 22.7 7.7 21.5 -12.3 10.7 38.1 Year 2 D 29.8 10.1 13.5 1.9 10.1 21.2 Year 3 E 37.1 12.6 11.5 4.2 10.4 21.4 Year 4 F 40.1 13.6 12.1 5.2 11.5 21.9 G Year 5 42.1 14.3 12.7 6.1 13.1 21.3 H
Expert Answer:
Answer rating: 100% (QA)
ANSWER Question 1 XYZs balance sheet in million dollars at the end of year 0 when acquisition is completed will be Assets Net fixed assets 600 Other a... View the full answer
Related Book For
Auditing An International Approach
ISBN: 978-1259087462
7th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these finance questions
-
Discuss the convergence of the following series and indicate whether it is absolute conver gence: (2) 1 n+cos(n!) n2+1 (6) 2 (-1)", (c) 1 n3 1 n In(n)
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
For each transaction, indicate in which journal it should be recorded. Sales Journal Cash Receipts Journal Purchases Journal Cash Payments Journal General Journal Returned products to a supplier....
-
What are the Four Eras of Commercial Aviation Safety in order from the 1950's to the future?
-
On May 7, 1992, the space shuttle Endeavour was launched on mission STS-49, the purpose of which was to install a new perigee kick motor in an Intelsat communications satellite. The table gives the...
-
Two baseballs from Prob. 7.68 are connected to a rod 7 mm in diameter and 56 cm long, as in Fig. P7.69 What power, in W, is required to keep the system spinning at 400 r/min? Include the drag of the...
-
In October, 2011, the first five transactions of Fines Maid Service, Corp., have been posted to the accounts as follows: Requirements 1. Prepare the journal entries that served as the sources for the...
-
Yummy Cereal Company is offering one toy shovel set for 15 box tops of its cereal. Year-to-date sales have been off, and it is hoped that this offer will stimulate demand. Each shovel set costs the...
-
Will the virtual teams be able to offer global environmental solutions for organizations and society?Explain
-
Provide the missing information. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Item Case 1...
-
An indirect cash flow in analyzing cash flow provided from operations adjusts what? Question options: a) Sales, cost of goods sold, operating expenses, interest expense, and income tax expense b)...
-
A contribution income statement for the Nantucket Inn is shown below. (Ignore income taxes.) Revenue Less: Variable expenses Contribution margin. Less: Fixed expenses. Net income $500,000 300,000...
-
Bergo Bay's accounting system generated the following account balances on December 31. The company's manager knows something is wrong with this list of balances because it does not show any balance...
-
What are the five efforts of a customer relationship management tools that are used to understand and influence customer behavior in order to improve customer acquisitions, retention, loyalty, and...
-
Customer equity refers to OA. the total annual revenue attributed to the brand's value OB. the value associated with a product line extension OC. the value of the customer relationships that the...
-
Your company wants to improve its customer service operations. Management has decided to compare your organization to Nordstrom which is know for its 'best in class' service. What this is called?
-
In law, there are exceptions to the general rules that exist. In certain types of crimes (offenses), the proving of the elements is not required. In 20 lines or less, name, describe, and define what...
-
What is master production scheduling and how is it done?
-
What qualitative considerations are related to the concept of materiality in auditing? Why are qualitative factors more important than the quantitative materiality level decision?
-
In the audit risk model, inherent risk (IR) refers to a. the probability that managements internal controls do not catch a misstatement once it has occurred. b. The probability that a material...
-
Explain the difference between compliance and VFM audits.
-
Prove: 'Bernoulli's equation is a restrictive form of energy equation'.
-
What are the assumption made for the establishment of Bernoulli's equation?
-
A shell and tube heat exchanger is used to cool lubricating oil by water at the rate of \(120 \mathrm{~kg} / \mathrm{min}\). The oil enters the heat exchanger at \(343 \mathrm{~K}\) and leaves at...
Study smarter with the SolutionInn App