Question: Create a cashflow statement with the same format like the sample below BUT model it as if it were for a Digital Marketing agency startup.
Create a cashflow statement with the same format like the sample below BUT model it as if it were for a Digital Marketing agency startup.
Cash Flow Statement Presents a realistic assessment of cash requirements -inflows and outflows- over a projected 3-year period; cash flows are consistent with operating and marketing strategies outlined in the body of the plan; cash flow information is detailed annually for 3 years.

Beginning Year 1 Year 2 Year 3 $ 125,000 $ 125,000 $ 185,000 $ 185,000 $ 280,000 $ 280,000 $ 0 Operating C.F. Inflows: Sales Total Inflows Outflows: COGS Lease Payroll Insurance Advertising Depreciation Supplies Utilitics/Phone Miscellaneous Debt Svc (P&I) Taxes Total Outflows: Total Ops C.F. Investing C.F. Equipment Fixtures/leasehold Startup Inventory Total Invest C.F. Financing C.F. Loans Equity Total Fin C.F. Beginning Cash Ending Cash Bal 53,000 30,000 18,000 7,000 20,000 0 3,000 6,000 3,000 7,200 0 147,200 (22,200) 84,140 30,000 35,000 7,000 10,000 0 4,000 6,500 4,000 7,200 0 187,840 (2,840) 127,360 30,000 65,000 7,000 10,000 0 5,000 7,000 5,000 7,200 3,725 267,285 12,715 $ $ 0 0 20,000 25,000 5,000 5,000 $ (55,000) 0 0 0 0 36,000 54,000 $ 90,000 $ $ $ 0 0 0 35,000 12,800 0 0 12,800 9,960 0 0 9,960 22,675 $ 35,000 Beginning Year 1 Year 2 Year 3 $ 125,000 $ 125,000 $ 185,000 $ 185,000 $ 280,000 $ 280,000 $ 0 Operating C.F. Inflows: Sales Total Inflows Outflows: COGS Lease Payroll Insurance Advertising Depreciation Supplies Utilitics/Phone Miscellaneous Debt Svc (P&I) Taxes Total Outflows: Total Ops C.F. Investing C.F. Equipment Fixtures/leasehold Startup Inventory Total Invest C.F. Financing C.F. Loans Equity Total Fin C.F. Beginning Cash Ending Cash Bal 53,000 30,000 18,000 7,000 20,000 0 3,000 6,000 3,000 7,200 0 147,200 (22,200) 84,140 30,000 35,000 7,000 10,000 0 4,000 6,500 4,000 7,200 0 187,840 (2,840) 127,360 30,000 65,000 7,000 10,000 0 5,000 7,000 5,000 7,200 3,725 267,285 12,715 $ $ 0 0 20,000 25,000 5,000 5,000 $ (55,000) 0 0 0 0 36,000 54,000 $ 90,000 $ $ $ 0 0 0 35,000 12,800 0 0 12,800 9,960 0 0 9,960 22,675 $ 35,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
