Chat with us, powered by LiveChat Apply ratio analysis to financial stateme - Writeedu

Apply ratio analysis to financial stateme

 

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

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. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. 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.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.

Click here to Place your Order Now