Unit 6 powerpoint

profileSkylerreybrasil
CashFlow-Q4.xlsx

Cash Flow

Cash Flow
Report Item Quarter 1 Quarter 2 Quarter 3 Quarter 4
Beginning Cash Balance 0 1,100,000 2,071,359 3,056,753
Receipts and Disbursements from Operating Activities
Revenues 0 1,878,000 3,959,500 8,636,500
- Rebates 0 35,700 71,600 159,300
- Production 0 1,209,029 2,157,994 6,129,752
- Research and Development 120,000 60,000 0 180,000
- Advertising 0 131,790 130,449 333,359
- Sales Force Expense 0 124,392 277,390 355,182
- Sales Office Expense 180,000 300,000 200,000 200,000
- Marketing Research 0 15,000 15,000 15,000
- Shipping 0 30,730 53,504 101,533
- Inventory Holding Cost 0 0 0 0
- Excess Capacity Cost 0 0 0 0
- Income Taxes 0 0 271,169 447,350
+ Interest Income 0 0 3,000 6,000
- Interest Charges 0 0 0 0
+ Other Income 0 0 0 0
- Other Expenses 0 0 0 0
= Net Operating Cash Flow -300,000 -28,641 785,394 721,024
Investing Activities
Fixed Production Capacity 600,000 0 600,000 600,000
= Total Investing Activities 600,000 0 600,000 600,000
Financing Activities
Increase in Common Stock 2,000,000 1,000,000 1,000,000 0
+ Borrow Emergency Loan 0 0 0 0
- Repay Emergency Loan 0 0 0 0
- Deposit 3 Month Certificate 0 0 200,000 200,000
+ Withdraw 3 Month Certificate 0 0 0 0
= Total Financing Activities 2,000,000 1,000,000 800,000 -200,000
Cash Balance, End of Period 1,100,000 2,071,359 3,056,753 2,977,778
End of Worksheet