ACCT 370 Week 3 Excel Project: Part 2 Example

Reviewed by Thomas Kerrigan, MBA, CPA · Liberty University · Updated

This ACCT 370 Week 3 sample Excel project part turns the statements entered in Part 1 into ratios and explains what they show about Crocs, Inc. beside its two footwear rivals. It computes liquidity, working capital activity, profitability, solvency and cash flow ratios for fiscal 2024 and 2025 using average balances, then splits return on equity into its DuPont components. Crocs earns the highest margins and turns its working capital fastest, but carries more debt per dollar of equity than Steven Madden, and its 2025 returns fall below zero only because of a non-cash impairment. A second set of figures without the charge shows the operating picture. Liberty University ACCT 370 sets this ratio work as Part 2 of the BS in Accounting course's Excel project, due with the forum replies.

CourseACCT 370 Financial Statement Analysis (ACCT370)
Module/Week3
AssignmentExcel Project: Part 2
Paper typeExcel project part with ratio analysis and interpretation
Lengthabout 629 words, 2 double-spaced pages plus title page and references. Course guide: a workbook computing liquidity, activity, profitability, solvency and cash flow ratios for the selected company and its competitors from the Part 1 statements, presented here as tables with the formulas and interpretation
FormatAPA 7 student paper
Points50
SchoolLiberty University Online
ProgramBS in Accounting
Where it sitsModule/Week 3 in Liberty's published ACCT 370 course guide; current sections can differ
UpdatedOctober 2026

Free sample paper for ACCT 370 Week 3

1

Ratio Analysis of Crocs, Inc. Against Steven Madden and Wolverine World Wide, 2024-2025

 

[Student Name]

School of Business, Liberty University

ACCT 370: Financial Statement Analysis

Excel Project: Part 2

[Instructor Name]

[Date]

 

Every ratio is calculated from the companies' Form 10-K filings; the commentary and the adjusted figures are written for this sample.

Why this part earns its pointsA method note states the conventions first, so every number below can be reproduced.
2

Ratio Analysis of Crocs, Inc. Against Steven Madden and Wolverine World Wide, 2024-2025

Method

All ratios use figures from the Part 1 sheets, taken from each company's Form 10-K (Crocs, Inc., 2026; Steven Madden, Ltd., 2026; Wolverine World Wide, Inc., 2026). Ratios that divide an income statement amount by a balance sheet amount use the average of the opening and closing balances, as Revsine et al. (2018) recommend, and days ratios use 365 days. Wolverine's fiscal 2025 had 53 weeks, which slightly raises its turnover and lowers its days figures relative to the others. For Steven Madden, trade receivables and factor accounts receivable are added together before computing days sales outstanding, since both represent amounts owed for sales.

Why this part earns its pointsLiquidity is read with the working capital structure, not judged against a rule of thumb.
3

Liquidity

RatioCrocs 2024Crocs 2025Steven Madden 2025Wolverine 2025
Current ratio (current assets / current liabilities)1.181.271.901.40
Quick ratio ((current assets - inventory) / current liabilities)0.700.741.110.87
Cash ratio (cash / current liabilities)0.240.190.210.40

Crocs has the thinnest liquidity cushion of the three, yet that is less worrying than it looks. A company that generates $710 million of operating cash a year, against current liabilities of $700 million, does not need a large stock of liquid assets to pay its bills. Steven Madden's higher ratios reflect a business that carried no long-term debt until 2025 and held more inventory and receivables relative to its payables.

Why this part earns its pointsActivity ratios explain the liquidity numbers by showing how fast working capital turns into cash.
4

Activity

RatioCrocs 2024Crocs 2025Steven Madden 2025Wolverine 2025
Inventory turnover (cost of sales / average inventory)4.564.644.403.78
Days inventory outstanding80.078.682.996.5
Days sales outstanding25.124.257.536.2
Days payables outstanding56.757.649.769.4
Cash conversion cycle (days)48.345.290.763.2
Total asset turnover (revenues / average total assets)0.870.901.521.11

Crocs collects its cash about 45 days after paying for inventory, half the time Steven Madden needs. Its large direct-to-consumer business brings in cash at the register, which keeps receivable days low, and its supplier terms let payables fund much of its inventory. Its asset turnover is the lowest because $1.7 billion of goodwill and intangibles from the HEYDUDE purchase sit on the balance sheet without producing revenue directly. Wolverine's inventory days fell from 116 in 2024 to 97 in 2025, continuing a cleanup of excess stock.

