There's a correction needed to be done . Please help me to solve this . Am really confused

N o M P @ E F G H Carl Fic- Foreca.ct - 12 months Total: 8 9 12 7 10 11 Mon: 3 5 Pre-Start 1 6 2 0 57,000 50.000 60,000 65.000 62,000 55 000 31000 600,000 50,000 40,000 45,000 40,000 45.000 0 Receipts Sales Revenues Collections New cquity inflow Loans received Other Total Receipts 100,000 00.000 100.000 100.000 o 31,000 800.000 200.000 50.000 57.000 60.000 62.000 65.000 55.000 50.000 40.000 40.000 45.000 45,000 20,000 40,000 5,000 10,000 STOO 10,000 6,000 10,000 6,200 10,000 6,500 10.000 5.500 10.000 5,000 10.000 4,000 10,000 4,000 10,000 4,500 10,000 4,500 1 10,000 20,000 140,000 30.000 60,000 10,000 130.000 O 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20.000 20,000 280.000 5,000 5,000 5,000 2,000 2,0100 2,000 2,000 2000 2,000 2.000 2,000 2,000 2,000 Pagneets Row yisterials 60,000 Production Wager 30,000 Sales Commissions 11 Salaries 10,000 Employee benefits Payroll taxes Bent 40,000 Ufiltities Repairs and maintenance 0 Insuranco Travel 15,000 Telephone 2,000 Postage Office supplies 10,000 A decrtising 5,000 Marketing promotion 7,500 Professional fees Training and development 3,000 Bank charges Owner's drawings Loan repayments Tax payments Capital purchases Other Total Payments 182.500 Cash Flow Forecast 500 500 15.000 0 15,000 2.000 26.000 0 500 12.000 7.000 7,500 2.500 1,000 6.000 500 1,000 1,000 2.500 1,000 2,000 2.000 2010 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2. UTO 2,000 42,000 0 24.000 12.000 0 0 39.000 0.700 65,500 41,200 40,500 82.500 44,000 40.000 38,500 38.500 43,500 100.600 797.000 Ovo Total Receipte 200.000 50,000 S7.000 60,000 62.000 65.000 55.000 50,000 10.000 40.000 45.000 45,000 31.000 300.000 20,000 | 40,000 Poyete FENSTE Production we Sales Common 60,000 00000 E E 20,000 140.000 30.000 3,100 60,000 10,000 130.000 5,000 | 10,000 5,700 10,000 6,000 10,000 6,200 10,000 6,500 110,000 5,500 10,000 5,000 10,000 4,000 10,000 4,000 10,000 4,500 10,000 4,500 10,000 10.000 olelle 40,000 20,000 20,000 20,000 20,000 20,000 20 000 20,000 20,000 20,000 20,000 20,000 20,000 280,000 2 0 5,000 5,000 5,000 15,000 2000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 4 5 6 IT 8 9 0 15,000 0 15.000 26.000 0 12.000 7,000 7.500 2,5010 6,000 500 500 500 Employee benefits Parole BAN UNITA Repairs and maintenance neurando Tra Telephone Portas Offee supplies Adverticing Marketing promotion Profesional Training and development Bank charges Owner's drawing Loon repayment: Tax payment Capital purchases Other Total Payments 500 10,000 5,000 1,500 1,000 1,000 2,500 3,000 1,000 1,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 . 2 3 34 35 36 37 38 39 10 0 24,000 42.000 42.000 0 182.500 39.000 40.700 65.500 11.200 40.500 82,500 44,000 40,000 38,500 38.500 43,500 100.600 797,0010 Cashflow SarplesDeficit (-) 17,500 11,000 16,300 -5,500 20.800 24.500 -27,500 6.000 1,500 6,500 1,500 -69,600 3.000 Opening Cash Balance 0 17,500 28.500 44.800 39,300 60.100 84,600 57.100 63.100 63.100 64,600 71,100 72,600 42 43 44 45 4.6 47 Closing Cash Balance 17,500 28.500 44.800 39,300 60.100 84,600 57.100 63.100 63.100 64.600 71,100 72,600 Explanitar Wars Step to enter information: 1) Rename the Receipts and Payment labels to align with your business 2) Monthly Revenues (Account for increasing Sales Revenues at the beginning and any other monthy wariances that would affect monthy sales like wamcold weather, gift giving periods, etc. 3) One time Pre-Start Payments 4) On-going monthly Payments 5) Sufficient Loans/Equity amounts to eliminate negative Closing Cash Balance and end up with a positive buffer of 1 (Important Note: The ratio of Loans to Equity will need to be adjusted after the "Financing' weekj Explanitory Notes: (Explain the rational behind your numbers. Examples: Loan payments, D seasonality in monthly revenues, etc.) Explanitory Notes: B 2 Sales revenue decreases by the end of the year due to seasonal changes and less sunlight during those months leads to less sale 1 Raw materials is heavily invested before staring the ventui And raw materials are procured evry 3 months to prevent back log and over supply. 2 Sales commision is 10% of sales generated for the respective month 3 Salaries is constant and are minimal for the first year, however subjective to change 4 Rent pre start is high as security is included. Repairs and maintainence is done every 3 months 6 Telephone charges are fixed 7 Advertising cost is heavily invested in the pre stari cycle, however additional sum in invested in regular months to conduct advertisements. 8 Training investment is done in pre start. And is additionally invested to facilitate training activities 9 Loan repayment is done in 48 months at an interest rate of 2.76% 5 Cash Flow Forecast N o M P @ E F G H Carl Fic- Foreca.ct - 12 months Total: 8 9 12 7 10 11 Mon: 3 5 Pre-Start 1 6 2 0 57,000 50.000 60,000 65.000 62,000 55 000 31000 600,000 50,000 40,000 45,000 40,000 45.000 0 Receipts Sales Revenues Collections New cquity inflow Loans received Other Total Receipts 100,000 00.000 100.000 100.000 o 31,000 800.000 200.000 50.000 57.000 60.000 62.000 65.000 55.000 50.000 40.000 40.000 45.000 45,000 20,000 40,000 5,000 10,000 STOO 10,000 6,000 10,000 6,200 10,000 6,500 10.000 5.500 10.000 5,000 10.000 4,000 10,000 4,000 10,000 4,500 10,000 4,500 1 10,000 20,000 140,000 30.000 60,000 10,000 130.000 O 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20.000 20,000 280.000 5,000 5,000 5,000 2,000 2,0100 2,000 2,000 2000 2,000 2.000 2,000 2,000 2,000 Pagneets Row yisterials 60,000 Production Wager 30,000 Sales Commissions 11 Salaries 10,000 Employee benefits Payroll taxes Bent 40,000 Ufiltities Repairs and maintenance 0 Insuranco Travel 15,000 Telephone 2,000 Postage Office supplies 10,000 A decrtising 5,000 Marketing promotion 7,500 Professional fees Training and development 3,000 Bank charges Owner's drawings Loan repayments Tax payments Capital purchases Other Total Payments 182.500 Cash Flow Forecast 500 500 15.000 0 15,000 2.000 26.000 0 500 12.000 7.000 7,500 2.500 1,000 6.000 500 1,000 1,000 2.500 1,000 2,000 2.000 2010 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2. UTO 2,000 42,000 0 24.000 12.000 0 0 39.000 0.700 65,500 41,200 40,500 82.500 44,000 40.000 38,500 38.500 43,500 100.600 797.000 Ovo Total Receipte 200.000 50,000 S7.000 60,000 62.000 65.000 55.000 50,000 10.000 40.000 45.000 45,000 31.000 300.000 20,000 | 40,000 Poyete FENSTE Production we Sales Common 60,000 00000 E E 20,000 140.000 30.000 3,100 60,000 10,000 130.000 5,000 | 10,000 5,700 10,000 6,000 10,000 6,200 10,000 6,500 110,000 5,500 10,000 5,000 10,000 4,000 10,000 4,000 10,000 4,500 10,000 4,500 10,000 10.000 olelle 40,000 20,000 20,000 20,000 20,000 20,000 20 000 20,000 20,000 20,000 20,000 20,000 20,000 280,000 2 0 5,000 5,000 5,000 15,000 2000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 4 5 6 IT 8 9 0 15,000 0 15.000 26.000 0 12.000 7,000 7.500 2,5010 6,000 500 500 500 Employee benefits Parole BAN UNITA Repairs and maintenance neurando Tra Telephone Portas Offee supplies Adverticing Marketing promotion Profesional Training and development Bank charges Owner's drawing Loon repayment: Tax payment Capital purchases Other Total Payments 500 10,000 5,000 1,500 1,000 1,000 2,500 3,000 1,000 1,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 . 2 3 34 35 36 37 38 39 10 0 24,000 42.000 42.000 0 182.500 39.000 40.700 65.500 11.200 40.500 82,500 44,000 40,000 38,500 38.500 43,500 100.600 797,0010 Cashflow SarplesDeficit (-) 17,500 11,000 16,300 -5,500 20.800 24.500 -27,500 6.000 1,500 6,500 1,500 -69,600 3.000 Opening Cash Balance 0 17,500 28.500 44.800 39,300 60.100 84,600 57.100 63.100 63.100 64,600 71,100 72,600 42 43 44 45 4.6 47 Closing Cash Balance 17,500 28.500 44.800 39,300 60.100 84,600 57.100 63.100 63.100 64.600 71,100 72,600 Explanitar Wars Step to enter information: 1) Rename the Receipts and Payment labels to align with your business 2) Monthly Revenues (Account for increasing Sales Revenues at the beginning and any other monthy wariances that would affect monthy sales like wamcold weather, gift giving periods, etc. 3) One time Pre-Start Payments 4) On-going monthly Payments 5) Sufficient Loans/Equity amounts to eliminate negative Closing Cash Balance and end up with a positive buffer of 1 (Important Note: The ratio of Loans to Equity will need to be adjusted after the "Financing' weekj Explanitory Notes: (Explain the rational behind your numbers. Examples: Loan payments, D seasonality in monthly revenues, etc.) Explanitory Notes: B 2 Sales revenue decreases by the end of the year due to seasonal changes and less sunlight during those months leads to less sale 1 Raw materials is heavily invested before staring the ventui And raw materials are procured evry 3 months to prevent back log and over supply. 2 Sales commision is 10% of sales generated for the respective month 3 Salaries is constant and are minimal for the first year, however subjective to change 4 Rent pre start is high as security is included. Repairs and maintainence is done every 3 months 6 Telephone charges are fixed 7 Advertising cost is heavily invested in the pre stari cycle, however additional sum in invested in regular months to conduct advertisements. 8 Training investment is done in pre start. And is additionally invested to facilitate training activities 9 Loan repayment is done in 48 months at an interest rate of 2.76% 5 Cash Flow Forecast