Question

In: Finance

The Income Statement of XYZ Company for the most recent fiscal year is given below. Its...

The Income Statement of XYZ Company for the most recent fiscal year is given below. Its sales are projected to increase by 20% in the coming year and it always retains 60% of its net income. Use the percentage of sales method to find out the addition to retained earnings amount.  

Sales                                                              $40,000

Operating costs                                                   30,000       

   Earnings before interests and taxes $10,000

Interest expenses                                               1,000   

Earnings before taxes                                         $ 9,000  

Taxes (40%)                                                      3,600   

Net income       $   5,400

Solutions

Expert Solution

Growth rate = 20%
Retention ratio = 60%

Payout ratio = 1 - Retention ratio
Payout ratio = 1 - 0.60
Payout ratio = 0.40

Coming Year:

Sales = $40,000 + 20% * $40,000
Sales = $48,000

Operating costs = $30,000 + 20% * $30,000
Operating costs = $36,000

Earnings before interest and taxes = Sales - Operating costs
Earnings before interest and taxes = $48,000 - $36,000
Earnings before interest and taxes = $12,000

Interest expenses = $1,000

Earnings before taxes = Earnings before interest and taxes - Interest expenses
Earnings before taxes = $12,000 - $1,000
Earnings before taxes = $11,000

Taxes = 40% * Earnings before taxes
Taxes = 40% * $11,000
Taxes = $4,400

Net income = Earnings before taxes - Taxes
Net income = $11,000 - $4,400
Net income = $6,600

Dividends = 40% * Net income
Dividends = 40% * $6,600
Dividends = $2,640

Addition to retained earnings = Net income - Dividends
Addition to retained earnings = $6,600 - $2,640
Addition to retained earnings = $3,960


Related Solutions

O'Neill, Incorporated's segmented income statement for the most recent month is given below. Total Company Store...
O'Neill, Incorporated's segmented income statement for the most recent month is given below. Total Company Store A Store B Sales $407,000 $133,000 $274,000 Variable expenses 264,230 97,090 167,140 Contribution margin 142,770 35,910 106,860 Traceable fixed expenses 89,800 31,600 58,200 Segment margin 52,970 $4,310 $48,660 Common fixed expenses 28,350 Net operating income $24,620 For each of the following questions, refer back to the above original data. A proposal has been made that will lower variable expenses in Store A to 62%...
A company’s contribution format income statement for the most recent month is given below:    Sales...
A company’s contribution format income statement for the most recent month is given below:    Sales (13,200 units × $30 per unit) $ 396,000 Variable expenses 198,000 Contribution margin 198,000 Fixed expenses 220,500 Net operating loss $ (22,500 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,200 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result...
You are given data further below for the most recent fiscal year, 2007, for Henley Corporation...
You are given data further below for the most recent fiscal year, 2007, for Henley Corporation and projections for 2008. Using this data, answer the following questions: Using the percent of sales method, forecast the first pass of the pro-forma statements and the firm’s external financing needs for 2008 (ignore, how financing is raised, i.e., focus on the first pass) assuming payout ratio is 50%. A firm's additional funds needed (AFN) must come from external sources. What are the typical...
A partial income statement for a company's most recent fiscal year follows: Sales $800,000 Inventory, January...
A partial income statement for a company's most recent fiscal year follows: Sales $800,000 Inventory, January 1 $420,000 Add purchases (a) ___ Goods available for sale (b) Inventory, December 31 470,000 Cost of goods sold (c) Gross margin 250,000 Deduct expenses: Selling (d) Administrative (e) Income before taxes (f) Income taxes (g) Net income (h) Earnings per share (5,000 shares outstanding) $4.20 Additional data: Selling expenses are 20 percent of sales, administrative expenses are 10 percent of cost of goods...
A partial income statement for a company's most recent fiscal year follows: Sales $400,000 Inventory, January...
A partial income statement for a company's most recent fiscal year follows: Sales $400,000 Inventory, January 1 $210,000 Add purchases (a) ____ Goods available for sale (b) ____ Inventory, December 31 235,000 Cost of goods sold (c) ____ Gross margin 125,000 Deduct expenses: Selling (d) ____ Administrative (e) ____ Income before taxes (f) ____ Income taxes (g) ____ Net income (h) ____ Earnings per share (5,000 shares outstanding) $2.10 Additional data: Selling expenses are 20 percent of sales, administrative expenses...
The income statement of XYZ Company for the 2016 financial year was below expectations be low...
The income statement of XYZ Company for the 2016 financial year was below expectations be low Financia l Item Total in TZS Sales (40,000 units) 400,000,000 Cost of raw materials 80,000,000 Other variable costs 100,000,000 Fixed factory overheads 160,000,000 Fixed administrative overheads 30,000,000 Sales commission (3% sales value) 12,000,000 Variable delivery costs 20,000,000 Other fixed costs 30,000,000 a) What is the break-even point of the company? b) The company proposes to reduce the selling price per unit by 10% and...
Gilley, Inc., sells a single product. The company's most recent income statement is given below.         ...
Gilley, Inc., sells a single product. The company's most recent income statement is given below.          Sales (4,000 units)                                       $120,000          Less variable costs                                         (68,000)          Contribution margin                                        52,000          Less fixed expenses                                        (40,000)          Net income                                                  $ 12,000          Required: Determine the following:          a.      Contribution margin per unit is                        $ _______________ per unit          b.      If sales are doubled to $240,000,                   total variable costs will equal                                         $ _______________          c.      If sales are doubled to $240,000,                  ...
Gilley, Inc. sells a single product. Gilley's most recent income statement is given below:          ...
Gilley, Inc. sells a single product. Gilley's most recent income statement is given below:           Sales (sold 4,000 units)                            $120,000        - Variable costs:                                                 Variable manufacturing costs                  (48,000)              Variable selling and general costs           (20,000)           Contribution margin                                    52,000        - Fixed costs:                                                      Fixed manufacturing costs                       (30,000)              Fixed selling and general costs                (10,000)           Operating income                                    $ 12,000 a. Contribution margin (CM) per unit is:                             $ __________ per...
Model Corp.'s most recent balance sheet and income statement are given below (all numbers in $...
Model Corp.'s most recent balance sheet and income statement are given below (all numbers in $ million): Assets Liabilities and Equity Cash 38 Accounts payable 114 Accounts receivable 76 Current liabilities 114 Inventory 114 Long-term debt 152 Current assets 228 Total liabilities 266 Machinary 152 Equity 114 Total assets 380 Total liab. & equity 380 Income statement Sales 110 Costs 66 Depreciation 22 EBIT 22 Interest 7.6 Taxable income 14.4 Taxes 4.896 Net income 9.5 Sales, assets and costs (including...
Model Corp.'s most recent balance sheet and income statement are given below (all numbers in $...
Model Corp.'s most recent balance sheet and income statement are given below (all numbers in $ million): Assets Liabilities and Equity Cash 41 Accounts payable 123 Accounts receivable 82 Current liabilities 123 Inventory 123 Long-term debt 164 Current assets 246 Total liabilities 287 Machinary 164 Equity 123 Total assets 410 Total liab. & equity 410 Income statement Sales 90 Costs 54 Depreciation 18 EBIT 18 Interest 4.92 Taxable income 13.08 Taxes 4.447 Net income 8.63 Sales, assets and costs (including...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT