EBK FINANCIAL ANALYSIS WITH MICROSOFT E
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
8th Edition
ISBN: 9781337515528
Author: Mayes
Publisher: CENGAGE LEARNING - CONSIGNMENT
Question
Book Icon
Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

    RatioValueFormula
    Current Ratio1.832716Current AssetsCurrent Liabilities
    Inventory Turnover 4.414239Cost of Goods SoldAverage Inventory
    A/R Turnover8.333333Net SalesAverage Accounts Receivable
    Fixed Turnover 1.657982Net SalesAverage Fixed Assets
    LTD To Equity0.843090Long Term DebtEquity
    Times Interest Earned1.833333Earnings Before Interest And TaxInterest
    Net Profit Margin0.016000Net ProfitSales
    Return On Total Assets0.018061Net Income Total Assets
    Return On Equity0.040307Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution
Check Mark

Explanation of Solution

Sequence of figures calculated and basis:

    Figure CalculatedRatio Used for CalculationRemark
    Cost of Goods SoldInventory Turnover RatioInventory value is given
    Net IncomeReturn on Total AssetsValue of total asset is given
    EquityReturn on EquityNet income used to calculate
    Long Term DebtLTD To EquityEquity value used
    SalesNet Profit MarginNet profit used to find sales
    Interest ExpenseTimes Interest EarnedEarnings before interest and tax used to calculate
    Accounts ReceivableA/R TurnoverSales figure already calculated
    Net Plant and EquipmentFixed Turnover Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip  1

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution
Check Mark

Explanation of Solution

Sequence of figures calculated and basis:

    Formula to Be CalculatedRemark
    Gross ProfitSales − Cost Of Goods Sold
    Earnings Before Interest and TaxGross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
    Earnings Before TaxEarnings Before Interest And Tax − Interest
    TaxCharged at 40 % of Earnings Before Tax
    Total Current AssetsCash + Accounts Receivable + Inventory
    Accumulated DepreciationBalancing Figure
    Short Term Notes PayableBalancing Figure
    Total Liabilities and Owner’s EquityTotal Assets

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip  2

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements including components of the return on investment calculations.Required:Help Krall rebuild its information database by completing the following table: (Do not round your intermediate calculations. Round your final answers to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.).)
The new owners of Sheraton Natural Foods Inc. have hired you to help them diagnose and cure problems that the company has had in maintaining adequate liquidity.  As a first step, you perform a liquidity analysis.  You then do an analysis of the company’s short-term activity ratios.  Your calculations and appropriate industry norms are listed.   Ratio                                                                Sheraton          Industry Norm Current ratio                                                     4.5                   4.0 Quick ratio                                                        2.0                   3.1 Inventory turnover                                            6.0                   10.4 Average collection period                                  73 days             52 days Average payment period                                   31 days             40 days   Requirements: What recommendations relative to the amount and the handling of inventory could you make…
As an analyst with a local investment firm, After reading through a recent report it is noticed a drop in the company's bad debt expense estimate. It could indicate an improvement in collectability from customers, but it is also known the expense was subject to estimates from management. There is needed to know whether to interpret the decline as a good sign or not.

Chapter 3 Solutions

EBK FINANCIAL ANALYSIS WITH MICROSOFT E

Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Text book image
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Text book image
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,