Question: 09 (10 pts) - Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below

09 (10 pts) - Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below (e.g. 5 yr horizon with 0% to 50%! rate assumptions. What is your project example? Develop your own spreadsheet analysis with your own numbers) and show the result similar to what has been provided below. Your numbers will be different. (b) Create a graph in your spreadsheet showing % on X-axis and PW on y-axis. (c) describe what such a graph would demonstrate to your management and how it would be interpreted in business terms. Year 0 1 2 3 4 5 ($6.400) $0 $1.000 $2.000 $3.000 $4.000 5% ($6,400 $0 $1,000 $2,000 $3.000 $4,000 10% ($6,400 $0 $1,000 $2,000 $3,000 $4,000 15% ($6.400 $0 $1,000 $2,000 $3.000 $4,000 20% ($6,400 $0 $1,000 $2,000 $3.000 $4,000 25% ($6.400 $0 $1,000 $2,000 $3,000 $4,000 30% 35% ($6.4001156.400 $0 $ $1,000 $1,000 $2,000 $2,000 $3.000 $3.000 $4,000 _$4.000 40% 56.400) $0 $1.000 $2.000 $3.000 $4.000 $6.400 $0 $1.000 $2.000 $3.000 $4.000 50% (56.400) $0 $1.000 $2.000 $3.000 $4.000 PW $3,600 $1,749 $420 ($543) ($1.245) ($1.757 ($2.130 ||$2.402) ($2.597) ($2.735) ($2.829) FormulaText to ENPV(B1. -NPVIC1. NPV(D1. -NPV(E1. ENPV(F1. ENPV(G1, -NPV(H1. -NPV(11,12-NPV(J1,J -NPV/K1, -NPVIL1, Calculate PW B2B7) 02.07) 02.07) E2:E7) F2 F7) G2 G7) H2 H7) :17). 12:37) K2 K7L2L7) 09 (10 pts) - Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below (e.g. 5 yr horizon with 0% to 50%! rate assumptions. What is your project example? Develop your own spreadsheet analysis with your own numbers) and show the result similar to what has been provided below. Your numbers will be different. (b) Create a graph in your spreadsheet showing % on X-axis and PW on y-axis. (c) describe what such a graph would demonstrate to your management and how it would be interpreted in business terms. Year 0 1 2 3 4 5 ($6.400) $0 $1.000 $2.000 $3.000 $4.000 5% ($6,400 $0 $1,000 $2,000 $3.000 $4,000 10% ($6,400 $0 $1,000 $2,000 $3,000 $4,000 15% ($6.400 $0 $1,000 $2,000 $3.000 $4,000 20% ($6,400 $0 $1,000 $2,000 $3.000 $4,000 25% ($6.400 $0 $1,000 $2,000 $3,000 $4,000 30% 35% ($6.4001156.400 $0 $ $1,000 $1,000 $2,000 $2,000 $3.000 $3.000 $4,000 _$4.000 40% 56.400) $0 $1.000 $2.000 $3.000 $4.000 $6.400 $0 $1.000 $2.000 $3.000 $4.000 50% (56.400) $0 $1.000 $2.000 $3.000 $4.000 PW $3,600 $1,749 $420 ($543) ($1.245) ($1.757 ($2.130 ||$2.402) ($2.597) ($2.735) ($2.829) FormulaText to ENPV(B1. -NPVIC1. NPV(D1. -NPV(E1. ENPV(F1. ENPV(G1, -NPV(H1. -NPV(11,12-NPV(J1,J -NPV/K1, -NPVIL1, Calculate PW B2B7) 02.07) 02.07) E2:E7) F2 F7) G2 G7) H2 H7) :17). 12:37) K2 K7L2L7)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Examine the analysis provided below. (a) Select your own imaginary / hypothetical engineering project example with the same structure as below (e.g. 5 yr horizon with 0% to 50% rate assumptions. What...

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

P e e r -R e v ie w e d O p tim iz in g Safety Engineering, Systems, Human Factors: Part 1 By Vladimir Ivensky T safety program is to reduce or eliminate in cidents that result in harm to people or...

Read the case above Directed Reading "What it takes to be a good project manager" to answer: 1/ What are the three most critical skills for project management according to a study in "What it takes...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

Put together 10-20 slide presentation with recorded audio that demonstrates how you would present and deliver your capstone project to your intended audience. Your presentation should be persuasive,...

PAPERS What Project Strategy Really Is: The Fundamental Building Block in Strategic Project ManagementPeerasit Patanakul, Stevens Institute of Technology, Hoboken, NJ, USA Aaron J. Shenhar, Rutgers...

Q) HomelWordtune Read x l D Discussion x 9 Case Studyodt x + v C (D File [Users/monicakommineni/Downloads/Case%20$tudy.pdf [3 3:, 0 2 I, l] u, 5 Casestudypdf 100% + El 0:) mi own moo. win December...

5-407-753 MARK JEFFERY Air France Internet Marketing: Optimizing Google, Yahoo!, MSN, and Kayak Sponsored Search Rob Griffin, senior vice president and U.S. director of search for Media Contacts, a...

52. f(x) = = n=1 (1)n+(x - 2)" n

When customers purchase goods at a Radio Shack store, they are typically asked for their name and phone number so their purchase information can be stored. This would be one portion of the vast...

Firms are more capable than markets at coordinating highly complex tasks, while markets are more capable of providing high - powered incentives for entrepreneurship. True or False Prev 6 of 6 0 Next

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...