AOClothingCashFlowFinal.xlsx
Sheet1
| Cash Flows Statement | | Year 1 Breakdown |
| | | Start Up | January | February | March | April | May | June | July | August | September | October | November | December | Y1 |
| Cash on Hand |
| Cash in | | $0.00 | $13,057.50 | $21,614.97 | $21,602.42 | $21,519.84 | $21,447.84 | $21,445.21 | $21,512.58 | $21,569.93 | $21,657.93 | $21,825.38 | $22,012.65 | $22,269.90 | $251,536.15 |
| Investment Owner | | $10,000.00 |
| Outside Investors | | $80,000.00 |
| Revenue | | $0.00 | $50,000.00 | $50,290.00 | $50,360.00 | $50,440.00 | $50,530.00 | $50,610.00 | $50,700.00 | $50,780.00 | $51,000.00 | $51,030.00 | $51,200.00 | $51,450.00 | $608,390.00 |
| Total Cash in | | $90,000.00 | $63,057.50 | $71,904.97 | $71,962.42 | $71,959.84 | $71,977.84 | $72,055.21 | $72,212.58 | $72,349.93 | $72,657.93 | $72,855.38 | $73,212.65 | $73,719.90 | $796,868.65 |
| Cash Out |
| Rent Deposit | | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $13,000.00 |
| Equipment Purchase | | $15,000.00 |
| Furniture Purchase | | $15,000.00 |
| Postage | | $12.50 | $12.53 | $12.55 | $12.58 | $12.00 | $12.63 | $12.63 | $12.65 | $12.00 | $12.55 | $12.73 | $12.75 | $12.40 | $162.50 |
| Insurance | | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $1,040.00 |
| Utilities | | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $650.00 |
| Wages | | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $3,250.00 |
| Advertising | | $550.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $1,150.00 |
| Leasehold Improvements | | $10,000.00 |
| Monthly Expenses |
| Inventory | | $35,000.00 | $40,000.00 | $48,860.00 | $49,000.00 | $49,070.00 | $49,090.00 | $49,100.00 | $49,200.00 | $49,250.00 | $49,390.00 | $49,400.00 | $49,500.00 | $49,600.00 | $616,460.00 |
| Total Cash Out | | $76,942.50 | $41,442.53 | $50,302.55 | $50,442.58 | $50,512.00 | $50,532.63 | $50,542.63 | $50,642.65 | $50,692.00 | $50,832.55 | $50,842.73 | $50,942.75 | $51,042.40 | $675,712.50 |
| Ending Cash Balance | | $13,057.50 | $21,614.97 | $21,602.42 | $21,519.84 | $21,447.84 | $21,445.21 | $21,512.58 | $21,569.93 | $21,657.93 | $21,825.38 | $22,012.65 | $22,269.90 | $22,677.50 | $274,213.65 |
Omar93
