Cash Budget

Hi Guys, I have just done a cash budget take a look, I can show ye proper wednesday

 

Q1 (100 Units) Q2 (180 Units) Q3 (60 Units) Q4 (60 Units)
Cash In
Sales 20000 36000 12000 12000
Bank loan 10000
Share Capital 20000
Total Cash In 50000 36000 12000 12000
Cash Out
Materials 10050 18090 6030 6030
Vehicles Expenses 503.5 503.5 503.5 503.5
Tools 50 50 50 50
Heat &Power 75 75 75 75
Telephone and internet 120 120 120 120
Advertising & Promotion 17.5 17.5 17.5 17.5
Office Supplies and Postage 12.5 12.5 12.5 12.5
Total Cash Out 10828.5 18868.5 6808.5 6808.5
Net Cash 39171.5 17131.5 5191.5 5191.5
Opening Cash Balance 39171.5 22040 16848.5
Closing Cash Balance 39171.5 22040 16848.5 11657
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s