OFFICIAL
Budgeted Income Statement and
Cashflows
Budgeted Income Statement
January February March Total
Receipts:
Fees Received $ 80,000.00 $ 90,000.00 $100,000.00 $270,000.00
Payments:
Wages 10,000.00 11,000.00 12,000.00 33,000.00
Office Expenses 4,000.00 4,200.00 4,800.00 13,000.00
Equipment Expenses 2,200.00 2,400.00 2,600.00 7,200.00
Motor Vehicle Expenses 5,800.00 5,200.00 5,000.00 16,000.00
Advertising 8,000.00 9,000.00 10,000.00 27,000.00
Other 3,400.00 3,600.00 3,000.00 10,000.00
Total Payments 33,400.00 35,400.00 37,400.00 106,200.00
Profit 46,600.00 54,600.00 62,600.00 163,800.00
Budgeted Cash Flows
Opening Cash Balance -$ 25,010.00 -$ 18,410.00 -$ 3,810.00 -$ 25,010.00
Add: Receipts 80,000.00 90,000.00 100,000.00 270,000.00
Equals Cash Available 54,990.00 71,590.00 96,190.00 244,990.00
Less: Payments 33,400.00 35,400.00 37,400.00 106,200.00
Less: Owner's Withdrawal 40,000.00 40,000.00 40,000.00 120,000.00
Closing Cash Balance - 18,410.00 - 3,810.00 18,790.00 18,790.00
Budgeted Income Statement
March Expected ChangeApril (Budgeted)
Receipts:
Fees Received $100,000.00 -$ 10,000.00 $ 90,000.00
Payments:
Wages 12,000.00 120.00 12,120.00
Office Expenses 4,800.00 240.00 5,040.00
Equipment Expenses 2,600.00 130.00 2,730.00
Motor Vehicle Expenses 5,000.00 250.00 5,250.00
Advertising 10,000.00 500.00 10,500.00
Other 3,000.00 150.00 3,150.00
Total Payments 37,400.00 1,390.00 38,790.00
Profit 62,600.00 $ 51,210.00
Budgeted Cash Flows
Opening Cash Balance -$ 3,810.00 $ 18,790.00
Add: Receipts 100,000.00 90,000.00
Equals Cash Available 96,190.00 108,790.00
Less: Payments 37,400.00 38,790.00
Less: Owner's Withdrawal 40,000.00 40,000.00
Closing Cash Balance 18,790.00 30,000.00