Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sales Revenue Product 1 $ 112,500.00 $ 160,000.00 $ 212,500.00 Product 2 $ 150,000.00 $ 280,000.00 $ 480,000.00 Product 3 $ 100,000.00 $ 180,000.00 $
Sales Revenue | |||
Product 1 | $ 112,500.00 | $ 160,000.00 | $ 212,500.00 |
Product 2 | $ 150,000.00 | $ 280,000.00 | $ 480,000.00 |
Product 3 | $ 100,000.00 | $ 180,000.00 | $ 300,000.00 |
Total Sales Revenue | $ 362,500.00 | $ 620,000.00 | $ 992,500.00 |
Expenses | |||
Cost of Goods Sold | $ 10,600.00 | $ 20,000.00 | $ 40,000.00 |
Rent | $ 18,000.00 | $ 19,000.00 | $ 20,000.00 |
Salaries and Wages | $ 180,000.00 | $ 300,000.00 | $ 500,000.00 |
Payroll taxes and Benefits | $ 60,000.00 | $ 130,000.00 | $ 250,000.00 |
Marketing and Advertising | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 |
Utilities | $ 6,000.00 | $ 6,000.00 | $ 6,000.00 |
Office Supplies and Equipment | $ 16,000.00 | $ 2,000.00 | $ 2,000.00 |
Insurance | $ 590.00 | $ 590.00 | $ 1,000.00 |
Repairs and Maintenance | |||
Total Expenses | $ 301,190.00 | $ 487,590.00 | $ 829,000.00 |
Net Income | $ 61,319.00 | $ 132,410.00 | $ 163,500.00 |
Common-Size Balance Sheet for Sht on December 31 | ||||
2022 | 2023 | |||
% | % | |||
Assets | ||||
Cash and marketable securities | ||||
Accounts receivable | ||||
Inventory | ||||
Other current assets | ||||
Total current assets | ||||
Plant, Property and equipment (net) | ||||
Goodwill and other assets | ||||
Total assets | ||||
Liabilities and Equity | ||||
Accounts payable | ||||
Wages payable | ||||
Accrued income taxes | ||||
Total current liabilities | ||||
Long-term debt | ||||
Total liabilities | ||||
Total Common Equity | ||||
Total Liabilities and Equity | ||||
Current Ratio | ||||
Quick Ratio |
Balance sheet from information on operating budget, and assumed info
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