Net Present Value / Discounted Cash Flow Calculations

Hi guys..

i need some help in calculating the Discounted cash flow and Net present value for a project I made.... can someone please help me with it and create a sheet for these? in the "Assumptions centralized" sheet all the expenses and savings can be found. the project is for a 4 year period. discount rate 10%.

thx a lot in advance!

I'm working on a Discounted Cash Flow analysis and I think I've done more bad than good. If anyone could tell me if I'm on the right line or provide a little feedback I would greatly appreciate it. I'm stuck on how to calculate the margin of safety without a prior stock price...?

Thanks in advance!!

Trying to find a template (Excel) that calculates discounted cash flow (DCF)
valuation. Also need to show calculated fair value premium over market.
Either that or a reference that tells how to do it. Any suggestions?
Thanks!

Hi,

I am trying to set-up a cashflow statement that will allow users to enter
data against various categories for each day of use: i.e.

01-Jan-05 02-Jan-05 03-Jan-05 04-Jan-05 etc
Revenue:
Sales
Rental Income
etc


Expenses:
Rent
Overheads
Miscellaneous
etc

So in effect users would have a grid to enter their data into.

What I want to be able to do is:

for each of these expenses / revenues, group them first of all weekly
(running Sun-Sat) on a separate sheet, then group them monthly on a separate
sheet, which would allow analysis of weekly / monthly trends.

What is the best way of doing this?

I've managed to do this for the weekly groups by using a combination of the
sum and offset functions (as each week is a constant number of days (7), the
offset function allows me to "jump" across by 7 columns each time). however,
getting something for the monthly groupings is more difficult as each month
obviously varies in the number of days within it.

Any suggestions greatly appreciated,

Regards,

Gary T.

I have read a lot, but still can't figure out the best way to do this:

I have 60 cells aligned horizontally: (Jan-05 to Dec-09)
Above the dates I have a project cash flow.

First I need to report the date at the first occurence of cash flow (a
negative number).

Secondly, I need to report the date at the last occurence of cash flow
(a positive number).

This is so I could set up for the XIRR function. The problem is that
the cash flow appears in various dates and durations based on the
project parameters, so I can't lock the XIRR calc to specific cells.

Any help or guidance is greatly appreciated!

How do I come up with an annual IRR on a 4 month cash flow?
Many thanks in advance
Luiz

Cash Flows nov/09 dez/09 jan/09 fev/09 Revenues 100% on month 8 85.000,00 Land Investment -15.000,00 Loan Fee Loan Interest Last Month Other Licenses & Fees -4.000,00 Other Costs -1.000,00 Salaries Divided Evenly -4.023,33 -4.023,33 -4.023,33 Site Manager Salary Monthly 0,00 0,00 0,00 Construction 50% 1st month/Evenly the last 2 -17.000,00 -8.500,00 -8.500,00 Brokers Last Month -500,00 Eng+Arq Last Month -1.000,00 Taxes Last Month -5.100,00 Project Net Cash -42.023,33 -12.523,33 -13.023,33 79.900,00

I have a worksheet that models a budget for a new business. I would like to take data from that worksheet and fill another worksheet. That is pretty simple. However, I'd like to have the option of delaying certain payments (think commissions paid) by a factor (say 90 days). To watch the effects of this I'd like to be able to change the factor and have data fill in different months.

For example, in the worksheet in Month 4 there is a value of 100,000 and Month 5 has 150,000, etc. My delay factor in a cell on the new worksheet is "3" which would represent 3 months. I would then ideally have the value from Month 4 (100,000) be put in month 7 and month 5 value (150,000) in Month 8and so on. What is the best way to accomplish this? I need to finish this relatively quickly so if all else fails I'll just hard code it (which I really want to avoid). Thanks for your help, wizards and gurus

Hi all:

I need some help. What I am trying to do is take cash receipts and payables data from 1/1/2007 - 4/11/2008 (by week, period ending Friday of each week) and forecast what our weekly cash flow will be going forward, using the historical data as a baseline. Averaging doesn't work as some of the expenses are only paid once a month, so I'm looking for a function that will help ascertain that information. Anyone? anyone? Bueller?

Also, I'm taking the cash receipts data based on our average aging value of 44 days.

I would appreciate any assistance that can be provided. I'm sure it's been done by someone before but after trying to figure this out for a couple days my blinders are very likely on and I could use a fresh set of eyes. haha

Thanks, JBG

Hi,

I would be very grateful for some help;

I need to create a 5 year spreadsheet which for the first 3 years has 950 a month added to the cash flow and after the three years has 950 subtracted. It also needs to have another column which details a property sold each month and the figure it sold for. In other words for the first three years a property will be bought which will increase the rent by 950 each property and after three years it will decrease by one property resulting in a 950 decrease in rental but a value for the amount of profit realized.

Thanks

Mark

I am working on a cost reduction project in an automobile company.
Pl go through the below table as an example
Vehicle A Vehicle B Vehicle C
Savings throu Idea 1........ 200 250 300
Savings throu Idea 2........ 250 300 250
Savings throu Idea 3........ 100 150 150

Volumes in April - 10 50 50
Volumes in May - 20 50 50
Volumes in Jun - 30 100 100

Now, I want to calculate cash flow. Suppose Idea1 implemented in April, the benifits of the fin. year will be accountable on the vehicles from next month onwards (i.e., May, jun, jul... upto Mar).

If idea 3 implemented in Jun, benifits would be from July, aug and sep...upto Mar).

So i want to create a formula that if we key in the implementable month then excel should calculate the savings from the next month.

The formula for calculating cashflow is (Ex. if Idea1 impl in Apr)
=savings in Veh A * vol of Veh A (sum from May to Mar no.s) + savings in Veh B * vol of Veh B + savings in Veh C * vol of Veh C... and so on.

Can anybody suggest me what could be the formula because the work book size is very huge hence It is difficult to do this manually, that too every month.