Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the information below, prepare a comparative balance sheet Year 2021 Year 2022 Year 2023 Sales Revenue Service Revenue Fee 1,840,000.00 2,800,000.00 3,200,000.00 Advertising/Corporate
Based on the information below, prepare a comparative balance sheet
Year 2021 | Year 2022 | Year 2023 | ||||
Sales Revenue | ||||||
Service Revenue Fee | 1,840,000.00 | 2,800,000.00 | 3,200,000.00 | |||
Advertising/Corporate Sponsorhip Revenue | 300,000.00 | 500,000.00 | ||||
Vendor's Pro Plan | 900,000.00 | 1,800,000.00 | ||||
Customer's Pro Plan | 120,000.00 | 180,000.00 | ||||
TOTAL SALES REVENUE | 1,840,000.00 | 4,120,000.00 | 5,680,000.00 | |||
Direct Labor | 963,000.00 | 1,926,000.00 | 2,022,300.00 | |||
Direct Cost | 177,000.00 | 162,000.00 | 202,000.00 | |||
Indirect Labor | 291,000.00 | 582,000.00 | 617,400.00 | |||
Fixed Asset - Equipment/Computers | 265,920.00 | 0.00 | 0.00 | |||
Operating Expenses | ||||||
Co-Working Space Rental Fee | 118,800.00 | 237,600.00 | 475,200.00 | |||
Gasoline/Transportation Allowance | 34,500.00 | 48,000.00 | 48,000.00 | |||
Marketing Budget | 75,000.00 | 100,000.00 | 250,000.00 | |||
Event & Workshop Budget | 0.00 | 15,000.00 | 75,000.00 | |||
SEC, Business Registration & Permit | 100,000.00 | 30,000.00 | 30,000.00 | |||
Fixed Expenses | ||||||
Administrative Expenses | 272,222.50 | 434,095.00 | 504,183.00 | |||
TOTAL OPERATING EXPENSES | 2,297,442.50 | 3,534,695.00 | 4,224,083.00 | |||
Net Income (Before Tax) | (457,442.50) | 585,305.00 | 1,455,917.00 | |||
Tax (30%) | (137,232.75) | 175,591.50 | 436,775.10 | |||
NET INCOME (LOSS) | (457,442.50) | 409,713.50 | 1,019,141.90 |
Values used for the computation of Sales Revenue Targets | |||
Year 2021 (Sept-Dec) | Year 2022 | Year 2023 | |
Projected # of Registered Vendors | 100 | 250 | 500 |
Estimated Average Yearly Transaction per vendor | 115,000.00 | 70,000.00 | 40,000.00 |
Total Gross Sales | 11,500,000.00 | 17,500,000.00 | 20,000,000.00 |
Service Revenue Fee (16%) | 1,840,000.00 | 2,800,000.00 | 3,200,000.00 |
Vendors Pro Plan | |||
Projected # of Registered Vendors | 100 | 250 | 500 |
Yearly Vendors Pro Plan (P300/month) | 0.00 | 3,600.00 | 3,600.00 |
Total Fee | 0.00 | 900,000.00 | 1,800,000.00 |
Customers Pro Plan | |||
Projected # of Customers Availing the Pro Plan | 0 | 200 | 300 |
Yearly Customers Pro Plan (P50/month) | 0 | 600.00 | 600.00 |
Total Fee | 0.00 | 120,000.00 | 180,000.00 |
Estimated Funds from Advertising/Corporate Sponsorship | 0 | 300,000.00 | 500,000.00 |
Total Revenue | 1,840,000.00 | 4,120,000.00 | 5,680,000.00 |
Note: 30% of the gross sales are through credit card transaction, 70% is cash on delivery and 84% of service revenue goes to the vendor
Step 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