Uncategorized

Accounting & Financial

Accounting & Financial

I need help in Accounting and Finance regarding an assignment in my Entrepreneurship course, can you help me please? Im Document Preview:Actual Cash Flow Projection Projection Projection Pre-Startup Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Monthly Cash Flow Projection (a) Cash Sales (b) Collections from Credit Accounts (c) Loan or Other Cash Injection (a) Purchases (Merchandise) (b) Gross Wages (excludes withdrawals) (c) Payroll Expenses (Taxes, etc.) (d) Outside Services (e) Supplies (Office and operating) (f) Repairs and Maintenance (g) Advertising (h) Auto, Delivery, and Travel (i) Accounting and Legal (j) Rent (k) Telephone (l) Utilities (m) Insurance (n) Taxes (Real Estate, etc.) (o) Interest (p) Other Expenses [Specify each] (q) Miscellaneous [Unspecified] 2. CASH RECEIPTS 5. CASH PAID OUT 1. CASH ON HAND [Beginning of month] 3. TOTAL CASH RECEIPTS [2a + 2b + 2c=3] 4. TOTAL CASH AVAILABLE [Before cash out] (1 + 3) (r) Subtotal (s) Loan Principal Payment (t) Capital Purchases [Specify] (u) Other Start-up Costs (v) Reserve and/or Escrow [Specify] (w) Owners Withdrawal 7. CASH POSITION [End of month] (4 minus 6) 6. TOTAL CASH PAID OUT [Total 5a thru 5w] A. Sales Volume [Dollars] B. Accounts Receivable [End of Month] C. Bad Debt [End of Month] D. Inventory on Hand [End of Month] E. Accounts Payable [End of Month] F. Depreciation Enter Company Name Here Enter Date Here TOTAL Note: See Guidelines and Explanation contained in this file, for instructions on the completion of this cash flow projection. Checking: See cell A55 for checks that spreadsheet is calculating correctly. CHECKING (calculation verification) CHECK 1 CHECK 2 CHECK 3 CHECK 4 [See Guidelines worksheet for details] ESSENTIAL OPERATING DATA [Non-cash flow information] Marson Attachments: MARSON-RE.xls MARSON-Real-E.docx

Is this the question you were looking for? If so, place your order here to get started!

×