SOA Candy Company is considering purchasing a machine that will allow them to expand operations. The machine will cost $22,000,000 and will have to be paid for at the time of purchase. If the machine is purchased, then SOA's annual sales will increase by $9,000,000 per year and the annual cash operating expenses will increase by $5,000,000 per year. The machine will last for 8 years and will then be disposed of at zero cost. SOA has a required rate of return of 15%. Ignore income taxes in this assignment. Requiramonte: Ca

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question

EXCEL Document. please show exact formulas used. screenshots perferred.

 

Assignment 11
SOA Candy Company is considering purchasing a machine that will allow them to expand
operations. The machine will cost $22,000,000 and will have to be paid for at the time of
purchase. If the machine is purchased, then SOA's annual sales will increase by $9,000,000 per
year and the annual cash operating expenses will increase by $5,000,000 per year. The machine
will last for 8 years and will then be disposed of at zero cost. SOA has a required rate of return of
15%. Ignore income taxes in this assignment.
Requirements: Complete each requirement on a separate worksheet.
1. Create a timeline of the cash flows and calculate the net present value of the machine.
a. Based on the net present value, create a formula that states either "This is a good
investment." or "The machine is a bad investment."
2. Create a timeline of the cash flows and calculate the internal rate of return.
a. Based on the internal rate of return, create a formula that states either "This is a
good investment." or "The machine is a bad investment."
3. Create a timeline of the cash flows and calculate the net present value based on the
following changes to the original problem:
a. The required rate of return is 12%.
b. SOA will have to perform maintenance on the machine at the end of year 4. The
cash cost of the maintenance will be $3,000,000.
c.
To dispose of the machine at the end of 8 years, SOA will have to pay $500,000
to have the machine recycled.
4. Create a timeline of the cash flows and calculate the modified internal rate of return
based on the following changes to the original problem:
a. The finance rate is 5%.
b. The reinvestment rate is 12%.
c. At the end of 8 years, SOA will sell the machine for $2,000,000.
Transcribed Image Text:Assignment 11 SOA Candy Company is considering purchasing a machine that will allow them to expand operations. The machine will cost $22,000,000 and will have to be paid for at the time of purchase. If the machine is purchased, then SOA's annual sales will increase by $9,000,000 per year and the annual cash operating expenses will increase by $5,000,000 per year. The machine will last for 8 years and will then be disposed of at zero cost. SOA has a required rate of return of 15%. Ignore income taxes in this assignment. Requirements: Complete each requirement on a separate worksheet. 1. Create a timeline of the cash flows and calculate the net present value of the machine. a. Based on the net present value, create a formula that states either "This is a good investment." or "The machine is a bad investment." 2. Create a timeline of the cash flows and calculate the internal rate of return. a. Based on the internal rate of return, create a formula that states either "This is a good investment." or "The machine is a bad investment." 3. Create a timeline of the cash flows and calculate the net present value based on the following changes to the original problem: a. The required rate of return is 12%. b. SOA will have to perform maintenance on the machine at the end of year 4. The cash cost of the maintenance will be $3,000,000. c. To dispose of the machine at the end of 8 years, SOA will have to pay $500,000 to have the machine recycled. 4. Create a timeline of the cash flows and calculate the modified internal rate of return based on the following changes to the original problem: a. The finance rate is 5%. b. The reinvestment rate is 12%. c. At the end of 8 years, SOA will sell the machine for $2,000,000.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 8 images

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 Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education