Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help making an Excel worksheet Project Integration Management 163 A B C D E F G Discount rate 10% 1 2 3 PROJECT

i need help making an Excel worksheet

image text in transcribed
Project Integration Management 163 A B C D E F G Discount rate 10% 1 2 3 PROJECT 1 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 |TOTAL 4 Benefits $0 $2,000 $3,000 $4,000 $5,000 $14,000 Costs $5,000 $1,000 $1,000 $1,000 $1,000 $9,000 6 Cash flow ($5,000) $1,000 $2,000 $3,000 $4,000 $5,000 7 NPV $2,316 Formula =npv(b1,b6:f6) Note that totals are CO equal, but NPVs are 10 PROJECT 2 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 TOTAL not because of the time value of money 11 Benefits $1,000 $2,000 $4,000 $4,000 $4,000 $15,000 12 Costs $2,000 $2,000 $2,000 $2,000 $2,000 $10,000 13 Cash flow ($1,000) $0 $2,000 $2,000 $2,000 $5,000 14 NPV- $3,201 15 Formula =npv(b1,b13:f13) 16 17 FIGURE 4-4 Net present value example Figure 4-4 illustrates this concept in Microsoft Excel for two different projects. Note that this example starts discounting immediately in Year 1 and uses a 10 percent discount rate. You can use the NPV function in Excel to calculate the NPV quickly. Detailed steps nted later

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Credit Portfolio Management

Authors: Arik Ben Do, Lev Dynkin, Jay Hyman, Bruce D. Phelps

1st Edition

1118117697, 978-1118117699

More Books

Students also viewed these General Management questions

Question

What are the pros and cons when 2 major restaurant chains merge?

Answered: 1 week ago