Question

In: Accounting

Net Present Value Project Details Starlight Industries has developed a project to produce a new product:...

Net Present Value Project Details

Starlight Industries has developed a project to produce a new product: Widgets. To develop the widgets, Starlight Industries needs to purchase a new machine that will help develop the widgets. Starliper Industries is deciding between two different machines, “New Tech” and “Standard Classic” that have the capabilities necessary to develop the widgets. Your job will be to compare the two different machines using net present value. The company has produced the following information regarding the widgets and the two machines:

  • The cost to purchase “New Tech” will be $421,000 and will have a useful life of 6 years; “New Tech” will have a salvage value of $26,000 at the end of 6 years. The cost to purchase “Standard Classic” will be $235,000 and will also have a useful life of 6 years; “Standard Classic” will have a salvage value of $5,000 at the end of 6 years.

  • Total Contribution Margin from the sale of Widgets will be different for each machine because the “Standard Classic” machine requires more variable manufacturing overhead costs. The expected contribution margin if the “New Tech” machine is chosen is the following:

    The contribution margin if the “Standard Classic” is chosen is expected to be the following:

  • Working Capital of $53,000 will be required at the beginning of the production of Widgets for the “New Tech” machine, and working capital of $95,000 will be required at the beginning of the production of Widgets for the “Standard Classic” machine. For both machines the working capital will be released at the end of the project (i.e., end of year 6).

  • The yearly cost of machine maintenance will be $50,000 for the “New Tech” and will be $72,000 for the “Standard Classic” machine.

  • Other fixed costs for salaries, property taxes, and insurance, which will be the same regardless of the machine chosen, will be the following:

Year

Total Contribution Margin

1

$180,000

2

$300,000

3

$360,000

4-6

$440,000

Year

Total Contribution Margin

1

$175,000

2

$280,000

3

$355,000

4-6

$438,000

Year

Total Other Fixed Costs

1-2

$180,000

3

$150,000

4-6

$120,000

  • The “Standard Classic” machine will require a major overhaul that will cost $100,000 at the end of year 3 of the project. This will not apply to the “New Tech” machine.

  • The Required Rate of Return for Starliper Industries is 9%.

  • Use the “Total-Cost Approach” as described in section “Expanding the Net Present Value

    Method” on page 646 of the textbook. Required:

  • Use the “NPV Project Template” Excel file on Blackboard.

  • The cells you are required to fill are the cells in the “Net Present Value Analysis” box in both the

    “New Tech” and “Standard Classic” tabs.

o Every cell for each ”Cash Flows” item from “Cost of Machine” to “Total Cash Flows” for

each year (“Now” through “Year 6”) must have a value. Some cells may have a zero

value.
o The “Net Present Value” cell must be filled
o The“ProjectProfitabilityIndex”cellmustbefilled
o The cells outside of the “Net Present Value Analysis” box are for your convenience


• You must use special Excel formulas to calculate Net Present Value

o You may use the Present Value (pv) formula method to find the present value of the cash flows of each individual year (use cell row “Discounted CF (Optional)” for this method)

o Alternatively, you may use the Net Present Value (NPV) formula method.
o You do not have to utilize both methods (although it may provide a nice check).

MUST SHOW YOUR FORMULAS

Solutions

Expert Solution

Calculation of NPV
Machine : New Tech
Period Cost (A) Contribution Margin {B} Other Fixed Costs (C) Yearly Costs (D) Working Capital (E) Major Overhaul Cost (F) Net Cash Inflows (A-B+C+D+E+F) P.V.F N.P.V
0 -4,21,000 0 0 0 -53000              -4,74,000 1.0000 -4,74,000
1 180000 -180000 -50000 0                 -50,000 0.9174      -45,872
2 300000 -180000 -50000 0                   70,000 0.8417        58,918
3 360000 -150000 -50000 0               1,60,000 0.7722    1,23,549
4 440000 -120000 -50000 0               2,70,000 0.7084    1,91,275
5 440000 -120000 -50000 0               2,70,000 0.6499    1,75,481
6 440000 -120000 -50000 53000               3,23,000 0.5963    1,92,594
   2,21,946
Salvage Value at Year End 6                   26,000 0.5963        15,503
Total    2,37,449
Machine : Standard Classic
Period Cost (A) Contribution Margin {B} Other Fixed Costs (C) Yearly Costs (D) Working Capital (E) Major Overhaul Cost (F) Net Cash Inflows (A-B+C+D+E+F) P.V.F N.P.V
0 -2,35,000 0 0 0 -95000              -3,30,000 1.0000 -3,30,000
1 175000 -180000 -72000                 -77,000 0.9174      -70,642
2 280000 -180000 -72000                   28,000 0.8417        23,567
3 355000 -150000 -72000 -100000                   33,000 0.7722        25,482
4 438000 -120000 -72000               2,46,000 0.7084    1,74,273
5 438000 -120000 -72000               2,46,000 0.6499    1,59,883
6 438000 -120000 -72000 95000               3,41,000 0.5963    2,03,327
   1,85,890
