Business plan

profileizzy16
CashflowStaplesYolonda_TenderLovNCare_CashFlow-LD2.XLSX
Home>Business & Finance homework help>Business plan

Cash Flow Monthly

YEAR 1: Monthly Cash Flow Projection BUSINESS NAME: Tender LovN Care Date: Nov 8, 2017
Pre-Startup Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 TOTAL
1. CASH ON HAND $ - 0 $ 188.00 $ 1,131.63 $ 775.26 $ 218.89 $ 112.52 $ 1,756.15 $ 3,049.78 $ 4,643.41 $ 2,737.04 $ 4,180.67 $ 5,374.30 $ 8,967.93
[Beginning of month]
2. REVENUES
Host Home Care 2,500 2,500 2,500 2,500 5,000 5,000 5,000 5,000 5,000 5,000 7,500 7,500 55,000
Other revenue categories -
Other revenue categories - - - - - - - - - - - - -
Other revenue categories - - - - - - - - - - - - -
Loan 2,000 - - - - - - - - - - - - 2,000
Personal Cash Injection 2,500 - - - - - - - - - - - - 2,500
3. TOTAL CASH RECEIPTS 4,500 2,500 2,500 2,500 2,500 5,000 5,000 5,000 5,000 5,000 5,000 7,500 7,500 59,500
[2a + 2b + 2c=3]
4. TOTAL CASH AVAILABLE 4,500 2,688 3,632 3,275 2,719 5,113 6,756 8,050 9,643 7,737 9,181 12,874 16,468 59,500
[Before cash out] (1 + 3)
5. EXPENSES
(A) COST OF GOODS SOLD
Toiletries 150 150 150 150 300 300 300 300 300 300 450 450 450 3,750
Food 250 250 250 250 500 500 500 500 500 500 750 750 750 6,250
Auto, Delivery, and Travel 25 25 25 25 25 25 25 25 25 25 25 25 300
Purchases (Merchandise - d) - - - - - - - - - - - - - -
Purchases (Merchandise - e) - - - - - - - - - - - - - -
Purchases (Merchandise - f) - - - - - - - - - - - - - -
TOTAL COGS 400 425 425 425 825 825 825 825 825 825 1,225 1,225 1,225 10,300
(B) SGA EXPENSES
Cleaning - - - - - 100 100 100 100 100 100 150 150 900
Supplies & Equipment 550 - - - - - - - - - - - 550
Repairs and Maintenance - - - - - - 200 - - - - - - 200
Advertising 200 - - 150 - - - - - 150 - - 500
Auto, Delivery, and Travel 35 35 35 35 35 35 35 35 35 35 35 35 35 455
Meals & Entertainment 100 - - - - - - - - - - - - 100
Accounting and Legal 650 - - 50 - - 100 - 500 - - 50 - 1,350
Telephone 24 124 124 124 124 124 124 124 124 124 124 124 124 1,512
Utilities - 75 75 75 75 75 125 125 125 125 125 125 175 1,300
Insurance (GL & Commercial Auto) 1,003 - - - - - - - - - - - - 1,003
Taxes (Real Estate, etc.) - - - - - - - - - - - - - -
Interest Expense 12 11 10 10 9 9 8 7 7 6 5 5 99
Website 25 10 10 10 10 10 10 10 10 10 10 10 10 145
Memberships, Dues - - - - - - - - - - - - - -
Professional Development 325 - - - - - - - - - - - - 325
Licenses and Fees 50 - - - - - - - - - - - - 50
Loan Principal Payment - 106 106 107 108 108 109 109 110 111 111 112 113 1,310
Loan Orgination fee 50
Capital Purchases 900 - - - - - - - - - - - - 900
Reserve / Contingency - 770 770 770 770 770 770 770 770 770 770 770 770 9,240
Owner's Withdrawal - - 1,300 1,300 650 1,300 1,300 1,300 4,300 1,300 1,300 1,300 1,300 16,650
TOTAL SGAE COSTS 3,912 1,131 2,431 2,631 1,781 2,531 2,881 2,581 6,081 2,731 2,581 2,681 2,681 36,588
6. TOTAL EXPENSES PAID OUT 4,312 1,556 2,856 3,056 2,606 3,356 3,706 3,406 6,906 3,556 3,806 3,906 3,906 46,888
[COGS + SGAE]
7. CASH POSITION 188 1,132 775 219 113 1,756 3,050 4,643 2,737 4,181 5,374 8,968 12,562 12,612
[End of month] (4 minus 6)