Page 54 - CAREPOINT GLOBAL BUSINESS PLAN
P. 54
Appendix
Table: Cash Flow
P ro Forma Cash Flow
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Cash Received
Cash fromOperations
Cash Sales $40,000 $62,500 $121,000 $105,000 $130,000 $175,000 $222,000 $250,000 $272,000 $257,500 $290,000 $312,368
Subtotal Cash fromOperations $40,000 $62,500 $121,000 $105,000 $130,000 $175,000 $222,000 $250,000 $272,000 $257,500 $290,000 $312,368
Additional Cash Received
Non Operating (Other) Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Tax, VAT, HST/GST Received 5.00% $2,000 $3,125 $6,050 $5,250 $6,500 $8,750 $11,100 $12,500 $13,600 $12,875 $14,500 $15,618
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-termLiabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-termAssets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $42,000 $65,625 $127,050 $110,250 $136,500 $183,750 $233,100 $262,500 $285,600 $270,375 $304,500 $327,986
Expenditures Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Expenditures fromOperations
Cash Spending $30,500 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500
Bill Payments $1,469 $44,327 $52,889 $74,070 $74,669 $82,799 $102,596 $120,250 $131,713 $139,344 $133,996 $142,533
Subtotal Spent on Operations $31,969 $74,827 $83,389 $104,570 $105,169 $113,299 $133,096 $150,750 $162,213 $169,844 $164,496 $173,033
Additional Cash Spent
Non Operating (Other) Expense $0 $0 $0 $0 $0 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-termLiabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-termAssets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $31,969 $74,827 $83,389 $104,570 $105,169 $123,799 $143,596 $161,250 $172,713 $180,344 $174,996 $183,533
Net Cash Flow $10,031 ($9,202) $43,661 $5,680 $31,331 $59,951 $89,504 $101,250 $112,887 $90,031 $129,504 $144,454
Cash Balance $354,031 $344,829 $388,490 $394,170 $425,501 $485,452 $574,956 $676,206 $789,092 $879,123 $1,008,628 $1,153,082
Page 5