+1-415-670-9189
info@expertsmind.com
Integrating case 5-23 balance sheet
Course:- Accounting Basics
Reference No.:- EM13149095




Assignment Help
Assignment Help >> Accounting Basics

integrating Case 5-23
Balance Sheet

Assets
Cash $ 15,000
Accounts receivable (net) (e)
Inventory (d)
Prepaid expenses and other current assets (i)
Current assets (h)
Property, plant, and equipment (net) (j)
$ (b)
Liabilities and Shareholders' Equity
Accounts payable $ (g)
Short-term notes 5,000
Current liabilities (f)
Bonds payable (l)
Shareholders' equity (k)
$ (b)
Income Statement
Sales (a)
Cost of goods sold (c)
Gross profit (c)
Operating expenses (o)
Interest expense (m)
Tax expense (n)
Net income mce_markernbsp;
Case 5-23 (concluded)

Calculations ($ in 000s):
a. Profit margin on sales = Net income ÷ Sales = 5% 
For example:
Net income = 17000
17000/X = .05
Cross multiply
17000
_____ =.05
X
17000 = .05X
Divide both sides by .05
X = 17000/.05
X = 340,000

b. Return on assets = Net income ÷ Total assets = 7.5%
For example:
Net income = 17000
17000/X = .075
Cross multiply
17000 = .075X
Divide both sides by .075
X = 17000/.075
X = 226,666




c. Gross profit margin = Gross profit ÷ Sales = 40%
Cost of goods sold = Sales - Gross profit =
d. Inventory turnover ratio = Cost of goods sold ÷ Inventory = 6

e. Receivables turnover ratio = Sales ÷ Accounts receivable = 25
f. Acid-test ratio = Cash + AR + ST Investments ÷ Current liabilities = .9
g. Accounts payable = Current liabilities - Short-term notes = $
h. Current ratio = Current assets ÷ Current liabilities = 2

i. Prepaid expenses and other current assets = 
Current assets - (Cash + AR + Inventory) = $
j. Property, plant, and equipment = Total assets - Current assets = 
k. Return on shareholders' equity = Net income ÷ Shareholders' equity =10%

l. Debt to equity ratio = Total liabilities ÷ Shareholders' equity = 
Bonds payable = Total liabilities - Current liabilities = 
m. Interest expense = 8% x (Short-term notes + Bonds )
Interest expense = 
n Times interest earned ratio = (Net income + Interest +Taxes) ÷ Interest = 12
Times interest earned ratio = 
Times interest earned ratio = 
Tax expense = mce_markernbsp;
o. Operating expenses = (Sales - Cost of goods sold - Interest expense - Tax expense) - Net income = 

Case 5-23                        

               Net income     16000

               Short term note           5000

               Bonds interest rate    0.08

               Cash balance  15000

               Profit margin on sales             0.05

               Return on assets         0.075

               Gross profit margin   0.4

               Inventory turnover ratio       6

               Receivables turnover ratio   25

               Acid test ratio               0.9

               Current ratio  2

               Return on shareholders equity          0.1

               Debt to equity ratio   0.33

               Times interest earned             12

 

Integrating Case 5-23

   Balance Sheet

        

    Assets        

    Cash        $  15,000
       Accounts receivable (net)                   (e)
       Inventory              (d)
       Prepaid expenses and other current assets               (i)
         
Current assets              (h)
       Property, plant, and equipment (net)             (j)
                $        (b)
          Liabilities and Shareholders’ Equity
       Accounts payable $        (g)
       Short-term notes        5,000     
         
Current liabilities                  (f)
       Bonds payable                (l)
       Shareholders’ equity                 (k)
                $        (b)

   Income Statement

   Sales                  (a)
      Cost of goods sold           (c)
         Gross profit                  (c)
      Operating expenses                    (o)
      Interest expense               (m)
      Tax expense           (n)
            Net income $       

Case 5-23 (concluded)

 

Calculations ($ in 000s):

a.  Profit margin on sales = Net income ÷ Sales = 5%     

     For example:

     Net income = 17000

     17000/X = .05

     Cross multiply

17000

_____    =.05

X

17000 = .05X

Divide both sides by .05

X = 17000/.05

X = 340,000

                                                                                       

b.  Return on assets = Net income ÷ Total assets = 7.5%

     For example:

     Net income = 17000

     17000/X = .075

     Cross multiply

     17000 = .075X

     Divide both sides by .075

     X = 17000/.075

     X = 226,666

 

 

    

c.  Gross profit margin = Gross profit ÷ Sales = 40%         
Cost of goods sold = Sales – Gross profit =              

d.  Inventory turnover ratio = Cost of goods sold ÷ Inventory = 6

e.  Receivables turnover ratio = Sales ÷ Accounts receivable = 25                    

f.   Acid-test ratio = Cash + AR + ST Investments ÷ Current liabilities = .9                                                                           

g.  Accounts payable = Current liabilities – Short-term notes = $

h.  Current ratio = Current assets ÷ Current liabilities = 2    

i.   Prepaid expenses and other current assets =              
Current assets – (Cash + AR + Inventory) = $

j.   Property, plant, and equipment = Total assets – Current assets =

k.  Return on shareholders’ equity = Net income ÷ Shareholders’ equity =10%

l.   Debt to equity ratio = Total liabilities ÷ Shareholders’ equity =                    
Bonds payable = Total liabilities – Current liabilities =

m. Interest expense = 8% x (Short-term notes + Bonds )
Interest expense =

n   Times interest earned ratio = (Net income + Interest +Taxes) ÷ Interest = 12
Times interest earned ratio =                                     
Times interest earned ratio =                                     
Tax expense = $

o.           Operating expenses = (Sales – Cost of goods sold – Interest expense – Tax expense) – Net income =

 

 

 




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Accounting Basics) Materials
Prepare a schedule showing the employer's total cost of wages for November by function. Prepare the journal entries to record the factory, sales, and administrative payrolls
Perform a financial analysis of the city of Milwaukee, WI, for the fiscal year 2012 based on the CAFR applying - Your report should include a profile of the entity, copy of fi
Classify each of the following as elements of the accounting equation using the following abbreviations: A = Assets; L = Liabilities; C = Capital. Cash, Accounts P
Parvati Fluid Controls, Inc., (PFC) is a major supplier of reverse osmosis and ultrafiltration equipment, which helps industrial and commercial customers achieve improved pr
How do unrealized intercompany inventory profits from a prior period affect the computation of consolidated net income when the inventory is resold in the current period?
If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, what amount would be shown as ending inventory in 1, 2, and 3 abov
The net present value and the internal rate of return are similar metrics to present the return of a project. What are the differences? What is an advantage of each metric com
The following situation involves a possible violation of the AICPA's code of professional conduct. For this situation, determine the applicable rule number from the code, an