we have to make a cash flow chart which we had to make it as 12 month cycle. we also had to add sales in this as of January sales is $5500 and fill the numbers of other months according to that and fill the numbers in the cash flow table which is given in the third and fourth picture.
these is the table which have to be filled not all the columns only the topics which are given in the question with the same values or numbers given. In cash receipts we have to add the sales of $5500 and adjust the numbers accordingly in the flow chart
Using the cash flow chart complete the following: Start Up Loan $25000 Purchased our raw materials paid cash all purchases all cash Production cost - invoice for branding pay 50%cash/Accounts Payable 50% don't forget to add the value to your inventory and equity. Sold final merchandise 50% of our purchased inventory, 50%cash/50% receivable invest into your business $5000 march withdraw from business for personal reasons $3000 September pay 3 bills rent $2500/mth telephone $100/mth internet $109/mth a/v rentals $500/mth office expenses $200 every 2 months salaries as below all new services in Jan add $100 set up cost/hookup Business registration $70 Business Insurance $160/mth Marketing $500/qtr Equipment purchase in April $20,000 you must finance half over 5 years @5% paid monthly Complete the chart for 12 month cycle, increasing merch sales by 10% for 6 months and then 15% for 4 months, 3% for remaining 2 months. Other revenue - Service Revenue Jan = $1000 this can increase by 3% each month Performance Revenue - $1500/mth Each month receivables increase based on original cash/receivable split, and you collect 30% of the previous months closing each month rent is fixed @ $2500/mth. Salaries fixed amount 1500/mthi.e, your pay Variable salaries Jan $450 and it increases by 7% every month Car/ins S320/$300 fixed monthly Gas S150/wk Use original transaction as your first cash inflows/receivables Don't forget your loan/interest payments, 6% interest on loan is paid separate from principle. Based on principle, declining balance G M H Small Business Cash Flow Projection Company Name Starting date Cash balance of minimum Jan18 Mar 11 Apr.18 1 10 Cash and the of May 11 Aeg 11 O 10 New: 10 Dec 12 Total 5 Jan 14 Fabia Mar 18 Ap 18 De 10 11 CASH RECEPTS Casas Races Calean she ther name 11 16 Ocions TOTAL CASH RECEIPTS Total cash avait F-16 A 18 May 10 De 23 22 24 CASH PAID UIT Mining Commons and Cantat labor Empley In the the w expense supplies (COGS) Mwand Margo Once Other par 20 21 90 29 30 11 1 Restor 3 SCOGS and licenses 0 N Purchase Rhe dece SCOGS Tv Wege Jensen Credits Other exams Opnas SUBTOTAL CASHION Lan pengalaman Feb 13 May 16 dum Ase New 18 D. Teen Ons with TOTAL CASH PAID OUT Cash OTHER OPERATING DATA Feb 18 Mar 18 A 18 May 18 18 Auto Sep 13 015 De- To web nart Screenshot My Add-ins Wikipedia Online Video Add-ins Media My sales for first month is : $5500 | Add-ins Media My sales for first month is : $5500 Purchase can be one time or quarterly Adjust the sales according to the purchase D F Small Business Cash Flow Projection Company Name Mart Starting date Cash balance et minimum Jan 11 Feb 18 M Jun 11 11 No.18 18 dent CASI RECEPTS Cab A10 OT 18 De 18 Collection cours TOTAL CAMERE.CUPS Tratash va Feb 18 Masa A 18 CASILLADOIT A Condes Cat Employee thane Materialin. M haaimani Mangga Ocepe O cand espere and sharing Purchase Rotor Rantades For and main SCOGS Taxes and Guppen in COGS Trees and comes Travel 41 Other pencer Other spanies Oh expenses Mac SULITOTAL CASH PAID OLIT Loan principalment Capital purchases an 11 Mar 18 AM 11 May 10 dan Sep 10 Now De 18 49 30 51 Tomarmander crow Om Www TOTAL CASH PAID OUT Cash and end of mom 54 35 Jan-18 Feb 18 Deet OTHER OPERATING DALA Sales womedor Archreceivable balance fed the yond Accountance Depreciation ta Mar-21 Starting date Cash balance alert minimum Beginning Jan-18 Fel Cash on hand (beginning of month) 0 Jan-18 Fet F CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available o 0 Jan-18 F e Fe 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 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 Loan principal payment 48 Capital purchases 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 47 49 55 Turn 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) 0 Jan-18 1 2 O 3 0 Jan-18 F 55 56 57 58 59 60 61 62 OTHER OPERATING DATA Sales volume (dollars) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation 63 64 65 66 67 68 69 70 22 13 Week 9- Cash Flow Using the cash flow chart complete the following: Start Up Loan $25000 Purchased our raw materials paid cash all purchases all cash Production cost - invoice for branding pay 50%cash/Accounts Payable 50% don't forget to add the value to your inventory and equity. Sold final merchandise 50% of our purchased inventory, 50%cash/50% receivable invest into your business $5000 march withdraw from business for personal reasons $3000 September pay 3 bills rent $2500/mth telephone $100/mth internet $109/mth a/v rentals $500/mth office expenses $200 every 2 months salaries as below all new services in Jan add $100 set up cost/hookup Business registration $70 Business Insurance $160/mth Marketing $500/qtr Equipment purchase in April $20,000 you must finance half over 5 years @5% paid monthly Complete the chart for 12 month cycle, increasing merch sales by 10% for 6 months and then 15% for 4 months, 3% for remaining 2 months Other revenue - Service Revenue Jan = $1000 this can increase by 3% each month Performance Revenue - $1500/mth Each month receivables increase based on original cash/receivable split, and you collect 30% of the previous months closing each month. rent is fixed @ $2500/mth. Salaries fixed amount 1500/mth i.e. your pay Variable salaries Jan $450 and it increases by 7% every month Car/ins - $320/$300 fixed monthly Gas $150/wk Use original transaction as your first cash inflows/receivables Don't forget your loan/interest payments, 6% interest on loan is paid separate from principle. Based on principle, declining balance Add class comment Using the cash flow chart complete the following: Start Up Loan $25000 Purchased our raw materials paid cash all purchases all cash Production cost - invoice for branding pay 50%cash/Accounts Payable 50% don't forget to add the value to your inventory and equity. Sold final merchandise 50% of our purchased inventory, 50%cash/50% receivable invest into your business $5000 march withdraw from business for personal reasons $3000 September pay 3 bills rent $2500/mth telephone $100/mth internet $109/mth a/v rentals $500/mth office expenses $200 every 2 months salaries as below all new services in Jan add $100 set up cost/hookup Business registration $70 Business Insurance $160/mth Marketing $500/qtr Equipment purchase in April $20,000 you must finance half over 5 years @5% paid monthly Complete the chart for 12 month cycle, increasing merch sales by 10% for 6 months and then 15% for 4 months, 3% for remaining 2 months. Other revenue - Service Revenue Jan = $1000 this can increase by 3% each month Performance Revenue - $1500/mth Each month receivables increase based on original cash/receivable split, and you collect 30% of the previous months closing each month rent is fixed @ $2500/mth. Salaries fixed amount 1500/mthi.e, your pay Variable salaries Jan $450 and it increases by 7% every month Car/ins S320/$300 fixed monthly Gas S150/wk Use original transaction as your first cash inflows/receivables Don't forget your loan/interest payments, 6% interest on loan is paid separate from principle. Based on principle, declining balance G M H Small Business Cash Flow Projection Company Name Starting date Cash balance of minimum Jan18 Mar 11 Apr.18 1 10 Cash and the of May 11 Aeg 11 O 10 New: 10 Dec 12 Total 5 Jan 14 Fabia Mar 18 Ap 18 De 10 11 CASH RECEPTS Casas Races Calean she ther name 11 16 Ocions TOTAL CASH RECEIPTS Total cash avait F-16 A 18 May 10 De 23 22 24 CASH PAID UIT Mining Commons and Cantat labor Empley In the the w expense supplies (COGS) Mwand Margo Once Other par 20 21 90 29 30 11 1 Restor 3 SCOGS and licenses 0 N Purchase Rhe dece SCOGS Tv Wege Jensen Credits Other exams Opnas SUBTOTAL CASHION Lan pengalaman Feb 13 May 16 dum Ase New 18 D. Teen Ons with TOTAL CASH PAID OUT Cash OTHER OPERATING DATA Feb 18 Mar 18 A 18 May 18 18 Auto Sep 13 015 De- To web nart Screenshot My Add-ins Wikipedia Online Video Add-ins Media My sales for first month is : $5500 | Add-ins Media My sales for first month is : $5500 Purchase can be one time or quarterly Adjust the sales according to the purchase D F Small Business Cash Flow Projection Company Name Mart Starting date Cash balance et minimum Jan 11 Feb 18 M Jun 11 11 No.18 18 dent CASI RECEPTS Cab A10 OT 18 De 18 Collection cours TOTAL CAMERE.CUPS Tratash va Feb 18 Masa A 18 CASILLADOIT A Condes Cat Employee thane Materialin. M haaimani Mangga Ocepe O cand espere and sharing Purchase Rotor Rantades For and main SCOGS Taxes and Guppen in COGS Trees and comes Travel 41 Other pencer Other spanies Oh expenses Mac SULITOTAL CASH PAID OLIT Loan principalment Capital purchases an 11 Mar 18 AM 11 May 10 dan Sep 10 Now De 18 49 30 51 Tomarmander crow Om Www TOTAL CASH PAID OUT Cash and end of mom 54 35 Jan-18 Feb 18 Deet OTHER OPERATING DALA Sales womedor Archreceivable balance fed the yond Accountance Depreciation ta Mar-21 Starting date Cash balance alert minimum Beginning Jan-18 Fel Cash on hand (beginning of month) 0 Jan-18 Fet F CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available o 0 Jan-18 F e Fe 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 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 Loan principal payment 48 Capital purchases 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 47 49 55 Turn 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) 0 Jan-18 1 2 O 3 0 Jan-18 F 55 56 57 58 59 60 61 62 OTHER OPERATING DATA Sales volume (dollars) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation 63 64 65 66 67 68 69 70 22 13 Week 9- Cash Flow Using the cash flow chart complete the following: Start Up Loan $25000 Purchased our raw materials paid cash all purchases all cash Production cost - invoice for branding pay 50%cash/Accounts Payable 50% don't forget to add the value to your inventory and equity. Sold final merchandise 50% of our purchased inventory, 50%cash/50% receivable invest into your business $5000 march withdraw from business for personal reasons $3000 September pay 3 bills rent $2500/mth telephone $100/mth internet $109/mth a/v rentals $500/mth office expenses $200 every 2 months salaries as below all new services in Jan add $100 set up cost/hookup Business registration $70 Business Insurance $160/mth Marketing $500/qtr Equipment purchase in April $20,000 you must finance half over 5 years @5% paid monthly Complete the chart for 12 month cycle, increasing merch sales by 10% for 6 months and then 15% for 4 months, 3% for remaining 2 months Other revenue - Service Revenue Jan = $1000 this can increase by 3% each month Performance Revenue - $1500/mth Each month receivables increase based on original cash/receivable split, and you collect 30% of the previous months closing each month. rent is fixed @ $2500/mth. Salaries fixed amount 1500/mth i.e. your pay Variable salaries Jan $450 and it increases by 7% every month Car/ins - $320/$300 fixed monthly Gas $150/wk Use original transaction as your first cash inflows/receivables Don't forget your loan/interest payments, 6% interest on loan is paid separate from principle. Based on principle, declining balance Add class comment
