Question
In: Finance
The Pixar Corporation has an opportunity to sell Buzz Lightyear flying action figures. Woody, the CEO,...
The Pixar Corporation has an opportunity to sell Buzz Lightyear flying action figures. Woody, the CEO, would like for Rex, the vice president, to evaluate the project. Mr. Potato Head, operations manager, believes the equipment will cost $600,000 with shipping and installation being another $75,000. Mr. Potato Head believes the cost will be $3.50 per unit or 35% of sales plus a fixed cost of $75,000. Mr. Potato Head estimates inventory will be increased by $82,500. Mr. Potato Head believes after the four-year run of action figures, the equipment will be worth $125,000. Bo Peep, marketing manager, believes that the demand for the Buzz Lightyear flying action figures will be 80,000 units in the first year, 65,000 in the second year, 40,000 units in the third year and 25,000 in the fourth year. Bo Peep tells Rex that she believes the price will be $10 per unit. Slinky Dog, the CFO, says the equipment will fall under the 3-years MACRS schedule. Slinky Dog believes accounts payable will increase by $8,000 and accounts receivable will decrease by $20,000. Slinky Dog tells Rex that the corporate tax rate is a flat 38%. Hamm, assistant financial accountant, says the required return on a project of this type should be 16%. Rex needs to report the NPV, IRR, Payback and the accept/reject decision to Woody.
Solutions
Expert Solution
| Pixar | 0 | 1 | 2 | 3 | 4 |
| MACRS % | 33.33% | 44.45% | 14.81% | 7.41% | |
| Unit Sales | 80000 | 65000 | 40000 | 25000 | |
| Investment | -$675,000.00 | ||||
| Salvage | $ 125,000.00 | ||||
| NWC | -$ 54,500.00 | $ 54,500.00 | |||
| Sales | $ 800,000.00 | $ 650,000.00 | $ 400,000.00 | $ 250,000.00 | |
| VC | -$280,000.00 | -$227,500.00 | -$140,000.00 | -$ 87,500.00 | |
| FC | -$ 75,000.00 | -$ 75,000.00 | -$ 75,000.00 | -$ 75,000.00 | |
| Depreciation | -$224,977.50 | -$300,037.50 | -$ 99,967.50 | -$ 50,017.50 | |
| EBT | $ 220,022.50 | $ 47,462.50 | $ 85,032.50 | $ 37,482.50 | |
| Tax (38%) | -$ 83,608.55 | -$ 18,035.75 | -$ 32,312.35 | -$ 14,243.35 | |
| Profits | $ 136,413.95 | $ 29,426.75 | $ 52,720.15 | $ 23,239.15 | |
| Cash Flows | -$729,500.00 | $ 361,391.45 | $ 329,464.25 | $ 152,687.65 | $ 205,256.65 |
| NPV | $38,071.90 | ||||
| IRR | 18.98% | ||||
| Payback | 2.25 |
Net Working Capital = Increase in Inventory + Increase in Receivables - Increase in Payables
= 82,500 - 8,000 - 20,000 = 54,500
Depreciation = Investment x MACRS%
Sales = Unit sales x $10, VC = Unit Sales x 3.50
Cash Flows = Investment + NWC + Profits + Depreciation + Salvage x (1 - tax rate)
NPV and IRR can be calculated using the same function in excel or calculator with 16% discount rate.
Payback Period is the no. of years it take to recover the investment.
As NPV > 0 and IRR > 16%, accept the project.
jeff jeffy answered 1 year agoRelated Solutions
The Pixar Corporation has an opportunity to sell Buzz Lightyear flying action figures. Woody, the CEO,...
The Pixar Corporation has an opportunity to sell Buzz Lightyear
flying action figures. Woody, the CEO, would like for Rex, the vice
president, to evaluate the project. Mr. Potato Head, operations
manager, believes the equipment will cost $900,000 with shipping
and installation being another $125,000. Mr. Potato Head believes
the cost will be $5.70 per unit plus a fixed cost of $95,000. Mr.
Potato Head estimates inventory will be increased by $120,000. Mr.
Potato Head believes after the four-year run...
A corporation operates snow sports facilities in Canada. The corporation has an opportunity to lease a...
A corporation operates snow sports facilities in Canada. The
corporation has an opportunity to lease a location in the mountains
for 10 years for $60,000 per year to open a new snow sports
location. They will also have access to trails in the provincial
park at an additional cost of $24,000 per year for trail
maintenance. To secure the lease they paid a non-refundable deposit
of $10,000 last year. The corporation will be required to purchase
snowshoes, cross-country skis and...
Oakmont Company has an opportunity to manufacture and sell a new product for a four-year period....
Oakmont Company has an opportunity to manufacture and sell a new
product for a four-year period. The company’s discount rate is 14%.
After careful study, Oakmont estimated the following costs and
revenues for the new product:
Cost of
equipment needed
$
140,000
Working
capital needed
$
62,000
Overhaul of
the equipment in two years
$
9,000
Salvage
value of the equipment in four years
$
13,000
Annual
revenues and costs:
Sales
revenues
$
270,000
Variable
expenses
$
130,000
Fixed...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Lou Barlow, a divisional manager for Sage Company, has an
opportunity to manufacture and sell one of two new products for a
five-year period. His annual pay raises are determined by his
division’s return on investment (ROI), which has exceeded 23% each
of the last three years. He has computed the cost and revenue
estimates for each product as follows: Product A Product B Initial
investment: Cost of equipment (zero salvage value) $ 390,000 $
585,000 Annual revenues and costs:...
Oakmont Company has an opportunity to manufacture and sell a new product for a four-year period....
Oakmont Company has an opportunity to manufacture and sell a new
product for a four-year period. The company’s discount rate is 18%.
After careful study, Oakmont estimated the following costs and
revenues for the new product:
Cost of equipment needed
$
160,000
Working capital needed
$
66,000
Overhaul of the equipment in year two
$
11,000
Salvage value of the equipment in four years
$
15,000
Annual revenues and costs:
Sales revenues
$
310,000
Variable expenses
$
150,000
Fixed out-of-pocket...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Lou Barlow, a divisional manager for Sage Company, has an
opportunity to manufacture and sell one of two new products for a
five-year period. His annual pay raises are determined by his
division’s return on investment (ROI), which has exceeded 25% each
of the last three years. He has computed the cost and revenue
estimates for each product as follows: Product A Product B Initial
investment: Cost of equipment (zero salvage value) $ 370,000 $
530,000 Annual revenues and costs:...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Lou Barlow, a divisional manager for Sage Company, has an
opportunity to manufacture and sell one of two new products for a
five-year period. His annual pay raises are determined by his
division’s return on investment (ROI), which has exceeded 21% each
of the last three years. He has computed the cost and revenue
estimates for each product as follows:
Product A
Product B
Initial investment:
Cost of equipment (zero salvage value)
$
210,000
$
420,000
Annual revenues and costs:...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Lou Barlow, a divisional manager for Sage Company, has an
opportunity to manufacture and sell one of two new products for a
five-year period. His annual pay raises are determined by his
division’s return on investment (ROI), which has exceeded 25% each
of the last three years. He has computed the cost and revenue
estimates for each product as follows
Product A
Product B
Initial investment:
Cost of equipment (zero salvage value)
$
370,000
$
530,000
Annual revenues and costs:...
Oakmont Company has an opportunity to manufacture and sell a new product for a four-year period....
Oakmont Company has an opportunity to manufacture and sell a new
product for a four-year period. The company’s discount rate is 18%.
After careful study, Oakmont estimated the following costs and
revenues for the new product:
Cost of equipment needed
$
160,000
Working capital needed
$
66,000
Overhaul of the equipment in year two
$
11,000
Salvage value of the equipment in four years
$
15,000
Annual revenues and costs:
Sales revenues
$
310,000
Variable expenses
$
150,000
Fixed out-of-pocket...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Lou Barlow, a divisional manager for Sage Company, has an
opportunity to manufacture and sell one of two new products for a
five-year period. He has computed the cost and revenue estimates
for each product as follows:
Product A
Product B
Initial investment:
Cost of equipment (zero salvage
value)
$
340,000
$
540,000
Annual revenues and costs:
Sales revenues
$
380,000
$
460,000
Variable expenses
$
170,000
$
206,000
Depreciation expense
$
68,000
$
108,000
Fixed out-of-pocket operating
costs
$...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Queueing Theory apply elementary queueing theory equations to compute statistics for the various scheduling systems assume...
- How is thunder and lightning made, and what causes it?
- Two small nonconducting spheres have a total charge of Q=Q1+Q2= 90.0 μC , Q1<Q2. When placed...
- QUESTION 6 A single line comment in C++ language source code can begin with _____ ...
- In a power plant based on a simple Rankine cycle, steam enters the turbine at 15...
- Cash budget—Basic Grenoble Enterprises had sales of $49,600 in March and $60,200in April. Forecast sales for...
- You have just purchased a share of stock for $ 21.03, The company is expected to...
ADVERTISEMENT