P5-7. Elsa Company shared the following prospective financial information to approximate price that should be set...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
P5-7. Elsa Company shared the following prospective financial information to approximate price that should be set if the investor buys out 15% share in a group of private equity investors. You were tasked to compute for the Elsa Company. Revenues Variable COGS Fixed COGS Gross profit Variable operating expenses Fixed operating expenses Operating income 2021 2022 2023 2024 2025 2,250,000 2,750,000 3,250,000 3,500,000 4,000,000 562,500 687,500 812,500 875,000 1,000,000 750,000 750,000 750,000 750,000 750,000 937,500 1,312,500 1,687,500 1,875,000 2,250,000 450,000 550,000 650,000 700,000 800,000 200,000 200,000 200,000 200,000 200,000 287,500 975,000 1,250,000 562,500 837,500 Other pertinent assumptions can be found below. . Depreciation of P500,000 is included in fixed cost of goods sold while P100,000 of depreciation is charged to fixed operating expenses. Income tax rate is at 20% • Elsa Company estimates it needed P200,000 cash on an annual basis to sustain its capital investments. • From 2026 until perpetuity, the company estimates net cash flows to grow at constant rate of 4%. • Elsa Company has debt-to-equity ratio of 1.5. Pre-tax cost of debt is at 4% while cost of equity is at 9%. • Elsa Company has outstanding loans of PhP2,000,000. Compute for the following: 1. Weighted average of cost of capital of Elsa Company 2. Net income from 2021 to 2025 3. Terminal value of Elsa Company 4. Net cash flow to the firm 5. Net cash flow to equity 6. Price to pay to buy 15% share in Elsa Company. P5-7. Elsa Company shared the following prospective financial information to approximate price that should be set if the investor buys out 15% share in a group of private equity investors. You were tasked to compute for the Elsa Company. Revenues Variable COGS Fixed COGS Gross profit Variable operating expenses Fixed operating expenses Operating income 2021 2022 2023 2024 2025 2,250,000 2,750,000 3,250,000 3,500,000 4,000,000 562,500 687,500 812,500 875,000 1,000,000 750,000 750,000 750,000 750,000 750,000 937,500 1,312,500 1,687,500 1,875,000 2,250,000 450,000 550,000 650,000 700,000 800,000 200,000 200,000 200,000 200,000 200,000 287,500 975,000 1,250,000 562,500 837,500 Other pertinent assumptions can be found below. . Depreciation of P500,000 is included in fixed cost of goods sold while P100,000 of depreciation is charged to fixed operating expenses. Income tax rate is at 20% • Elsa Company estimates it needed P200,000 cash on an annual basis to sustain its capital investments. • From 2026 until perpetuity, the company estimates net cash flows to grow at constant rate of 4%. • Elsa Company has debt-to-equity ratio of 1.5. Pre-tax cost of debt is at 4% while cost of equity is at 9%. • Elsa Company has outstanding loans of PhP2,000,000. Compute for the following: 1. Weighted average of cost of capital of Elsa Company 2. Net income from 2021 to 2025 3. Terminal value of Elsa Company 4. Net cash flow to the firm 5. Net cash flow to equity 6. Price to pay to buy 15% share in Elsa Company.
Expert Answer:
Answer rating: 100% (QA)
Answer 1 WACC 55 2 Net Income P000 2021 2022 2023 2024 2025 Net Income 230 450 670 780 1000 3 Termin... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A group of private equity investors provided $16 million to a start-up company involved in making high-technology detection systems for drugs and other types of contraband. Immediately after the...
-
An asset manager is making the valuation exercise of "Uppy" equity shares. The asset manager's estimation of the Free Cash Flow to Firm (FCF) for the period 2021-2025 is illustrated in Table 2. Table...
-
Find the most recent 10k (annual report filed with the SEC) for your chosen company Update the project spreadsheet so the headings (the dates on the columns) represent the most recent years that...
-
Posting the entries from the sales journal to the accounts receivable subsidiary ledger should be done ______. a). at the end of each month b). on a weekly basis c). on a daily basis d). only at the...
-
Word Wizard is a publishing company with a number of different book lines. Each line has contracts with a number of different authors. The company also owns a printing operation called Quick Press....
-
Five batch jobs. A through E, arrive at a computer center at almost the same time. They have estimated running times of 10, 6, 2, 4, and 8 minutes. Their (externally determined) priorities are 3, 5,...
-
(MIRR) For the question above, if your reinvestment or financing rate is 15%, what is the modified IRR?
-
Temco, Inc., conveyed to the Wynns certain property adjoining an apartment complex being developed by Sonnett Realty Company. Although nothing to this effect was contained in the deed, the sales...
-
6 Find the value of the integral f (ac ) dac if you know that J3 2 2 f (a) dac = -3 and f(x) dx = 5. J3 6 Answer: f(x ) dx = 13
-
Sherina Smith (Social Security number 785-23-9873) lives at 536 West Lapham Street, Milwaukee, WI 53204, and is self-employed for 2019. She estimates her required annual estimated tax payment for...
-
Triangle ABC has the property that ZA+ LB = ZC. Find the measure of ZC in degrees.
-
What does it mean to say that a game has been solved? How likely is it that games like Go and chess will ever be solved? Is it always the case that the player who goes first will win a game that has...
-
A single-stage, continuous steam distillation of 1-octanol at \(760.0 \mathrm{~mm} \mathrm{Hg}\) with liquid water present distills \(1.0 \mathrm{kmol} / \mathrm{h}\) of a feed of \(90.0...
-
To understand how two-pressure distillation works, in Lab 7 plot \(\mathrm{y}-\mathrm{x}\) diagrams (from Aspen Plus Analysis) for MEK versus water (plot MEK mole fractions) at \(1.0 \mathrm{~atm}\)...
-
A water and n-butanol mixture is separated in a stripping column with a partial reboiler. The feed \((\mathrm{F}=100 \mathrm{kmol} / \mathrm{h}, \mathrm{z}=0.65\) [mole fraction water], saturated...
-
\(200.0 \mathrm{kmol} / \mathrm{h}\) of saturated vapor feed, \(80.0 \mathrm{~mol} \%\) water and \(20.0 \mathrm{~mol} \%\) n-butanol, is condensed and sent to a decanter. The water layer is the...
-
Determine all solutions for the following equations.sec(?) = -2/?3
-
Which, if any, of the dichloroethene molecules drawn in Data Table II (3.) (4.) and (5.) are geometric isomers? A. B. C. D. cis-1,2-dichloroethene and trans-1,2-dichloroethene...
-
The IT department allocates indirect costs to user departments on the basis of CPU time at the rate of $2000 per second. For the first quarter, the two heaviest-use departments logged 900 and 1300...
-
In an effort to reduce pipe breakage, water hammer, and product agitation, a chemical company plans to install several chemically resistant pulsation dampeners. The cost of the dampeners today is...
-
The cash flow associated with making self-locking fasteners is shown below. Determine the net present worth (year 0) at an interest rate of 10% peryear. Year 02 3 4 5 6 78 9 Income, 1000 20 20 20 20...
-
During 20x7, Arizona Company issued $500,000 in long-term bonds at 96, repaid $75,000 of bonds at face value, paid interest of $40,000, and paid dividends of $25,000. Prepare the cash flows from the...
-
Lower of Cost and Net Realizable Value} Meredith's Appliance Store has the following data for the items in its inventory at the end of the accounting period: \section*{Required:} 1. Compute the...
-
Assuming the indirect method is used to prepare the statement of cash flows, tell whether each of the following items would appear (a) in cash flows from operating activities, (b) in cash flows from...
Study smarter with the SolutionInn App