Make a pro forma model for yummy and computer the firm value

Assignment Help Financial Management

Reference no: EM132059690

The following sheet presents the balance sheet and value drivers of Yummy Company, which manufactures a very special tomato sauce. (You might want to copy the table into Excel.)

Yummy Company, Financial Model
Value Drivers
Sales growth	12%
Current assets/Sales	22%
Current liabilities/Sales	20%
Net fixed assets growth rate	5%
Cost of goods sold/sales	45%
Depreciation rate (of average fixed assets at cost)	20%
interest rate on debt	8%
interest earned on cash balances	4%
tax rate	36%
dividend payout ratio	25%
sales	2000000
WACC	16%
long term FCF growth rate	4%

Balance sheet
Cash	460000
Current assets	440000
Fixed Assets
At cost	4000000
Depreciation	500000
Net fixed assets	3500000
total assets	4400000

Current liabilities	400000
Debt	3000000
Stock (1500000 shares, issued at $0.5 each)	750000
accumulated retained earnings	250000
Total Liabilities + Equity	4400000

Additional model assumptions are as follows:

The FCF evaluation is for a 5-year period. In addition, a terminal value should be determined using the long-term FCF growth rate.
The debt principal repayments are $300,000 each year.
Cash is a plug in the model.

a. Make a pro forma model for Yummy and computer the firm value using a DCF valuation model with year-end discounting. (MUST SHOW ALL YOUR WORK ON EXCEL, SHOW ALL YOUR STEPS)

b. Show in a graph the sensitivity of the enterprise value to the growth in sales; . (MUST SHOW ALL YOUR WORK ON EXCEL, SHOW ALL YOUR STEPS)

c. Show in a graph the sensitivity of the enterprise value to the company's WACC. (MUST SHOW ALL YOUR WORK ON EXCEL, SHOW ALL YOUR STEPS)

Reference no: EM132059690

Questions Cloud

Examine should the firm accept the project : What is the NPV for the project if the required return is 7 percent? (Do not round intermediate calculations. Round your answer to 2 decimal places, e.g., 32.16

Determining the arithmetic sequence : The first term, a1, in an arithmetic sequence is 8; the fourth term, a4, is 6. How many terms must be added to have the sum, Sn, of the terms equal 42?

What is the future value of this prize : What is the future value of this prize if each payment is put in an account earning 0.08?

What is the average rate the projectile was traveling : What is the average rate the projectile was traveling in the interval between 1 and 4 seconds?

Make a pro forma model for yummy and computer the firm value : The FCF evaluation is for a 5-year period. In addition, a terminal value should be determined using the long-term FCF growth rate.

Formulate the net present value of the project : A project has profitability index of 1.24 and requires an initial investment of $873,000. Calculate the net present value of the project.

Find the average sales for the first quarter : Find the average sales for the first quarter (0 = t = 3). Round answer to three decimal places.

Discuss how the various loading end conditions affect : Discuss how the various loading end conditions affect the load at breaking and the type of loading. For example, where is the maximum stress predicted

Calculate the carrying value of the assets : Calculate the carrying value of the assets after two years if the company used the double-declining balance method of depreciation

User Account

All Pages