# Question: Comprehensive problem quantitative and qualitative analysis The following data have been

Comprehensive problem—quantitative and qualitative analysis The following data have been collected by capital budgeting analysts at Sunset Beach, Inc., concerning an investment in an expansion of the company’s product line. Analysts estimate that an investment of $150,000 will be required to initiate the project at the beginning of 2013. The estimated cash returns from the new product line are summarized in the following table; assume that the returns will be received in a lump sum at the end of each year:

Amount of

Year Cash Return

2013 . . . . . . . . . . . . . . . . . . . . . . . . . $40,000

2014 . . . . . . . . . . . . . . . . . . . . . . . . . 50,000

2015 . . . . . . . . . . . . . . . . . . . . . . . . . 64,000

2016 . . . . . . . . . . . . . . . . . . . . . . . . . 46,000

The new product line will also require an investment in inventory and receivables of $50,000; this investment will become available for other purposes at the end of the project. The salvage value of machinery and equipment at the end of the product line’s life is expected to be $25,000. The cost of capital used in Sunset Beach, Inc.’s, capital budgeting analysis is 12%.

Required:

a. Calculate the net present value of the proposed investment. Ignore income taxes and round all answers to the nearest $1.

b. Calculate the present value ratio of the investment.

c. What will the internal rate of return on this investment be relative to the cost of capital? Explain your answer.

d. Calculate the payback period of the investment.

e. Based on the quantitative analysis, would you recommend that the product line expansion project be undertaken? Explain your answer.

f. Identify some qualitative factors that you would want to have considered with respect to this project before management proceeds with the investment.

Amount of

Year Cash Return

2013 . . . . . . . . . . . . . . . . . . . . . . . . . $40,000

2014 . . . . . . . . . . . . . . . . . . . . . . . . . 50,000

2015 . . . . . . . . . . . . . . . . . . . . . . . . . 64,000

2016 . . . . . . . . . . . . . . . . . . . . . . . . . 46,000

The new product line will also require an investment in inventory and receivables of $50,000; this investment will become available for other purposes at the end of the project. The salvage value of machinery and equipment at the end of the product line’s life is expected to be $25,000. The cost of capital used in Sunset Beach, Inc.’s, capital budgeting analysis is 12%.

Required:

a. Calculate the net present value of the proposed investment. Ignore income taxes and round all answers to the nearest $1.

b. Calculate the present value ratio of the investment.

c. What will the internal rate of return on this investment be relative to the cost of capital? Explain your answer.

d. Calculate the payback period of the investment.

e. Based on the quantitative analysis, would you recommend that the product line expansion project be undertaken? Explain your answer.

f. Identify some qualitative factors that you would want to have considered with respect to this project before management proceeds with the investment.

## Answer to relevant Questions

MFG Company experiences the following cost behavior patterns each week:Fixed costs: supervisor's salary $1,000; factory rent $2,500 Mixed costs: utilities $1,500 + $5.25 per unit Variable costs per unit: manufacturing labor ...Acme Company's production budget for August is 17,500 units and includes the following component unit costs: direct materials, $8; direct labor, $10; variable overhead, $6. Budgeted fixed overhead is $32,000. Actual ...Fixed overhead variances In addition to the information for Acme Company in Mini-Exercises 15.1 and 15.2, the standard fixed overhead application rate per unit consists of $2 per machine hour and each unit is allowed a ...Calculate variable cost variances—explain results. The standards for one case of liquid weed killer are:During the week ended May 6, the following activity took place:2,910 machine hours were worked.11,400 lb of raw ...Gillman Co. is forecasting sales of 62,000 units of product for August. To make one unit of finished product, 5 pounds of raw materials are required. Actual beginning and desired ending inventories of raw materials and ...Post your question