Cash Flow

profilebondsp
cash_flow.xlsx

Sheet1

Cash Flow 2014 2015 2016 2017 2018
CASH RECEIPTS
Income from Sales
Cash Sales $805,955 $1,363,790 $1,818,961 $2,344,876 $2,893,550
Collections $0 $0 $0 $0 $0
Total Cash from Sales $805,955 $1,363,790 $1,818,961 $2,344,876 $2,893,550
Income from Financing
Interest Income $2,483 $4,605 $10,538 $19,416 $37,846
Loan Proceeds $0 $0 $0 $0 $0
Equity Capital Investments $230,000 $0 $0 $0 $0
Total Cash from Financing $232,483 $4,605 $10,538 $19,416 $37,846
Other Cash Receipts $0 $0 $0 $0 $0
TOTAL CASH RECEIPTS $1,038,438 $1,368,394 $1,829,499 $2,364,291 $2,931,396
CASH DISBURSEMENTS
Inventory $150,695 $250,598 $316,381 $418,331 $515,185
Operating Expenses $614,517 $850,571 $989,022 $1,153,745 $1,334,105
Commissions/Returns & Allowances $29,300 $50,519 $66,745 $85,472 $105,659
Capital Purchases $40,244 $0 $0 $0 $0
Loan Payments $0 $0 $0 $0 $0
Income Tax Payments $0 $0 $0 $0 $0
Investor Dividend Payments $0 $0 $0 $0 $0
Owner's Draw $0 $0 $0 $0 $0
TOTAL CASH DISBURSEMENTS $834,756 $1,151,688 $1,372,148 $1,657,549 $1,954,949
NET CASH FLOW $203,682 $216,706 $457,351 $706,743 $976,447
Opening Cash Balance $1,584,482
Cash Receipts $2,931,396
Cash Disbursements $1,954,949
ENDING CASH BALANCE $203,682 $420,388 $877,739 $1,584,482 $2,560,929

Sheet2

Sheet3