Solved

Excel NPV Partial Year 1 DCF

Posted on 2016-09-20
3
21 Views
Last Modified: 2016-10-12
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
Comment
Question by:John Davis
  • 3
3 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points (awarded by participants)
ID: 41808227
please see attached example.
Discount-Cash-Flow-Half-Year.xlsx
0
 
LVL 25

Expert Comment

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

Expert Comment

by:ProfessorJimJam
ID: 41839748
.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now