Friday 9 November 2012

The following table contains financial information from 5 different companies:


The following table contains financial information from 5 different companies:



Company
A
Company
B
Company
C
Company
D
Company
E

  December 31, 2010
















      Assets
$
37,000  

$
28,860  

$
23,680  

$
65,860

$
101,010


      Liabilities

30,340  


20,202  


12,787  


45,443


?      


  December 31, 2011
















      Assets

40,000  


28,800  


?      


72,800


110,400


      Liabilities

?      


19,584  


13,132  


34,944


87,216


  During year 2011
















      Stock issuances

6,000  


1,400  


9,750  


?    


6,500


      Net income (loss)

8,840  


?      


1,100  


10,439


7,482


      Cash dividends

3,500  


2,000  


5,875  


0


11,000


Required:
Answer the following questions about Company A (Omit the "$" sign in your response):

1a.
What is the amount of equity on December 31, 2010?

  Amount of equity
$ 6,660 correct  

1b.
What is the amount of equity on December 31, 2011?

  Amount of equity
$ 18,000 correct  

1c.
What is the amount of liabilities on December 31, 2011?

  Amount of liabilities 
$ 22,000 correct  

 
Explanation:
Company A: 
  





a.
  Equity on December 31, 2010:





  Assets
$
37,000



  Liabilities

(30,340
)

  






 Equity
$
6,660


   









b.
 Equity on December 31, 2011:





 Equity, December 31, 2010
$
6,660



 Plus stock issuances

6,000



 Plus net income

8,840



 Less cash dividends

(3,500
)

  






 Equity, December 31, 2011
$
18,000


  









c.
 Amount of liabilities on December 31, 2011:





 Assets
$
40,000



 Equity

(18,000
)

  






 Liabilities
$
22,000


  









Answer the following questions about Company B (Omit the "$" sign in your response):

2a.
What is the amount of equity on December 31, 2010?

  Amount of equity
$ 8,658 correct  

2b.
What is the amount of equity on December 31, 2011?

  Amount of equity
$ 9,216 correct  

2c.
What is net income for year 2011?

  Net income
$ 1,158 correct  

 
Explanation
Explanation:
Company B:

a. and b.

12/31/2010

12/31/2011

  Equity:




    Assets
$
28,860


$
28,800


    Liabilities

(20,202
)


(19,584
)

  








    Equity
$
8,658



9,216


  
















c.
  




  Net income for 2011:




    Equity, December 31, 2010
$
8,658


    Plus stock issuances

1,400


    Plus net income

   ?


    Less cash dividends

(2,000
)

  




    Equity, December 31, 2011
$
9,216


  









  
Therefore, net income must have been   $ 1,158.

3.
Calculate the amount of assets for Company C on December 31, 2011. (Omit the "$" sign in your response)

  Amount of Assets
$ 29,000 correct  

Explanation:
Company C:
First, calculate the beginning balance of equity:


Dec. 31, 2010
  Assets

$
23,680


  Liabilities


(12,787
)

  





  Equity

$
10,893


  










Next, find the ending balance of equity as follows:

  




  Equity, December 31, 2010
$
10,893


  Plus stock issuances

9,750


  Plus net income

1,100


  Less cash dividends

(5,875
)

  




  Equity, December 31, 2011
$
15,868


  









Finally, find the ending amount of assets by adding the ending balance of equity to the ending balance of liabilities:


Dec. 31, 2011

  Liabilities

$
13,132



  Equity


15,868



  






  Assets

$
29,000



  









4.
Calculate the amount of stock issuances for Company D during year 2011. (Omit the "$" sign in your response):









 Amount of stock issuances
$  


Explanation:
Company D:
First, calculate the beginning and ending owner’s equity balances:


12/31/2010

12/31/2011

  Assets
$
65,860


$
72,800


  Liabilities

(45,443
)


(34,944
)

  








  Equity
$
20,417



37,856


  
















Then, find the amount of stock issuances during 2011:

  



  Equity, December 31, 2010
$
20,417

  Plus stock issuances

?

  Plus net income

10,439

  Less cash dividends

0

  



  Equity, December 31, 2011
$
37,856

  







Thus, stock issuances must have been: $ 7,000

5.
Calculate the amount of liabilities for Company E on December 31, 2010. (Omit the "$" sign in your response):

  Amount of Liabilities
$  


Explanation:
Company E:
First, compute the balance of equity as of December 31, 2011:
 
  

  Assets

$
110,400


  Liabilities


(87,216
)

  





  Equity

$
23,184


  









 
Next, find the beginning balance of equity as follows:

  




  Equity, December 31, 2010
$
?


  Plus stock issuances

6,500


  Plus net income

7,482


  Less cash dividends

(11,000
)

  




  Equity, December 31, 2011
$
23,184


  









Thus, the beginning balance of equity was $20,202.

