eases 3 years Create a table with: interest ranging from 0% o 50% increasing by 5% increments NPV for each of these %. Use NPV function. Tip: do not include the cost of machine in the function; add that amount to NPV. - Plot the NPV's for all %s. - What is the IRR(s)? Not only graphically, but solve for IRR(s) using Goal Seek for the problem. Cashflow: Year

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
Question
12
B
You are adding a machine to an existing factory that costs $4 million (this is both an investment and loan)..
- Years 1-4 = $8 million production with a $1 million decrease each of the 4 yrs.
- Years 5-7 = -4.5 million that that decreases by $1 million for each of the 3 years
Create a table with: interest ranging from 0% o 50% increasing by 5% increments
NPV for each of these %. Use NPV function. Tip: do not include the cost of machine in the function; add that amount to NPV.
- Plot the NPV's for all %s.
- What is the IRR (s)? Not only graphically, but solve for IRR(s) using Goal Seek for the problem.
Cashflow:
Year
0
с
-4 million
1
D
2
E
3
F
4
3.5 million 2.5 millior 1.5 millior .5 million
G
5
H
6
I
7
-.5 millior-1.5 millio-2.5 million
J
Transcribed Image Text:12 B You are adding a machine to an existing factory that costs $4 million (this is both an investment and loan).. - Years 1-4 = $8 million production with a $1 million decrease each of the 4 yrs. - Years 5-7 = -4.5 million that that decreases by $1 million for each of the 3 years Create a table with: interest ranging from 0% o 50% increasing by 5% increments NPV for each of these %. Use NPV function. Tip: do not include the cost of machine in the function; add that amount to NPV. - Plot the NPV's for all %s. - What is the IRR (s)? Not only graphically, but solve for IRR(s) using Goal Seek for the problem. Cashflow: Year 0 с -4 million 1 D 2 E 3 F 4 3.5 million 2.5 millior 1.5 millior .5 million G 5 H 6 I 7 -.5 millior-1.5 millio-2.5 million J
Expert Solution
steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Knowledge Booster
Techniques of Time Value Of Money
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