Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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)
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
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
Additional model assumptions are as follows:
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)
What is the required return for the overall stock market? What is the required rate of return on a stock with a beta of 1.2?
You deposited $500 each month in to your new IRA account at the beginning of each month. For how many years did you make the payments?
A fast-growing firm recently paid a dividend of $0.55 per share. what is its value today.
An insurance company is analyzing the following three bonds, each with five years to maturity, annual coupon payments.
Calculate the expected number of units to be replaced in each of weeks 1 to 7. What rate of failures can be expected in the long run?
You plan to make a series of annual investments as follows. How much money will you have in your investment fund at the end of year 5 if you earn 8 percent?
What is the degree of operating leverage at the given level of output? What is the degree of operating leverage at the accounting break-even level of output?
EXTERNAL EQUITY FINANCING Coastal Carolina Heating and Cooling Inc. has a 6-month backlog of orders for its patented solar heating system.
Which of the following is NOT true relative to reserve requirements?
Filer Manufacturing has 6 million shares of common stock outstanding. The current share price is $78, and the book value per share is $5. Filer Manufacturing also has two bond issues outstanding. The most recent dividend was $5 and the dividend growt..
Use the free cash flow approach to calculate the value of the firm and the firm’s equity.
Suppose that everything stays the same as was presented in the original problem (for example, the costs each year, the value of the hotel under the two scenarios, and the probability of the city being awarded the franchise) except for two things: Usi..
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd