Question
In: Finance
Tiara Wings Ltd is a firm that makes Tiaras and chicken wings. The firm has projected...
Tiara Wings Ltd is a firm that makes Tiaras and chicken wings. The firm has projected its future growth in the table below. The firm has a required Return on Equity of 15% and WACC of 12%, the long-run growth rate after year 5 is 4%. The firm has $5 million in debt and 865,000 shares outstanding. The accounting statement is in thousands of $. Assuming that the projections are correct, compute the stock price per share using:
a) the WACC/FCF method
b) the Flow-to-Equity method
|
Latest |
||||||||
|
Year |
Forecast |
|||||||
|
-1 |
0 |
1 |
2 |
3 |
4 |
5 |
||
|
1. |
Sales |
39,357.0 |
40,123.0 |
36,351.0 |
30,155.0 |
28,345.0 |
29,982.0 |
30,450.0 |
|
2. |
Cost of Goods Sold |
18,564.0 |
22,879.0 |
21,678.0 |
17,560.0 |
16,459.0 |
15,631.0 |
14,987.0 |
|
3. |
Other Costs |
7,645.0 |
8,025.0 |
6,797.0 |
5,078.0 |
4,678.0 |
4,987.0 |
5,134.0 |
|
4. |
EBITDA (1 – 2 – 3) |
13,148.0 |
9,219.0 |
7,876.0 |
7,517.0 |
7,208.0 |
9,364.0 |
10,329.0 |
|
5. |
Depreciation and Amortization |
5,745.0 |
5,678.0 |
5,890.0 |
5,670.0 |
5,908.0 |
6,107.0 |
5,908.0 |
|
6. |
EBIT (pretax profit) (4 – 5) |
7,403.0 |
3,541.0 |
1,986.0 |
1,847.0 |
1,300.0 |
3,257.0 |
4,421.0 |
|
7. |
Tax at 35% |
2,591.1 |
1,239.4 |
695.1 |
646.5 |
455.0 |
1,140.0 |
1,547.4 |
|
8. |
Profit after Tax (6 – 7) |
4,811.0 |
2,301.7 |
1,290.9 |
1,200.6 |
845.0 |
2,117.1 |
2,873.7 |
|
9. |
Change in Working Capital |
566.0 |
784.0 |
-54.0 |
-342.0 |
-245.0 |
127.0 |
235.0 |
|
10. |
Investment (change in gross PP&E) |
6,467.0 |
6,547.0 |
7,345.0 |
5,398.0 |
5,470.0 |
6,420.0 |
6,598.0 |
Solutions
jeff jeffy answered 2 years agoRelated Solutions
Ruff, Inc. makes dog food out of chicken and grain. Chicken has 10 grams of protein...
Ruff, Inc. makes dog food out of chicken and grain.
Chicken has 10 grams of protein and 5 grams of fat per ounce, and
grain has 2 grams of protein and 2 grams of fat per ounce. A bag of
dog food must contain at least 248 grams of protein and at least
158 grams of fat. If chicken costs 11¢ per ounce and grain costs 1¢
per ounce, how many ounces of each should Ruff use in each bag...
Ruff, Inc. makes dog food out of chicken and grain. Chicken has 10 grams of protein...
Ruff, Inc. makes dog food out of chicken and grain. Chicken has
10 grams of protein and 5 grams of fat per ounce, and grain has 2
grams of protein and 2 grams of fat per ounce. A bag of dog food
must contain at least 220 grams of protein and at least 180 grams
of fat. If chicken costs 11¢ per ounce and grain costs 1¢ per
ounce, how many ounces of each should Ruff use in each bag...
Joe is going to a buffet that allows him to eat as many chicken wings as he wants at a fixed price.
Joe is going to a buffet that allows him to eat as many chicken wings as he wants at a fixed price. How would you predict the number of chicken wings that Joe will eat using utility theory?
Grand Swell Company produces three types of high-fat guy food – chicken wings, meatballs, and meat...
Grand Swell Company produces three types of high-fat guy food –
chicken wings, meatballs, and meat sticks. For some unknown reason,
the company can sell all it produces of any of the products. Profit
is limited only by a special machine through which all of the
products must pass. Unit sales and cost data for the three products
are as follows:
Wings
Meat Balls
Meat Sticks
Sale Price
$10
$12
$15
Direct Materials Cost/Unit
3
2
3
Direct Labor Cost/Unit...
Siyi Ltd is a specialist engineering firm that makes four products, for which the following information...
Siyi Ltd is a specialist engineering firm that makes four
products, for which the following information is available:
A B C D
Selling price per unit £100 £64 £54 £62
Variable cost per unit £50 £40 £42 £30
Weekly demand (units) 40 70 50 80
Machine hours per unit 5 2 3 4
Due to a recent market boom, demand is now outstripping the
capacity of its plant, which is constrained to 500 hours machine
time per week. In the...
Firm X has the opportunity to invest $200,000 in a new venture. The projected cash flows...
Firm X has the opportunity to invest $200,000 in a new venture.
The projected cash flows from the venture are as follows. Use
Appendix A and Appendix B. Year 0 Year 1 Year 2 Year 3 Initial
investment $ (200,000 ) Revenues $ 40,000 $ 40,000 $ 40,000
Expenses (25,000 ) (7,000 ) (7,000 ) Return of investment 200,000
Before-tax net cash flow (200,000 ) $ 15,000 $ 33,000 $ 233,000
Firm X uses an 8 percent discount rate, and...
Firm W has the opportunity to invest $150,000 in a new venture. The projected cash flows...
Firm W has the opportunity to invest $150,000 in a new venture.
The projected cash flows from the venture are as follows.
Year 0
Year 1
Year 2
Year 3
Initial investment
$
(150,000)
After-tax cash flow
$
5,000
$
8,000
$
10,000
Return of investment
150,000
Net cash flow
$
(150,000)
$
5,000
$
8,000
$
160,000
a-1. Complete the below table to calculate NPV.
Assume Firm W uses a 6 percent discount rate.
Complete the below table to...
Australia has only one firm that makes aircraft. Without assistance from the government, that firm has...
Australia has only one firm that makes aircraft. Without
assistance from the government, that firm has lost most of its
business to imports from the United States and Europe. Which of the
following policies would be most costly for the Australian nation
as a whole, and which would be least costly? Explain.
Policy A: Paying the lone Australian firm a production
subsidy per plane, without protecting it against
imports.
Policy B: Imposing a tariff equal to the production
subsidy in...
if a firm makes negative economic profit, then the firm A) has total revenues greater than...
if
a firm makes negative economic profit, then the firm
A) has total revenues greater than its economic costs
B) can be earned positive accounting profit
C) must have no fixed costs
D) must shut down immediately
A firm has projected free cash flows of $175,000 for Year 1, $200,000 for Year 2,...
A firm has projected free cash flows of $175,000 for Year 1,
$200,000 for Year 2, and 225,000 for Year 3, $250,000 for Year 4,
and 300,000 for Year 5. The projected terminal value at the end of
Year 5 is $600,000. The firm's Weighted Average cost of Capital
(WACC) is 10.5%.
Microsoft® Excel® document to determine the Discounted Cash Flow
(DCF) value of the firm based on the information provided above.
Show calculations.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Journal Entries and Trial Balance Elite Realty acts as an agent in buying, selling, renting, and...
- In racket Assume that the elements of a list are indexed starting with 1. Write a...
- Describe System Development Life Cycle (SDLC) and how it is used.
- What symbolism do you find in the play,Oedipus?
- • Using the Scanner class to obtain input from the user. • Using printf to output...
- In each of the following situations, develop a tentative plan for the client. List the various...
- MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
ADVERTISEMENT