_$Ratio Analysis.xlsx - STATEMENT OF CASH FLOWS Business Name Start Date End Date Category Cash on Hand Cash Receipts Cash Sales Collections from credit

_$Ratio Analysis.xlsx - STATEMENT OF CASH FLOWS Business...

This preview shows page 1 - 3 out of 3 pages.

STATEMENT OF CASH FLOWS Business Name Start Date End Date Category Pre Start Up Estimate Month 1 Cash on Hand $ - ### Cash Receipts Cash Sales $ 637,599.14 Collections from credit accounts $ - Cash from Loans or other outside sources $ - TOTAL CASH RECEIPTS $ - $ 637,599.14 Total cash available $ - $ 637,599.14 Cash Paid Out Purchases $ 510,079.31 Gross Wages $ 59,300.00 Outside Services $ 1,500.00 Supplies $ 4,500.00 Repairs & Maintenance $ 300.00 Advertising $ 2,700.00 Car, Delivery, Travel $ 1,900.00 Rent $ 5,000.00 Telephone $ 1,500.00 Utilities $ 3,000.00 Depreciation $ 600.00 Other Expenses $ 2,500.00 SUBTOTAL $ - $ 592,879.31 Loan Principal Payment $ - Capital Purchase $ - Other Start Up Costs $ - Reserve and/or escrow $ - Other Withdrawals $ - Total Cash Paid Out $ - $ 592,879.31 Cash Position $ - $ 44,719.83
Image of page 1
Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 $ 44,719.83 $ 89,439.66 $ 134,159.48 $ 178,879.31 $ 223,599.14 $ 268,318.97 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 637,599.14 $ 682,318.97 $ 727,038.80 $ 771,758.63 $ 816,478.45 $ 861,198.28 $ 905,918.11 $ 510,079.31 $ 510,079.31 $ 510,079.31 $ 510,079.31 $ 510,079.31 $ 510,079.31 $ 59,300.00 $ 59,300.00 $ 59,300.00 $ 59,300.00 $ 59,300.00 $ 59,300.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 4,500.00 $ 4,500.00 $ 4,500.00 $ 4,500.00 $ 4,500.00 $ 4,500.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 2,500.00 $
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '17
  • Total Cash Receipts, total cash

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture