Question

In: Accounting

Prepare a Horizontal Financial Statement for Albertsons in the chart below. Compare the Condensed statement to...

Prepare a Horizontal Financial Statement for Albertsons in the chart below. Compare the Condensed statement to Kroger (already listed).

Financial Statement Analysis Project Alberstons Alberstons
Condensed Financial Statements Kroger 2019 FY Kroger 2018 FY 2019 2018
Consolidated Balance Sheets
Cash 1,610 1,508
Merchandise Inventory 6,846 6,533
Receivables 1,589 1,637
Other Current Assets 758 1,439
Total Current Assets 10,803 11,117
Property and Equipment, net 21,635 21,071
Other Assets 5,680 5,009
Total Assets 38,118 37,197
Total Current Liabilities 14,274 14,197
Total Long-Term Liabilities 16,009 16,095
Total Liabilities 30,283 30,292
Total Shareholders Equity 7,835 6,905
Total Liabilities & Shareholders Equity 38,118 37,197
Consolidated Income Statement
Revenue (Net Sales) 121,162 122,662
Cost of Goods Sold (Merchandise Costs) 94,894 95,662
Gross Profit (Gross Margin) 26,268 27,000
Operating Expenses 23,654 24,388
Operating Income (Profit) 2,614 2,612
Other Income (Expense) 1,364 (1,128)
Earnings before tax 3,978 1,484
Income Tax Expense 900 (405)
Other Adjustments 32 18
Net Earnings (Net Income) 3,110 1,907
Earnings per share 3.80 2.11

Albertsons Balance Sheet

Current assets 2019 2018
Cash and cash equivalents $ 926.1 $ 670.3
Receivables, net 586.2 615.3
Inventories, net 4,332.8 4,421.1
Prepaid assets 316.2 368.6
Other current assets 88.7 73.3
Total current assets 6,250 6,148.6
Property and equipment, net 9,861.3 10,770.3
Intangible assets, net 2,834.5 3,142.5
Goodwill 1,183.3 1,183.3
Other assets 647.5 567.6
TOTAL ASSETS 20,776.6 21,812.3
Current liabilities
Accounts payable 2,918.7 2,833
Accrued salaries and wages 1,054.7 984.1
Current maturities of long-term debt and capitalized lease obligations 148.8 168.2
Current portion of self-insurance liability 306.8 296
Taxes other than income taxes 309 323.5
Other current liabilities 414.7 424.8
Total current liabilities 5,152.7 5,029.6
Long-term debt and capitalized lease obligations 10,437.6 11,707.6
Deferred income taxes 561.4 579.9
Long-term self-insurance liability 839.5 921.7
Other long-term liabilities 2,334.7 2,175.3
Commitments and contingencies
STOCKHOLDERS' EQUITY
Preferred stock, $0.01 par value; 30,000,000 shares authorized, no shares issued and outstanding as of February 23, 2019 and February 24, 2018, respectively 0 0
Common stock, $0.01 par value; 1,000,000,000 shares authorized, 277,882,010 and 279,654,028 shares issued and outstanding as of February 23, 2019 and February 24, 2018, respectively 2.8 2.8
Additional paid-in capital 1,814.2 1,773.3
Treasury stock, at cost, 1,772,018 and no shares held as of February 23, 2019 and February 24, 2018, respectively (25.8) 0
Accumulated other comprehensive income 91.3 191.1
Accumulated deficit (431.8) (569)
Total stockholders' equity 1,450.7 1,398.2
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 20,776.6 $ 21,812.3

Albertson's Consolidated Statements of Operations and Comprehensive Income (Loss) - USD ($)

12 Months Ended
Feb. 23, 2019 Feb. 24, 2018
Income Statement [Abstract]
Net sales and other revenue $ 60,534,500,000 $ 59,924,600,000
Cost of sales 43,639,900,000 43,563,500,000
Gross profit 16,894,600,000 16,361,100,000
Selling and administrative expenses 16,107,300,000 16,275,400,000
Goodwill impairment 0 142,300,000
Operating income (loss) 787,300,000 (56,600,000)
Interest expense, net 830,800,000 874,800,000
Loss (gain) on debt extinguishment 8,700,000 (4,700,000)
Other income (104,400,000) (9,200,000)
Income (loss) before income taxes 52,200,000 (917,500,000)
Income tax benefit (78,900,000) (963,800,000)
Net income (loss) 131,100,000 46,300,000
Other comprehensive income (loss):
(Loss) gain on interest rate swaps, net of tax (15,500,000) 47,000,000
Recognition of pension (loss) gain, net of tax (83,100,000) 92,200,000
Foreign currency translation adjustment, net of tax (300,000) 65,000,000
Other (900,000) (300,000)
Current-period other comprehensive loss, net (99,800,000) 203,900,000
Comprehensive income (loss) $ 31,300,000 $ 250,200,000

Solutions

Expert Solution


Related Solutions

