Question

In: Finance

Dave Alvin, the CFO of Blasters Powertrain Products (BPP) has requested your assistance in evaluating a...

Dave Alvin, the CFO of Blasters Powertrain Products (BPP) has requested your assistance in evaluating a capital budgeting proposal. The proposal involves the production of a new line of gearboxes for use in heavy freight applications. Research and development costs to develop this new line of gearboxes were $570,000 last year (2018). Production of the new product would require investment in (i.e., the purchase of) new machinery at a cost of $6.6 million, with a useful life of 4 years. BPP has conferred with its tax accountant and has been informed that they must depreciate the machinery under the MACRs 5-year class. (See page 4 for a MACRS depreciation schedule.) Forecasts indicate that the machinery can be sold for a market value of $270,480 at the end of the 4-year period.

Management expects sales to be $7.65 million in year 1, and sales are projected to increase by 6%/year over the life of the project. Variable production costs are projected to be $5.85 million in year 1 and management expects these costs to increase by 2%/year over the life of the project. Fixed production costs for the gearboxes are expected to be $165,000 each year.

If BPP produces the new line of gearboxes, BPP will need to make additional investments in Net Working Capital (NWC) to support the increased operations. In particular, NWC (entering any year) is expected to be 10% of the projected sales for that year. That is, the NWC balance at t=0 would be 10% of the projected sales for year 1, the NWC balance at t=1 would be 10% of the projected sales for t=2, and so on. The cumulative investments in NWC made as a result of this project would be recovered in the project's final year. In other words, the NWC balance will drop to $0 at t = 4.

The discount rate (also called cost of capital) used to evaluate this project would be 9.06% (although this variable is not needed in this problem, given the instructions below), and the relevant tax rate is 25.00%.

Develop the incremental cash flow projections for this proposal. Your worksheet should resemble the numerous examples covered in Lesson 6, including the terms relating to “operating” cash flows, ΔNWC, and net capital spending. Of course, any given column in your worksheet should contain the total cash flow for that column. [Note: Normally, you would then use these cash flows to calculate NPV and IRR of the decision to start the new line of gearboxes or (2) do nothing. If NPV > 0 (and, equivalently, IRR > required return), then the firm will choose option 1. If NPV < 0 (and, equivalently, IRR < required return), then the firm will choose option 2. However, this assignment already contains an adequate number of other NPV and IRR calculations.]

Solutions

Expert Solution


Related Solutions

1. (13 pts.) Dave Alvin, the CFO of Blasters Powertrain Products (BPP) has requested your assistance...
1. (13 pts.) Dave Alvin, the CFO of Blasters Powertrain Products (BPP) has requested your assistance in evaluating a capital budgeting proposal. The proposal involves the production of a new line of gearboxes for use in heavy freight applications. Research and development costs to develop this new line of gearboxes were $570,000 last year (2018). Production of the new product would require investment in (i.e., the purchase of) new machinery at a cost of $6.6 million, with a useful life...
Mr. Tanner, the manager of the Spruce Resort, has requested your assistance in forecasting the lodging...
Mr. Tanner, the manager of the Spruce Resort, has requested your assistance in forecasting the lodging and food service operations sales for April. The resort has single and double guestrooms. Number of guestrooms = 100 Number of dining room sales = 80 Estimated paid occupancy percentage = 80% Double occupancy percentage = 60% Average daily rate = $120 Average double room rate = single room rate + $20 Average occupancy per room      Single = 1      Double = 2.2...
A firm has requested your assistance in ensuring that its multigenerational workforce functions effectively as a...
A firm has requested your assistance in ensuring that its multigenerational workforce functions effectively as a team. What strategies or programs would you recommend? Why?
Alexandra Marcus, manager of the Sky Club Hotel, has requested your assistance on a queuing issue...
Alexandra Marcus, manager of the Sky Club Hotel, has requested your assistance on a queuing issue to improve the guest service at the hotel. Alexandra Marcus is considering how to restructure the front desk to reach an optimal level of staff efficiency and guest service. Observation of arrivals during the peak check-in time of 3:00PM to 5:00PM shows that an average of 80 guests arrive each hour. It takes an average of 3 minutes for the front-desk clerk to register...
Springfield Bank is evaluating Creek​ Enterprises, which has requested a $ 3,750,000 ​loan, to assess the​...
Springfield Bank is evaluating Creek​ Enterprises, which has requested a $ 3,750,000 ​loan, to assess the​ firm's financial leverage and financial risk. On the basis of the debt ratios for​ Creek, along with the industry averages and​ Creek's recent financial​ statements, evaluate and recommend appropriate action on the loan request. Industry Averages Debt ratio: 0.46              Times interest earned ratio: 7.31 Fixed-payment coverage ratio: 2.00 Creek Enterprises Income Statement for the Year Ended December 31, 2019           Sales revenue...
P3-16: Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,000,000 loan, to...
P3-16: Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,000,000 loan, to assess the firm’s financial leverage and financial risk. On the basis of the debt ratios for Creek, along with the industry average and Creek’s recent financial statements (following), evaluate and recommend appropriate action on the loan request. Sales revenue $30,000,000 Less: Cost of goods sold 21,000,000       Gross profits $ 9,000,000 Less: Operating expenses       Selling expense $ 3,000,000       General and administrative expenses 1,800,000       Lease expense...
Your boss has asked for your assistance regarding the company’s investments. One of their current investments...
Your boss has asked for your assistance regarding the company’s investments. One of their current investments has $10 million invested in long-term corporate bonds. This bond portfolio's expected annual rate of return is 9%, and the annual standard deviation is 10%. An external firm was contacted to see if the company could improve their return. Their recommendation has the company invested in an index fund that closely tracks the Standard & Poor's 500 Index. The index has an expected return...
A pizza company has asked you for your assistance in developing a model that predicts the...
A pizza company has asked you for your assistance in developing a model that predicts the demand for the new snack pizza named Pizza1. This product competes in a market with another brand that is named B2 for identification. At present, the products are sold by three major distribution chains identified as​ 1, 2, and 3. These three chains have different market​ sizes, and,​ thus, sales for each distributor are likely to be different. The accompanying data table contains randomly...
Shanghai Enterprises has asked for your assistance in preparing a cash budget for the month of...
Shanghai Enterprises has asked for your assistance in preparing a cash budget for the month of December 2020 and has provided projected sales revenue data below Projected sales: October 2020 $144,000 November 2020 $205,000 December 2020 $220,000 All sales are on credit with 65% collected during the month of sale, 18% collected during the month following the sale, 15% during the second month after the sale and 2% uncollectable. Required: a) Prepare the cash receipts section of a cash budget...
ABC Enterprises has asked for your assistance in preparing a cash budget for the month of...
ABC Enterprises has asked for your assistance in preparing a cash budget for the month of December 2020 and has provided projected sales revenue data below: Projected sales: October 2020 $144,000 November 2020 $205,000 December 2020 $220,000 All sales are on credit with 65% collected during the month of sale, 18% collected during the month following the sale, 15% during the second month after the sale and 2% uncollectable. Required: a) Prepare the cash receipts section of a cash budget...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT