Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please complete the following cash flow statement and write all steps please complete the following cash flow statement and write all steps thanks 15 2
please complete the following cash flow statement and write all steps
please complete the following cash flow statement and write all steps thanks
15 2 Til 1 3 4 15 16 17 18 9 101 11 112 1 13 1 14 115 11 17 18 I. Plant and equipment/Furniture (Plant and Equipment example: Machines, Tool box etc.) (Furniture example: Tables, Chairs, A/C, Refrigerator, water coolers etc.) Cost per Number required unit/piece 10,000 Total Cost 10,000 Depreciation=Cost : Life span of Item 400 1 6 6 1 2 1 Sr. Description of Furniture Plant No. / Equipment Item 1 Automatic Medical Face Mask Making Machine 2. Electrostatic Sprayer Fog Machine 3. Vehicle 4. Tables 5. Computers 6. Chairs 7 Air conditioner 8 Telephone 9 Printer 10 Trolly Total 4 4 12 3 4 2 10 42 5,000 9 50 5 160 4 12 10 15,256 5,000 36 200 60 480 16 24 100 15,922 625 0.600 10 0.625 8 0.500 3 1 1050.725 DI a Tools Add-ons Help Last edit was made 8 minutes ago by Hajer Abdulhakim Al Farsi ACHA. al text Cambria 10 B I U A + I - E-EE 2. +12 13. 14. 151 671 8 19 110 11.1 112 113 114 1151 17 18 Sr. No Name of the Supplier Product/Service Cost per Volume Quantity Purchase d 500 1000g Total Cost for a month Unit/Ite 0.300 48 g 150 48000 Carton box Thiazolyi Blue Tetrazolium Bromide (change color) Mask Fabric (non-woven) 300kg 1.54 kg 462 Mask Fabric (melt-blown) 100kg 10.01 kg 1001 Sigma-Aldrich(chemica Is company) Wuxi Denuo Machinery Technology Wuxi Denuo Machinery Technology Wuxi Denuo Machinery Technology Wuxi Denuo Machinery Technology Earloop 27.5kg 2.70 kg 74.25 Nose clip 15kg 2.50 kg 37.5 Plastic Cover 50000 0.005 250 49974.75 Total Cost 6. FINANCIAL PLAN a. Sales Forecast: UC UYU UY Hue Adulhakim Al Farsi nal text Cambria 10 B TU A EE 1 1.1.1 12 13 14 15 16 17 18 19.10 11 13 1.10 1.15.1 16. 17. 18 SALES REVENUE Sales in Unit X Selling Price per Unit Sales Plan for Year 2018. (OMR) Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 7 Month 8 Month 9 Month 10 Month 11 Month 12 Tot al Sal es 17000 16500 16875 16125 16200 15600 17250 17250 17325 19050 19200 19350 19650 210 125 Sales Revenue (Product/S ervice) Small sized masks Medium sized masks Large sized masks Total 34500 34500 34875 35250 35700 35625 35250 37500 41250 41550 42000 42000 450 000 239 875 17500 18000 18000 19125 19500 20025 18000 20175 22200 22350 22650 22350 69000 69000 69750 69750 71400 71250 70500 75000 82500 83100 84000 84000 900 000 b. Monthly Operational Cost Plan for first Year(1)(OMR): BI a A google translate G SOLE Inbox (46) - marya.... Report 2 insert Format Tools Add-ons Help Last edit was made 8 minutes ago by Hajer Abdulhakim Al Farsi ACHA 0% Normal text Cambria 10 CD BIU A 4 13 - 9.1.10 1.11 12 13 14 1:15:33 Editing Variable Cost: Values (OMR) Raw material cost/ cost of Goods/Services sold depending on 49974.7 projected sales Fixed Cost: 1. Office / Factory/ Shop/Showroom Rent 800 2. Staff Salaries 3200 3. Water 30 4. Electricity 100 33 5. Telephone and Internet Services Pla... 6. Insurance for Business/Shop 125 400 7. Advertising Expenses Total Fixed Cost 4688 54662.7 Total Operational Cost (Total variable cost + Total Fixed Cost) NS3. 4. 5. 6. 7. 8. satu Z log No la T 12 UMR Months Opening Balance + Equity (Own Fund) + Loan 5000 70000 ---- 6900 0 6900 0 6975 0 6975 0 7140 0 7125 0 7050 0 7500 0 8250 0 8310 0 8400 0 8400 0 75000 + Sales Revenue 1. Total Cash inflow Investment ---- 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 350 350 350 350 350 350 350 350 350 350 350 350 350 Operational cost +Interest on loan (6%) + Start Up Expense II. Total Cash out flow Cash at the end of -monthl 15 2 Til 1 3 4 15 16 17 18 9 101 11 112 1 13 1 14 115 11 17 18 I. Plant and equipment/Furniture (Plant and Equipment example: Machines, Tool box etc.) (Furniture example: Tables, Chairs, A/C, Refrigerator, water coolers etc.) Cost per Number required unit/piece 10,000 Total Cost 10,000 Depreciation=Cost : Life span of Item 400 1 6 6 1 2 1 Sr. Description of Furniture Plant No. / Equipment Item 1 Automatic Medical Face Mask Making Machine 2. Electrostatic Sprayer Fog Machine 3. Vehicle 4. Tables 5. Computers 6. Chairs 7 Air conditioner 8 Telephone 9 Printer 10 Trolly Total 4 4 12 3 4 2 10 42 5,000 9 50 5 160 4 12 10 15,256 5,000 36 200 60 480 16 24 100 15,922 625 0.600 10 0.625 8 0.500 3 1 1050.725 DI a Tools Add-ons Help Last edit was made 8 minutes ago by Hajer Abdulhakim Al Farsi ACHA. al text Cambria 10 B I U A + I - E-EE 2. +12 13. 14. 151 671 8 19 110 11.1 112 113 114 1151 17 18 Sr. No Name of the Supplier Product/Service Cost per Volume Quantity Purchase d 500 1000g Total Cost for a month Unit/Ite 0.300 48 g 150 48000 Carton box Thiazolyi Blue Tetrazolium Bromide (change color) Mask Fabric (non-woven) 300kg 1.54 kg 462 Mask Fabric (melt-blown) 100kg 10.01 kg 1001 Sigma-Aldrich(chemica Is company) Wuxi Denuo Machinery Technology Wuxi Denuo Machinery Technology Wuxi Denuo Machinery Technology Wuxi Denuo Machinery Technology Earloop 27.5kg 2.70 kg 74.25 Nose clip 15kg 2.50 kg 37.5 Plastic Cover 50000 0.005 250 49974.75 Total Cost 6. FINANCIAL PLAN a. Sales Forecast: UC UYU UY Hue Adulhakim Al Farsi nal text Cambria 10 B TU A EE 1 1.1.1 12 13 14 15 16 17 18 19.10 11 13 1.10 1.15.1 16. 17. 18 SALES REVENUE Sales in Unit X Selling Price per Unit Sales Plan for Year 2018. (OMR) Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 7 Month 8 Month 9 Month 10 Month 11 Month 12 Tot al Sal es 17000 16500 16875 16125 16200 15600 17250 17250 17325 19050 19200 19350 19650 210 125 Sales Revenue (Product/S ervice) Small sized masks Medium sized masks Large sized masks Total 34500 34500 34875 35250 35700 35625 35250 37500 41250 41550 42000 42000 450 000 239 875 17500 18000 18000 19125 19500 20025 18000 20175 22200 22350 22650 22350 69000 69000 69750 69750 71400 71250 70500 75000 82500 83100 84000 84000 900 000 b. Monthly Operational Cost Plan for first Year(1)(OMR): BI a A google translate G SOLE Inbox (46) - marya.... Report 2 insert Format Tools Add-ons Help Last edit was made 8 minutes ago by Hajer Abdulhakim Al Farsi ACHA 0% Normal text Cambria 10 CD BIU A 4 13 - 9.1.10 1.11 12 13 14 1:15:33 Editing Variable Cost: Values (OMR) Raw material cost/ cost of Goods/Services sold depending on 49974.7 projected sales Fixed Cost: 1. Office / Factory/ Shop/Showroom Rent 800 2. Staff Salaries 3200 3. Water 30 4. Electricity 100 33 5. Telephone and Internet Services Pla... 6. Insurance for Business/Shop 125 400 7. Advertising Expenses Total Fixed Cost 4688 54662.7 Total Operational Cost (Total variable cost + Total Fixed Cost) NS3. 4. 5. 6. 7. 8. satu Z log No la T 12 UMR Months Opening Balance + Equity (Own Fund) + Loan 5000 70000 ---- 6900 0 6900 0 6975 0 6975 0 7140 0 7125 0 7050 0 7500 0 8250 0 8310 0 8400 0 8400 0 75000 + Sales Revenue 1. Total Cash inflow Investment ---- 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 5466 2.7 350 350 350 350 350 350 350 350 350 350 350 350 350 Operational cost +Interest on loan (6%) + Start Up Expense II. Total Cash out flow Cash at the end of -monthlStep 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