Prepare the following: 1. Horizontal Analysis 2. Vertical Analysis 3. Calculate the return on equity with...

Prepare the following:

1. Horizontal Analysis
2. Vertical Analysis
3. Calculate the return on equity with the DuPont model
4. Calculate the sustainable growth rate.

	2020	2019
Revenue	622,658.00	330,517.00
Cost of Revenue	115,396.00	61,001.00
Gross Profit	507,262.00	269,516.00
Operating Expenses
R&D	67,079.00	33,014.00
Sales & Marketing	340,646.00	185,821.00
G&A	86,841.00	44,514.00
Total Operating Expenses	494,566.00	263,349.00
Income from Operations	12,696.00	6,167.00
Interest income	13,666.00	2,182.00
Net Income	26,362.00	8,349.00
Income Tax Provision	1,057.00	765.00
Net Income	25,305.00	7,584.00

Assume that dividends were 15,000. Utilize Excel formulas.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Prepare a paragraph to tell us what is horizontal and vertical analysis. State why vertical and...

Prepare a paragraph to tell us what is horizontal and vertical analysis. State why vertical and horizontal analysis can be of value to any company. How it might apply to your employer/business or other business you know of?

1) Evaluate the following taxes from the standpoint of vertical and horizontal equity. a. A 25...

1) Evaluate the following taxes from the standpoint of vertical and horizontal equity. a. A 25 cent per gallon tax on milk b. A tax on stock market transactions c. A sales tax on men’s clothing d. A tax on cigarettes

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.

DuPont Analysis of Return on Equity 1. Using the following table, calculate the ROE in each...

DuPont Analysis of Return on Equity 1. Using the following table, calculate the ROE in each year using the simple formula. 2. Use the three step DuPont ROE process and show your work. 3. Summarize the findings in your DuPont ROE analysis. Select Financial Data for ABC Corp. 2017 2018 2019 Sales 20,000 22,000 25,000 Net Income 1,000 1,500 1,600 Total Assets 20,000 20,000 30,000 Total Equity 15,000 16,000 15,000

Q: Please review the Income Statement and Balance Sheet Prepare the following analysis: 1) Calculate Horizontal...

Q: Please review the Income Statement and Balance Sheet Prepare the following analysis: 1) Calculate Horizontal (Trend) Analysis of the Income Statement and Balance Sheet 2) Calculate Vertical (Common Size) Analysis of the Income Statement and Balance Sheet 3) Calculate the Liquidity Ratios only for COSTCO for the most recent (newest) year with a brief explanation of what each reveals to management COSTCO WHOLESALE CORPORATION CONSOLIDATED BALANCE SHEET (amounts in millions) ASSETS CURRENT ASSETS August 31, 2016 August 31, 2015...

Using the income statement, calculate the vertical and horizontal analysis and insert your answers in the...

Using the income statement, calculate the vertical and horizontal analysis and insert your answers in the appropriate spaces provided VERTICAL ANALYSIS HORIZONTAL ANALYSIS Statement of Operations Income Statement 2017 Percent 2018 percent CHANGE PERCENT Sales (net) 8,100,000 10,000,000 Cost of goods sold 5,300,000 6,000,000 Gross Margin 2,800,000 4,000,000 General Expense (1,050,000.00) (1,080,000) Depreciation Expense (300,000.00) (300,000) Operating Income 1,450,000.00 2,620,000 Interest Expense (40,000.00) (50,000) Income Taxes (35%) (507,500.00) (917,000.00) Net Income 902,500.00 1,653,000

1a) Discuss Horizontal and vertical equity. Provide taskbase and and 3 major categories.

1a) Discuss Horizontal and vertical equity. Provide taskbase and and 3 major categories. 1b) Discuss important methods of financing deficit and consequeces of each method. 1c) Discuss tax evasion and avoidiance and the cost and benefits.

1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a...

1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a base. Neiman Corp. Comparative Balance Sheet For the years ended December 31 2019 2018 Assets Current Assets 360 300 Plant Assets 640 500 Total Assets 1,000 800 Liabilities & Stockholders' Equity Current liabilities 150 120 Long-term debt 240 160 Common stock 350 320 Retained earnings 260 200 Total liabilities & stockholders' equity 1,000 800 2 VERTICAL ANALYSIS INSTRUCTIONS: Prepare a vertical analysis of the...

Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...

Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) ADAMS COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $16,700 $12,100 % Marketable securities 20,200 7,400 Accounts receivable (net) 54,900 47,600 Inventories 135,200 144,500 Prepaid items 25,000 10,500 Total current assets...

Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...

Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) BAIRD COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $17,600 $12,200 % Marketable securities 21,000 6,200 Accounts receivable (net) 54,700 46,800 Inventories 136,500 143,300 Prepaid items 26,500 11,800 Total current assets...

Subjects