Why this part earns its pointsProfitability is shown as reported, and the adjustment is kept for a separate section so nothing is hidden.
5

Profitability

RatioCrocs 2024Crocs 2025Steven Madden 2025Wolverine 2025
Gross margin58.8%58.3%41.4%47.3%
Operating margin24.9%3.7%3.2%8.0%
Net margin23.2%(2.0%)1.8%5.1%
Return on assets (net income / average total assets)20.1%(1.8%)2.7%5.7%
Return on equity (net income / average equity)57.8%(5.2%)5.2%26.6%

Crocs's gross margin, about 17 points above Steven Madden's, reflects a product with few components and strong brand pricing. Its reported 2025 operating, net and return figures are dominated by the impairment. Steven Madden's operating margin fell from 9.9% in 2024 to 3.2% in 2025, the year it acquired Kurt Geiger and faced higher tariffs on imported product (Steven Madden, Ltd., 2026). Wolverine's margins improved for a second straight year as its restructuring took hold.

Why this part earns its pointsSolvency ratios test whether the debt is affordable, which matters most for the company with the most debt.
6

Solvency

RatioCrocs 2024Crocs 2025Steven Madden 2025Wolverine 2025
Debt ratio (total liabilities / total assets)61.9%69.0%52.8%76.1%
Liabilities to equity1.622.231.173.19
Times interest earned (operating income / net interest expense)9.41.76.54.6

Crocs's debt ratios rose in 2025 only because equity shrank through the loss and $582 million of share repurchases; its borrowings actually fell. Steven Madden, which ended 2024 with no long-term debt, borrowed to finance its acquisition, and its debt ratio rose from 38% to 53%. Wolverine remains the most indebted, with liabilities more than three times equity, though that ratio has improved from 6.4 in 2023. Coverage for the competitors uses net interest expense as each reports it, so the comparison is approximate; even so, Wolverine's 4.6 times shows less room than Crocs had before the impairment.

Why this part earns its pointsThe DuPont table explains why the returns differ, separating operations from financing.
7

Return on Equity Decomposed

ComponentCrocs 2024Crocs 2025Steven Madden 2025Wolverine 2025
Net margin23.2%(2.0%)1.8%5.1%
Asset turnover0.870.901.521.11
Equity multiplier (average assets / average equity)2.872.871.944.69
Return on equity57.8%(5.2%)5.2%26.6%

Nissim and Penman (2001) show that separating operating profitability from the effect of debt financing helps explain differences in returns and their persistence. Here, Wolverine's 26.6% return on equity comes mostly from an equity multiplier of 4.69, not from margins, while Crocs's 2024 return came from margins that no competitor approaches. Soliman (2008) found that the components of a DuPont analysis carry information about future profitability beyond the return figure itself, and that is the reason to report all three here.

Why this part earns its pointsThe adjusted section isolates the impairment, which is the single most important judgment in the analysis.
8

Crocs 2025 Without the Impairment

Because the $738.1 million impairment was non-cash and not deductible for tax purposes, removing it adds the full amount back to both operating income and net income (Crocs, Inc., 2026). On that basis, 2025 operating income would be $887.6 million, an operating margin of 22.0%, and net income would be $656.9 million, a net margin of 16.3% and a return on average equity of 42.0%. Interest coverage would be 10.1 times. The adjusted figures are lower than 2024's, because HEYDUDE revenue fell 13.3% and tariffs trimmed gross margin, but they show a highly profitable core business, not a company in decline. Part 3 will test whether those trends hold across all three years.

9

References

Crocs, Inc. (2026). Annual report on Form 10-K for the fiscal year ended December 31, 2025. U.S. Securities and Exchange Commission. https://www.sec.gov/Archives/edgar/data/1334036/000133403626000006/crox-20251231.htm

Nissim, D., & Penman, S. H. (2001). Ratio analysis and equity valuation: From research to practice. Review of Accounting Studies, 6(1), 109-154. https://doi.org/10.1023/A:1011338221623

Revsine, L., Collins, D. W., Johnson, W. B., Mittelstaedt, H. F., & Soffer, L. C. (2018). Financial reporting and analysis (7th ed.). McGraw-Hill Education.

Soliman, M. T. (2008). The use of DuPont analysis by market participants. The Accounting Review, 83(3), 823-853. https://doi.org/10.2308/accr.2008.83.3.823

