2. Compute the NPV of each project assuming the cost of capital is 10 percent. Note: Round your PV amounts to 4 decimal places. Project A Project B Project NPV 3. Compute the profitability index of each project. Note: Round your answer to 2 decimal places. Project A Project B Project C Profitability index

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter12: Integer Linear Optimization_models
Section: Chapter Questions
Problem 3P: Spencer Enterprises is attempting to choose among a series of new investment alternatives. The...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Subject: 

Required information
Part 5: Performance Evaluation and Analysis Problems
[The following information applies to the questions displayed below.]
These problems relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case
Overview, Case Background, and Part 5: Performance Evaluation and Analysis.
Part 5 Problem 01: Capital Budgeting
For this problem, assume that Taylor is considering investing in one or more of the following projects:
Project A: Expand the manufacturing facility to increase capacity by 20 percent. This investment is expected to cost $360,000 and
generate net cash flow of $80,000 per year for the next eight years.
Project B: Overhaul the company website to optimize the user experience and generate more traffic from online advertising. This
project would cost $210,000 and is expected to generate an additional $100,000 in sales for the next 10 years. Assume that the
contribution margin is 42 percent and that there would be no increase in fixed costs, including depreciation.
Project C: Invest in solar panels and more fuel-efficient delivery vehicles to reduce operating expenses (e.g., electricity and fuel) and
the company's carbon footprint. The initial investment in assets would be $360,000, which would be depreciated over five years. The
investment is expected to increase net income by $18,000 per year, after the depreciation adjustment.
Required:
1. Compute the payback period for each project.
Note: Round your answer to 1 decimal place.
Project A
Project B
Project C
Payback period
years
years
years
Transcribed Image Text:Required information Part 5: Performance Evaluation and Analysis Problems [The following information applies to the questions displayed below.] These problems relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case Overview, Case Background, and Part 5: Performance Evaluation and Analysis. Part 5 Problem 01: Capital Budgeting For this problem, assume that Taylor is considering investing in one or more of the following projects: Project A: Expand the manufacturing facility to increase capacity by 20 percent. This investment is expected to cost $360,000 and generate net cash flow of $80,000 per year for the next eight years. Project B: Overhaul the company website to optimize the user experience and generate more traffic from online advertising. This project would cost $210,000 and is expected to generate an additional $100,000 in sales for the next 10 years. Assume that the contribution margin is 42 percent and that there would be no increase in fixed costs, including depreciation. Project C: Invest in solar panels and more fuel-efficient delivery vehicles to reduce operating expenses (e.g., electricity and fuel) and the company's carbon footprint. The initial investment in assets would be $360,000, which would be depreciated over five years. The investment is expected to increase net income by $18,000 per year, after the depreciation adjustment. Required: 1. Compute the payback period for each project. Note: Round your answer to 1 decimal place. Project A Project B Project C Payback period years years years
2. Compute the NPV of each project assuming the cost of capital is 10 percent.
Note: Round your PV amounts to 4 decimal places.
Project A
Project B
Project
NPV
3. Compute the profitability index of each project.
Note: Round your answer to 2 decimal places.
Project A
Project B
Project C
Profitability
index
Transcribed Image Text:2. Compute the NPV of each project assuming the cost of capital is 10 percent. Note: Round your PV amounts to 4 decimal places. Project A Project B Project NPV 3. Compute the profitability index of each project. Note: Round your answer to 2 decimal places. Project A Project B Project C Profitability index
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,