Based on the chart below, prepare the following: Prepare the following: -An income statement for 2015...
Based on the chart below, prepare the following: Prepare the following: -An income statement for 2015 and 2016 -A balance sheet for 2015 and 2016 -Operating cash flows for the two years -Cash flows from assets in 2016 -Cash flows to creditors for 2016 -Cash flows to stockholders for 2016 2015 2016 Cost of Goods Sold    235,942 297,915 Cash      36,542 51,940 Depreciation      61,056 69,011 Interest Expense 13,877 15,905 Selling and Admin Exp 40,952 58,569 Accounts Payable 32,194...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) ADAMS COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $16,700 $12,100 % Marketable securities 20,200 7,400 Accounts receivable (net) 54,900 47,600 Inventories 135,200 144,500 Prepaid items 25,000 10,500 Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) BAIRD COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $17,600 $12,200 % Marketable securities 21,000 6,200 Accounts receivable (net) 54,700 46,800 Inventories 136,500 143,300 Prepaid items 26,500 11,800 Total current assets...
Condensed statement of financial position and income statement data for Richetti Ltd. are shown below: RICHETTI...
Condensed statement of financial position and income statement data for Richetti Ltd. are shown below: RICHETTI LTD. Statement of Financial Position December 31 (in thousands) 2018 2017 2016 Assets Current assets    Cash $28 $81 $200    Accounts receivable 908 707 497    Inventory 1,188 794 504 Total current assets 2,124 1,582 1,201 Property, plant, and equipment (net) 4,076 3,778 3,195 Total assets $6,200 $5,360 $4,396 Liabilities and Shareholders’ Equity Liabilities    Current liabilities $600 $553 $497    Non-current liabilities 3,042 2,330 1,491       Total liabilities...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a base. Neiman Corp. Comparative Balance Sheet For the years ended December 31 2019 2018 Assets Current Assets 360 300 Plant Assets 640 500 Total Assets 1,000 800 Liabilities & Stockholders' Equity Current liabilities 150 120 Long-term debt 240 160 Common stock 350 320 Retained earnings 260 200 Total liabilities & stockholders' equity 1,000 800 2 VERTICAL ANALYSIS INSTRUCTIONS: Prepare a vertical analysis of the...
Prepare a horizontal analysis on the income statement and Balance statement. (Please show the formula &...
Prepare a horizontal analysis on the income statement and Balance statement. (Please show the formula & your calculations balance Sheet December 31, 20X7 & 20X6 Assets 20X7 20X6 Cash $ 15,000   17,000 Marketable securities 10,000 10,000 Accounts receivable (net) 20,000 22,000 Inventory 30,000 27,000 Prepaid expenses 8,000 9,000 Property, plant, and equipment 117,000 117,000 Total assets $200,000 202,000 Liabilities and Stockholders' Equity Current liabilities $ 30,000 27,000 Long-term liabilities 61,000 56,000 Stockholders' equity 109,000 119,000 Total liabilities and stockholders' equity...
Selected financial statement information and additional data for Stanislaus Co. is presented below. Prepare a statement...
Selected financial statement information and additional data for Stanislaus Co. is presented below. Prepare a statement of cash flows for the year ending December 31, 2020 and answer the question below and other questions from the same statement of cash flows. December 31 2019 2020 Cash........................................................ $39,000 $54,000 Accounts receivable (net)....................... 84,000 144,200 Inventory................................................. 168,000 206,600 Land......................................................... 61,800 32,000 Equipment............................................... 504,000 789,600 TOTAL.......................................... $856,800 $1,226,400 Accumulated depreciation...................... $84,000 $110,600 Accounts payable................................... 50,400 91,000 Notes payable - short-term.................... 67,200 29,400 Notes...
Selected financial statement information and additional data for Jasmine Co. is presented below. Prepare a statement...
Selected financial statement information and additional data for Jasmine Co. is presented below. Prepare a statement of cash flows for the year ending December 31, 2020 December 31 2020 2019 Cash $65,000 $42,000 Accounts receivable (net) 144,200 84,000 Inventory 206,600 168,000 Land 21,000 58,800 Equipment…………………………………. 789,600 504,000 A/D- Eqp………....................................... 115,600 84,000 Accounts payable 86,000 50,400 Notes payable - short-term 29,400 67,200 Notes payable - long-term 302,400 168,000 Common stock 487,200 420,000 Retained earnings 205,800 67,200 *change in inventory is an...
Selected financial statement information and additional data for Stanislaus Co. is presented below. Prepare a statement...
Selected financial statement information and additional data for Stanislaus Co. is presented below. Prepare a statement of cash flows for the year ending December 31, 2017.                                                                                                 December 31                                                                                     2016                            2017 Cash......................................................... $42,000                       $60,000 Accounts receivable (net)........................     84,000                       144,200 Inventory.................................................. 168,000                       206,600 Land.........................................................     58,800                         26,000 Equipment................................................ 504,000                       789,600 TOTAL......................................... $856,800                  $1,226,400 Accumulated depreciation....................... $84,000                     $110,600 Accounts payable....................................     50,400                         91,000 Notes payable - short-term......................     67,200                         29,400 Notes payable - long-term....................... 168,000                       302,400 Common stock........................................ 420,000                      ...
Condensed financial data of Oakley Company appear below.
Condensed financial data of Oakley Company appear below.     Additional information: 1. Equipment costing $97,000 was purchased for cash during the year. 2. Investments were sold at cost. 3. Equipment costing $47,000 was sold for $15,550, resulting in gain of $8,750. 4. A cash dividend of $83,400 was declared and paid during the year.   Instructions Prepare a worksheet for the statement of cash flows using the indirect method. Enter the reconciling items directly in the worksheet columns, using letters to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT