Chat with us, powered by LiveChat Apply ratio analysis to financial stateme | WriteDen

03 Aug Apply ratio analysis to financial stateme

Posted at 00:09h in Business & Finance / Accounting by

 

Apply ratio analysis to financial statements.

Introduction

Note: Accounting requires specific steps that need to be executed in a sequence. The assessments in this course are presented in sequence and must be completed in order.

Ratio analysis is done to compare trends over time.

Ratio analysis is a managerial accounting tool for making and evaluating managerial decisions.

Instructions

Note: Accounting requires specific steps that need to be executed in a sequence. The assessments in this course are presented in sequence and must be completed in order.

Use the Ratio Analysis Template [XLSX] to complete this assessment. Complete the problems based on the data provided in the template.

Competencies Measured

By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:

  • Competency 4: Analyze financial statements.
    • Calculate a current ratio.
    • Calculate an acid-test ratio.
    • Calculate the number of days sales are uncollected.
    • Calculate an inventory turnover.
    • Calculate the amount sold per day in the inventory of an entity.
    • Calculate a debt-to-equity ratio.
    • Calculate the number of times interest is earned.
    • Calculate a profit margin ratio.
    • Calculate a total asset turnover.
    • Calculate a return on total assets.
    • Calculate a return on common stockholders' equity.
  • Competency 5: Communicate in a manner that is professional and consistent with expectations for professionals in the field of accounting.

Sheet1

BUS-FPX4061 – Managerial Accounting Principles
Assessment 10: Ratio Analysis Worksheet
Problem 1 Input values
Solve the given problem based on the following scenario. Company name Crouch Corp.
Crouch Corp.'s balance sheet and income statement, including all credit sales, are given in the table below. Tax rate 20%
As of December 31, 2016: Balance sheet date 12/31/17
·      Inventories were $15,660. 12/31/16
·      Total assets were $85,410. Inventories $15,660
·      Common stock was $31,950. Total assets $85,410
·      Retained earnings were $11,430. Common stock $31,950
Retained earnings $11,430
Crouch Corp. Income Statement (December 31, 2017) Crouch Corp. Income Statement (December 31, 2017)
Sales $ 283,950 Sales 283,950
Cost of goods sold 212,490 Cost of goods sold 212,490
Gross profit 71,460 Gross profit 71,460
Operating expenses 44,280 Operating expenses 44,280
Interest expenses 1,980 Interest expenses 1,980
Income before taxes 25,200 Income before taxes 25,200
Taxes (at 20%) 5,040 Taxes (at 20%) 5,040
Net income $ 20,160 Net income 20,160
Crouch Corp. Balance Sheet (December 31, 2017)
Crouch Corp. Balance Sheet (December 31, 2017) Assets Amount ($) Liability and Equity Amount ($)
Assets Amount ($) Liability and Equity Amount ($) Cash 5,490 Accounts payable 10,350
Cash 5,490 Accounts payable 10,350 Short-term investment 6,210 Accrued wages payable 2,970
Short-term investment 6,210 Accrued wages payable 2,970 Accounts receivable 10,890 Income taxes payable 2,340
Accounts receivable 10,890 Income taxes payable 2,340 Notes receivable 2,700 Notes payable (long-term) 27,000
Notes receivable 2,700 Notes payable (long-term) 27,000 Inventory 12,150 Common stock 31,500
Inventory 12,150 Common stock 31,500 Prepaid expenses 1,800 Retained earnings 31,590
Prepaid expenses 1,800 Retained earnings 31,590 Plant 66,510
Plant 66,510 Total assets 105,750 Total liability and equity 105,750
Total assets 105,750 Total liability and equity 105,750
TRUE
Compute the following and show your work. TRUE
Ratio Calculation
Current ratio
Days' sales uncollected
Days' sales in inventory
Times interest earned
Total asset turnover
Return on common stockholders' equity
Acid-test ratio
Inventory turnover
Debt-to-equity ratio
Profit margin ratio
Return on total assets

HOW OUR WEBSITE WORKS

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
HIGH QUALITY & PLAGIARISM FREE.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.