Frozen Turkeys Scenario
Cost of Land $ 200,000
Cost of Buildings & Equipment $ 350,000
MACRS Class 20
Life of Project (Years) 5
Terminal Value of Land $ 300,000
Terminal Value of Buildings & Equipment $ 175,000
First year sales (pounds) 250,000
Price per Pound $3.50
Unit Sales Growth Rate 7.0%
Variable Costs as % of Sales 62%
Fixed Costs 75,000
Tax Rate 35%
WACC 10.0%
a. Prepare a statement of annual cash flows for years 0 through 5. Cash flows in year 0 are your expenses for building and land.
Sales growth is based on the annual growth rate in units.
Assume no changes in fixed or variable costs.
Depreciate the project cost for 5 years, with the cash flow in year 5 to include the terminal cash flow of ending the investment.
b. Calculate the NPV,
c. profitability index,
d. IRR,
e. MIRR,
f. payback and
g. discounted payback of the cash flows
h Using scenario manager find best case, worst case, base case of NPV based on sales in pounds, price per pound, and variable cost percent. Make sure to include scenario summary.
Frozen Turkeys Scenario
Cost of Land $ 200,000
Cost of Buildings & Equipment $ 350,000
MACRS Class 20
Life of Project (Years) 5
Terminal Value of Land $ 300,000
Terminal Value of Buildings & Equipment $ 175,000
First year sales (pounds) 250,000
Price per Pound $3.50
Unit Sales Growth Rate 7.0%
Variable Costs as % of Sales 62%
Fixed Costs 75,000
Tax Rate 35%
WACC 10.0%
a. Prepare a statement of annual cash flows for years 0 through 5. Cash flows in year 0 are your expenses for building and land.
Sales growth is based on the annual growth rate in units.
Assume no changes in fixed or variable costs.
Depreciate the project cost for 5 years, with the cash flow in year 5 to include the terminal cash flow of ending the investment.
b. Calculate the NPV,
c. profitability index,
d. IRR,
e. MIRR,
f. payback and
g. discounted payback of the cash flows
h Using scenario manager find best case, worst case, base case of NPV based on sales in pounds, price per pound, and variable cost percent. Make sure to include scenario summary.
Related questions
Suppose that you are approached with an offer to purchase an investment that will provide cash flows of $1,300 per year for 15 years. The cost of purchasing this investment is $9,200. You have an alternative investment opportunity, of equal risk, that will yield 9% per year. What is the NPV that makes you indifferent between the two options?
___________________________________________________________________
10. The Claustrophobic Solution, Inc., a residential window and door manufacturer, has the following historical record of earnings per share (EPS) from 2011 to 2007:
| 2011 | 2010 | 2009 | 2008 | 2007 | |
| EPS | $1.10 | $1.05 | $1.00 | $0.95 | $0.90 |
The companyâs payout ratio has been 60% over the last five years and the last quoted price of the firmâs share of stock was $12. Flotation costs for new equity will be 6%. The company has 32,000,000 of common shares of stock outstanding and a debt-equity ratio of 0.5.
If dividends are expected to grow at the same arithmetic average growth rate of the last five years, what is the dividend payment in 2012?
_________________________________________________________________________-
11. The following are the company sales from 2000-2009
| Year | Xylophone |
| 1 | $230 |
| 2 | $573 |
| 3 | $994 |
| 4 | $1,683 |
| 5 | $3,192 |
| 6 | $6,140 |
| 7 | $10,624 |
| 8 | $16,549 |
| 9 | $21,975 |
Fit an exponential trend curve to the data and
Calculate the projected sales in 2010,
2011,
2012.
________________________________________________________________________________________
12. THE FINAL PROBLEM IS A CALCULATION PROBLEM with multiple parts
Frozen Turkeys Scenario
Cost of Land $ 210,000
Cost of Buildings & Equipment $ 325,000
MACRS Class 20
Life of Project (Years) 5
Terminal Value of Land $ 315,000
Terminal Value of Buildings & Equipment $ 170,000
First year sales (pounds) 250,000
Price per Pound $3.40
Unit Sales Growth Rate 7.5%
Variable Costs as % of Sales 65%
Fixed Costs 72,000
Tax Rate 33%
WACC 10.5%
a. Prepare a statement of annual cash flows for years 0 through 5. Cash flows in year 0 are your expenses for building and land.
Sales growth is based on the annual growth rate in units.
Assume no changes in fixed or variable costs.
Depreciate the project cost for 5 years, with the cash flow in year 5 to include the terminal cash flow of ending the investment.
b. Calculate the NPV,
c. profitability index,
d. IRR,
e. MIRR,
f. payback and
g. discounted payback of the cash flows
h Using scenario manager find best case, worst case, base case of NPV based on sales in pounds, price per pound, and variable cost percent. Make sure to include scenario summary.
Capstone Quarry is analyzing whether a new contract proposal will be a good idea. The relevant data is shown below. The net working capital will be paid in the same time period as the cost of the equipment and will be recovered at the end of the project. Remember to calculate the after-tax gain or loss of salvage as part of your terminal cash flow.
| Capstone Quarry Company Contract Analysis | |
| Amount of Rock Salt per Year | 23,000 Tons |
| Revenue per Ton | $ 145 |
| Cost of Equipment | $ 2,750,000 |
| Life(years) | 5 |
| MACRS Class | 5 |
| Fixed Cost per year | $ 475,000 |
| Var Cost/Ton | $ 85 |
| Actual Salvage | $ 105,000 |
| Change in NWC | $ 85,000 |
| Required Return | 12% |
| Tax Rate | 34% |
Find the cash flows for each year
Net present value
Payback period
Discounted payback
IRR
MIRR
Hint:
| Annual Cash Flows for Capstone Quarry | ||||||
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Initial Outlay | ||||||
| Unit Sales | ||||||
| Sales | ||||||
| Variable Costs | ||||||
| Fixed Costs | ||||||
| Depreciation | ||||||
| Taxable Cash Flows | ||||||
| Taxes | ||||||
| Add: Depreciation | ||||||
| Annual After-Tax Cash Flow | ||||||
| Terminal Cash Flow | ||||||
| Total Annual Cash Flows | ||||||
Use the following data for the remaining problems.
Capstone Quarry is analyzing whether a new contract proposal will be a good idea. The relevant data is shown below. The net working capital will be paid in the same time period as the cost of the equipment and will be recovered at the end of the project. Remember to calculate the after-tax gain or loss of salvage as part of your terminal cash flow.
| Capstone Quarry Company Contract Analysis | |
| Amount of Rock Salt per Year | 23,000 Tons |
| Revenue per Ton | $ 145 |
| Cost of Equipment | $ 2,750,000 |
| Life(years) | 5 |
| MACRS Class | 5 |
| Fixed Cost per year | $ 475,000 |
| Var Cost/Ton | $ 85 |
| Actual Salvage | $ 105,000 |
| Change in NWC | $ 85,000 |
| Required Return | 12% |
| Tax Rate | 34% |
20) Find the cash flows for each year
21) Net present value
22) Payback period
23) Discounted payback
24) IRR
25) MIRR
Hint:
| Annual Cash Flows for Capstone Quarry | ||||||
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Initial Outlay | ||||||
| Unit Sales | ||||||
| Sales | ||||||
| Variable Costs | ||||||
| Fixed Costs | ||||||
| Depreciation | ||||||
| Taxable Cash Flows | ||||||
| Taxes | ||||||
| Add: Depreciation | ||||||
| Annual After-Tax Cash Flow | ||||||
| Terminal Cash Flow | ||||||
| Total Annual Cash Flows | ||||||
