Question
In: Accounting
Prepare a horizontal analysis on the income statement and Balance statement. (Please show the formula &...
Prepare a horizontal 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' equity $200,000 202,000
Westwood Corporation
Income Statement
For the Year Ended December 31, 20X7 & 20X6
Net sales $160,000 150,000
Cost of goods sold 120,000 118,000
Gross margin $ 40,000 32,000
Operating expenses
Selling and administrative expenses $ 16,000 23,000
Interest expense 8,000 7,750
Income taxes expense 4,000 28,000 250
Net income $ 12,000 1,000
Solutions
Expert Solution
| Westwood Corporation | ||||
| Horizontal Analysis of Balance Sheets | ||||
| 2017 | 2016 | Percentage Change | ||
| Assets | ||||
| Cash | $15,000.00 | $17,000.00 | -$2,000.00 | -11.76% |
| Marketable securities | $10,000.00 | $10,000.00 | $0.00 | 0.00% |
| Accounts receivable (net) | $20,000.00 | $22,000.00 | -$2,000.00 | -9.09% |
| Inventories | $30,000.00 | $27,000.00 | $3,000.00 | 11.11% |
| Prepaid Expense | $8,000.00 | $9,000.00 | -$1,000.00 | -11.11% |
| Property Plant & Equipment | $117,000.00 | $117,000.00 | $0.00 | 0.00% |
| Total assets | $200,000.00 | $202,000.00 | -$2,000.00 | -0.99% |
| Liabilities and Stockholders’ Equity | ||||
| Liabilities | ||||
| Current liabilities | $30,000.00 | $27,000.00 | $3,000.00 | 11.11% |
| Long Term Liabilities | $61,000.00 | $56,000.00 | $5,000.00 | 8.93% |
| Total liabilities | $91,000.00 | $83,000.00 | $8,000.00 | 9.64% |
| Stockholders' equity | $109,000.00 | $119,000.00 | -$10,000.00 | -8.40% |
| Total liabilities & stockholders’ equity | $200,000.00 | $202,000.00 | -$2,000.00 | -0.99% |
| Westwood Corporation | ||||
| Horizontal Analysis of Income Statements | ||||
| 2017 | 2016 | Percentage Change | ||
| Sales (net) | $160,000 | $150,000 | $10,000 | 6.67% |
| Less: Cost of goods sold | 120,000 | 118,000 | $2,000 | 1.69% |
| Gross Margin | 40,000 | 32,000 | $8,000 | 25.00% |
| Less: Selling, general, and administrative expenses | 16,000 | 23,000 | ($7,000) | -30.43% |
| Interest expense | 8,000 | 7,750 | $250 | 3.23% |
| Income tax expense | 4,000 | 250 | $3,750 | 1500.00% |
| Net income (loss) | $12,000 | $1,000 | $11,000 | 1100.00% |
Note : Answer may be slighlty difference due to Income tax Expense , there is 2 figuere mentioned for income tax expense in 2016, one is 28000 and second is 250 , i have considered income tax expense as $250 to solve the solution . if any this is different please replace the same , rest all the solution is correct.
ekkarill92 answered 1 year agoRelated 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 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...
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).)
THORNTON COMPANY
Horizontal Analysis of Balance
Sheets
2019
2018
Percentage Change
Assets
Current assets
Cash
$16,700
$12,200
%
Marketable securities
21,300
7,500
Accounts receivable (net)
54,100
46,500
Inventories
136,100
144,600
Prepaid items
26,300
10,400
Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Analysis Bal Sheet...
Prepare a horizontal analysis of both the balance sheet and
income statement. Analysis Bal Sheet Analysis Inc Stmt Complete
this question by entering your answers in the tabs below. 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).) Analysis Bal Sheet
Analysis Inc Stmt $ $ $ $ $ $ $ $ STUART COMPANY Horizontal
Analysis...
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...
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 the income statement data for Delaney Corporation, using 2016 as a base.
*Exercise 9-6 Here are the comparative income statements of Delaney Corporation, DELANEY CORPORATION Comparative Income Statements For the Years Ended December 31 20172016Net sales $598,000$500,000Cost of goods sold 477,000420,000Gross Profit 121,00080,000Operating expenses 80,00044,000Net income $ 41,000$36,000 Prepare a horizontal analysis of the income statement data for Delaney Corporation, using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55, 000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.) Prepare a vertical analysis of the income statement...
Prepare a horizontal analysis of the following comparative income statement for the Buff Bodies Corporation. Round...
Prepare a horizontal analysis of the following comparative
income statement for the Buff Bodies Corporation.
Round percentage changes to the nearest one-tenth
percent.
Buff Bodies Corporation
Comparative Income Statement
For the Years Ended December 31, 2019 and 2018
2019
2018
Total
revenue
$1,450,000
$1,300,000
Expenses:
Cost of goods
sold $
1,023,000
$ 930,000
Operating
expenses
310,000
275,000
Interest
expense
48,300
38,000
Income tax
expense
12,000
10,000
Total
expenses
$1,393,300
$1,253,000
Net
income
$ ...
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.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Give an example of a 2x2 matrix of numbers that represent the changes in the size...
- Every COBOL program I've browsed professionally has had Paragraph numbers. It is somewhat of Programmer Preference/Art...
- 1. Which of the following is true about property rights? You don’t need property rights for...
- Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...
- Case Study Baseball Team Manager For this case study, you’ll use the programming skills that you...
- 1. Create a color image of size 200 × 200. The image should have a blue...
- What changes in the investor’s circumstances cause the rebalancing of the investment portfolio? Explain why.
ADVERTISEMENT