Please help me tutors!
Hi tutor Can you help me to do RETURN ON INVESTMENT Expenses Costing For Equipment Equipment Quantity Amount Refrigerator P 20,350 Stove P 9,295 Electric Mixer P 4,985 Multipurpose blender P 2,300 Digital weighing scale P 699 Waffle maker 2 P 8,600 Total: P 46,229 -Costing For Raw Materials Ingredients Price Milk tea flavored powder P 3,200 Fruit tea powder P 1,200 Gelatin powder P 1,000 Yogurt P 1,000 Fruit Syrup P 2,000 Tapioca pearls P 1,000 Cream puff P 2,000 Condensed milk P 750 Cream cheese P 2,000 Sugar P 1,000 Total: 5,383 monthly p 16 150X4 / 64,600 yearlyCosting For Supplies Cleaning Supplies Quantity Price Mop bucket & wringer P 2,100 Broom & dust pan ? sets P 490 Styles Pane Squeegee 1 P 680 Cleaning solutions 10 bottles P 1,100 Total: P 4,370 Milk Tea Supplies Quantity Price Measuring cups 1 50 Cups and lids 8 oz 500 B 750 12 oz 500 800 Wooden spoon 1000 850 Containers 10 500 Strainer 1 P 50 # 3,000 Furniture and Fixture Quantity Price Wooden chair 12 B 12,924 Round table 4 11,996 Total: P 24,920Utilities Monthly Annually Electric Bills 4000 48.000 Water Bills 1000 12.000 LPG Tank # 600 # 7,200 Total: # 5.600 67.200 Salaries and Wages Position Compensation Annually Cashier 10,000 120,000 Food Processing 9 7,500 9 90.000 Delivery Rider # 4,500 54.000 Total: # 22,000 264,000Required Cost of Start-Up Sources of Capital Owner's Investment INVESTOR 1 (50% 1,000,000 Ownership) INVESTOR 2 25% Ownership) 500,000 INVESTOR 3 (25% Ownership) 500,000 Total Investment 2,000,000Estimated Profitability Projected Daily Low High Medium Sales by 30 days Monthly Gross 118,500 143,100 150,000 Sales Royalty Fee (3%) None None None Average Mark-up 55% 55% 55% Gross Profit 65,000 78,705 82.500 Less Operating 33,000 49,500 61,875 Expenses Salaries and 15,000 82,000 94,000 wages Utilities 5,600 5,600 6,000 Rent 20,0000 20,000 20,000 Financial Projection Income Statement 2021 2022 2023 2024 2025 Sales 1,780,500 # 1,812,000 1,853, 190 # 1,880.680 # 1,907.920 Cost of Goods | # 445,125 B 453,000 # 483,297 B 470,170 B 476,980 sold Gross Profit # 1,335,375 # 1,359,000 # 1.389.893 # 1.410.510 # 1,430,94024,000 # 24,000 24.000 # 24,00 0 # 24.000 Miscellaneous Expenses Total # 887,861 9777.290 9777.290 B 777,290 # 777.290 Operating Expenses Net Income # 447.514 # 581,710 # 612,603 # 633,220 # 653.650 Here's the example on how to fill up the return on investment RETURN ON INVESTMENT Net Profit from ROI Return on Shareholders Investment Investment Percentage Investment Total Payback Investor 1 P 6,000,000.00 P 7,745,491.85 29.09% P 1,745,491.85 P 7,745,491.85 Investor 2 P 6,000,000.00 P 7,745,491.85 29.09% P 1,745,491.85 P 7,745,491.85 Investor 3 P 6,000,000.00 P 7,745,491.85 29.09% P 1,745,491.85 P 7,745,491.85 Investor 4 P 6,000,000.00 P 7,745,491.85 29.09% P 1,745,491.85 P 7,745,491.85 Investor 5 P 6,000,000.00 P 7,745,491.85 29.09% P 1,745,491.85 P 7,745,491.85 Private Investors 1 P 4,000,000.00 P 4,930,961.00 23.27% P 930,961.00 P 4,930,961.00 Private Investors 2 P 8,000,000.00 P 10,995,348.87 37.44% P 2,995,348.87 P 10,995,348.87 Total P 42,000,000.00 P 54,653,769.12 Here's my table. until investor 3 only. ThankyouHere's my table. until investor 3 only. Thankyou Re1urn on Investment
