Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare horizontal analysis of the change in key accounts; at least 3 ratios Prepare vertical analysis of key expense accounts (amount as a percent of

 Prepare horizontal analysis of the change in key accounts; at least 3 ratios
 Prepare vertical analysis of key expense accounts (amount as a percent of sales); at least 2 ratios for each year
Falls Jewelry Co.




Income Statement




For the year ended December 31




(000s)


2022
2023



Sales - All on Credit
$ 500,000

$ 565,000



Cost of Goods Sold
220,000

226,000




Gross Profit

280,000
339,000



Salaries Expense
120,000

170,000



Advertising Expense
40,000

36,000



Depreciation Expense
13,000

16,000



IT Expenses
7,000

8,000




Total Expenses

180,000
230,000



Operating Income
100,000

109,000



Interest Expense
14,000

21,000



Income Before Taxes
86,000

88,000



Income Tax Expense
17,200

17,600



Net Income
$ 68,800

$ 70,400



Average Shares Outstanding
20,000

20,000



Number of Stores
150

190
All stores opened on 1/1/23
Stock Price
$ 70.00

$ 20.35














1. - Calculate the following ratios:












2022
2023




Gross profit margin %

56.0%
60.0%




Operating profit margin %

20.0%
19.0%




Net Profit margin %

13.8%
12.5%




Earnings per share

$ 3.44
$ 3.52




2022 PE Ratio

70.0
20.35














2.





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

Introductory Financial Accounting for Business

Authors: Thomas Edmonds, Christopher Edmonds

1st edition

1260299449, 978-1260299441

More Books

Students also viewed these Finance questions

Question

Give an example of an asset exchange transaction.

Answered: 1 week ago