Kindly help me in balancing the business plan from early on. The one that have been edited can simply highlight it with red and those that are highlighted in yellow are the balance sheet
RM - 2300 Start-Up Costs START-UP COSTS Capital Expenditure: Administrative Office Building (Shah Alam) monthly rental - unfurnished Office fixtures and equipments Office furnitures Utilities (Office) Parking fees (Office) Office supplies 8550 5555 1200 800 2350 1500 2550 Capital expenditures: Operations Workshop Maintenance cost Workshop fixtures and equipments Workshop furnitures Monthly lease payments (Workshop) Utilities (Workshop) 4256 583 550 3800 Lorry Professional fees (Architect, Legal and Engineer) Contractor fees (General contractor, Crane operator, Electrician and Painter) Commercial or Risk Insurance Commercial Auto Insurance Supplies (Wedding stage props) 18400 12000 2500 1800 6200 One time start-up Expenditure Installation of fixtures/equipments for workshop (hydraulic doors, solar panels, wiring, painting) Stamp duty and admin charges 8750 2300 Advertising for opening 750 600 Other pre-operations expenditure Business premise licence Signboard licence Road Tax for motor vehicles 400 612 500 300 Other pre-administration expenditure Utility Deposit Security Deposit Business premise license - DBKL Signboard license LLP registration Start up costs 600 400 500 90606 Working Capital Working Capital (Monthly) Marketing RM Fixed (RM) Variable (RM) Advertising 980 2300 Administrative Salaries and Wages (EPF) Rent Utilities Office supplies Depreciation of Lorry 1200 2350 633 Operations 1500 583 Workshop Maintenance Workshop Lease Payment Workshop Utilities Parking fees 550 800 11115 370 Contractor fees Rental for equipment Professional fees Wedding stage props Logistics cost 9525 6200 6610.6 Other expenditure Lorry 317 Total working capital Total working capital required Working capital +Contingencies Estimated Start Up Capital RM 1 100 000 Financing RM Equity: Share & Venture Capital Abu 75 000 Ali 150 000 Chong 75 000 Muthu 125 000 Alex 75 000 Liability: Long term loan 600 000 Annual interest rate (%) 6 Duration of loan (years) 5 WEDDING BOX CASH FLOW PRO FORMA STATEMENT Year 1 2022 Year 2 2023 Year 3 Year 4 2024 2025 Year 5 2026 CASH INFLOW Share Capital 500000 Business Loan 600000 Sales 1170000 2340000 35100004680000 5850000 TOTAL CASH INFLOW 2270000 2340000 35100004680000 5850000 CASH OUTFLOW Administrative Expenditure 506139.6 612350 657890 789000.2 800009.9 Salaries and Wages Utilities 10400 11781 12365 11457 10435 27600 Rental 27600 27600 27600 27600 office supplies 10005 9310 8010 8405 7573 Marketing Expenditure Advertising 6550 7040 7000 5782 6281 Operational Expenditure Utilities 5600 4480 3637 4438 4299 7000 14000 14000 21000 21000 Lease Payment Logistics cost 8055 9870 10367 11543 13459 Miscellaneous cost (maintenance + parking) 9200 9001 10033 10562 10506 Depreciation of Lorry 7600 7600 7600 15200 15200 Rental Equipment 750 900 1055 1480 1901 Pre-Operations Deposits of Utilities (Security and Utility) 800 Business registrations and licenses (LLP, PBT, Signboard) 2500 Stamp duty and admin cost 2300 Installation of equipment and fixtures (hydraulic doors, solar panels, wiring. painting) 8750 8765 10873 Other expenditure Professional fees (Architect, Legal and Engineer) 18400 25000 36700 45721 55321 Contractor fees (General contractor, Crane operator, Electrician and Painter) 12000 13450 11785 14290 15905 Insurance (Risk, Commercial Auto) and Road Tax 4912 4912 4912 6034 7138 Interest on loan 36000 36000 36000 36000 36000 Loan Payment (principal) 120000 120000 120000 120000 120000 Tax Payable 2600 3188 4120 5455 Fixed Assets Office Furniture 5555 2400 3786 4006 Office Equipment and fittings 8550 3006 3567 4173 Lorry 3800 3800 3800 7600 7600 Supplies (Wedding stage items) 6200 6481 7500 7964 9596 Workshop Furniture 4256 3840 2305 3555 Workshop Equipment and fittings 2550 4780 5679 6790 7896 TOTAL CASH OUTFLOW 835472.6 932615 994777 1174317 2 1206803.9 Year 1 Year 2 Year 3 Year 4 Year 5 2022 2023 2024 2025 2026 1434527.4 1407385 2515223 3505682.8 4643196.1 CASH (SURPLUS/ DEFICIT) 0 1434527-42841912.45357135.4 8862818.2 BEGINNING CASH BALANCE 1434527.42841912.45357135.48862818-2 13506014.3 ENDING CASH BALANCE WEDDING BOX Production Cost Pro-Forma Statement Year 1 Year 2 Year 3 2022 2023 2024 Year 4 2025 Year 5 2026 0 6200 12681 20181 28145 Raw Materials Opening stock Wedding stage items Ending stock 6200 6481 7500 7964 9596 6200 12681 20181 28145 37741 Raw Materials use 6200 12681 20181 28145 37741 506139.6612350 657890 789000.2800009.9 Labour Salaries and wages Contractor fees 12000 13450 11785 14290 15905 8055 9870 10367 11543 13459 Logistic cost 5600 4480 3637 4438 4299 7000 14000 14000 Overhead Utility Lease of shipping container Rental equipment Depreciation of Lorry 21000 21000 750 900 1055 1480 1901 7600 7600 7600 15200 15200 Production Cost 553344.6 675331 726515 885096.2 909514.9 WEDDING BOX Pro-Forma Income Statement Year 1 Year 2 Year 3 2022 2023 2024 Year 4 2025 Year 5 2026 Sales 1170000 2340000 3510000 4680000 5850000 (-) Cost Of Sale Opening Stock 12681 20181 28145 0 6200 553344.6 675331 -6200 -12681 726515 Production Cost -) ending stock 885096.2 909514.9 -20181 -28145 -37741 Gross profit 622855.4 1671150 2790985 3802867.8 4950081.1 (-) Expenditure Administrative Expenditure utilities 10400 10435 11781 12365 11457 rental 27600 27600 27600 27600 27600 10005 office supplies 9310 8010 8405 7573 Marketing Expenditure Advertising 6550 7040 7000 5782 6281 Other Expenditure Professional fees (Architect, Legal and Engineer) 18400 25000 36700 45721 55321 Insurance (Risk, Commercial Auto) and Road Tax 4912 4912 4912 6034 7138 Operational Expenditure Miscellaneous Cost (maintenance cost + parking fees) 9200 9001 10033 10562 10506 Business Registeration & License LLP 500 800 Signboard License business premise license 1000 800 Other Pre-Operations Expenditure Deposits of utilities Stamp duty and admin cost Installation of equipment and fixtures 2300 8750 8765 10873 36000 36000 36000 Interest on Loan 36000 36000 Total Expenditure 137217 129298 142036 161234 172749 Net profit before tax 485638.40 1541852 2648949 3641633.8 4777332.1 Tax-24% 116553.22 370044.48 635747.76 873992.112 1146559.7 Net profit after tax 369085.18 1171807.522013201.242767641.69 3630772.4 369085.18 1540892.70 3554093.94 6321735.639952508.03 Accumulated Net Profit BALANCE SHEET Year 1 Year 2 Year 3 Year 4 Year 5 2022 2023 2024 2025 2026 NON-CURRENT ASSETS Office Furniture 5555 2400 3786 4006 Office Equipment and fittings 8550 3006 . 3567 4173 Lorry 3800 3800 3800 7600 7600 Supplies (Wedding stage items) 6200 6481 7500 7964 9596 Workshop Furniture 4256 3840 2305 3555 Workshop Equipment and fittings 2550 4780 5679 6790 7896 Office supplies 10005 9310 8010 8405 7573 38123130242218319957 27377 23219 40417 44399 40916 TOTAL ASSETS Equity Share capital 500000 Non-Current Liabilities Loan Payment (principal) 120000 120000 120000 120000 120000 Business Loan 600000 Current Liabilities Interest on loan 36000 36000 36000 36000 36000 Tax Payable 2600 3188 4120 5455 Lease of shipping container 7000 14000 14000 21000 21000 Rental equipment 750 900 1055 1480 1901 1263750 65500 66243 6260064356 TOTAL EQUITY & LIABILITY 38123- 900 = 37223-2600 = 34623 43024-1055 = 41969 - 3188 = 38781 22183-1480 = 20703-4120 = 16583 19957-1901 = 18056- 5455 = 12601 RM - 2300 Start-Up Costs START-UP COSTS Capital Expenditure: Administrative Office Building (Shah Alam) monthly rental - unfurnished Office fixtures and equipments Office furnitures Utilities (Office) Parking fees (Office) Office supplies 8550 5555 1200 800 2350 1500 2550 Capital expenditures: Operations Workshop Maintenance cost Workshop fixtures and equipments Workshop furnitures Monthly lease payments (Workshop) Utilities (Workshop) 4256 583 550 3800 Lorry Professional fees (Architect, Legal and Engineer) Contractor fees (General contractor, Crane operator, Electrician and Painter) Commercial or Risk Insurance Commercial Auto Insurance Supplies (Wedding stage props) 18400 12000 2500 1800 6200 One time start-up Expenditure Installation of fixtures/equipments for workshop (hydraulic doors, solar panels, wiring, painting) Stamp duty and admin charges 8750 2300 Advertising for opening 750 600 Other pre-operations expenditure Business premise licence Signboard licence Road Tax for motor vehicles 400 612 500 300 Other pre-administration expenditure Utility Deposit Security Deposit Business premise license - DBKL Signboard license LLP registration Start up costs 600 400 500 90606 Working Capital Working Capital (Monthly) Marketing RM Fixed (RM) Variable (RM) Advertising 980 2300 Administrative Salaries and Wages (EPF) Rent Utilities Office supplies Depreciation of Lorry 1200 2350 633 Operations 1500 583 Workshop Maintenance Workshop Lease Payment Workshop Utilities Parking fees 550 800 11115 370 Contractor fees Rental for equipment Professional fees Wedding stage props Logistics cost 9525 6200 6610.6 Other expenditure Lorry 317 Total working capital Total working capital required Working capital +Contingencies Estimated Start Up Capital RM 1 100 000 Financing RM Equity: Share & Venture Capital Abu 75 000 Ali 150 000 Chong 75 000 Muthu 125 000 Alex 75 000 Liability: Long term loan 600 000 Annual interest rate (%) 6 Duration of loan (years) 5 WEDDING BOX CASH FLOW PRO FORMA STATEMENT Year 1 2022 Year 2 2023 Year 3 Year 4 2024 2025 Year 5 2026 CASH INFLOW Share Capital 500000 Business Loan 600000 Sales 1170000 2340000 35100004680000 5850000 TOTAL CASH INFLOW 2270000 2340000 35100004680000 5850000 CASH OUTFLOW Administrative Expenditure 506139.6 612350 657890 789000.2 800009.9 Salaries and Wages Utilities 10400 11781 12365 11457 10435 27600 Rental 27600 27600 27600 27600 office supplies 10005 9310 8010 8405 7573 Marketing Expenditure Advertising 6550 7040 7000 5782 6281 Operational Expenditure Utilities 5600 4480 3637 4438 4299 7000 14000 14000 21000 21000 Lease Payment Logistics cost 8055 9870 10367 11543 13459 Miscellaneous cost (maintenance + parking) 9200 9001 10033 10562 10506 Depreciation of Lorry 7600 7600 7600 15200 15200 Rental Equipment 750 900 1055 1480 1901 Pre-Operations Deposits of Utilities (Security and Utility) 800 Business registrations and licenses (LLP, PBT, Signboard) 2500 Stamp duty and admin cost 2300 Installation of equipment and fixtures (hydraulic doors, solar panels, wiring. painting) 8750 8765 10873 Other expenditure Professional fees (Architect, Legal and Engineer) 18400 25000 36700 45721 55321 Contractor fees (General contractor, Crane operator, Electrician and Painter) 12000 13450 11785 14290 15905 Insurance (Risk, Commercial Auto) and Road Tax 4912 4912 4912 6034 7138 Interest on loan 36000 36000 36000 36000 36000 Loan Payment (principal) 120000 120000 120000 120000 120000 Tax Payable 2600 3188 4120 5455 Fixed Assets Office Furniture 5555 2400 3786 4006 Office Equipment and fittings 8550 3006 3567 4173 Lorry 3800 3800 3800 7600 7600 Supplies (Wedding stage items) 6200 6481 7500 7964 9596 Workshop Furniture 4256 3840 2305 3555 Workshop Equipment and fittings 2550 4780 5679 6790 7896 TOTAL CASH OUTFLOW 835472.6 932615 994777 1174317 2 1206803.9 Year 1 Year 2 Year 3 Year 4 Year 5 2022 2023 2024 2025 2026 1434527.4 1407385 2515223 3505682.8 4643196.1 CASH (SURPLUS/ DEFICIT) 0 1434527-42841912.45357135.4 8862818.2 BEGINNING CASH BALANCE 1434527.42841912.45357135.48862818-2 13506014.3 ENDING CASH BALANCE WEDDING BOX Production Cost Pro-Forma Statement Year 1 Year 2 Year 3 2022 2023 2024 Year 4 2025 Year 5 2026 0 6200 12681 20181 28145 Raw Materials Opening stock Wedding stage items Ending stock 6200 6481 7500 7964 9596 6200 12681 20181 28145 37741 Raw Materials use 6200 12681 20181 28145 37741 506139.6612350 657890 789000.2800009.9 Labour Salaries and wages Contractor fees 12000 13450 11785 14290 15905 8055 9870 10367 11543 13459 Logistic cost 5600 4480 3637 4438 4299 7000 14000 14000 Overhead Utility Lease of shipping container Rental equipment Depreciation of Lorry 21000 21000 750 900 1055 1480 1901 7600 7600 7600 15200 15200 Production Cost 553344.6 675331 726515 885096.2 909514.9 WEDDING BOX Pro-Forma Income Statement Year 1 Year 2 Year 3 2022 2023 2024 Year 4 2025 Year 5 2026 Sales 1170000 2340000 3510000 4680000 5850000 (-) Cost Of Sale Opening Stock 12681 20181 28145 0 6200 553344.6 675331 -6200 -12681 726515 Production Cost -) ending stock 885096.2 909514.9 -20181 -28145 -37741 Gross profit 622855.4 1671150 2790985 3802867.8 4950081.1 (-) Expenditure Administrative Expenditure utilities 10400 10435 11781 12365 11457 rental 27600 27600 27600 27600 27600 10005 office supplies 9310 8010 8405 7573 Marketing Expenditure Advertising 6550 7040 7000 5782 6281 Other Expenditure Professional fees (Architect, Legal and Engineer) 18400 25000 36700 45721 55321 Insurance (Risk, Commercial Auto) and Road Tax 4912 4912 4912 6034 7138 Operational Expenditure Miscellaneous Cost (maintenance cost + parking fees) 9200 9001 10033 10562 10506 Business Registeration & License LLP 500 800 Signboard License business premise license 1000 800 Other Pre-Operations Expenditure Deposits of utilities Stamp duty and admin cost Installation of equipment and fixtures 2300 8750 8765 10873 36000 36000 36000 Interest on Loan 36000 36000 Total Expenditure 137217 129298 142036 161234 172749 Net profit before tax 485638.40 1541852 2648949 3641633.8 4777332.1 Tax-24% 116553.22 370044.48 635747.76 873992.112 1146559.7 Net profit after tax 369085.18 1171807.522013201.242767641.69 3630772.4 369085.18 1540892.70 3554093.94 6321735.639952508.03 Accumulated Net Profit BALANCE SHEET Year 1 Year 2 Year 3 Year 4 Year 5 2022 2023 2024 2025 2026 NON-CURRENT ASSETS Office Furniture 5555 2400 3786 4006 Office Equipment and fittings 8550 3006 . 3567 4173 Lorry 3800 3800 3800 7600 7600 Supplies (Wedding stage items) 6200 6481 7500 7964 9596 Workshop Furniture 4256 3840 2305 3555 Workshop Equipment and fittings 2550 4780 5679 6790 7896 Office supplies 10005 9310 8010 8405 7573 38123130242218319957 27377 23219 40417 44399 40916 TOTAL ASSETS Equity Share capital 500000 Non-Current Liabilities Loan Payment (principal) 120000 120000 120000 120000 120000 Business Loan 600000 Current Liabilities Interest on loan 36000 36000 36000 36000 36000 Tax Payable 2600 3188 4120 5455 Lease of shipping container 7000 14000 14000 21000 21000 Rental equipment 750 900 1055 1480 1901 1263750 65500 66243 6260064356 TOTAL EQUITY & LIABILITY 38123- 900 = 37223-2600 = 34623 43024-1055 = 41969 - 3188 = 38781 22183-1480 = 20703-4120 = 16583 19957-1901 = 18056- 5455 = 12601
