*Use accounting terms * Need ASAP

•  Complete a 2-part assessment in which you analyze and compute financial ratios and interpret the results of a multi-year financial ratio analysis.
  Smart investors also execute due diligence by performing a bit of financial statement analysis (also known as ratio analysis), where financial statement numbers are used to evaluate three characteristics of an organization’s performance: (1) liquidity, (2) profitability, and (3) solvency.
  SHOW LESS
  By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:
  Save Time On Research and Writing

  Hire a Pro to Write You a 100% Plagiarism-Free Paper.

  Get My Paper

  Competency 2: Apply accounting cycle strategies to manage business financial events.

  Compute financial ratios using accounting data from financial statements.
  Interpret the results of financial ratios.
  Interpret trends found in a multi-year financial ratio analysis.
  Recommend strategies to improve financial trends.

•  Competency Map
  CHECK YOUR PROGRESS
  Use this online tool to track your performance and progress through your course.
  You have reached the end of the organization’s accounting period. The accounting cycle, consisting of recording transactions, transferring to the ledger, and preparing the financial statements, is complete for this calendar or fiscal (an accounting period other than January to December) year. So now, what do you do with all the accounting information that has been gathered? You analyze it, synthesize it, and use it to make decisions concerning the current health of the organization and its future financial direction.
  If you were a potential investor (and had some disposable income to burn), you would mostly likely look through the annual reports of various organizations, read the comments of key decision makers, talk to friends and family members, and make an informed decision about which organization deserves your hard-earned money. Or, you could trust Wall Street to advise you on where to invest your money (but remember, they get a cut of your investment dollars as a commission).
  Questions to Consider
  To deepen your understanding, you are encouraged to consider the questions below and discuss them with a fellow learner, a work associate, an interested friend, or a member of the business community.
  Consider these final reflections:

  What did you find to be the most complicated?
  What did you find to be the least complicated?
  What concept or principle surprised you the most?
  Which concepts and principles do you believe you will use the most in your professional life
  Required Resources
  The following resources are required to complete the assessment.
  Capella Resources
  Click the links provided to view the following resources:
  Assessment 5, Part 1 Template.
  Assessment 5, Part 2 Template.

  Save Time On Research and Writing

  Hire a Pro to Write You a 100% Plagiarism-Free Paper.

  Get My Paper
•  Suggested Resources
  The following optional resources are provided to support you in completing the assessment or to provide a helpful context. For additional resources, refer to the Research Resources and Supplemental Resources in the left navigation menu of your courseroom.
  Library Resources
  The following e-books or articles from the Capella University Library are linked directly in this course:

  Fields, E. (2011). The essentials of finance and accounting for nonfinancial managers (2nd ed.). New York, NY: AMACOM Books.

  Chapter 6, “Key Financial Ratios,” is particularly applicable to the assessment.

•  Course Library Guide
  A Capella University library guide has been created specifically for your use in this course. You are encouraged to refer to the resources in the BUS-FP3061 – Fundamentals of Accounting Library Guide to help direct your research.
  Internet Resources
  Access the following resources by clicking the links provided. Please note that URLs change frequently. Permissions for the following links have been either granted or deemed appropriate for educational use at the time of course publication.

  Accounting Basics for Students. (2013). Retrieved from http://www.accounting-basics-for-students.com/
  Bean Counter’s Free Accounting & Bookkeeping Tutorial Site. (n.d.). Retrieved from http://www.dwmbeancounter.com/moodle/

•  Additional Resources
  The resources listed below are relevant to the topics and assessments in this course and are not required. 

  McCrary, S. A. (2010). Mastering financial accounting essentials: The critical nuts and bolts. Hoboken, NJ: Wiley.
  Mullis, D., & Orloff, J. (2008). The accounting game: Basic accounting fresh from the lemonade stand. Naperville, IL: Sourcebooks.
  Shim, J. K., & Siegel, J. G. (2010). Dictionary of accounting terms (5th ed.). Hauppauge, NY: Barrons Educational Series.

