80.2K

Verified Solution

Link Copied!

\begin{tabular}{|l|r|r|r|r|} \hline \multicolumn{5}{|c|}{ Casey's General Store } \\ \hline & \multicolumn{4}{|c|}{ Consolidated Balance Sheet (in 1,000) } \\ \hline & 2022 & \multicolumn{1}{|c|}{2021} & \multicolumn{1}{c|}{2022} & \multicolumn{1}{c|}{2019} \\ \hline Total Revenue & $12,952,594 & $8,707,189 & $9,175,296 & $8,391,124 \\ \hline Cost of Goods Sold & $10,189,880 & $6,350,754 & $7,030,612 & $6,621,731 \\ \hline Operating Expenses & $1,961,473 & $1,637,191 & $1,498,043 & $1,283,046 \\ \hline Depreciation \& Amortization & $303,541 & $265,191 & $251,174 & $220,970 \\ \hline Interest, net & $56,972 & $46,679 & $53,419 & $50,940 \\ \hline Income Before Income Taxes & $440,728 & $407,370 & $342,048 & $214,437 \\ \hline Federal \& State Income Taxes & $100,938 & $94,470 & $78,202 & $103,466 \\ \hline Net Income & $339,790 & $312,900 & $263,846 & $317,903 \\ \hline Net Income Per Share & & & & \\ \hline Basic & & & & \\ \hline Diluted & $9.14 & $8.44 & $7.14 & $8.41 \\ \hline Dividend Per Share & $9.10 & $8.38 & $7.10 & $8.34 \\ \hline & $1.39 & $1.32 & $1.28 & $1.04 \\ \hline Market Data & & & & \\ \hline Price Per Share & $201.30 & $222.19 & $151.41 & $132.35 \\ \hline Shares Outstanding (in 1,000) & 37,176 & 37,073 & 36,953 & 37,801 \\ \hline \end{tabular} 2. In the excel file provided for this assignment, balance sheets, income statements and statements of cash flow in the past few years from a U.S. company (Casey's General Store) are provided. Let's assume the company just released their most recent financial statements a few days ago (ignore errors in the statements, if any). 3. The submitted assignment should be formatted as a professional report (memo). Everything specified in part 4 should be included in the report. 4. Specific things to do for the report: 1) Brief history of the company, what do they do, which industry are they in, who are their major competitors? 2) Calculate major financial ratios for all years if data are available in the excel file, including liquidity ratios, financial leverage ratios, coverage ratios, activity ratios, profitability ratios and market ratios. 3) Dupont Identity Equation - Calculate the key financial ratios by category ( 3 part) and use this data to for all years as part of your analysis in part (4). 4) Analysis a) What are the major trends we can identify from the ratios? What factors contributed to the major trends (hint: use the Dupont Identity)? What issues can we tell from the identified trends? b) What can you identify about the company's financial situation from the statements of cash flow? 5) Predictions a) In your opinion, how will the company do in the near future (e.g., any improvements in some aspects)? b) In your opinion, what should the company do to deal with issues identified in part "(4) Analysis

Answer & Explanation Solved by verified expert

See Answer