20x0 2
Dec Jan
Total sales 400,000 440000
Cash sales 100000 110000
Sales on account 300,000 330,000
20x1
Feb Mar I Quarter
484000 532400 1456400
121000 133100 364100
363,000 399,300 1,092,300
Jan
cash sales 110000
Cash coll. from credit
sales made during the
month 33000
Cash coll. from credit
sales made during the
preceding month 270000
Total cash receipts 413000
20x1
Feb Mar I Quarter
121000 133100 364100
36300 39930 109230
297000 326700 893700
454300 499730 1367030
20x0
Dec
Budgeted cost of goods sold 280000
Add:Desired ending inv 154000
Total goods needed 434000
Less:Expected beg inv 140000
Purchases 294000
20x1
Jan Feb Mar I Quarter
308000 338800 372680 1019480
169400 186340 186340 186340
477400 525140 559020 1205820
154000 169400 186340 154000
323400 355740 372680 1051820
Inv purchases:
Cash payments for purchases
during the current month
Cash payments for purchases
during the preceding month
Total cash payment for inv
purchases
Other expenses:
Sales salaries
Adv and promotion
Admin salaries
Interest on bonds
Property taxes
Sales commissions
Total cash payments for other exp
Total cash disbur
20x1
Jan Feb Mar I Quarter
129360 142296 149072 420728
176400 194040 213444 583884
305760 336336 362516 1004612
21000 21000 21000 63000
16000 16000 16000 48000
21000 21000 21000 63000
15000 0 0 15000
0 5400 0 5400
4400 4840 5324 14564
77400 68240 63324 208964
383160 404576 425840 1213576
Cash receipts
Less:Cash disb
Change in cash balances during
period due to operations
Sale of marketable securities
Proceeds from bank loan
Purchase of equipment
Repayment of bank loan
Interest on bank loan
Payment of dividends
Change in cash balance during first
quarter
Cash balance 1/1/x1
Cash balance 3/31/x1
20x1
Jan Feb Mar I Quarter
413000 454300 499730 1367030
383160 404576 425840 1213576
29840 49724 73890.0000000001 153454
15000
100000
125000
100000 100000
2500 2500
50000 50000
19840 49724 -78610 -9046
35000
25954
Projected cash balance as on Dec 31 20x0
Less:Minimum cash balance
Cash avl for equip purchase
Projected proceeds from sale of marketable securities
Cash available
Less:Cost of investment in equipment
Required short-term borrowing
35000
25000
10000
15000
25000
125000
-100000
Income statement for first quarter 20x1
Revenue
COGS
Gross Margin
Expenses:
Sales salaries
Adv and promotion
Admin salaries
Interest on bonds
Property taxes
Sales comm
Interest on bank loan
Depreciation
Total exp
Net income
ement for first quarter 20x1
1456400
1019480
436920
63000
48000
63000
7500
2700
14564
2500
75000
276264
160656
Retained earnings on Mar 31 20x1
Retained earnings on Dec 31 20x0 107500
Net income 160656
Dividends 50000
Retained earnings on Mar 31 20x1 218156
Balance sheet on March 31 20x1
Cash
Accounts receivable
Marketable securities
Inventory
Buildings and equip
Total assets
Accounts payable
Bond interests payable
Property tax payable
Bonds payable(10% due in 20x6)
Common stock
Retained earnings
Total liabilities and stockholders' equity
25954.0000000001
359370
0
186340
676000
1247664
223608
5000
900
300000
500000
218156
1247664