Problem 1: Comparative income statements for 2020 and 2019 follow. Sales Cost of Sales Gross Profit Operating Expenses Operating Income Interest Expense Earnings Before Tax Income Taxes Net Income 2020 $9,434,000 7,075,400 $2,358,600 $2,201,360 1,367,690 1,365,060 $ 990,910 $836,300 157,500 126,000 $ 833,410 $ 710,300 400,000 317,200 $ 433,410 $ 393,100 2019 $7,862,000 5,660,640 Required: 4 a. Prepare a vertical common-size analysis of this statement for each year, using sales as the base. b. Comment briefly on the changes between the two years, based on the vertical common-size statement.

Problem 1: Comparative income statements for 2020 and 2019 follow. Sales Cost of Sales Gross Profit Operating Expenses Operating Income Interest Expense Earnings Before Tax Income Taxes Net Income 2020 $9,434,000 7,075,400 $2,358,600 $2,201,360 1,367,690 1,365,060 $ 990,910 $836,300 157,500 126,000 $ 833,410 $ 710,300 400,000 317,200 $ 433,410 $ 393,100 2019 $7,862,000 5,660,640 Required: 4 a. Prepare a vertical common-size analysis of this statement for each year, using sales as the base. b. Comment briefly on the changes between the two years, based on the vertical common-size statement.

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter2: Financial Statements, Cash Flow,and Taxes

Section: Chapter Questions

Problem 15P: Use the following income statement of Elliott Game Theory Consulting to determine its net operating...

See similar textbooks

Similar questions

Use the following income statement of Elliott Game Theory Consulting to determine its net operating profit after taxes (NOPAT). Use 25% as the tax rate. Elliott Game Theory Consulting Income Statement for Year Ending December 31
Ratio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Rhodes Corporations financial statements are shown after part f. Suppose the federal-plus-state tax corporate tax is 25%. Answer the following questions. a. What is the net operating profit after taxes (NOPAT) for 2020? b. What are the amounts of net operating working capital for both years? c. What are the amounts of total net operating capital for both years? d. What is the free cash flow for 2020? e. What is the ROIC for 2020? f. How much of the FCF did Rhodes use for each of the following purposes: after-tax interest, net debt repayments, dividends, net stock repurchases, and net purchases of short-term investments? (Hint: Remember that a net use can be negative.) Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported Horizon Period $ millions 2018 2019 2020 2021 2022 TerminalPeriod Sales $56,912 $57,766 $58,632 $59,512 $60,404 $61,008 NOPAT 2,492 2,542 2,580 2,619 2,658 2,684 NOA 4,032 4,097 4,158 4,221 4,284 4,327 Answer the following requirements assuming a discount rate (WACC) of 7.8%, a terminal period growth rate of 1%, common shares outstanding of 135.6 million, net nonoperating obligations (NNO) of $(6,129) million, which is negative because Humana’s nonoperating assets exceed its nonoperating liabilities, and no noncontrolling interest (NCI) on the balance sheet. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31, 2018. Instructions: Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and…
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,788,322 211,362 571,823 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…
Herbert Wong has extracted the following information from her income statement and balance sheet for 2021 and 2020: 2021 2020 Profit After Tax $656,810 $672,346 Cost of Sales $54,269 $53,251 Sales Revenue $259,368 $212,962 Inventory $35,505 $45,285 Accounts payable $120,483 $129,398 Accounts receivable (Debtors) $59,498 $79,380 Owner's Equity $1,523,999 $1,131,784 Based on the information provided, calculate the Days in Accounts Receivable for 2021, expressed in days to 2 decimal places.
CALCULATE THE EBITDA For the year ended December 31, Notes 2020 2019 Revenue ₱ 10,775,731.00 ₱ 11,334,976.00 Cost of Sales 7,175,540.00 7,552,700.00 Gross profit 3,600,191.00 3,782,276.00 General and Administrative expenses 3,278,202.00 3,417,740.00 Finance Cost Or Interest Expense 48,000.00 16,000.00 Net Income before Tax 273,989.00 348,536.00 Provision for Income Tax 82,197.00 104,561.00 NET INCOME AFTER TAX ₱ 191,792.00 ₱ 243,975.00 (See Notes to Financial Statement)
CAN SOMEONE HELP ME PREPARE A SCHEDULE VERTICAL ANALYSIS? Operating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $754,000 $605,000 Cost of goods sold 465,218 392,645 Selling expenses 122,148 69,575 Administrative expenses 61,828 54,450 Income tax expense 33,176 21,780 Net income 71,630 66,550
Using the information provided below:Rubialac PaintsSelected Income Statement Items, 2020Cash Sales $2,500,000Credit Sales $9,500,000Total Sales $12,000,000COGS 7,000,000 Rubialac PaintsSelected Balance Sheet Accounts12/31/2020 12/31/19 ChangeAccounts Receivable $550,000 $400,000 $150,000Inventory $275,000 $250,000 $25,000Accounts Payable $150,000 $110,000 $40,000 What is the inventory turnover for Rubialac Paints? What is the average production cycle for the firm? What is the average collection cycle? What could Eagle Paints do to reduce the average collection cycle?