Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Accounting Volume 1 Financial Accounting

Authors: Mitchell Franklin, Patty Graybeal, Dixon Cooper, OpenStax

1st Edition

1593995946, 978-1593995942

More Books

Students also viewed these Accounting questions

Question

Discuss whether happier people make more money.

Answered: 1 week ago

Question

What are the steps that the EEOC uses once a charge is filed?

Answered: 1 week ago

Question

What would you do?

Answered: 1 week ago