Steven Madden, Ltd. (2026). Annual report on Form 10-K for the fiscal year ended December 31, 2025. U.S. Securities and Exchange Commission. https://www.sec.gov/Archives/edgar/data/913241/000162828026012995/shoo-20251231.htm

Wolverine World Wide, Inc. (2026). Annual report on Form 10-K for the fiscal year ended January 3, 2026. U.S. Securities and Exchange Commission. https://www.sec.gov/Archives/edgar/data/110471/000162828026012614/www-20260103.htm

What the ACCT 370 Week 3 instructions ask

Part 2 of the ACCT 370 Excel project, ratio analysis for the company and its competitors, falls due in the third module/week. The same week brings chapters 5 through 7 of Revsine et al., which cover the essentials of financial statement analysis and the use of financial information in valuation, credit assessment and contracting, along with Connect Homework 3 and the replies for the group forum. The ratios are built from the historical statements entered in Part 1, so the workbook should calculate every ratio with formulas that reference those sheets. Most instructors expect the main families of ratios, liquidity, activity, profitability and solvency, with enough interpretation to show what each comparison means.

How this ACCT 370 Week 3 example is built

The sample opens with a short note on method: average balances for every ratio that mixes a flow with a stock, days computed on a 365-day year, and Wolverine's 53-week fiscal year flagged. Five tables follow, one per ratio family, each with Crocs's 2024 and 2025 figures beside the two competitors' 2025 figures. A sixth table decomposes return on equity for all three companies. Interpretation paragraphs sit under each table, and a final section recalculates Crocs's 2025 margins and returns without the HEYDUDE impairment, showing why the reported loss and the underlying operations should be judged separately.

ACCT 370 Week 3 grading rubric: where the points go

Accuracy carries the most weight when instructors grade ACCT 370 Part 2: correct formulas, correct inputs from Part 1 and consistent use of averages or year-end balances. Completeness comes next, which means each family of ratios is covered for the company and every competitor. Instructors then read the interpretation, looking for comparisons that explain why the companies differ rather than restating that one number is larger than another. Points are also given for presentation, such as clear labels, consistent decimals and percentages and a note on any adjustment. A workbook that hard-codes ratio results instead of using formulas usually loses accuracy credit even when the numbers happen to be right.

ACCT 370 Week 3 help: mistakes that cost points

Compute every ratio with a formula that points to the Part 1 sheets so a correction there updates Part 2 automatically. Decide once whether to use average or year-end balances and say which in a note. Watch for missing or differently labeled lines: some companies split receivables into categories, as Steven Madden does with factored receivables, and the totals must be combined before computing days sales outstanding. Interpret each ratio family in two or three sentences that connect the number to the business model, and compare it with at least one competitor so the reader sees what is unusual. Separate one-time items such as impairments into an adjusted column rather than ignoring them. The forum replies are due the same week, so finish the workbook early.

Related ACCT 370 sample papers

Other ACCT 370 weeks

More BS in Accounting sample papers

ACCT 370 Week 3 questions, answered

What is ACCT 370 Excel Project Part 2?

The 50-point second part of the course's Excel project, in which students calculate and interpret financial ratios for their company and its competitors from the Part 1 statements.

Where can I find a free ACCT 370 Week 3 sample paper?

A worked ACCT 370 Week 3 ratio analysis sample is on this page, comparing Crocs, Inc. with Steven Madden and Wolverine World Wide, with formulas, tables and interpretation.

Which ratios should a financial statement analysis include?

Liquidity measures like the current, quick and cash ratios, activity ratios such as inventory and receivable days, profitability ratios such as margins and returns, and solvency measures such as liabilities to equity and times interest earned.

Should ratios use average or year-end balances?

When a ratio sets a full year's income against a balance taken on one date, averaging the opening and closing balances gives a fairer denominator.

What else is due in ACCT 370 Module/Week 3?

The two replies for the group forum and Connect Homework 3 are due with Part 2, along with chapters 5 through 7 of Revsine et al. and a presentation.

Use it as a model, or ask for your own

This paper is an original model written by our desk for study. It is not a submitted student paper and not an official Liberty University document. Read it for structure and reasoning, then write your own to the instructions in your Canvas course. If you want a version built to your exact prompt and rubric, the first custom sample is free and arrives in 24 to 48 hours.