Image transcription text

Total Revenue Cost of Goods Sold Operating Expenses Depreciation 8: Amortization Interest. net Income Before Income Taxes Federal & State Income Taxes Net Income Net Income Per Share Basic Diluted Dividend Per Share Market Data Price Per Share Shares Outstanding [in 1.000) Casey's General Store Consolidated Balance Sheet {in 1.000} 2022 312.952.594 310.189.880 31.961.473 3303.541 356.972 3440.728 3100.938 3339.790 39.14 39.10 31.39 3201.30 37.176 2021 38.707.189 36.350.754 31.63 7.191 3265.191 346.679 3407.370 394.470 3312.900 38.44 38.38 31.32 3222.19 37.073 2022 39.175.296 37.030.612 31.498.043 3251.174 353.419 3342.048 378.202 3263.846 37.14 37.10 31.28 3151.41 36.953 2019 38.391.124 36.621.731 31.283.046 3220.970 350.940 3214.437 3103.466 3317.903 38.41 38.34 31.04 3132.35 37.801 

Image transcription text

Casey's General Store Consolidated Statements of Cash Flow (in 1:000) Cash flows from operations Net income Depreciation a: amortization Other non—cash Changes in assets and liabilities Receivables Inventories Prepaid expenses Accounts Payable Accrued expenses Income taxes Other; net Net cash flows from operations Cash flows from invest'mg artivit'rrs Purchase of property and equipment Payments for aoquistions; net of cash Proceeds from sales ofproperty and equipment Net cash flowsused in investing activities Cash flows from financ'ng activities Proceeds from long-term debt Repayments of long-term debt Net (payments) borrowings of short-term debt Payments of debt issuance costs Proceeds from exercise ofstock options Payments of cash dividends Repurchase of common stock Tax withholding of employee stock—based awards Net cash flows from financing activities Net (data-ease) increase in cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year '7'}? 555 $339590 $303541 $122523 $33525 $75530 $5575 $155593 $23574 $35515 $14533 $78854] $3 25475 $901538 $70118 $1557595 $450500 $188537 $1549 $133 $513212 $17548 $191587 $177557 $335545 $158578 2021 $312500 $255595 $47592 $263278 $50542 $1;413 $155545 $55597 $5514 $18577 $804588 $441552 $9555 $5558 $444540 $550000 $571551 $120000 $5525 $1584 $47571 $83105 $101578 $258,270 $783275 $3 35545 $253545 $251574 $713434 $10544 $37513 $2508 $140151 $25400 $15583 $8533 $504514 $438577 $32505 $5541 $455542 $17575 $45500 $2558 $45551 $7322 $22593 $14579 $53295 $83275 2019 $203585 $244587 $53131 $7,189 $29548 $1527 $12451 $3 0927 $22545 $22527 $530514 $394599 $58500 $5559 $457530 $15500 $3 5400 $2590 $413430 $3 73479 $5548 $531157 $9,517 $53579 $53595 

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"?
 

Transcribed Image Text:

Casey's General Store Consolidated Balance Sheet (in 1,000) 2022 2021 2020 2019 Assets Current Assets Cash Receivables Inventories Prepaid Expenses Tax Receivable Total Current Assets Net Fixed Assets Other Assets $158,878 $336,545 $78,275 $63,296 $108,028 $79,698 $48,500 $37,856 $396,199 $286.598 $236,007 $273,040 $17,859 $11,214 $9,801 $7,493 $44,071 $9,578 $14,667 $28,895 $725,035 $723,633 $387,250 $410,580 $3,980,542 $3,493,459 $3,323,801 $3,122,419 $187,219 $82,147 $71,766 $41,154 Goodwill $612.934 Total Assets $6,230,765 $161,075 $5,183,947 $161,075 $157,223 $4,331,142 $4,141,956 Liabilities & Shareholders' Equity Current Liabilities Notes Payable $120,000 $75,000 Current Maturities of Long-Term D $24,466 $2,354 $570,280 $17.205 Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Debt, net Current Maturities $588,783 $355,471 $291,429 $254,924 $904,678 $612,749 $184,800 $335,240 $188,348 $163,487 $1,063,428 $590,932 $1,663,403 $1,361,395 $714,502 $1,283,275 Deferred Income Taxes $520,472 $439,721 $435,598 $385,788 Deferred Compensation $12,746 $15,094 $13,604 $15.881 Insurance Accruals, net Current Portion $27,957 $26,239 $22,862 $22,663 Other Long-Term Liabilities $135,636 $72,437 $50,693 $24,068 Total Liabilities $4,169,570 $3,140,384 $3,364,115 $2,913,539 Shareholders' Equity Preferred Stocks - - Common Stocks Retained Earnings Total Shareholders' Equity Total Liabilities & Shareholders' Equity $79,412 $1,981,783 $1,984,612 $58,951 $33,286 $15,600 $933,741 $1,212,817 $1,228,417 $4,141,956 $2,061,195 $2,043,563 $967,027 $6,230,765 $5,183,947 $4,331,142 Casey's General Store Consolidated Balance Sheet (in 1,000) 2022 2021 2020 2019 Assets Current Assets Cash Receivables Inventories Prepaid Expenses Tax Receivable Total Current Assets Net Fixed Assets Other Assets $158,878 $336,545 $78,275 $63,296 $108,028 $79,698 $48,500 $37,856 $396,199 $286.598 $236,007 $273,040 $17,859 $11,214 $9,801 $7,493 $44,071 $9,578 $14,667 $28,895 $725,035 $723,633 $387,250 $410,580 $3,980,542 $3,493,459 $3,323,801 $3,122,419 $187,219 $82,147 $71,766 $41,154 Goodwill $612.934 Total Assets $6,230,765 $161,075 $5,183,947 $161,075 $157,223 $4,331,142 $4,141,956 Liabilities & Shareholders' Equity Current Liabilities Notes Payable $120,000 $75,000 Current Maturities of Long-Term D $24,466 $2,354 $570,280 $17.205 Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Debt, net Current Maturities $588,783 $355,471 $291,429 $254,924 $904,678 $612,749 $184,800 $335,240 $188,348 $163,487 $1,063,428 $590,932 $1,663,403 $1,361,395 $714,502 $1,283,275 Deferred Income Taxes $520,472 $439,721 $435,598 $385,788 Deferred Compensation $12,746 $15,094 $13,604 $15.881 Insurance Accruals, net Current Portion $27,957 $26,239 $22,862 $22,663 Other Long-Term Liabilities $135,636 $72,437 $50,693 $24,068 Total Liabilities $4,169,570 $3,140,384 $3,364,115 $2,913,539 Shareholders' Equity Preferred Stocks - - Common Stocks Retained Earnings Total Shareholders' Equity Total Liabilities & Shareholders' Equity $79,412 $1,981,783 $1,984,612 $58,951 $33,286 $15,600 $933,741 $1,212,817 $1,228,417 $4,141,956 $2,061,195 $2,043,563 $967,027 $6,230,765 $5,183,947 $4,331,142

Answer rating: 100% (QA)

Heres the Consolidated Balance Sheet for Caseys General Store for the years 2019 to 2022 2022 2021 2... View the full answer