Excel budgeting tool recommendations sought

[agwalsh]

Hi Folks
I've had a request from a client for the following...
She wants to locate an Excel budgeting tool that will allow her to
input actual balance sheet balances (as they are changed throughout the
year) in such a way that based on certain assumptions linking sheets
with cashflow projections and P & L data are filled in for the
following 3 -6 months. She said she has seen this model used in other
organisations (she can't get a copy, it was a custom built one).
She has a good model at the moment but it does not allow her to input
actual figures during the year without a great deal of tweaking and
fiddling.
For example, at the end of Quarter 1, she wants to be able to input
actual debtors, cash balances, asset balances and revised assumptions
if needs be and to have Excel then automatically generate cash flow
statements, revised Profit & Loss and Balance sheet for the coming
months...

Any thought/suggestions..

Anne

 

[Guest]

Start with the standard templates:

http://office.microsoft.com/en-us/templates/CT062100751033.aspx