NPV IRR MRR PBP ($675,000,000) 90,000,000.00 0 1 $ 2 $ 135,000,000.00 204,000,000.00 3 $ 4 $ 235,000,000.00 5 $ 200,000,000.00 6 $ 154,000,000.00 7 $ 118,000,000.00 8 $ 86,000,000.00 9 $ (50,000,000.00) 10 $ 45,000,000.00

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

Subject :- Accounting 

Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, net present value, and Profitability Index of the proposed mine.

Bullock Gold Mining has a 12 percent required return on all of its gold mines.  

NPV
IRR
MRR
PBP
($675,000,000)
90,000,000.00
0
1 $
2 $
3 $
4 $
235,000,000.00
5 $
200,000,000.00
6 $ 154,000,000.00
7 $
118,000,000.00
8 $
86,000,000.00
9 $ (50,000,000.00)
10 $ 45,000,000.00
135,000,000.00
204,000,000.00
Transcribed Image Text:NPV IRR MRR PBP ($675,000,000) 90,000,000.00 0 1 $ 2 $ 3 $ 4 $ 235,000,000.00 5 $ 200,000,000.00 6 $ 154,000,000.00 7 $ 118,000,000.00 8 $ 86,000,000.00 9 $ (50,000,000.00) 10 $ 45,000,000.00 135,000,000.00 204,000,000.00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Income
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
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