Forecast payments over 24 months

[gk759]

Hi,

I have the task of creating an excel formula to spread total value for each contract over 24 month columns....i.e 2010 and 2011. Based on start date. The amount needs to be spread Monthly,quarterly, semi-annually or yearly dependng on the terms of the contract.

I am not sure if this can be accomplished within the excel boundaries with VBA or a formula.I tried to look up forums, vba excel books etc....but couldn't come across something relevant to steer me in the right direction

Thoughts?

Thanks in advance.

Gary

 

[SkipVought]

Hi,

This seems like a pretty simple spreadsheet solution would work.

Your formule would determine which type and return a value accordingly,based on the dates in the top row.

I'd suggest reposting in forum68. Please include the data related to contract terms, that would be used to determine how the payments are accrued.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gk759]

Thanks Skip I'll repost on the other forum too


Here is a sample of the date

Contract Start Date Amount Type

A 1/20/2010 $1000 Quarterly

B 2/10/2010 $2000 Semi Annually

C 4/01/2010 $3000 Monthly

D 3/23/2010 $5000 Yearly