Home Insert Page Layout Formulas Data R Review View Help X Cut Calibri - 12 - A A E 29 Wrap Text General Norma Paste LG Copy BIU - - GA- Conditional Format as Merge & Center Neutra Format Painter Formatting * Table ~ Clipboard Font Alignment Number A33 V : X V fx PROFITABILITY C D Ratio Analysis IN Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. FY 2021 FY 2020 LIQUIDITY Working capital Formula current assets - current liabilities Calculation 8 Current ratio 9 Formula current assets / current liabilities 10 Calculation 11 Quick ratio 12 Formula current assets - inventory / current liabilities 13 Calculation 14 Inventory turnover 15 Formula Cost of goods sold / average inventory 16 Calculation 17 Average days to sell inventory 18 Formula 365 / inventory turnover 19 Calculation 20 SOLVENCY Debt to assets 22 Formula Total liabilities / total assets 23 Calculation Debt to equity 25 Formula total liabilities / total equi 26 Calculation 27 Number of times interest is earned 28 Formula EBIT / Interest expense Calculation 30 P Plant assets to long-term liabilities 31 Formula Net plant assets / Long-term liabil 32 Calculation 33 PROFITABILITY 34 Net margin (return on sales) SECTION 1 - A SECTION 1 - B | SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready 1 Accessi Temps to rise Tomorrow Q SearchAutoSave Off ) Comprehensive Financial Analysis Calculations StudentTem.. . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Help Cut Calibri 1 -A A de Wrap Text Gener Normal Bad Paste LE Copy Merge & Center % Conditional Format as Neutral Calculation Format Painter Formatting Table Clipboard Font Alignment Number Styles K38 B C D G 1 Horizontal Analysis of the Balance Sheets 2 Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. FY 2021 FY 2020 $ Change % Change FY 2019 $ Change % Change 4 ASSETS Cash and cash equivalents #DIV/O! S 2,577 $ (2,577) -100.00% Inventory #DIV/O! S 8,992 $ (8,992) -100.00% Assets of discontinued operations 0.00% 0.00% Other current assets #DIV/O! S (1,333) -100.00% 9 Total current assets $ #DIV/O! $ 12,902 $ (12,902) -100.00% o Property and equipment Land #DIV/O! $ (6,036) -100.00% Buildings and equipment #DIV/O! (30,603) -100.00% Fixtures and equipment #DIV/O! (6,083) -100.00% Computer hardware and software #DIV/O! (2,692) -100.00% Construction-in-progress #DIV/O! (533) -100.00% 16 Accumulated depreciation #DIV/O! 19,664 -100.00% 17 Property and equipment, net S #DIV/O! $ 26,283 $ (26,283) -100.00% Noncurrent assets of discontinued operations 0.00% 0.00% 19 Operating Lease Assets 0.00% $ 2 236 5 0.00% 20 Other noncurrent assets #DIV/O! $ 1 358 $ (1,358) -100.00% 21 Total assets #DIV/0! $ 42,779 5 (42,779) -100.00% 22 LIABILITIES Accounts payable #DIV/O! $ 9,920 5 #DIV/O! (9,920) -100.00% 24 Accrued and other current liabilities 4,406 $ (4,406) -100.00% 25 Current portion of long-term debt and other borrowings #DIV/O! 161 $ Liabilities of discontinued operations 0.00% (161) -100.00% S 27 Total current liabilities S #DIV/O! #DIV/O! $ 14,487 $ (14,487) -100.00% long-term debt and other borrowings SECTION 1 - D 1 338 SECTION 1 - A SECTION 1 - B SECTION 1 -C SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready % Accessibility. Investigate Temps to rise Q SearchAutoSave ott Comprehensive Financial Analysis Calculations StudentTem... . Saved to this PC Search Home Insert Page Layout Formulas Data Re Review View Help Cut Calibr 14 AA Custom 60% - Accent4 60% Accent5 60% - Accent6 Paste Copy BIU H. GA Conditional Format as Accent1 Format Painter Table Accent2 Accent3 Clipboard Styles F16 VIX fx +E16-D16 10 Depreciation and amortization #DIV/O! 11 Total relevant expenses #DIV/O! 12 Budgeted and actual income statement accounts FY 2020-2021 13 Actual 2020 verage % change 2016-202 Budget 2021 Actual 2021 Difference | difference from budgeted amount Sales #DIV/O! #DIV/O! #DIV/Q! #DIV/O! 15 Relevant expenses: Cost of sales #DIV/O! #DIV/O! #DIV/O! #DIV/O! 17 Selling, general, and adminstrative expense #DIV/O! #DIV/O! #DIV/O! #DIV/O! 18 Depreciation and amortization #DIV/O #DIV/O! #DIV/O! #DIV/O! Total relevant expenses #DIV/O! #DIV/O! S #DIV/O! #DIV/O! SECTION 1 - A | SECTION 1 - B | SECTION 1 -C | SECTION 1 - D | SECTION 2 - Ratio Analysis SECTION 3 - Budget + Ready To Accessibility. Inv P Temps to rise Q SearchHome Insert Page Layout Formulas Data Review View Help & Cut Calibri ~ 18 - A ap Wrap Text General Paste LE Copy Cond B I U - - GA - Merge & Center Format Painter Forma Clipboard Font Alignment Number A1 vi XV fx Vertical Analysis - Balance Sheets D G 10 Property and equipment Land Buildings and equipment 13 Fixtures and equipment Computer hardware and software Construction-in-progress 16 Accumulated depreciation 17 Property and equipment, net S 18 Noncurrent assets of discontinued operations Other noncurrent assets 20 Total assets $ 100.00% $ 100.00% 21 LIABILITIES 22 Accounts payable 23 Accrued and other current liabilities 24 Current portion of long-term debt and other borrowings 25 Liabilities of discontinued operations 26 Total current liabilities S Long-term debt and other borrowings Deferred income taxes Noncurrent liabilities of discontinued operations 0 Other noncurrent liabilities 31 Total noncurrent liabilities S 32 Total liabilities S 33 SHAREHOLDERS' INVESTMENT 34 Common stock 5 Additional paid-in capital 36 Retained earnings 37 Accumulated other comprehensive loss 38 Total shareholders' investment S S 39 Total liabilities and shareholders investment S 100.00% $ 100.00% 40 41 42 43 44 SECTION 1 - A SECTION 1 - B SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready Accessibility: I Temps to rise Tomorrow Search TCalibri 12 A A de Wrap Text General Conditional Format Paste G Copy BI U - - GA- Merge & Center $ Formatting Table Format Painter Alignment Number Clipboard Font A33 v I X V fx PROFITABILITY B 28 Formula EBil / Interest expense 29 Calculation 30 Plant assets to long-term liabilities 31 Formula Net plant assets / Long-term liabilities (debt and borrowings) 32 Calculation 33 PROFITABILITY 34 Net margin (return on sales) 35 Formula Net incomeet sales 36 Calculation 7 Asset turnover 38 Formula Net sales / average total assets 39 Calculation 40 Return on investment 41 Formula Net income / average total assets Calculation 43 Return on equity Formula Net income/average total stockholders equity Calculation 5 Earnings per share 9.42 6.39 47 Formula Net earnings available for common stock / average number of shares outstanding 48 Calculation 49 Price-earnings 20.04 19.53 50 Formula Market price per share / earnings per share 51 Calculation $2 Book value per share (common) 28.82 23.48 53 Formula Stockholders equity preferred stock / outstanding common shares Calculation 55 62 SECTION 1 - A SECTION 1 - B SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready 1% Accessibility: Investigate 1 Temps to rise Tomorrow Search SAMSUNGx AutoSave off Comprehensive Financial Analysis Calculations StudentTem.. . Saved to this PC Search File Home Insert Page Layout Formulas Data Review View Help K Cut Calibri - -AA de Wrap Text General Normal Bad Paste Copy BIU . GA EEEE Merge & Center $ % 9 00 Conditional Format as Neutral Calculation Format Painter ormatting Table Clipboard Font Alignment Number Styles K38 v IX fx D H 1 Total assets S S #DIV/O! | $ 42,779 $ (42,779) -100.0 22 LIABILITIES 23 Accounts payable #DIV/O! S 9,920 $ (9,920) -100.00 24 Accrued and other current liabilities #DIV/O! 4,406 $ (4,406) -100.00 25 Current portion of long-term debt and other borrowings #DIV/O! 161 $ (161) -100.00% 26 Liabilities of discontinued operations 0.00% S #DIV/O! 27 Total current liabilities $ #DIV/O! $ 14,487 $ (14,487) -100.00% 28 Long-term debt and other borrowings #DIV/O! 11,338 0.00% Noncurrent operating lease liabilities 0.00% 2,275 0.00% 30 Deferred income taxes #DIV/O! 1 122 0.00% 31 Noncurrent liabilities of discontinued operations 0.00% 0.00% 32 Other noncurrent liabilities #DIV/O! 0.009 33 Total noncurrent liabilities #DIV/O! $ 16,459 $ (16,459) -100.00% 34 Total liabilities #DIV/O! $ 30,946 5 (30,946) -100.00% SHAREHOLDERS' INVESTMENT 36 Common stock #DIV/O! S (42) -100.00% 37 Additional paid-in capital #DIV/O! 96, 226 (6,226) -100.00% 38 Retained earnings #DIV/O! $ (6,433) -100.00% Accumulated other comprehensive loss #DIV/O! (868) $ 868 0.00% Total shareholders' investment #DIV/0! $ 11,833 $ (11,833) -100.00% 41 Total liabilities and shareholders' investment #DIV/0! |$ 42,779 $ (42,779) -100.00% 42 43 49 50 SECTION 1 - A | SECTION 1 - B | SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready % Accessibility. Investigate Temps to rise Tomorrow Q Searchvi XV fx Vertical Analysis - Balance Sheets A B Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert additional rows based on the actual Target Consolidated statement. FY 2021 % FY 2020 % ASSETS Cash and cash equivalents Inventory Assets of discontinued operations Other current assets Total current assets S $ Property and equipment Land Buildings and equipment Fixtures and equipment Computer hardware and software Construction-in-progress 6 Accumulated depreciation 17 Property and equipment, net $ 18 Noncurrent assets of discontinued operations 19 Other noncurrent assets 20 Total assets 100.00% 100.00% 21 LIABILITIES 22 Accounts payable 23 Accrued and other current liabilities 24 Current portion of long-term debt and other borrowings 25 Liabilities of discontinued operations 26 Total current liabilities $ $ Long-term debt and other borrowings 28 Deferred income taxes 29 Noncurrent liabilities of discontinued operations 30 Other noncurrent liabilities 1 Total noncurrent liabilities S 32 Total liabilities 33 SHAREHOLDERS' INVESTMENT SECTION 1 - A SECTION 1 - B SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready 1X Accessibility: 1 Today's high To break record SearchAutoSaveoff Comprehensive Financial Analysis Calculations StudentTem.. . Saved to this PC Search File Insert Page Layout Formulas Data Review View Help Cut Calibri 14 AA Wrap Text Custom 60% - Accent4 60% - Accent5 60% - Accent6 Paste Copy FREEMerge & Center Conditional Format as Accent1 Accent2 Accents Format Painter Formatting Table Clipboard Font Alignment Styles F4 VIXfx G Horizontal Analysis of the Income Statements Target Corporation 3 INSTRUCTIONS: Change XX to the year of the report you are analyzing. FY 2021 F FY 2020 $ Change | % Change FY 2019 $ Change % Change 4 Total Revenue #DIV/O! #DIV/O! Cost of sales #DIV/O! #DIV/O! Selling, general, and administrative expenses #DIV/O! #DIV/O! Depreciation and amortization #DIV/O! #DIV/O! Operating Income #DIV/O! #DIV/O! Net other (income)/ expense 0.00% 0.00% 10 Net interest expense #DIV/O! #DIV/O! 11 Earnings from continuing operations before income taxes #DIV/O! S #DIV/O! 12 Provision for income taxes #DIV/O! #DIV/O! 13 Net earnings from continuing operations #DIV/O! $ #DIV/O! Discontinued operations, net of tax #DIV/O! #DIV/O! 15 Net earnings/(loss) #DIV/O! #DIV/O! + SECTION 1 - A SECTION 1 - B SECTION 1 - C SECTION 1 - D | SECTION 2 - Ratio Analysis | SECTION 3 - Budget | Ready To Accessibility. Investigate Temps to rise Tomorrow Q Search* AutoSave Off " Comprehensive Financial Analysis Calculations StudentTem.. . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Help & Cut Calibri 1 AA de Wrap Text General Normal Bad Paste LE Copy Merge & Center Conditional Format as Neutral Calculation Format Painter Formatting ~ Table Clipboard Font Alignment Number Styles K38 v IX V fx C G Buildings and equipment #DIV/O! 30,603 $ (30,603) -100.0 Fixtures and equipment #DIV/O! 6,083 $ (6,083) -100.00 Computer hardware and software #DIV/O! S 2,692 $ (2,692) -100.00% Construction-in-progress #DIV/O! 533 $ (533) -100.00% Accumulated depreciation #DIV/O! $ (19,664) $ 19,664 -100.00% Property and equipment, net #DIV/O! $ 26,283 $ (26,283) -100.00% Noncurrent assets of discontinued operations 0.00% 0.00% Operating Lease Assets 0.00% S 2,236 5 0.00% 20 Other noncurrent assets #DIV/O! S 1,358 $ (1,358) -100.00% 21 Total assets #DIV/O! $ 42,779 $ (42,779) -100.00% 22 LIABILITIES 23 Accounts payable #DIV/O! 9, 920 $ (9,920) -100.00% 24 Accrued and other current liabilities #DIV/O! 4,406 5 (4,406) -100.00% 25 Current portion of long-term debt and other borrowings #DIV/O! (161) -100.00% Liabilities of discontinued operations 0.00% #DIV/O! Total current liabilities #DIV/O! $ 14,487 $ (14,487) -100.00% 28 Long-term debt and other borrowings #DIV/O! 0.00% 29 Noncurrent operating lease liabilities 0.00% $ 2,275 0.00% 30 Deferred income taxes #DIV/O! 1, 122 0.00% 1 Noncurrent liabilities of discontinued operations 0.00% 0.00% Other noncurrent liabilities #DIV/0! $ 1,724 0.00% Total noncurrent liabilities #DIV/0! $ 16,459 $ (16,459) -100.00% 34 Total liabilities #DIV/O! $ 30,946 $ (30,946) -100.00% 35 SHAREH 36 Common stock #DIV/O! 42 5 #DIV/O! (42) -100.00% 37 Additional paid-in capital 6,226 5 #DIV/O! (6,226) -100.00% Retained earnings 6,433 $ 39 Accumulated other comprehensive loss #DIV/O! (6,433) -100.00% (868) $ 868 0.00% SECTION 1 - A SECTION 1 - B SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget Ready 1 Accessibility: Investigate Temps to rise Q Search Tomorrow