Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Excel NPV Partial Year 1 DCF

Posted on 2016-09-20
Medium Priority
78 Views
I need to discount a cash flow that has a partial (6 mo.) Year 1.  All other years are 12 months.  End of period discounting.
0
Question by:John Davis
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3

LVL 27

Accepted Solution

ProfessorJimJam earned 2000 total points (awarded by participants)
ID: 41808227
Discount-Cash-Flow-Half-Year.xlsx
0

LVL 27

Expert Comment

ID: 41812769
the example portrays the partial year DCF. please let me know, if you need further help.
0

LVL 27

Expert Comment

ID: 41839748
.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month4 days, 21 hours left to enroll