Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you please convert the budget into the XL file that I have provide 3.2 Cash flow estimate Produce a cash flow estimate for the
can you please convert the budget into the XL file that I have provide
3.2 Cash flow estimate Produce a cash flow estimate for the first year of operation. Or if your business is already in operation, you may decide to do this for the future operating year. Ensure you split your year into quarters to allow any seasonal income and expenses. This can be produced in a spreadsheet using the template supplied. You may keep it in the spreadsheet and submit separately with this financial plan or paste a link into this document to your calculations. To show you are serious about your financial plan, you need to create an email to the financial manager attaching this cash flow estimate to submit with your loan application Page 9 of 19 5041 words X English (United States) Focus + 239%Wages (2 employees - 520/ hour - 40 hours per week) 51,600 _- Total monthly fixed cost 3,630 Total variable cost per sale $7.10 Total variable cost per sale $10.60 1 2 3 4 5 6 9 LO 11 12 investment $19,430 SO 50 SO SO $0 SO SO SO SO Cash sales $14,630 Total cash $19,430 $14,630 $14,630 $14,630 $14,630 $14,630 $14,630 $14,630 $14,630 $14,630 $14,630 | $14,630 received expenses Wages (2 employees $20/hour $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 $6,930 - 40 hours per week) utilities 40 400 400 400 400 400 400 400 400 400 400 400 licenses 150 150 150 150 150 150 150 150 150 150 150 150 insurances 100 100 100 100 100 100 100 100 100 100 100 100 ent 930 930 930 930 930 930 930 930 930 930 930 930 Lase of fixed 400 400 400 400 400 400 400 400 400 400 400 400 assets marketing 100 100 100 100 100 100 inventories $12,000 $6,869 $6,869 $6,869 $6,869 $6,869 $6,869 $6,869 $6,869 $6,869 $6,869 $6,869 Total $21,010 $7,390 $7,390 $7,390 $7,390 $7,390 $7,390 $7,390 $7,390 $7,390 $7,390 $7,390 expenses Cash flow $2,630 $7,661 $7,661 $7,761 $7,761 $7,661 $7,761 $7,761 $7,761 $7,761 $7,761 $7,661 Cash $2,630 $10,291 $17,952 $25,713 $33,474 $41,135 $48,896 $56,657 $64,318 $72,079 $79,840 $87,501 balanceSmall Business Cash Flow Projection 2 Young & Unique Starting date Oct-21 Cash balance alert minimum 5 Beginning Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Cash on hand (beginning of month) 9 CASH RECEIPTS Apr Jun Aug Sep Oct Nov Total 10 Cash sales 11 Returns and allowances 12 Collections on accounts receivable 13 Interest, other income 14 Loan proceeds 15 Owner contributions 16 TOTAL CASH RECEIPTS 17 Total cash available 18 19 CASH PAID OUT Apr May Jun Jul Aug Sep Oct Nov Dec Total 20 Advertising 21 Commissions and fees 22 Contract labor 23 Employee benefit programs 24 Insurance (other than health) 25 Interest expense 26 Materials and supplies (in COGS) 27 Meals and entertainment 28 Mortgage interest 29 Office expense 30 Other interest expense 31 Pension and profit-sharing plan 32 Purchases for resale 33 Rent or lease 34 Rent or lease: vehicles, equipment 35 Repairs and maintenance 36 Supplies (not in COGS) 37 Taxes and licenses 38 Travel 39 Utilities 40 Wages (less emp. credits) 41 Other expenses 42 Other expenses 43 Other expenses 44 Miscellaneous 45 SUBTOTAL 46 CASH PAID OUT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 47 Loan principal payment 48 Capital purchases 49 Other startup costs 50 To reserve and/or escrow 51 Owners' withdrawal 52 TOTAL CASH PAID OUT 53 Cash on hand (end of month) 54 5 OTHER OPERATING DATA Aor Mav Jun Aua Sen Oct Nov Total 56 Sales volume (dollars) 57 Accounts receivable balance 58 Bad debt balance 59 Inventory on hand 60 Accounts payable balance 61 DepreciationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started