Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A timely reply would be very much appreciated. Thank you... I have each TARGET financial statement information (page 6 and 7) on two screens so

A timely reply would be very much appreciated. Thank you... image text in transcribed
image text in transcribed
image text in transcribed
I have each TARGET financial statement information (page 6 and 7) on two screens so it can be more visible to you. Hope this is better. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
November 2, Nov.018 Change $ November 2, 2019 $ 18.414 251 18,665 12,935 4,153 November 3 2018 5 17,590 2 31 17,821 12,535 3,937 Change 4.7% 8.8 7 4. 3. 2 5.5 2019 53,997 5 716 5 4,713 3 7,808 11.728 2018 51,699 680 52,379 36,400 11,347 Change 44% 5.3 4.5 3.9 3.4 5 1 575 1,002 113 530 819 115 (9) 8. 22.3 (1.6) 36.5 ,717 3,460 359 (38) 1,639 2,993 352 (21) 4.8 15.6 2.0 83.8 195 713 26,3 97 100. 8 616 14.5 706 (millions, except per share data) (unandited) Sales Other revenue Total revenue Cost of sales Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Operating income Net interest expense Net other (income)/expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basie carnings per share Continuing operations Discontinued operations Net earnings per share Diluted earnings per share Continuing operations Discontinued operations Net earnings per share Weighted average common shares outstanding Basic Diluted Antidilutive shares 3,139 2,662 17.9 703530 32.8 2,436 2,132 14.3 117 2,447 $ 2,139 14.4% $ 714 S 622 14.8 % S 1.38 S 18.2% $ $ 18.5% 0.02 1.17 0.01 1.18 4.75 0.02 4.77 4.01 0.01 4.02 1.40 18.5% $ $ 18.6% 18.2% S $ 18.5% 1.37 S 0.02 1.16 0.01 1.17 4.71 0.02 4.74 3.98 0.01 3.99 1.39S 18.5% S $ 18,7 % 509.7 514.8 525.0 531.2 (3.1% (3.11% 512.5 516.8 531.5 536.2 (3.63% (3.6% 0.66 S 0.64 3.1 % 5 1.96 $ 1.90 3.2% Dividends declared per share $ Nate Rescamounts may not feature to munding Consolidated Statements of Financial Position 2019 2019 Assets Cash and cash equivalents S 969$ 1,556 S 825 11,396 Inventory 9 ,497 12,393 Other current assets 1,440 1,466 1,421 Total current assets 13,805 1 2,519 14,639 Property and equipment Land 6,040 6 ,064 0,009 Buildings and improvements 30,467 29,240 29,090 Fixtures and equipment 6,032 5,912 5,784 Computer hardware and software 2,636 2,544 2,660 Construction-in-progress 298 400 384 Accumulated depreciation (19,089) (18,687) (18,380) Property and equipment, net 26,384 25,533 25,607 Operating lease assets 2,151 1,965 1.997 Other noncurrent assets 1.401 1,273 1.329 Total assets S 43,741 $ 41,290 S 43,572 Liabilities and shareholders investment Accounts payable 11.258 S 9,761 S 11,959 Accrued and other current liabilities 4,191 4.201 4,00 Current portion of long-term debt and other borrowings 1.159 1,052 1,535 Total current liabilities 16,608 15,014 17,590 Long-term debt and other borrowings 10,513 10.223 10,104 Noncurrent operating lease liabilities 2.208 2,004 2,046 Deferred income taxes 1,215 9 72 970 Other noncurrent liabilities 1,652 1,780 1,782 Total noncurrent liabilities 15.588 14,979 14.902 Shareholders' investment Common stock 42 43 Additional paid-in capital 6,006 6,042 5 ,867 Retained earnings 6,270 6 ,017 5.884 Accumulated other comprehensive loss (773) (805) (714) Total shareholders investment 11.545 11.297 1 1,080 Total liabilities and shareholders investment 5 43.741 5 41,290S 43,572 Common Stock Authorized 6,000,000,000 shares, 50.0833 par value, 506,677,740, 517,761,600 and 521.810,597 shares issued and outstanding at November 2, 2019 February 2, 2019 and November 3, 2018, respectively Preferred Stock Authorized 5,000,000 shares. So 01 par value, no shares were issued or outstanding during any period presented INSTRUCTIONS 1.) Using the data provided: -Target's 2019 3rd Quarter Earnings Report (the financial statements are on page 6 and 7) 2.) Prepare the following in excel: 1.) A comparison of 2019 and 2108 Net Earnings/A comparison of 2019 and 2018 Balance sheet (bar graph) 2.) Pie Chart - Revenues and Expenses 2019 and 2018 3.) Pie Chart Total Assets and Total Liabilities 2019 ONLY 4.) Pie Chart - Property and Equipment line items for 2019 ONLY For number 1 name the tab "At a glance For number 2 name the tab "Net Earnings Detail" For number 3 name the tab "Balance Sheet Detail" For number 4 name the tab "PPE Detail" o e W FARGET CORPORATION Consolidated Statements of Operations Three Months Ended November November 2019 S 18.414 251 18.665 12,935 4,153 17,590 4.7% 231 8.8 17.8214 7 12,535 3.2 3,937 5.5 Nine Month Ended November November 2018 $ 53,997 S 51,699 716 680 54,713 52,379 37,808 36,400 11,728 11,347 4.4 % 5.3 4.5 3.9 3.4 575 1,002 113 (12) 530 819 115 (9) 85 223 (1.6) 36.5 1,717 3.460 359 (38) 1,639 2,993 352 (21) 4.8 15.6 2.0 83.8 (lies, encept per share data) (medited) Sales Other revenue Total revenue Cost of sales Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Operating income Net interest expense Net other (income)/expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basic earnings per share Continuing operations Discontinued operations Net carmines per share Diluted earnings per share Continuing operations Discono 2,662 901 195 706 713 97 616 26.3 1008 14.5 3,139 703 2,436 17.9 328 530 2,132 14.3 S 714 5 622 14.8 % 5 2,447 5 2,139 14.4% S 1 $ 18.2% 18.5% .38 0.02 30 S 1.17 0.01 I 4 .75 S 002 4 775 4.01 0.01 4.02 185 18.6% $ 1.37 116 18.2% 5 4 .71 $ 3.98 18.5% ACTOZOAL UG 190 * Microsoft Word - 302019 Releas x Reports Third Quarter 2019 Earnings.pdf?target=1d876e4b-0832-4c19-b794-ce 699e0be23b 6/13 (12) (9) 36.5 (38) (21) 83.8 901 195 713 97 616 26.3 100.8 145 3,139 703 2,436 2,662 530 2,132 17.9 32,8 14.3 706 $ 714 5 6 22 14.8 % $ 2,447 $ 2,139 14.4 % $ $ 18.2% $ $ 18.5% Net other income)/expense Farnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basic earnings per share Continuing operations Discontinued operations Net earnings per share Diluted earnings per share Continuing operations Discontinued operations Net earnings per share Weighted average common shares outstanding Basic Diluted Antidilutive shares 1.38 0.02 1.405 0 1.17 .01 1.18 4.75 0.02 4.77 4.01 0.01 4.02 $ 18.5% $ $ 18.6% $ $ 18.2% $ 182603 $ 1.37 0,02 1.39 18.5% 1.16 .01 1.17 0 4.71 0.02 4.74 3.98 0.01 3.99 $ S 18.5 % $ $ 18.7 % 509.7 514.8 - 525.0 531 2 (3.19% (3.19% 5125 5168 531.5 536.2 (3.69% (3.6) 5 0643 . 151 96 1.90 Dividends declared per share 066 Note: Per share amounts may not foot due to rounding Target Corporation Reports Third Quarter 2019 Earnings - Page 7 of 13 TARGET CORPORATION Consolidated Statements of Financial Position November 2 February 2 November 969 $ 11,396 1,440 13,805 1.556 5 9,497 1,466 12,519 825 12 393 ,421 14619 1 (milions, except footnotes) (naudited) Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment Land Buildings and improvements Fixtures and equipment Computer hardware and software Construction-in-progress Accumulated depreciation Property and equipment, net Operating lease assets Other noncurrent assets AS Total assets Liabilities and shareholders'investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowings Total current liabilities 6,064 29,240 5,912 2544 460 6,040 30,467 6,032 2,636 298 (19.089) 26 384 2,151 1,401 43.741 6,069 29,090 5,784 2,660 384 (18380 25,607 1.997 1.129 43,572 (18,687) 25.533 1.965 1.273 S S 41.290 S S 11.258 5 4191 1.159 16,608 9 ,761 S 4,201 1 052 15,014 11,959 4,096 1.535 17.590 7/13 Accuatu upachadon (19,059) (16,067) (10,560 Property and equipment, net 26,384 25,533 25,607 Operating lease assets 2,151 1 ,965 1,997 Other noncurrent assets 1,401 1,273 1,329 Total assets $ 43,741 $ 41,290 $ 43,572 Liabilities and shareholders' investment Accounts payable 11,258 $ 9,761 $ 11,959 Accrued and other current liabilities 4,191 4,201 4,096 Current portion of long-term debt and other borrowings 1,159 1,052 1,535 Total current liabilities 16,608 15,014 17,590 Long-term debt and other borrowings 10,513 10,223 10,104 Noncurrent operating lease liabilities 2,208 2,004 2,046 Deferred income taxes 1,215 972 970 Other noncurrent liabilities 1,652 1,780 Total noncurrent liabilities 15,588 14,979 14,902 Shareholders' investment Common stock 42 Additional paid-in capital 6,006 6,042 5,867 Retained earnings 6,270 6,017 5,884 Accumulated other comprehensive loss (773) (805) (714) Total shareholders' investment 11,545 11,297 11,080 Total liabilities and shareholders' investment $ 43,741 $ 41,290 $ 43,572 Common Stock Authorized 6,000,000,000 shares, $0.0833 par value; 506,677,740, 517,761,600 and 521,810,597 shares issued and outstanding at November 2, 2019, February 2, 2019, and November 3, 2018, respectively. 1,782 43 43 Preferred Stock Authorized 5,000,000 shares, $0.01 par value, no shares were issued or outstanding during any period presented INSTRUCTIONS 1.) Using the data provided: -Target's 2019 3rd Quarter Earnings Report (the financial statements are on page 6 and 7) 2.) Prepare the following in excel: 1.) A comparison of 2019 and 2108 Net Earnings/A comparison of 2019 and 2018 Balance sheet (bar graph) 2.) Pie Chart - Revenues and Expenses 2019 and 2018 3.) Pie Chart - Total Assets and Total Liabilities 2019 ONLY 4.) Pie Chart - Property and Equipment line items for 2019 ONLY For number 1 name the tab "At a glance" For number 2 name the tab "Net Earnings Detail" For number 3 name the tab "Balance Sheet Detail" For number 4 name the tab "PPE Detail" SER November 2, Nov.018 Change $ November 2, 2019 $ 18.414 251 18,665 12,935 4,153 November 3 2018 5 17,590 2 31 17,821 12,535 3,937 Change 4.7% 8.8 7 4. 3. 2 5.5 2019 53,997 5 716 5 4,713 3 7,808 11.728 2018 51,699 680 52,379 36,400 11,347 Change 44% 5.3 4.5 3.9 3.4 5 1 575 1,002 113 530 819 115 (9) 8. 22.3 (1.6) 36.5 ,717 3,460 359 (38) 1,639 2,993 352 (21) 4.8 15.6 2.0 83.8 195 713 26,3 97 100. 8 616 14.5 706 (millions, except per share data) (unandited) Sales Other revenue Total revenue Cost of sales Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Operating income Net interest expense Net other (income)/expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basie carnings per share Continuing operations Discontinued operations Net earnings per share Diluted earnings per share Continuing operations Discontinued operations Net earnings per share Weighted average common shares outstanding Basic Diluted Antidilutive shares 3,139 2,662 17.9 703530 32.8 2,436 2,132 14.3 117 2,447 $ 2,139 14.4% $ 714 S 622 14.8 % S 1.38 S 18.2% $ $ 18.5% 0.02 1.17 0.01 1.18 4.75 0.02 4.77 4.01 0.01 4.02 1.40 18.5% $ $ 18.6% 18.2% S $ 18.5% 1.37 S 0.02 1.16 0.01 1.17 4.71 0.02 4.74 3.98 0.01 3.99 1.39S 18.5% S $ 18,7 % 509.7 514.8 525.0 531.2 (3.1% (3.11% 512.5 516.8 531.5 536.2 (3.63% (3.6% 0.66 S 0.64 3.1 % 5 1.96 $ 1.90 3.2% Dividends declared per share $ Nate Rescamounts may not feature to munding Consolidated Statements of Financial Position 2019 2019 Assets Cash and cash equivalents S 969$ 1,556 S 825 11,396 Inventory 9 ,497 12,393 Other current assets 1,440 1,466 1,421 Total current assets 13,805 1 2,519 14,639 Property and equipment Land 6,040 6 ,064 0,009 Buildings and improvements 30,467 29,240 29,090 Fixtures and equipment 6,032 5,912 5,784 Computer hardware and software 2,636 2,544 2,660 Construction-in-progress 298 400 384 Accumulated depreciation (19,089) (18,687) (18,380) Property and equipment, net 26,384 25,533 25,607 Operating lease assets 2,151 1,965 1.997 Other noncurrent assets 1.401 1,273 1.329 Total assets S 43,741 $ 41,290 S 43,572 Liabilities and shareholders investment Accounts payable 11.258 S 9,761 S 11,959 Accrued and other current liabilities 4,191 4.201 4,00 Current portion of long-term debt and other borrowings 1.159 1,052 1,535 Total current liabilities 16,608 15,014 17,590 Long-term debt and other borrowings 10,513 10.223 10,104 Noncurrent operating lease liabilities 2.208 2,004 2,046 Deferred income taxes 1,215 9 72 970 Other noncurrent liabilities 1,652 1,780 1,782 Total noncurrent liabilities 15.588 14,979 14.902 Shareholders' investment Common stock 42 43 Additional paid-in capital 6,006 6,042 5 ,867 Retained earnings 6,270 6 ,017 5.884 Accumulated other comprehensive loss (773) (805) (714) Total shareholders investment 11.545 11.297 1 1,080 Total liabilities and shareholders investment 5 43.741 5 41,290S 43,572 Common Stock Authorized 6,000,000,000 shares, 50.0833 par value, 506,677,740, 517,761,600 and 521.810,597 shares issued and outstanding at November 2, 2019 February 2, 2019 and November 3, 2018, respectively Preferred Stock Authorized 5,000,000 shares. So 01 par value, no shares were issued or outstanding during any period presented INSTRUCTIONS 1.) Using the data provided: -Target's 2019 3rd Quarter Earnings Report (the financial statements are on page 6 and 7) 2.) Prepare the following in excel: 1.) A comparison of 2019 and 2108 Net Earnings/A comparison of 2019 and 2018 Balance sheet (bar graph) 2.) Pie Chart - Revenues and Expenses 2019 and 2018 3.) Pie Chart Total Assets and Total Liabilities 2019 ONLY 4.) Pie Chart - Property and Equipment line items for 2019 ONLY For number 1 name the tab "At a glance For number 2 name the tab "Net Earnings Detail" For number 3 name the tab "Balance Sheet Detail" For number 4 name the tab "PPE Detail" o e W FARGET CORPORATION Consolidated Statements of Operations Three Months Ended November November 2019 S 18.414 251 18.665 12,935 4,153 17,590 4.7% 231 8.8 17.8214 7 12,535 3.2 3,937 5.5 Nine Month Ended November November 2018 $ 53,997 S 51,699 716 680 54,713 52,379 37,808 36,400 11,728 11,347 4.4 % 5.3 4.5 3.9 3.4 575 1,002 113 (12) 530 819 115 (9) 85 223 (1.6) 36.5 1,717 3.460 359 (38) 1,639 2,993 352 (21) 4.8 15.6 2.0 83.8 (lies, encept per share data) (medited) Sales Other revenue Total revenue Cost of sales Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Operating income Net interest expense Net other (income)/expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basic earnings per share Continuing operations Discontinued operations Net carmines per share Diluted earnings per share Continuing operations Discono 2,662 901 195 706 713 97 616 26.3 1008 14.5 3,139 703 2,436 17.9 328 530 2,132 14.3 S 714 5 622 14.8 % 5 2,447 5 2,139 14.4% S 1 $ 18.2% 18.5% .38 0.02 30 S 1.17 0.01 I 4 .75 S 002 4 775 4.01 0.01 4.02 185 18.6% $ 1.37 116 18.2% 5 4 .71 $ 3.98 18.5% ACTOZOAL UG 190 * Microsoft Word - 302019 Releas x Reports Third Quarter 2019 Earnings.pdf?target=1d876e4b-0832-4c19-b794-ce 699e0be23b 6/13 (12) (9) 36.5 (38) (21) 83.8 901 195 713 97 616 26.3 100.8 145 3,139 703 2,436 2,662 530 2,132 17.9 32,8 14.3 706 $ 714 5 6 22 14.8 % $ 2,447 $ 2,139 14.4 % $ $ 18.2% $ $ 18.5% Net other income)/expense Farnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basic earnings per share Continuing operations Discontinued operations Net earnings per share Diluted earnings per share Continuing operations Discontinued operations Net earnings per share Weighted average common shares outstanding Basic Diluted Antidilutive shares 1.38 0.02 1.405 0 1.17 .01 1.18 4.75 0.02 4.77 4.01 0.01 4.02 $ 18.5% $ $ 18.6% $ $ 18.2% $ 182603 $ 1.37 0,02 1.39 18.5% 1.16 .01 1.17 0 4.71 0.02 4.74 3.98 0.01 3.99 $ S 18.5 % $ $ 18.7 % 509.7 514.8 - 525.0 531 2 (3.19% (3.19% 5125 5168 531.5 536.2 (3.69% (3.6) 5 0643 . 151 96 1.90 Dividends declared per share 066 Note: Per share amounts may not foot due to rounding Target Corporation Reports Third Quarter 2019 Earnings - Page 7 of 13 TARGET CORPORATION Consolidated Statements of Financial Position November 2 February 2 November 969 $ 11,396 1,440 13,805 1.556 5 9,497 1,466 12,519 825 12 393 ,421 14619 1 (milions, except footnotes) (naudited) Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment Land Buildings and improvements Fixtures and equipment Computer hardware and software Construction-in-progress Accumulated depreciation Property and equipment, net Operating lease assets Other noncurrent assets AS Total assets Liabilities and shareholders'investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowings Total current liabilities 6,064 29,240 5,912 2544 460 6,040 30,467 6,032 2,636 298 (19.089) 26 384 2,151 1,401 43.741 6,069 29,090 5,784 2,660 384 (18380 25,607 1.997 1.129 43,572 (18,687) 25.533 1.965 1.273 S S 41.290 S S 11.258 5 4191 1.159 16,608 9 ,761 S 4,201 1 052 15,014 11,959 4,096 1.535 17.590 7/13 Accuatu upachadon (19,059) (16,067) (10,560 Property and equipment, net 26,384 25,533 25,607 Operating lease assets 2,151 1 ,965 1,997 Other noncurrent assets 1,401 1,273 1,329 Total assets $ 43,741 $ 41,290 $ 43,572 Liabilities and shareholders' investment Accounts payable 11,258 $ 9,761 $ 11,959 Accrued and other current liabilities 4,191 4,201 4,096 Current portion of long-term debt and other borrowings 1,159 1,052 1,535 Total current liabilities 16,608 15,014 17,590 Long-term debt and other borrowings 10,513 10,223 10,104 Noncurrent operating lease liabilities 2,208 2,004 2,046 Deferred income taxes 1,215 972 970 Other noncurrent liabilities 1,652 1,780 Total noncurrent liabilities 15,588 14,979 14,902 Shareholders' investment Common stock 42 Additional paid-in capital 6,006 6,042 5,867 Retained earnings 6,270 6,017 5,884 Accumulated other comprehensive loss (773) (805) (714) Total shareholders' investment 11,545 11,297 11,080 Total liabilities and shareholders' investment $ 43,741 $ 41,290 $ 43,572 Common Stock Authorized 6,000,000,000 shares, $0.0833 par value; 506,677,740, 517,761,600 and 521,810,597 shares issued and outstanding at November 2, 2019, February 2, 2019, and November 3, 2018, respectively. 1,782 43 43 Preferred Stock Authorized 5,000,000 shares, $0.01 par value, no shares were issued or outstanding during any period presented INSTRUCTIONS 1.) Using the data provided: -Target's 2019 3rd Quarter Earnings Report (the financial statements are on page 6 and 7) 2.) Prepare the following in excel: 1.) A comparison of 2019 and 2108 Net Earnings/A comparison of 2019 and 2018 Balance sheet (bar graph) 2.) Pie Chart - Revenues and Expenses 2019 and 2018 3.) Pie Chart - Total Assets and Total Liabilities 2019 ONLY 4.) Pie Chart - Property and Equipment line items for 2019 ONLY For number 1 name the tab "At a glance" For number 2 name the tab "Net Earnings Detail" For number 3 name the tab "Balance Sheet Detail" For number 4 name the tab "PPE Detail" SER

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services An Integrated Approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley

10th Edition

0131457349, 978-0131457348

More Books

Students also viewed these Accounting questions

Question

Identify the motives that fuel prejudice.

Answered: 1 week ago

Question

7.1 Define selection and discuss its strategic importance.

Answered: 1 week ago