Homework Help is Here – Start Your Trial Now!
Business
Accounting
+Caprale Finnur faalilala", All rigkla rearvard. FINANCIAL STATEMENTS Income Statement Revenue Cost of Goods Sold (COGS) Gross Profit Expenses Salaries and Benefits Rent and Overhead Depreciation & Amortization Interest Total Expenses Earnings Before Tax Taxes Net Earnings Balance Sheet Assets Cash Accounts Receivable Inventory Property & Equipment Total Assets Liabilities Accounts Payable Debt Total Liabilities Shareholder's Equity Equity Capital Retained Earnings Shareholder's Equity Total Liabilities & Shareholder Cash Flow Statement Operating Cash Flow Net Earnings Plus: Depreciation & Amortization Less: Changes in Working Capital Cash from Operations Investing Cash Flow Investments in Property & Equipment Cash from Investing Financing Cash Flow Issuance (repayment) of debt Issuance (repayment) of equity Cash from Financing Net Increase (decrease) in Cash Opening Cash Balance Closing Cash Balance 2012 102,007 39,023 62,984 26,427 10,963 19,500 2,500 59,390 3,594 1,120 2,474 167,971 5,100 7,805 45,500 226,376 3,902 50,000 53,902 170,000 2,474 172,474 226,376 2.474 19,500 9,003 12,971 15,000 15,000 Historical Results 2014 2013 118,086 131,345 48,004 49,123 70,082 82,222 22,658 10,125 18,150 2,500 53,433 16,649 4,858 11,791 181,210 5,904 9,601 42,350 239,065 4,800 50,000 54,800 170,000 14,265 184,265 239,065 11,791 18,150 1,702 28,239 15,000 15,000 170,000 170,000 167,971 13,239 167.971 167,971 181,210 23,872 10,087 17,205 1,500 52,664 29,558 8,483 21,075 183,715 6,567 9,825 40,145 240,252 21,075 17,205 775 37,505 15,000 15,000 2015 (20,000) 20,000) 2,505 181,210 183,715 142,341 150,772 52,654 56,710 89,687 94,062 23,002 11,020 16,544 1,500 10,908 26,713 52,066 54,237 37,622 39,825 211,069 7,117 10,531 38,602 267,319 4,912 5,265 5,671 30,000 30,000 30,000 34,912 35,265 35,671 170,000 62,053 2016 170,000 35,340 205,340 232,053 260,280 240,252 267,319 295,951 26,713 16,544 903 42,354 25,245 11,412 16,080 1,500 15,000 15,000 27,354 183,715 211,069 239,550 7,539 11,342 37,521 295,951 170,000 90,280 11,598 12,968 28,227 33,346 28,227 16,080 827 43,480 15,000 15,000 2017 28,480 211,069 239,550 158,311 58,575 99,736 26,913 10,000 15,008 1,500 53,421 46,314 272,530 7,807 11,715 37,513 329,564 5,938 30,000 35,938 170,000 123,627 293,627 329,564 33,346 15,008 375 47,980 15,000 15,000 32,980 239,550 272,530

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

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

Perform the following:

a. horizontal analysis

b. vertical analysis

c. ratio analysis

d. interpret the results

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

Step by step

Solved in 5 steps with 21 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS