Use Excel® to solve the following problem. An eight-year life project has an initial capital expenditure of $450,000, annual income of $300,000 beginning at the end of year 1, and annual operating costs of $80,000 beginning at the end of year 1. Calculate the IRR for the following cases:

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

Please all solve the question

Use Excel® to solve the following problem. An eight-year life project has an initial capital
expenditure of $450,000, annual income of $300,000 beginning at the end of year 1, and
annual operating costs of $80,000 beginning at the end of year 1. Calculate the IRR for
the following cases:
(a) Assume the cash flows given are in escalated dollars and the escalated dollar MARR
is 10%, 20%, and 30%.
(b) Assume the cash flows given are in today dollars and pairs of escalation rates are:
a. Incomes are escalated at 7% and costs are escalated at 6%
b. Incomes are escalated at 3% and costs are escalated at 5%
c. Incomes are escalated at 4% and costs are escalated at 4%
(c) Assume inflation is 49% and rework all portions of part (b) in terms of constant dollars.
Transcribed Image Text:Use Excel® to solve the following problem. An eight-year life project has an initial capital expenditure of $450,000, annual income of $300,000 beginning at the end of year 1, and annual operating costs of $80,000 beginning at the end of year 1. Calculate the IRR for the following cases: (a) Assume the cash flows given are in escalated dollars and the escalated dollar MARR is 10%, 20%, and 30%. (b) Assume the cash flows given are in today dollars and pairs of escalation rates are: a. Incomes are escalated at 7% and costs are escalated at 6% b. Incomes are escalated at 3% and costs are escalated at 5% c. Incomes are escalated at 4% and costs are escalated at 4% (c) Assume inflation is 49% and rework all portions of part (b) in terms of constant dollars.
Expert Solution
steps

Step by step

Solved in 4 steps with 18 images

Blurred answer
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education