Waldo Entertainment Products, Inc. is negotiating with Disney for the rights to manufacture and sell superhero-themed toys for a three-year period. At the end of year 3, Waldo plans to liquidate the assets from the project. In addition to the facts and assumptions below, assume that working capital must be invested immediately (in year 0) and will be fully recovered at the end of year 3, and that no incremental overhead expense will be incurred from the project. Note that the difference between the selling price of the equipment at the end of year 3 and the equipment's book value at the time of the sale is a taxable gain. Identify the relevant cash flows, then calculate the investment’s net present value, benefit-cost ratio, and internal rate of return.
Step 1:Calculation of Working capital requirement.
Working Capital= (Account Receivable+Inventories-Account Payable)
= ($60000+$40000-$25000)
=$75000.
Step 2:Calculation of depreciation.
Depreciation=Initial Cost-Salvage Value / useful Life of asset
=($250000-$50000)/5 Years.
=$40,000
Step 3:Final Answer.
Purticulers | 0 | 1 | 2 | 3 |
---|---|---|---|---|
Initial Investment | -$250,000 | 0 | 0 | $150000 |
Working Capital Required(Note-1) | -$75000 | 0 | 0 | $75,000 |
Total | -$325,000 | 0 | 0 | $225,000 |
2 Profitability Statement
Purticulers | 0 | 1 | 2 | 3 |
---|---|---|---|---|
Sales | 350000 | 350000 | 350000 | |
Less:Cost Of goods Sold | 170000 | 170000 | 170000 | |
Gross Profit | 180000 | 180000 | 180000 | |
Less:Selling and administative Expenses | 55000 | 55000 | 55000 | |
Operating Income | 125000 | 125000 | 125000 | |
Depreciation(note 2) | 40000 | 40000 | 40000 | |
Income Before Tax | 85000 | 85000 | 85000 | |
Less:TAx@25% | 21250 | 21250 | 21250 | |
Income after TAx | 63750 | 63750 | 63750 | |
Free Cash Flow (See working Note 4) | -325000 | 103750 | 103750 | 328750 |
Discounting factor@14% | 1 | 0.8772 | 0.7695 | 0.6749 |
Discounted Cash Flow | -325000 | 91009.5 | 79835.625 | 221873.375 |
Note 4:Free Cash Flow= (Cash Flow after tax+Depreciation-Cash Outflow+Cash Inflow)
Note 5: Net Present Value it is sum of discounted cash flow).
=-325000+91009.5+79385.625+221873.375
=67,268.50
Note 6 :Payback Period.
=Initial Investment /Cash Flow
=$325000/$103750
=3 Years.
Waldo Entertainment Products, Inc. is negotiating with Disney for the rights to manufacture and sell superhero-themed...
What are the formulas used for the cells shaded in blue? Waldo Entertainment Products, Inc. is negotiating with Disney for the rights to manufacture and sell superhero- themed toys for a three-year period. At the end of year 3, Waldo plans to liquidate the assets from the project. In addition to the facts and assumptions below, assume that working capital must be invested immediately in year 0) and will be fully recovered at the end of year 3, and that...
RET Inc. has decided to manufacture and sell a new line of high-priced commercial stoves. Projected saes for the new line of stoves in annual units for the next 10 years are 10,000 a year. The sales price is $3,000 per stove, the variable costs are 2250 per stove, and fixed costs are $4,000,000 annually. The plant and equipment required for producing the new line of stoves costs 10,000,000 (today) and will be depreciated down to zero over 10 years...
The managers of Classic Autos incorporated. Plan to manufacture classic Thunderbirds. The necessary foundry equipment will cost $4000000 and will be depreciated using 5 yr MACRS life. Annual sales yr 1 is 260, yr 2 is 280, yr 3 is 340, yr 4 is 370 yr 5 is 310.If the sales is $26000 per car, variable costs are $16,000 per car and fixed costs are $1200000 annually. What is the annual operating cash flow if the tax rate is 30%....
Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of$4,100,000 and will be depreciated using a five-year MACRS life, LOADING... . The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 250 Year four: 360 Year two: 280 Year five: 300 Year three: 340 If the sales price is $28,000...
NPV Simes Innovations, Inc., is negotiating to purchase exclusive rights to manufacture and market a solar-powered toy car. The car's inventor has offered Simes the choice of either a one-time payment of $1,200,000 today or a series of 5 year-end payments of $350,000 a. If Simes has a cost of capital of 12%, which form of payment should it choose? b. What yearly payment would make the two offers identical in value at a cost of capital of 12%? c....
Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $4 comma 100 comma 0004,100,000 and will be depreciated using afive-year MACRS life, LOADING... . The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 230230 Year four: 380380 Year two: 280280 Year five: 300300 Year three: 340340 If the...
3. Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $4,000,000 and will be depreciated using a five-year MACRS life, The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 240 Year two: 290 Year three: 330 Year four: 350 Year five: 300 If the sales price is $26,000...
REX Inc. currently has one product, low-priced stoves. REX Inc. has decided to sell a new line of medium-priced stoves. Sales revenues for the new line of stoves are estimated at $60 million a year. Variable costs are 90% of sales. The project is expected to last 10 years. Also, non-variable costs are 2,500,000 per year. The company has spent $1,000,000 in research and a marketing study that determined the company will lose (cannibalization) $2.8 million in sales a year...
HURDLE RATE IS 5.55% Frm's net property, plant, and equipment is $31,603 in Millions The firm is looking to expand its operations by 10% of the firm's net property, plant, and equipment. (Calculate this amount by taking 10% of the property, plant, and equipment figure that appears on the firm's balance sheet.) The estimated life of this new property, plant, and equipment will be 12 years. The salvage value of the equipment will be 5% of the property, plant and...
HURDLE RATE IS 5.55% Frm's net property, plant, and equipment is $31,603 in Millions The firm is looking to expand its operations by 10% of the firm's net property, plant, and equipment. (Calculate this amount by taking 10% of the property, plant, and equipment figure that appears on the firm's balance sheet.) The estimated life of this new property, plant, and equipment will be 12 years. The salvage value of the equipment will be 5% of the property, plant and...