Salvage Value at Year End 6 5000 0.5963          2,981
Total    1,88,871
Summary: Machiner New Tech's NPV is better than Standar Classic.
Profitability Index= (NPV+ initial Investment)
initial investment
Machine : New Tech Machine : Standard Classic

Related Solutions

Starliper Industries has developed a project to produce a new product: Widgets. To develop the widgets,...
Starliper Industries has developed a project to produce a new product: Widgets. To develop the widgets, Starliper Industries needs to purchase a new machine that will help develop the widgets. Starliper Industries is deciding between two different machines, “New Tech” and “Standard Classic” that have the capabilities necessary to develop the widgets. Your job will be to compare the two different machines using net present value. The company has produced the following information regarding the widgets and the two machines:...
Case 13-32 Net Present Value Analysis of a New Product [LO13-2] Matheson Electronics has just developed...
Case 13-32 Net Present Value Analysis of a New Product [LO13-2] Matheson Electronics has just developed a new electronic device that it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information: New equipment would have to be acquired to produce the device. The equipment would cost $258,000 and have a six-year useful life. After six years, it would have a salvage value of about $24,000. Sales in units over the...
Case 13-32 Net Present Value Analysis of a New Product [LO13-2] Matheson Electronics has just developed...
Case 13-32 Net Present Value Analysis of a New Product [LO13-2] Matheson Electronics has just developed a new electronic device that it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information: New equipment would have to be acquired to produce the device. The equipment would cost $300,000 and have a six-year useful life. After six years, it would have a salvage value of about $24,000. Sales in units over the...
Net present value. Quark Industries has a project with the following projected cash​ flows: Initial​ cost:...
Net present value. Quark Industries has a project with the following projected cash​ flows: Initial​ cost: ​$210,000 Cash flow year​ one: ​$25,000 Cash flow year​ two: ​$72,000 Cash flow year​ three: ​$146,000 Cash flow year​ four: ​$146,000 a. Using a discount rate of 11​% for this project and the NPV​ model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 13​%? c. Should the company accept...
Net present value. Quark Industries has a project with the following projected cash​ flows: Initial​ cost:...
Net present value. Quark Industries has a project with the following projected cash​ flows: Initial​ cost: ​$270,000 Cash flow year​ one: ​$24,000 Cash flow year​ two: ​$79,000 Cash flow year​ three: ​$155,000 Cash flow year​ four: ​$155,000 a. Using a discount rate of 10​% for this project and the NPV​ model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 13​%? c. Should the company accept...
Net present value. Lepton Industries has a project with the following projected cash​ flows: Initial​ cost:...
Net present value. Lepton Industries has a project with the following projected cash​ flows: Initial​ cost: ​$460,000 Cash flow year​ one: ​$132,000 Cash flow year​ two: ​$200,000 Cash flow year​ three: ​$191,000 Cash flow year​ four: ​$132,000 a. Using a discount rate of 11​% for this project and the NPV​ model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 13​%? c. Should the company accept...
Avalon Aviation Products is evaluating a new project. What is the net present value of this...
Avalon Aviation Products is evaluating a new project. What is the net present value of this project if the discount rate is 12% and the net cash flows are as per the following table? Year Cashflow 0 -$5334 1 $8301 2 $4682 3 $9112 4 $20025 5 $24873
1. a) What is the net present value of a project that has upfront costs of...
1. a) What is the net present value of a project that has upfront costs of $5 million and pays end of the year cash flows of $1 million in one year, $2 million in two years, and $3 million in three years if the annual discount rate for the project is 3 percent? Show how much money you would have at the end of three years if you bought the project and what you would have instead if you...
What is the net present value of a project that has an initial cash outflow of...
What is the net present value of a project that has an initial cash outflow of $-13,000, at time 0, and the following cash flows for years 1-4? The required return is 10.0%. DO NOT USE DOLLAR SIGNS OR COMMAS IN YOUR ANSWER. ENTER YOUR ANSWER TO THE NEAREST DOLLAR (e.g. 1250). Year Cash Flows 1 $3,950 2 $3,750 3 $5,900 4 $6,400
APPLY THE CONCEPTS: Net present value and Present value index Sutherland Industries is looking to invest...
APPLY THE CONCEPTS: Net present value and Present value index Sutherland Industries is looking to invest in Project A or Project B. The data surrounding each project is provided below. Sutherland's cost of capital is 10%. Project A Project B This project requires an initial investment of $172,500. The project will have a life of 3 years. Annual revenues associated with the project will be $130,000 and expenses associated with the project will be $35,000. This project requires an initial...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT