Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Projected Dates....
I am trying to determine a formula to work out an estimated projected date
in the future that an account will reach a certain balance. Because the amounts credited are random in date and amount, I need to simplify things by assuming that the next amount credited will be an average (mean) of all credits to the account spread over the time since the first payment and will be credited daily. This will change over time, depending on the amount and frequency of payment. In column A I have dates, in B a balance, which is calculated as the sum of all credits so far and column C holds payments to the account. Example 1 Jan 10------0------0 2 Jan 10------5------5 3 Jan 10------5------0 4 Jan 10-----15-----10 5 Jan 10-----15------0 6 Jan 10-----22------7 7 Jan 10-----28------6 ...... Column D will hold the calculation for the projection, this will be graphed and the resulting line will be used to calculate the projected date when it intersects with the projected amount (in E1) Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate a projected date | Excel Worksheet Functions | |||
What is the formula to get projected growth | Excel Discussion (Misc queries) | |||
Calculating Projected Dates | Excel Worksheet Functions | |||
Calculate projected figure | Excel Worksheet Functions | |||
projected sales? | Excel Discussion (Misc queries) |