+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
Analyze inventory valuation methods discussed in the textbook. Based on your analysis, recommend the most accurate valuation method that reflects current economic conditions
Compute the NAL for this transaction. Should Alamo lease or borrow and buy? Comment on the effects that a different loan rate and residual value would have on your answer abov
2. The Bernard Company issues 8%, 10-year bonds with a par value of $250,000 and semiannual interest payments. On the date of issue, the annual market rate for these bonds is
Search the Internet, and find definitions of the thinking process and the indicated thinking process tools. List some of the benefits achieved by these companies. Is TOC more
What kind of measures might Sam's Pita Pit and the Classic Steakhouse include in the customer category of their new balanced scorecards? Create a table with one column for e
OUV has spent $2,000,000 in R&D to develop a new product.  The company plans to sell the product for $10 per unit.  It will cost $2 in materials and $1 in labor to produce e
D.L. Manufacturing Inc.'s joint cost of producing 1,000 units of Product A, 500 units of Product B, and 500 units of Product C is $20,000. The unit sales values of the three
Name is a student currently studying to obtain her degree in Human Services Management. It is name's goal to graduate with her associate's degree then continue on with her e