OBJECTIVES Calculate the current ratio and quick ratio Calculate asset utilization ratios, including inventory turnover, receivables turnover, and total asset turnover Calculate times interest earned...

1 answer below »

OBJECTIVES



  • Calculate the current ratio and quick ratio

  • Calculate asset utilization ratios, including inventory turnover, receivables turnover, and total asset turnover

  • Calculate times interest earned (TIE) and debt ratios

  • Calculate profitability and market value ratios, including return on equity (ROE), return on assets (ROA), market-to-book, and price-earnings (P/E) ratios


ASSIGNMENT OVERVIEW


This assignment provides students with practice calculating ratios.


DELIVERABLES


A spreadsheet file with answers to the ratio calculations requested in the assignment details below


Step 1

Access the handout to access financial statements and information you will need to make the required calculations.


Handout.(opens an external site)


Step 2

Use a spreadsheet file to calculate and report the following information:

  • What is the current ratio of this firm?

  • What is the quick ratio of this firm?

  • What is the inventory turnover ratio of this firm?

  • What is the receivables turnover of this firm?

  • What is the total asset turnover of this firm?

  • What is the times interest earned (TIE) of this firm?

  • What is the total debt ratio of this firm?

  • What is the return on equity (ROE) of this firm?

  • What is the return on assets (ROA) of this firm?

  • What is the market-to-book ratio of this firm?

  • What is the price-to-earnings (P/E) ratio of this firm?

  • I will be attaching the handout by email so you can access the financial statements and the information you will need in order to find the above calculations. Please show all your work as I have to show my professor in class.

Answered Same DayApr 25, 2021

Answer To: OBJECTIVES Calculate the current ratio and quick ratio Calculate asset utilization ratios, including...

Ashish answered on Apr 26 2021
157 Votes
Sheet1
    
        Step-1
        Handout for Assignment 4.2: Calculating Ratios
        INCOME STATEMENT – Fiction, INC.
        Sal
es    $2,000,000
        Cost of goods sold    $1,400,000
        Gross profit    $600,000
        Operating expenses
        Selling & marketing    $100,000
        Administrative    $80,000
        Depreciation exp.    $50,000
        Total operating expenses    $230,000
        Operating income (operating profits)    $370,000
        Interest expense    $50,000
        Earnings before tax    $320,000
        Income taxes    $80,000
        Net income    $240,000
        Total number of shares outstanding = 100,000
        Current market price = $41.40
        Earnings per share (EPS) = $2.40
        Dividends per share = $1.10
        BALANCE SHEET – Fiction, INC.
        Assets
        Cash    $150,000
        Accounts receivables    $250,000
        Inventory    $500,000
        Total Current assets    $900,000
        Gross plant & equip.    $2,200,000
        Less accumulated depreciation    $650,000
        Net property, Plant, & equip.    $1,550,000
        Total assets    $2,450,000
        Debt & Equity
        Accounts Payable    $145,000
        Accruals    $90,000
        S.T. Notes    $310,000
        Total current liabilities    $545,000
        Long-term debt    $625,000
        Total debt    $1,170,000
        Common...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here