• Assessment Instructions
  This assessment includes two parts. Use the templates provided as you complete each part. Both of the templates are linked in the Resources under the Required Resources heading. Note that for Part 2 you will use the template for data but will create your own document to submit.
  Part 1: Ratio Analysis
  Making sense of accounting data on financial statements can be difficult. Thankfully, combining numbers from income statements, balance sheets, and other data provides a starting point to analyze a company’s financial results. You now have the opportunity to demonstrate your prowess by identifying and computing financial ratios.
  Using the Assessment 5, Part 1 Template, analyze and compute the necessary financial ratios. The Financial Statements worksheet in the template contains the income statement, balance sheets, and additional information needed. The Ratio Analysis worksheet contains space for your calculations and answers.
  Part 2: Interpreting Financial Statement Analysis
  What does the calculation of a financial statement ratio represent? How does one year compare to another? Is there a trend to the ratio data? Is the trend positive or negative? What can be done to change the trend? These are some of the questions that can be answered when the ratio data is interpreted. For this part of the assessment, demonstrate your ability to interpret the results of a multi-year financial ratio analysis.
  On the Assessment 5, Part 2 Template you will find selected ratios for a company over a two-year period. Compare the ratios, and in a separate document (Word or Excel), submit your answers to the following questions:

  What does the calculation of each ratio represent?
  How does year one compare with year two, and what trend can be seen when you compare the two years?
  Is the trend from year one to year two positive or negative?
  What are the possible reasons for the trend?
  What recommendations do you have for turning a negative trend to a positive trend?

•  Submit the completed template for Part 1 and the document you created with answers to the questions for Part 2 for this assessment.

Ratio Analysis

Calculations

turnover

Dividend payout

BUS-FP3061 – Fundamentals of Accounting

Assessment 5, Part 1 Template

2013

2013 Answers

Current ratio

Quick ratio

Receivables turnover

Inventory

Profit margin

Asset turnover

Return on assets

Return on equity

Earnings per share

Price-earnings

Cash

Debt ratio

Debt-to-Equity

Times interest earned

Financial Statements

BUS-FP3061 – Fundamentals of Accounting
Assessment 5, Part 1 Template

Orange Company

December 31

2013

2013 2012

Cash

$ 18,000

$ 18,000

Inventory

Stockholder’s Equity

$ 150,000

$ 638,000 $ 560,000

	Orange Company
Income Statement	Balance Sheets
For the Years Ended	December 31
	2012
Net sales (all on account)	$ 600,000	$ 520,000	Assets
Expenses:	Current Assets
Cost of Goods Sold	$ 415,000	$ 354,000	$ 21,000			$ 18,000
Selling and administrative	$ 120,800	$ 114,600	Short-term investments	$ 15,000
Interest Expense	$ 7,800	$ 6,000	Accounts Receivable	$ 86,000	$ 74,000
Income Tax Expense	$ 14,000	$ 90,000	$ 70,000
Total expenses	$ 561,600	$ 488,600	Total Current Assets	$ 215,000	$ 177,000
Net Income	$ 38,400	$ 31,400	Plant Assets	$ 423,000	$ 383,000
Total Assets		$ 638,000		$ 560,000
Additional Data:
1. The common stock recently sold at $19.50 per share.	Liabilities and	Stockholder’s Equity
2. Cash dividends in the amount of $15,400 were paid-out in 2013.	Current Liabilities
Accounts Payable	$ 122,000	$ 110,000
Income Taxes Payable	$ 23,000	$ 20,000
Total Curent Liabilities	$ 145,000	$ 130,000
Long-term Liabilities
Bonds Payable	$ 120,000	$ 80,000
Total Liabilities	$ 265,000	$ 210,000
Common Stock ($5 par value)		$ 150,000
Retained Earnings	$ 223,000	$ 200,000
Total Stockholder’s Equity	$ 373,000	$ 350,000
Total Liabilities and Stockholder’s Equity

Title

BUS-FP3061 – Fundamentals of Accounting

Ratio	Year 1	Year 2
Current ratio	3.12:1	2.96:1
Quick ratio	1.34:1	1.02:1
Receivables turnover	9.7 times	10.2 times
Inventory turnover	2.4 times	2.3 times
Profit margin	11.4%	12.6%
Asset turnover	1.21 times	1.22 times
Return on assets	13.7%	15.4%
Return on equity	28.5%	29.3%
Price-earnings ratio	10.4 times	12.4 times
Debt ratio	50.2%	45.3%
Times interest earned	9.6 times	13.0 times

Capella Proprietary and Confidential

ShortDoc_Internal

Last updated: 2/25/2015 9:18 AM
1

Capella Proprietary and Confidential
ShortDoc_Internal

Last updated: 2/25/2015 9:18 AM
2