Considering 2012 as the base year, you are required to compute the trend index for the following items: Revenue, cost of goods sold, total expenses and net earnings. Comment on the trends of each of the items. Total assets, total liabilities and shareholders’ equity. Comment on the trends of each of the items. Cash flow from operation, cash flow from investing, cash flow from financing and closing cash balances. Comment on the trends of each of the items.

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 59BE
icon
Related questions
icon
Concept explainers
Topic Video
Question

Considering 2012 as the base year, you are required to compute the trend index for the following items:

  1. Revenue, cost of goods sold, total expenses and net earnings. Comment on the trends of each of the items.
  2. Total assets, total liabilities and shareholders’ equity. Comment on the trends of each of the items.
  3. Cash flow from operation, cash flow from investing, cash flow from financing and closing cash balances. Comment on the trends of each of the items.
*Carperale finar lallalr, rigklarerd.
Historical Results
FINANCIAL STATEMENTS
2012
2013
2014
2015
2016
2017
Income Statement
Revenue
158,311
102,007
39,023
62,984
118,086
131,345
49,123
82,222
142,341
150,772
56,710
94,062
Cost of Goods Sold (COGS)
48,004
70,082
52,654
89,687
58,575
99,736
Gross Profit
Еxрenses
22,658
10,125
18,150
23,002
11,020
16,544
Salaries and Benefits
26,427
10,963
19,500
2,500
59,390
3,594
23,872
10,087
17,205
25,245
11,412
16,080
26,913
10,000
15,008
Rent and Overhead
Depreciation & Amortization
Interest
Total Expenses
Earnings Before Tax
2,500
1,500
1500
52,066
37,622
1,500
54,237
39,825
1.500
53,433
16,649
52,664
29,558
53,421
46,314
Taxes
1.120
2,474
4,858
11,791
8.483
21,075
11,598
10,908
26,713
12,968
33,346
Net Earnings
28,227
Balance Sheet
Assets
181,210
5,904
Cash
167,971
5,100
7,805
183,715
6,567
9,825
211,069
7,117
10,531
38,602
267,319
239,550
7,539
11,342
272,530
7,807
11,715
Accounts Receivable
Inventory
Property & Equipment
Total Assets
9,601
45,500
42,350
40.145
37,521
37,513
226,376
239,065
240,252
295,951
329,564
Liabilities
Accounts Payable
Debt
3,902
4,800
50,000
4,912
5,265
50,000
53,902
30,000
34,912
5,671
30,000
5,938
30,000
35,938
30,000
Total Liabilities
54,800
35,265
35,671
Shareholder's Equity
Equity Capital
Retained Earnings
Shareholder's Equity
Total Liabilities & Shareholder
170,000
170,000
170,000
35,340
205,340
240,252
170,000
62.053
170,000
170,000
123,627
293,627
2,474
14,265
90,280
260,280
172,474
184,265
232,053
226,376
239,065
267,319
295,951
329,564
Cash Flov Statement
Operating Cash Flow
Net Earnings
Plus: Depreciation & Amortization
Less: Changes in Working Capital
Cash from Operations
2,474
19,500
9,003
11,791
18,150
1,702
28,239
21,075
26,713
28,227
33,346
17,205
16,544
16,080
15,008
775
903
827
375
12,971
37,505
42,354
43,480
47,980
Investing Cash Flow
Investments in Property & Equipment
Cash from Investing
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
Financing Cash Flov
Issuance (repayment) of debt
Issuance (repayment) of equity
Cash from Financing
(20,000)
170,000
170,000
[20,000)
Net Increase (decrease) in Cash
Opening Cash Balance
Closing Cash Balance
167,971
13,239
167.971
2,505
181,210
183,715
27,354
28,480
211,069
239,550
32,980
183,715
211,069
239,550
272,530
167,971
181,210
Transcribed Image Text:*Carperale finar lallalr, rigklarerd. Historical Results FINANCIAL STATEMENTS 2012 2013 2014 2015 2016 2017 Income Statement Revenue 158,311 102,007 39,023 62,984 118,086 131,345 49,123 82,222 142,341 150,772 56,710 94,062 Cost of Goods Sold (COGS) 48,004 70,082 52,654 89,687 58,575 99,736 Gross Profit Еxрenses 22,658 10,125 18,150 23,002 11,020 16,544 Salaries and Benefits 26,427 10,963 19,500 2,500 59,390 3,594 23,872 10,087 17,205 25,245 11,412 16,080 26,913 10,000 15,008 Rent and Overhead Depreciation & Amortization Interest Total Expenses Earnings Before Tax 2,500 1,500 1500 52,066 37,622 1,500 54,237 39,825 1.500 53,433 16,649 52,664 29,558 53,421 46,314 Taxes 1.120 2,474 4,858 11,791 8.483 21,075 11,598 10,908 26,713 12,968 33,346 Net Earnings 28,227 Balance Sheet Assets 181,210 5,904 Cash 167,971 5,100 7,805 183,715 6,567 9,825 211,069 7,117 10,531 38,602 267,319 239,550 7,539 11,342 272,530 7,807 11,715 Accounts Receivable Inventory Property & Equipment Total Assets 9,601 45,500 42,350 40.145 37,521 37,513 226,376 239,065 240,252 295,951 329,564 Liabilities Accounts Payable Debt 3,902 4,800 50,000 4,912 5,265 50,000 53,902 30,000 34,912 5,671 30,000 5,938 30,000 35,938 30,000 Total Liabilities 54,800 35,265 35,671 Shareholder's Equity Equity Capital Retained Earnings Shareholder's Equity Total Liabilities & Shareholder 170,000 170,000 170,000 35,340 205,340 240,252 170,000 62.053 170,000 170,000 123,627 293,627 2,474 14,265 90,280 260,280 172,474 184,265 232,053 226,376 239,065 267,319 295,951 329,564 Cash Flov Statement Operating Cash Flow Net Earnings Plus: Depreciation & Amortization Less: Changes in Working Capital Cash from Operations 2,474 19,500 9,003 11,791 18,150 1,702 28,239 21,075 26,713 28,227 33,346 17,205 16,544 16,080 15,008 775 903 827 375 12,971 37,505 42,354 43,480 47,980 Investing Cash Flow Investments in Property & Equipment Cash from Investing 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Financing Cash Flov Issuance (repayment) of debt Issuance (repayment) of equity Cash from Financing (20,000) 170,000 170,000 [20,000) Net Increase (decrease) in Cash Opening Cash Balance Closing Cash Balance 167,971 13,239 167.971 2,505 181,210 183,715 27,354 28,480 211,069 239,550 32,980 183,715 211,069 239,550 272,530 167,971 181,210
Expert Solution
steps

Step by step

Solved in 7 steps with 3 images

Blurred answer
Knowledge Booster
Stock Valuation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage