if you could please help me out it would be highly appreciate
Produce a cash flow estimate for the first year of operation. 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 also make an email to the financial manager attaching this cash flow estimate to submit with your loan application
my business ia a small clothing business that will offer young teens ECO friendly clothing at a cheap price
I have provide a photo of my answer and feedback
AutoSave OF AP vG... Cash flow projection template 9 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial (Headings) 14 ~ Al A ah Wraa Text General SR X G V SIX V 7 @ Pagic :- %3D%3D Insert BIU Merge & Centre Delete - A A $ - % Conditional Format Cell Formatting as Table Styles Format Sort Filter Fine Select Analyse Data B1 fx Small Business Cash Flow Projection T A B D E F G H 1 J K M N O P 6 Beginning Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Cash on hand (beginning of month) 0 6,357 7,494 8,431 9,568 10.705 11,592 12,729 13,266 14,403 15,540 16.677 Jun Jan 19,430 Feb 14,6301 Mar 14,630 Apr 14,630 May 14,630 Jul 14,630 Aug 14,630 Sep 14,630 Oct 14,630 Nov 14,630 Dec 14.630 7 8 9 10 11 12 13 14 14,630 CASH RECEIPTS Cash sales Returns and allowances receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available Total 180,360 0 0 0 0 20.000 0 200,360 20,000 39,430 39,430 14,630 20,987 14,630 22,124 14,630 23,061 14,630 24,198 14,630 25,335 14,630 26,222 14,630 27,359 14,630 27,896 14,630 29,033 14,630 30,170 14,630 31,307 0 Jan 100 Feb 100 Mar 100 Apr 100 May 100 Jun 100 Jul 100 Aug 100 Sep 1001 Oct 100 Nov 100 Dec 100 0 0 560 100 0 560 100 0 560 100 0 0 560 100 0 560 100 660 100 0 560 100 0 560 100 0 560 100 0 0 560 100 0 560 100 ol 660 100 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 3,000 0 3,000 0 3,000 ol 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 CASH PAID OUT Advertising Commissions and fees Contract labor Employee benefit programs Insurance (other than health) Interest expense Materials and supplies (in COGS Meals and entertainment Mortgage Interest Office expense Other interest expense Pension and profit-sharing plan Purchases for resale Rent or lease Rent or lease: vehicles, equipmeil Repairs and maintenance Supplies (not in COGS) Taxes and licenses Cash Flow Total 1,200 0 0 6,920 1,200 0 36,000 0 0 300 0 0 0 10,8001 0 1,000 12.000 6,000 150 150 900 900 0 900 U 0 900 0 900 0 900 0 900) 0 900 0 900 0 0 900 0 200 1,000 500 900 0 600 1,000 500 900 ol 200 1.000 500 1.000 500 1,000 500 1.000 500 1,000 500 1,000 500 1,000 500 1.000 500 1,000 500 1,000 500 + Ready Average: 18577.33984 Count: 499 Sum: 6929347.76 169% AutoSave OF AP vG... Cash flow projection template 9 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LE Arial (Headings) 14 ~ Al A 5 Wran Text General SR V V 7 @ v Paste B 1 :- %3D%3D Merge & Centre Insert Delete Format A Sort $ - % Conditional Format Cell Formatting as Table Styles Find & Select Analyse Data B1 X T fx Small Business Cash Flow Projection A B D E F G H 1 J K L M N o ol 400 6,933 0 400 6,933 ol 400 6,933 0 400 6,933 0 400 6,933 ol 400 6,933 0 ol 4001 6,933 0 400 6,933 ol 400 6,933 0 400 6.933 400 6,933 0 400 6,933 0 4.800 83,196) 0 38 39 40 41 42 43 44 45 46 47 48 Travel Utilities Wages (less emp. credits) Other expenses Other expenses Other expenses Miscellaneous SUBTOTAL CASH PAID OUT Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month) 13,6431 Jan 13,493 Feb 13,693 Mar 13,493 Apr 13,493 May 13,743 Jun 13.4931 Jul 14.093 Aug 13,493 Sep 13,493 Oct 13,493 Nov 13,793 Dec 0 0 0 163.416 Total 0 0 19,430 0 0 182,846 49 19,430 33,073 6.357 13,4931 7,494) 13,6931 8,431 13,493 9,568 13,493 10,705 13,743 11.592 13,493 12,7291 14,0931 13,266 13,493 14,403 13,493 15,540 13,493 16,677 13,793 17,514 Jan 77,720 34 Feb 58,412 34 Mar 58,412 34 Apr 58,412 34 May 58,412 34 Jun 58,412 34 Jul 58,4121 34 Aug 58,412 34 Sep 58,412 34 Oct 58,412 34 Nov 58,412 34 Dec 58,412 34 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 OTHER OPERATING DATA Sales volume (dollars) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation Total 720,252 404) 0 17,159 30 737,845 1,456 2 79,212 1,457 2 59,905 1,466 2 59,914 1,440 2 59,888 1,430 2 59,878 1,457 2 59,905 1.398 2 59,846 ) 1,306 2 59,754 1,390 2 59,8387 1,420 2 59,868 1,493 2 59,941 1.446 2 2 59,894 Cash Flow + Ready Average: 18577.33984 Count: 499 Sum: 6929347.76 S: 169% 3.2 As part of your loan application, you need to develop a cash flow estimate for the first year of operation. The year needs to be split into financial quarters (July Sep, Oct-Dec, Jan-Mar, Apr-Jun) to allow for any seasonal income and expenses. You may use the Cashflow projection template provided. You need to email the Cash Flow Projection to the bank, as part of the application process, you may use the email template provided. Rebecca you've made a good start on this question however you have not followed instructions. The year needs to be split into financial quarters for example July to September I would suggest you use the cash flow projection template provided. Also note that the cash flow should show when the cash comes and goes in your business it would appear that you have listed your expenses as if this was a profit and loss does not demonstrate the changes in outgoings that would occur to match your revenue. I would suggest you discuss this area with a teacher. You were also meant to include an email to the bank as part of the application process. Please resubmit AutoSave OF AP vG... Cash flow projection template 9 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial (Headings) 14 ~ Al A ah Wraa Text General SR X G V SIX V 7 @ Pagic :- %3D%3D Insert BIU Merge & Centre Delete - A A $ - % Conditional Format Cell Formatting as Table Styles Format Sort Filter Fine Select Analyse Data B1 fx Small Business Cash Flow Projection T A B D E F G H 1 J K M N O P 6 Beginning Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Cash on hand (beginning of month) 0 6,357 7,494 8,431 9,568 10.705 11,592 12,729 13,266 14,403 15,540 16.677 Jun Jan 19,430 Feb 14,6301 Mar 14,630 Apr 14,630 May 14,630 Jul 14,630 Aug 14,630 Sep 14,630 Oct 14,630 Nov 14,630 Dec 14.630 7 8 9 10 11 12 13 14 14,630 CASH RECEIPTS Cash sales Returns and allowances receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available Total 180,360 0 0 0 0 20.000 0 200,360 20,000 39,430 39,430 14,630 20,987 14,630 22,124 14,630 23,061 14,630 24,198 14,630 25,335 14,630 26,222 14,630 27,359 14,630 27,896 14,630 29,033 14,630 30,170 14,630 31,307 0 Jan 100 Feb 100 Mar 100 Apr 100 May 100 Jun 100 Jul 100 Aug 100 Sep 1001 Oct 100 Nov 100 Dec 100 0 0 560 100 0 560 100 0 560 100 0 0 560 100 0 560 100 660 100 0 560 100 0 560 100 0 560 100 0 0 560 100 0 560 100 ol 660 100 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 3,000 0 3,000 0 3,000 ol 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 3,000 0 CASH PAID OUT Advertising Commissions and fees Contract labor Employee benefit programs Insurance (other than health) Interest expense Materials and supplies (in COGS Meals and entertainment Mortgage Interest Office expense Other interest expense Pension and profit-sharing plan Purchases for resale Rent or lease Rent or lease: vehicles, equipmeil Repairs and maintenance Supplies (not in COGS) Taxes and licenses Cash Flow Total 1,200 0 0 6,920 1,200 0 36,000 0 0 300 0 0 0 10,8001 0 1,000 12.000 6,000 150 150 900 900 0 900 U 0 900 0 900 0 900 0 900) 0 900 0 900 0 0 900 0 200 1,000 500 900 0 600 1,000 500 900 ol 200 1.000 500 1.000 500 1,000 500 1.000 500 1,000 500 1,000 500 1,000 500 1.000 500 1,000 500 1,000 500 + Ready Average: 18577.33984 Count: 499 Sum: 6929347.76 169% AutoSave OF AP vG... Cash flow projection template 9 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LE Arial (Headings) 14 ~ Al A 5 Wran Text General SR V V 7 @ v Paste B 1 :- %3D%3D Merge & Centre Insert Delete Format A Sort $ - % Conditional Format Cell Formatting as Table Styles Find & Select Analyse Data B1 X T fx Small Business Cash Flow Projection A B D E F G H 1 J K L M N o ol 400 6,933 0 400 6,933 ol 400 6,933 0 400 6,933 0 400 6,933 ol 400 6,933 0 ol 4001 6,933 0 400 6,933 ol 400 6,933 0 400 6.933 400 6,933 0 400 6,933 0 4.800 83,196) 0 38 39 40 41 42 43 44 45 46 47 48 Travel Utilities Wages (less emp. credits) Other expenses Other expenses Other expenses Miscellaneous SUBTOTAL CASH PAID OUT Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month) 13,6431 Jan 13,493 Feb 13,693 Mar 13,493 Apr 13,493 May 13,743 Jun 13.4931 Jul 14.093 Aug 13,493 Sep 13,493 Oct 13,493 Nov 13,793 Dec 0 0 0 163.416 Total 0 0 19,430 0 0 182,846 49 19,430 33,073 6.357 13,4931 7,494) 13,6931 8,431 13,493 9,568 13,493 10,705 13,743 11.592 13,493 12,7291 14,0931 13,266 13,493 14,403 13,493 15,540 13,493 16,677 13,793 17,514 Jan 77,720 34 Feb 58,412 34 Mar 58,412 34 Apr 58,412 34 May 58,412 34 Jun 58,412 34 Jul 58,4121 34 Aug 58,412 34 Sep 58,412 34 Oct 58,412 34 Nov 58,412 34 Dec 58,412 34 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 OTHER OPERATING DATA Sales volume (dollars) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation Total 720,252 404) 0 17,159 30 737,845 1,456 2 79,212 1,457 2 59,905 1,466 2 59,914 1,440 2 59,888 1,430 2 59,878 1,457 2 59,905 1.398 2 59,846 ) 1,306 2 59,754 1,390 2 59,8387 1,420 2 59,868 1,493 2 59,941 1.446 2 2 59,894 Cash Flow + Ready Average: 18577.33984 Count: 499 Sum: 6929347.76 S: 169% 3.2 As part of your loan application, you need to develop a cash flow estimate for the first year of operation. The year needs to be split into financial quarters (July Sep, Oct-Dec, Jan-Mar, Apr-Jun) to allow for any seasonal income and expenses. You may use the Cashflow projection template provided. You need to email the Cash Flow Projection to the bank, as part of the application process, you may use the email template provided. Rebecca you've made a good start on this question however you have not followed instructions. The year needs to be split into financial quarters for example July to September I would suggest you use the cash flow projection template provided. Also note that the cash flow should show when the cash comes and goes in your business it would appear that you have listed your expenses as if this was a profit and loss does not demonstrate the changes in outgoings that would occur to match your revenue. I would suggest you discuss this area with a teacher. You were also meant to include an email to the bank as part of the application process. Please resubmit
