Cash Budget2

Hi guys, did more to the cash budget, I hope i am going in the right direction here!!!

 

Notes Q1 (100 Units) Q2 (180 Units) Q3 (60 Units) Q4 (60 Units) Q1 Q2 Q3 Q4
Cash In Sales volume 100 180 60 60
Sales 1 20000 36000 12000 12000 Selling price 200 200 200 200
Bank loan 10000 20000 36000 12000 12000
Share Capital 20000
Total Cash In 50000 36000 12000 12000
Cash Out
Purchases 2 20100 5025 10050 15075 Material to make 1 board by the amount units sold
Petrol 8 1000 1000 1000 1000
Vehicles Expenses 7 2014 Q1 Q2 Q3 Q4
Tools 6 500 500 2 Opening Stock 0 100 50 50
Heat &Power 5 75 75 75 75 Closing Stock 100 50 50 100
Telephone and internet 120 120 120 120 Sales Value 100 100 100 100
Advertising & Promotion 3 500 500 300 300 Required Production 200 50 100 150
Interest payment 4 1382.97 1382.97 1382.97 1382.97 Cost per unit 100.5 100.5 100.5 100.5
Office Supplies and Postage 100 100 100 100 Purchases 20100 5025 10050 15075
Total Cash Out 25791.97 8702.97 13027.97 18052.97
3 Advertising: We will set aside 1600 for advertising in year 1
Net Cash 24208.03 27297.03 -1027.97 -6052.97
Opening Cash Balance 24208.03 -3089 -2061.03 4 10,000 Loan from the credit union with monthylu payments of 406.99, Total Interest: 1063.76
Closing Cash Balance 24208.03 -3089 -2061.03 3991.94
5 Due to uour small work area is a residental premises we will have no rent in yr 1 and Heat and power will be average 120 per quarter
6 Budget for 1000 for tools in year 1
7 Car Insurance for year 1 will be 2014 fully comp for year 1
8 Petrol budget will be 1000 for year 1
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