Question

In: Finance

A company reported the following numbers for the most recent fiscal year: Revenues $3,000 EBITDA $650...

A company reported the following numbers for the most recent fiscal year:

Revenues

$3,000

EBITDA

$650

DA (Depreciation)

$150

EBIT

$500

- Interest Expenses

$50

Taxable Income

$450

Taxes

$135

Net Income

$315

Payout

$157.5

During the year, the company reported capital expenditures of $250 and an increase in net working capital of $40. The tax rate is 30%. Assume that we know the following:
• The company’s FCF will grow at 8% per year for the next five years.
• The company’s current cost of capital is 12%, which will stay at that level for the next 5 years.
• The company maintains a stable dividend policy, i.e., its payout ratio stays the same for all future years.
• At the end of year 5, the company is expected to become a mature business, facing a cost of capital of 8% (mature company levels). It will also maintain a constant debt-to-equity ratio (sustainable growth).
• At the end of year 5, the company is expected to have an ROE of 4%, and an ROA of 3%.

Assume also for simplicity that all cash flows are nominal and risky, and they occur at the end of the periods.

What is the FCF at year 3?                            [ Select ]                       ["$265", "$314", "$245", "None of the above", "$277"]      

Estimate the company’s terminal value at the end of year 5 from future FCFs.                            [ Select ]                       ["None of the above", "3,161", "2,990", "5,284", "4,861"]      

Solutions

Expert Solution

Solution:

FCF at Year 3:

Growth rate = 8%

FCF at year 3 = FCF at year 0 * [ 1+ 8%]3

= 210 * 1.083

=$265

Terminal Value at Year 5:

Terminal Value =[ FCF at year 5 ( 1+growth) ] / (Cost of capital - growth)

Sustainable Growth rate = ROE at year 5 * Retention ratio / [ 1- ( ROE at year 5 * Retention ratio ) ]

retention ratio = 1- Dividend payout ratio

Dividend payout ratio = Dividend payout / Net income = 157.5/315 = 0.5

Therefore, Retention ratio = 1-0.5 = 0.5

ROE = 4%

Sustainable Growth rate = 4% * 0.5 / [ 1- (4%*0.5) ]

= 2% / 0.98% = 2.040816%

Cost of capital = 8% (given)

FCF at year 5 = FCF at year 0 * [ 1+ 8%]5 = 308.59

Applying the values,

Terminal Value = [308.59 ( 1+2.040816%) ] / (8% - 2.040816%)

= 314.88775 / 5.959184%

= $5284


Related Solutions

Starbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year:...
Starbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year: Recent Year (in millions, rounded) Prior Year (in millions, rounded) Americas $9,904 $7,974 China/Asia Pacific 2,396 1,130 Channel Development* 1,731 1,546 EMEA** 1,217 1,295 Other 2,100 1,675 Total $17,348 $13,620 *Sells packaged coffee and teas globally **Europe, Middle East, and Africa a. Prepare a horizontal analysis of the segment data using the prior year as the base year. Round all percents to one decimal...
Johnson Company had the following account balances at the end of the most recent fiscal year:...
Johnson Company had the following account balances at the end of the most recent fiscal year: Cash: $4,300, Accounts Receivable: $1,200, Supplies: $200, Accounts Payable: $700, S. Johnson, Capital: $2,900, S. Johnson, Drawing: $300, Fees Income: $4,900, Rent Expense: $1,300, Advertising Expense: $1,000, Supplies Expense: $200. Assuming that these were the only accounts used by Johnson Company during the year, for which of the following steps in the closing process would a compound entry be necessary? Step 1: Transfer Revenue...
Pepper Company reported revenues of $12,000, supplies expense of $3,000, and net income of $2,000 for...
Pepper Company reported revenues of $12,000, supplies expense of $3,000, and net income of $2,000 for the most recent period. If the company’s only other expense was Rent Expense, what was its balance at the end of the period? Multiple Choice $7,000 $9,000 $14,000 $15,000
Allison & Co. and Bee, Inc. reported the following numbers (in millions) for fiscal year 2014.  ...
Allison & Co. and Bee, Inc. reported the following numbers (in millions) for fiscal year 2014.   Allison & Co. Bee, Inc. Net income $ 595.70 $ 217.24 Shares outstanding 87.17 57.22 Stock price $ 92.59 $ 37.26 Total equity $ 1,738.30 $ 959.48 Calculate the earnings per share, market-to-book ratio, and price–earnings ratio for each company. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Allison & Co. Bee, Inc. Earnings per share $...
Theta Company reported the following for its most recent year of operations, (in millions): Capital expenditures:...
Theta Company reported the following for its most recent year of operations, (in millions): Capital expenditures: $163.10 Net income: $46.10 Depreciation expense: $49.00 Theta Company uses the indirect method of preparing the statement of cash flows. How will these items effect the statement of cash flows?
The Income Statement of XYZ Company for the most recent fiscal year is given below. Its...
The Income Statement of XYZ Company for the most recent fiscal year is given below. Its sales are projected to increase by 20% in the coming year and it always retains 60% of its net income. Use the percentage of sales method to find out the addition to retained earnings amount.   Sales                                                              $40,000 Operating costs                                                   30,000           Earnings before interests and taxes $10,000 Interest expenses                                               1,000    Earnings before taxes                                         $ 9,000   Taxes (40%)                                                      3,600    Net income   ...
Verispace Software sells inventory management software and reported revenues of $25 million in the most recent...
Verispace Software sells inventory management software and reported revenues of $25 million in the most recent financial year. You estimate that the total mar- ket for inventory management software to be $25 billion, growing at 5% a year for the foreseeable future. If you expect Verispace to have 10% market share of this market in 10 years, estimate the compounded revenue growth rate over that period.
Barnes & Noble Inc. reported the following financial information for its last fiscal year (all numbers...
Barnes & Noble Inc. reported the following financial information for its last fiscal year (all numbers in thousands): Revenues $6,839,005 Inventory $1,410,769 A/P $1,374,434 A/R $149,369 AAI 105.21 days APP 100.86 days ACP 8.52 days For the upcoming fiscal year B&N management has set a goal for the company to reduce the average age of inventory to 90 days. What would the impact be on the CCC? The CCC will decrease by 25.14 days The CCC will decrease by 15.21...
The company has revenues of £235million, a gross margin of 47% and an EBITDA margin of...
The company has revenues of £235million, a gross margin of 47% and an EBITDA margin of 1%. Interest costs of £6 million make it loss-making overall. Prepare a summary income statement for the last financial year from the information above, including Revenue, Cost of Goods Sold, Gross Profit, Gross Margin, Overheads, EBITDA, EBITDA Margin, Interest Costs, Net Profit and Net Margin. Your boss wants you to model some of his ideas for improving the business. Closing failing stores. This would...
Apple’s balance sheet for the most recent fiscal year yields the following information related to accounts...
Apple’s balance sheet for the most recent fiscal year yields the following information related to accounts receivable: Accounts Receivable $17,932,000,000 Allowance for Doubtful Accounts 58,000,000 Accounts Receivable, Net $17,874,000,000 Provide several sentences to describe the meaning of each line item and related dollar amount shown above for Accounts Receivable, Allowance for Doubtful Accounts, and Accounts Receivable, Net.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT