Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

for the income statement revenue the December 31 2018 total revenue is 21,412.8 total cost of sales is 18,015.5 December 31 2017 total revenue is

image text in transcribed

image text in transcribed

image text in transcribed

for the income statement revenue the December 31 2018 total revenue is 21,412.8 total cost of sales is 18,015.5

December 31 2017 total revenue is 21,534.6 total cost of sales is 18,175.6

Lillage cu infee digits. For example Il Casil as a percentage of total assets is .054029834, your answer should be shown as 5.4%. These numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data. Common Size Income Statement Prepare a spreadsheet with common size income statements for the 2019 and 2018 fiscal years. You do not need to do 2017. In this case, your denominator will be Revenues. Again, remember fp round. Horizontal Analysis of both financial statements Prepare a horizontal analysis of the balance sheet and income statement, showing the percentage change from 2018 to 2019 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows: (2019 amount - 2018 amount)/2018 amount Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles. 2019 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Dec. 31, Dec. 31, Dec. 31, 2 2018 2017 3 Revenue: TOTAL REVENUE $ 21,335.7 5 Cost of Sales: 6 TOTAL COST OF SALES (excluding depreciation shown below) $ 17,812.7 7 Gross Profit: 8 TOTAL GROSS PROFIT $ 3,523.0 $ 3,397.3 $ 3,359.0 9 Selling, general, and administrative expenses $ 2,558.6 $ 2,509.8 $2,436.2 10 Depreciation and amortization $ 180.5 $ 166.2 $ 158.6 11 Franchise rights impairment $ 9.6 $ 8.1 $ 0.0 12 Other income, net $ (49.3) $ (64.7) $ (79.2) 13 OPERATING INCOME $ 823.6 $ 777.9 $ 843.4 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) $ (130.4) $ (97.0) 16 Other interest expense $ (106.7) $ (119.4) $ (120.2) 17 Interest income $ 0.5 $ 1.1 $ 1.0 18 Other income, net $ 33.6 $ 0.2 $ 9.3 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES $ 612.6 $ 529.4 $ 636.5 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash 14 Average: S 10.4) Count 3 B F $ 777.9 $ 843.4 13 OPERATING INCOME $ 823.6 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) 16 Other interest expense $(106.7) 17 Interest income $ 0.5 18 Other income, net $ 33.6 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES $ 612.6 20 Income tax provision $ 161.8 21 NET INCOME FROM CONTINUING OPERATIONS $ 450.8 22 Income (loss) from discontinued operations, net of income taxes $ (0.8) 23 NET INCOME $ 450.0 24 BASIC EARNINGS (LOSS) PER SHARE: 25 Continuing operations in dollars per share) $ 5 26 Discontinued operations in dollars per share) -0.01 27 Net income in dollars per share) $ 4.99 28 Weighted average common shares outstanding (in shares) 90.1 29 DILUTED EARNINGS (LOSS) PER SHARE: Bo Continuing operations (in dollars per share) $ 4.98 1 Discontinued operations (in dollars per share) -0.01 2 Net income (in dollars per share) $ 4.97 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash eady $(130.4) $ (119.4) $ 1.1 $ 0.2 $ 529.4 $ 133.5 $ 395.9 $ 0.1 $ 396.0 $ (97.0) $ (120.2) $ 1.0 $9.3 $ 636.5 $201.5 $ 435.0 $ (0.4) $ 434.6 $ 4.36 0 $ 4.36 90.9 $4.45 0 $ 4.44 97.8 $ 4.34 0 $ 4.43 0 $ 4.43 $ 4.34 Average: 5 10.4) Count sun Lillage cu infee digits. For example Il Casil as a percentage of total assets is .054029834, your answer should be shown as 5.4%. These numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data. Common Size Income Statement Prepare a spreadsheet with common size income statements for the 2019 and 2018 fiscal years. You do not need to do 2017. In this case, your denominator will be Revenues. Again, remember fp round. Horizontal Analysis of both financial statements Prepare a horizontal analysis of the balance sheet and income statement, showing the percentage change from 2018 to 2019 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows: (2019 amount - 2018 amount)/2018 amount Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles. 2019 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Dec. 31, Dec. 31, Dec. 31, 2 2018 2017 3 Revenue: TOTAL REVENUE $ 21,335.7 5 Cost of Sales: 6 TOTAL COST OF SALES (excluding depreciation shown below) $ 17,812.7 7 Gross Profit: 8 TOTAL GROSS PROFIT $ 3,523.0 $ 3,397.3 $ 3,359.0 9 Selling, general, and administrative expenses $ 2,558.6 $ 2,509.8 $2,436.2 10 Depreciation and amortization $ 180.5 $ 166.2 $ 158.6 11 Franchise rights impairment $ 9.6 $ 8.1 $ 0.0 12 Other income, net $ (49.3) $ (64.7) $ (79.2) 13 OPERATING INCOME $ 823.6 $ 777.9 $ 843.4 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) $ (130.4) $ (97.0) 16 Other interest expense $ (106.7) $ (119.4) $ (120.2) 17 Interest income $ 0.5 $ 1.1 $ 1.0 18 Other income, net $ 33.6 $ 0.2 $ 9.3 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES $ 612.6 $ 529.4 $ 636.5 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash 14 Average: S 10.4) Count 3 B F $ 777.9 $ 843.4 13 OPERATING INCOME $ 823.6 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) 16 Other interest expense $(106.7) 17 Interest income $ 0.5 18 Other income, net $ 33.6 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES $ 612.6 20 Income tax provision $ 161.8 21 NET INCOME FROM CONTINUING OPERATIONS $ 450.8 22 Income (loss) from discontinued operations, net of income taxes $ (0.8) 23 NET INCOME $ 450.0 24 BASIC EARNINGS (LOSS) PER SHARE: 25 Continuing operations in dollars per share) $ 5 26 Discontinued operations in dollars per share) -0.01 27 Net income in dollars per share) $ 4.99 28 Weighted average common shares outstanding (in shares) 90.1 29 DILUTED EARNINGS (LOSS) PER SHARE: Bo Continuing operations (in dollars per share) $ 4.98 1 Discontinued operations (in dollars per share) -0.01 2 Net income (in dollars per share) $ 4.97 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash eady $(130.4) $ (119.4) $ 1.1 $ 0.2 $ 529.4 $ 133.5 $ 395.9 $ 0.1 $ 396.0 $ (97.0) $ (120.2) $ 1.0 $9.3 $ 636.5 $201.5 $ 435.0 $ (0.4) $ 434.6 $ 4.36 0 $ 4.36 90.9 $4.45 0 $ 4.44 97.8 $ 4.34 0 $ 4.43 0 $ 4.43 $ 4.34 Average: 5 10.4) Count sun

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

Cost Benefit Analysis Concepts And Practice

Authors: Anthony E. Boardman, David H. Greenberg, Aidan R. Vining, David L. Weimer

5th Edition

1108401295, 978-1108401296

More Books

Students also viewed these Accounting questions

Question

=+b) Find the predicted value for the year 2012. Is it realistic?

Answered: 1 week ago