Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare the following key performance indicators from the financial statements below Accounts Receivable and Inventory are both the year-end and average balances Show your work

  
Prepare the following key performance indicators from the financial statements below 
Accounts Receivable and Inventory are both the year-end and average balances
Show your work OR use formulas in the cells
2. Make at least 4 meaningful observations regarding the company's 2023 performance
Quote a key performance indicator or another ratio in each of your observations
"Another ratio" can include a percentage change from 2022 to 2023 or an expense account / sales
2022 2023
Current Ratio
Days Sales Outstanding
Inventory Turnover
Sales Growth Rate - 2023 only XXXXXXX
Net Income Growth Rate - 2023 only XXXXXXX
Gross Profit Margin %
Operating Profit Margin %
Net Profit Margin %
Earnings per Share
PE Ratio
Balance Sheet as of December 31,
Current Assets 2022 2023
Cash 10,000 5,000
Accounts receivable (avg) 30,000 42,000
Inventory (avg) 25,000 40,000
Other Assets 10,000 10,000
Current Assets 75,000 97,000
Property Plant and Equipment
Equipment 150,000 182,000
Less: Accum Depreciation 58,000 68,000
Office equipment, Net 92,000 114,000
Total Assets 167,000 211,000
Current Liabilities
Accounts payable 30,000 35,000
Accrued Expenses 4,000 5,000
Other Current Liabilities 3,000 3,000
Current Liabilities 37,000 43,000
Notes payable, Due 2028 40,000 55,000
Total liabilities 77,000 98,000
Stockholders Equity
Common stock 40,000 40,000
Retained earnings 50,000 73,000
Total equity 90,000 113,000
Total liabilities and equity 167,000 211,000
Income Statement For the 12 months ended December 31,
2022 2023
Sales revenue 400,000 450,000
Cost of sales 300,000 328,000
Gross Profit 100,000 122,000
Operating Expenses
Salaries expense 25,000 35,000
Marketing expense 11,000 16,000
Technology expense 14,000 15,000
Total Expenses 50,000 66,000
Operating Income 50,000 56,000
Interest expense 5,000 6,000
Income Before Taxes 45,000 50,000
Tax Expense 9,000 12,000
Net Income 36,000 38,000
Average Shares Outstanding 10,000 10,000
Stock Price (per share) 60 86

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

Horngrens Financial and Managerial Accounting

Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

978-0133251241, 9780133427516, 133251241, 013342751X, 978-0133255584

More Books

Students also viewed these Accounting questions

Question

What does the term bitwise refer to ? in computer programming

Answered: 1 week ago