New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Bank Balance Projection

Free Excel Templates

Bank Balance Projection

Postby Sisyphus » Sun Apr 08, 2012 10:21 pm

Enter today’s date and balance. Enter the desired reach and, at the click of a button, this little tool will show you how your bank or credit card balance will develop over the next couple of months under the influence of recurring items of revenue and expenditure.
To set up a list of recurring posts takes but a few minutes. You can include non-recurring and estimated items, too. There is a tab for concise ‘Help’.
Maintenance requirements are near zero. Just update the actual balance once in a while. Outdated items will be removed, new items will be added. Review any estimates, add any non-recurring items, and go back to enjoy your life.

This isn’t an accounting tool. Accounts deal with the past. This tool concerns itself with the future.
It can easily be adapted to project balances for inventory levels, too.

Open the attached Example workbook to see a demonstration. On the ‘Projection’ tab, enter today’s date and press the ‘Update’ button.
Use the template workbook, also attached, to create your own workbooks. Use a different workbook for each balance you need to keep an eye on. For technical reasons the template is attached as a zipped file. You can also create your own template file by deleting all recurring entries from the 'Posts' worksheet of the Example workbook and saving it with an xlt or xltm extension.
You do not have the required permissions to view the files attached to this post.
Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Return to Excel Templates

Who is online

Users browsing this forum: No registered users and 5 guests

cron