Scribd
Upload
5 views3 pages

Cash Flow Analysis with NPV Calculation

The document presents a project timeline and cash flow analysis with an annual discount rate of 20% and monthly discount rate of 1.67%. It shows 5 tasks of varying durations between 0-8 months, with milestones and cash flows of -$5,000 and $3,000 occurring at months 3 and 8. The net present value is calculated to be $371.55.

Uploaded by

eleri morales
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
5 views3 pages

Cash Flow Analysis with NPV Calculation

The document presents a project timeline and cash flow analysis with an annual discount rate of 20% and monthly discount rate of 1.67%. It shows 5 tasks of varying durations between 0-8 months, with milestones and cash flows of -$5,000 and $3,000 occurring at months 3 and 8. The net present value is calculated to be $371.55.

Uploaded by

eleri morales
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Annual discount rate = 20%

Monthly discount rate = 1.67%

Duration Dollar-
Activity (mos) Start Time Finish Time Cash Flow Months NPV
START* 0 0 0 -
Task A 2 0 2 -
Task B 8 0 8 -
M 1* 0 3 $ (5,000) $(15,000) ###
Task C 4 3.75 7.75 -
M 2* 0 8 $ 3,000 $ 24,000 $2,628.41
Task D 8 3 11 -
Task E 3 8 11 -
END* 0 11 11 $ 3,000 $ 33,000 $2,501.25
$ 42,000 $ 371.55

*denotes milestone
0
0

Make payment
of $5000

M
1
TaskA Receive
2mos
TaskD payment of
8mos $3000
START TaskC
4mos
EN
D
TaskB
8mos TaskE
3mos

M
2

Receive
payment of
$3000
Receive
payment of
$3000

EN
D

You might also like