Example of sales method, Finance Basics

Assignment Help:

Example of Sales Method

The balance sheet of XYZ Ltd as on date 31st December 2002 is as following:       

 

Net fixed asset

Current assets

 

Financed by:

Ordinary share capital

Retained earnings

10% debentures

Trade creditors

Accrued expenses

Sh.'000'

300

100

400

 

100

70

150

50

  30

400

Additional Information

1. The sales for year 2002 amounted to Sh.500,000. The sales will increase with 15% in year 2003 and 10% in year 2004.

2. The after tax return on sales is 12% that shall be maintained in future.

3. The company's dividend payout ratio is 80%. This will be sustained in forecasting period.

4. Any additional financing from external sources such will be affected with the issue of commercial paper via company.

Required

a) Determine the amount of external finance for 2 years upto 31st December 2004.

b) Prepare a performa balance as on date 31 December 2004

Solution

Identify various items in balance sheet directly along with sales as:

  1. Accrued expenses
  2. Trade creditors
  3. Current Asset
  4. Fixed Asset

Net fixed assets   =     (300M/500M) x 100   =  60%

Current Assets     =     (100M/500M )x 100   =  20%    

Trade creditors      =    (50/50) x 100             = 10%

Accrued expenses =    ( 30/500) x 100          =   6%

a) Compute the increase in sales over the 2 years.

Year 2002 sales           =500 * (115/100) =575M       

Year 2003 sales           = 575* (115/100) = 632M      

Increase in sales in 2003-03-26=        632.5 - 500     =          132.5M

b) Compute the amount of external requirement of the firm over the 2 years of forecasting period.

i) Increase in F. Assets                    =          % of sales x increase in sales

                                                        =          60% x 132.5  =  79.5M

ii) Increase in C. Assets = % of sales x increase in sales

                                                       =          20% of 132.5  =  26.5M

  Total additional investment/asset required                          106M

Interpretation

For the company to earn increase in sales of 132.5M it will have to acquire additional assets costing 106M.

                                                                                                                                    Sh.'000'

Additional investment/asset required                                                                        106,000

Less: Spontaneous source of finance

Increase in creditors   = % of sales x increase in sales

                                    = 132,500 x 10%                                                                     (13,250)

Increase in accrued expenses = % of sales x increase in sales         

                                                            = 132,500 x 6%                                               (7,950)

Less: Retained earnings during 2 years of operation (initial sources)

            Net profit for 2003      = Net profit margin x sales of 2003

                                                = 12% of 575,000                    =          69,000

            Less: Dividend payable 80% of 69,000                                   =55,200           (13,800)

            Net profit for 2004      = Net profit margin x sales of 2004

                                                = 12% of 632,500                    =          75,900

            Less: dividend payable 80% of 75,900                                    =60,720          (15,180)

External financial needs (commercial paper)                                                               55,820


Related Discussions:- Example of sales method

Analysis, Inventories turnover 8 times 4 times Re...

Inventories turnover 8 times 4 times Receivable days 63 days 40 days

Explain the term - giving margin money to broker, Explain the Giving Margi...

Explain the Giving Margin Money to Broker Marin  is  the  amount  of  money  which is provided  by customer to the brokers who have agreed to trade their securities. It may

Required Return.., Valuing Preferred Stock Gest, Inc has an issue of prefer...

Valuing Preferred Stock Gest, Inc has an issue of preferred stock outstanding that pays a $4.50 dividend every year in perpetuity. If this issue currently sells for for $79.85 per

Prepare journal and adjusting entries, Prepare Journal and Adjusting Entrie...

Prepare Journal and Adjusting Entries I need assignment help on topic Prepare Journal and Adjusting Entries. Can you please suggest me the answer. The following two events o

Types of stock markets, Types of Stock Markets 1. Over the Counter or...

Types of Stock Markets 1. Over the Counter or OTC and Organised Exchange market This is whereas the selling and buying of securities is done through sellers and buyers ar

Work, A bond that has $1000 face value and a contract interest rate of 11.4...

A bond that has $1000 face value and a contract interest rate of 11.4%. The bonds have a current value of $1124 and will mature in 10 years. The firms marginal tax rate is 34%. The

Solution to the agency conflict, Solution to the Agency Conflict The g...

Solution to the Agency Conflict The government can acquire the following actions to protect itself and its interests. 1. Acquire monitoring costs E.g. the gover

What is a treasury bill, What is a Treasury bill? How risky is it? Trea...

What is a Treasury bill? How risky is it? Treasury bills are short-term debt instruments granted by the U.S. Treasury which are sold at a discount and pay face value at maturit

Advantages of central depository system or cds, Advantages of Central Depos...

Advantages of Central Depository System or CDS 1. It shortens the registration procedure in the stock exchange that is high speed of registering shareholders. 2. It improve

Calculate the current stock price, The Bim-Bom Company is expected to pay a...

The Bim-Bom Company is expected to pay a dividend of $3.10 per share at the end of the year, and that dividend is expected to grow at a constant rate of 4.00% per annum.  The compa

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd