bmun
Dec 5, 2008, 08:33 PM
I am preparing a cash flow statement and do not understand how to come up with the ending cash balance. This is what I have so far:
Cash Received 2008 2009 2010 2011
Cash From Operations:
Cash Sales $20,895.00 $39,025.00 $55,200.00 $78,885.00
Cash from Receivables $0 $0 $0 $0
Subtotal Cash From Operations $20,895.00 $39,025.00 $55,200.00 $78,885.00
Additional Cash Received
Sales tax, Vat, HST/GST Received $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0
New other Liabilities (interest free) $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0
New Investment Received $0 $0 $0 $0
Subtotal Cash Received $20,895.00 $39,025.00 $55,200.00 $78,885.00
Expenditures
Expenditures from Operations:
Cash Spending $21,800.00 $21,800.00 $32,200.00 $42,600.00
Payment of Accounts Receivable $26,333.00 $33,060.00 $45,999.00 $54,005.00
Subtotal Spent on Operations $48,133.00 $54,860.00 $78,199.00 $96,605.00
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0
Principal Repayment of Current Borrowing$0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0
Long-term Liabilities Principal Repayment $8,600.00 $9,100.00 $9,850.00 $10,255.00
Purchase other Current Assets $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0
Dividends $0 $0 $0 $0
Subtotal Cash Spent $56,733.00 $63,960.00 $88,049.00 $106,860.00
Net Cash Flow ($35,838.00) ($24,935.00) ($32,849.00) ($27,975.00)
Cash Balance
Cash Received 2008 2009 2010 2011
Cash From Operations:
Cash Sales $20,895.00 $39,025.00 $55,200.00 $78,885.00
Cash from Receivables $0 $0 $0 $0
Subtotal Cash From Operations $20,895.00 $39,025.00 $55,200.00 $78,885.00
Additional Cash Received
Sales tax, Vat, HST/GST Received $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0
New other Liabilities (interest free) $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0
New Investment Received $0 $0 $0 $0
Subtotal Cash Received $20,895.00 $39,025.00 $55,200.00 $78,885.00
Expenditures
Expenditures from Operations:
Cash Spending $21,800.00 $21,800.00 $32,200.00 $42,600.00
Payment of Accounts Receivable $26,333.00 $33,060.00 $45,999.00 $54,005.00
Subtotal Spent on Operations $48,133.00 $54,860.00 $78,199.00 $96,605.00
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0
Principal Repayment of Current Borrowing$0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0
Long-term Liabilities Principal Repayment $8,600.00 $9,100.00 $9,850.00 $10,255.00
Purchase other Current Assets $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0
Dividends $0 $0 $0 $0
Subtotal Cash Spent $56,733.00 $63,960.00 $88,049.00 $106,860.00
Net Cash Flow ($35,838.00) ($24,935.00) ($32,849.00) ($27,975.00)
Cash Balance