Question

In: Accounting

Prepare a vertical analysis of the 2020 income statement data for Duke Company and Lord Company.


Here are comparative statement data for Duke Company and Lord Company, two competitors. All balance sheet data are as of December 31, 2020, and December 31, 2019.



Duke Company


Lord Company



2020


2019


2020


2019

Net sales
$1,878,000


$559,000

Cost of goods sold
1,100,508


296,829

Operating expenses
261,042


79,937

Interest expense
9,390


4,472

Income tax expense
54,462


6,149

Current assets
329,000
$312,100
83,200
$78,300
Plant assets (net)
519,900
501,200
139,800
124,200
Current liabilities
65,400
74,800
34,200
29,600
Long-term liabilities
108,800
90,400
30,200
26,000
Common stock, $10 par
499,500
499,500
120,500
120,500
Retained earnings
175,200
148,600
38,100
26,400

(a)

Prepare a vertical analysis of the 2020 income statement data for Duke Company and Lord Company. (Round percentages to 1 decimal place, e.g. 12.1%.)

Condensed Income Statement
choose the accounting period                                                                      December 31, 2020For the Quarter Ended December 31, 2020For the Year Ended December 31, 2020


Duke Company


Lord Company


Dollars


Percent


Dollars


Percent

select an income statement item                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

$enter a dollar amount


enter a percentage number rounded to 1 decimal place %


$enter a dollar amount


enter a percentage number rounded to 1 decimal place %

select an income statement item                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a dollar amount


enter a percentage number rounded to 1 decimal place %


enter a dollar amount


enter a percentage number rounded to 1 decimal place %

select a summarizing line for the first part                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a total amount for the first part


enter total percentages rounded to 1 decimal place %


enter a total amount for the first part


enter total percentages rounded to 1 decimal place %

select an income statement item                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a dollar amount


enter a percentage number rounded to 1 decimal place %


enter a dollar amount


enter a percentage number rounded to 1 decimal place %

select a summarizing line for the second part                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a total amount for the second part


enter total percentages rounded to 1 decimal place %


enter a total amount for the second part


enter total percentages rounded to 1 decimal place %

select an opening name for the third part                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues








select an income statement item                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a dollar amount


enter a percentage number rounded to 1 decimal place %


enter a dollar amount


enter a percentage number rounded to 1 decimal place %

select a summarizing line for the third part                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a total amount for all three parts


enter total percentages rounded to 1 decimal place %


enter a total amount for all three parts


enter total percentages rounded to 1 decimal place %

select an income statement item                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

enter a dollar amount


enter a percentage number rounded to 1 decimal place %


enter a dollar amount


enter a percentage number rounded to 1 decimal place %

select a closing name for this statement                                                                      Cost of Goods SoldDividendsExpensesGross ProfitIncome Before Income TaxesIncome From OperationsIncome Tax ExpenseInterest ExpenseNet Income / (Loss)Net SalesOperating ExpensesOther Expenses and LossesRevenuesTotal ExpensesTotal Revenues

$enter a total net income or loss amount


enter total percentages rounded to 1 decimal place %


$enter a total net income or loss amount


enter total percentages rounded to 1 decimal place %

Solutions

Expert Solution

Condensed Income Statement
For the Year Ended December 31, 2020
Duke   Company Lord   Company
Dollars
(A)
%
( A/ $ 1,878,000 )
Dollars
(B)
%
( B / $ 559,000 )
Net sales $ 1,878,000 100% $ 559,000 100%
Less: Cost of goods sold ($ 1,100,508 ) 58.6% ($ 296,829 ) 53.1%
Gross profit $ 777,492 41.4% $ 262,171 46.9%
Less: Operating expenses ($ 261,042) 13.9% ($ 79,937) 14.3%
Income from Operations $ 516,450 27.5% $ 182,234 32.6%
Other Expenses and Losses :
Interest expense ($ 9,390) 0.5% ($ 4,472) 0.8%
Income before Income taxes $ 507,060 27% $ 177,762 31.8%
Income Tax Expense ($ 54,462) 2.9% ($ 6,149) 1.1%
Net income / (Loss) $ 452,598 24.1% $ 171,613 30.7%

Related Solutions

1. Prepare a vertical analysis on the income statement and Balance statement. (Please show the formula...
1. Prepare a vertical 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'...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca Cola for 2016 and 2017. Write a paragraph highlighting what you learn from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2016 and 2017 and between Coke and Pepsi.
Prepare a Vertical Analysis of Income Statement. (Show your % out to 2 Decimals, example =9.55%...
Prepare a Vertical Analysis of Income Statement. (Show your % out to 2 Decimals, example =9.55% Answer the Following Questions Below the Analysis Report .i) How much of Every Dollar from a Customer does our Business Keep? ii) What is the Largest Single Expense for our Biz and How much does it Cost per Dollar? iii) What is the Largest Single Operating Expense and How much does it Cost per Dollar? 1) Jan-1 The JW-Corp Received $120,000 from Investors in...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $92,316 $104,544 Event-related revenue 135,648 131,648 NASCAR broadcasting revenue 179,922 170,368 Other operating revenue 63,114 77,440 Total revenue $471,000 $484,000 Expenses and other: Direct expense of...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on years 2017 and 2016. 2. Perform the following ratios, Current, Debt, Return on Equity on years 2017 and 2016 https://www.thewaltdisneycompany.com/wp-content/uploads/2017-Annual-Report.pdf Return on common stockholders’ equity ratio. Return on asset ratio. Profit margin rate. Earnings per share. Debt to total asset ratio. Current ratio Average collection period. Receivables turnover ratio. Asset turnover ratio.
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for two...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for two recent fiscal years was adapted from the annual report of Speedway Motorsports, Inc. (TRK), owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $90,639 $100,694 Event-related revenue 136,900 146,980 NASCAR broadcasting revenue 224,227 217,469 Other operating revenue 60,390 31,320 Total revenues $512,156 $496,463 Expenses and other: Direct expense of...
   Calculate the vertical analysis of the following data. Income Statement 2018 2019 Sales $ 800,000 $950,000...
   Calculate the vertical analysis of the following data. Income Statement 2018 2019 Sales $ 800,000 $950,000 Cost of Goods Sold 350,000 600,000 Gross Margin 450,000 350,000 Operating Expenses 250,000 280,000 Net Income $200,000 $ 70,000 From the following Balance sheet of A Co. Ltd., you are required to prepare a Schedule of Changes in Working Capital Liabilities 2011 2012 Assets 2011 2012 Share Capital 200000 210000 Cash at bank 105000 106000 Profit & loss A/c 20000 23000 Debtors 18000 28000...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $450,000 $387,000 Cost of goods sold 270,000 212,850 Selling expenses 72,000 69,660 Administrative expenses 76,500 61,920 Income tax expense 13,500 15,480 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $392,000 $353,000 Cost of goods sold 231,280 180,030 Selling expenses 62,720 70,600 Administrative expenses 70,560 60,010 Income tax expense 11,760 17,650 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $518,000 $471,000 Cost of goods sold 290,080 240,210 Selling expenses 93,240 94,200 Administrative expenses 98,420 80,070 Income tax expense 15,540 23,550 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT