Optimistic Most Likely Pessimistic Сapital $90,000 $100,000 $120,000 investment 12 years $30,000 10 years $20,000 $30,000 Useful life 6 years SO Market value Net annual $35,000 $20,000 cash flow MARR (per year) 11% 11% 11%

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 9EA: If you invest $12,000 today, how much will you have in (for further Instructions on future value in...
icon
Related questions
Question

Suppose that, for an engineering project, the optimistic, most likely, and pessimistic estimates are as shown in the accompanying table. Develop a spreadsheet to determine the AW for each of the three estimate conditions. It is thought that the most critical elements are useful life and net annual cash flow. Include in your spreadsheet a table showing the AW for all combinations of the estimates for these two factors, assuming that all other factors remain at their most likely values.

Optimistic Most Likely Pessimistic
Сapital
$90,000
$100,000
$120,000
investment
12 years
$30,000
10 years
$20,000
$30,000
Useful life
6 years
SO
Market value
Net annual
$35,000
$20,000
cash flow
MARR (per
year)
11%
11%
11%
Transcribed Image Text:Optimistic Most Likely Pessimistic Сapital $90,000 $100,000 $120,000 investment 12 years $30,000 10 years $20,000 $30,000 Useful life 6 years SO Market value Net annual $35,000 $20,000 cash flow MARR (per year) 11% 11% 11%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College