Finally, find the beginning amount of liabilities by subtracting the beginning balance of equity from the beginning balance of assets:


Dec. 31, 2010
  Assets

$
101,010


  Equity


(20,202
)

  





  Liabilities

$
80,808


  










3 comments:

  1. Last month when Harrison Creations, Inc., sold 40,000 units, total sales were $300,000, total variable expenses were $240,000, and fixed expenses were $45,000.

    Required:
    1. What is the company’s contribution margin (CM) ratio? (Omit the "%" sign in your response.)

    Contribution margin ratio %

    2. Estimate the change in the company’s net operating income if it were to increase its total sales by $1,500. (Omit the "$" sign in your response.)

    Estimated change in net operating income $

    ReplyDelete
  2. Shirts Unlimited operates a chain of shirt stores that carry many styles of shirts that are all sold at the same price. To encourage sales personnel to be aggressive in their sales efforts, the company pays a substantial sales commission on each shirt sold. Sales personnel also receive a small basic salary.

    The following worksheet contains cost and revenue data for Store 36. These data are typical of the company's many outlets:

    Per Shirt
    Selling price $ 40.00

    Variable expenses:
    Invoice cost $ 18.00
    Sales commission 7.00

    Total variable expenses $ 25.00

    Annual
    Fixed expenses:
    Rent $ 80,000
    Advertising 150,000
    Salaries 70,000

    Total fixed expenses $ 300,000


    The company has asked you, as a member of its planning group, to assist in some basic analysis of
    its stores and company policies.

    Required:
    1.
    Calculate the annual break-even point in dollar sales and in unit sales for Store 36. (Omit the "$" sign in your response.)


    Break-even point in unit sales shirts
    Break-even point in dollar sales $

    3.
    If 19,000 shirts are sold in a year, what would be Store 36's net operating income or loss? (Input the amount as a positive value. Omit the "$" sign in your response.)

    $

    4.
    The company is considering paying the store manager of Store 36 an incentive commission of $3 per shirt (in addition to the salespersons' commissions). If this change is made, what will be the new break-even point in dollar sales and in unit sales? (Omit the "$" sign in your response.)


    New break-even point in unit sales shirts
    New break-even point in dollar sales $

    5.
    Refer to the original data. As an alternative to (4) above, the company is considering paying the store manager a $3 commission on each shirt sold in excess of the break-even point. If this change is made, what will be the store’s net operating income or loss if 23,500 shirts are sold in a year? (Input the amount as a positive value. Omit the "$" sign in your response.)

    $

    6.
    Refer to the original data. The company is considering eliminating sales commissions entirely in its stores and increasing fixed salaries by $107,000 annually. If this change is made, what will be the new break-even point in dollar sales and in unit sales in Store 36? (Omit the "$" sign in your response.)


    New break-even point in unit sales shirts
    New break-even point in dollar sales $

    ReplyDelete
  3. Memofax, Inc., produces memory enhancement kits for fax machines. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below:



    Sales (13,500 units at $20 per unit) $ 270,000
    Variable expenses 189,000

    Contribution margin 81,000
    Fixed expenses 90,000

    Net operating loss $ (9,000)


    Required:
    1.
    Compute the company's CM ratio and its break-even point in both units and dollars. (Omit the "%" and "$" signs in your response.)


    CM ratio %
    Break-even point in units
    Break-even point in dollars $

    2.
    The sales manager feels that an $8,000 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in a $70,000 increase in monthly sales. If the sales manager is right, what will the revised net operating income or loss? (Use the incremental approach in preparing your answer.) (Omit the "$" sign in your response.)

    is $

    3.
    Refer to the original data. The president is convinced that a 10% reduction in the selling price, combined with an increase of $35,000 in the monthly advertising budget, will double unit sales. What will the new contribution format income statement look like if these changes are adopted? (Input all amounts as positive values. Omit the "$" sign in your response.)

    Contribution Income Statement
    $





    $


    4.
    Refer to the original data. The company’s advertising agency thinks that a new package would help sales. The new package being proposed would increase packaging costs by $0.60 per unit. Assuming no other changes, how many units would have to be sold each month to earn a profit of $4,500? (Do not round intermediate calculations.)

    Sales units

    5.
    Refer to the original data. By automating, the company could slash its variable expenses in half. However, fixed costs would increase by $118,000 per month.

    a.
    Compute the new CM ratio and the new break-even point in both units and dollars. (Do not round intermediate calculations. Omit the "%" and "$" signs in your response.)


    CM ratio %
    Break-even point in units
    Break-even point in dollars $

    b.
    Assume that the company expects to sell 20,000 units next month. Prepare two contribution format income statements, one assuming that operations are not automated and one assuming that they are. (Omit the "$" and "%" signs in your response.)


    Not Automated
    Automated

    Total Per Unit % Total Per Unit %
    $ $ $ $


    $ $





    $ $



    ReplyDelete