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

Potential investors - measuring business performance, Potential Investors -...

Potential Investors - Measuring Business Performance Potential investors These parties are interested in a company in total both on long and short term basis in particula

Oogenesis - gametogenesis, Oogenesis - Gametogenesis The maturing proc...

Oogenesis - Gametogenesis The maturing procedure in oogenesis leading to the formation of ovum begins before birth but is not completed until after puberty. The primary oocyte

Evaluate the riskiness of an investment , Compare the three investments bel...

Compare the three investments below in terms of their riskiness. What is the best way to evaluate the riskiness of an investment given the information you have on them?

Calculate the nominal, calc the nimonal(annual percentagerete)interest rate...

calc the nimonal(annual percentagerete)interest rate if the iffective interest rate earned on an investment is 16.08%/Unum but interest is calculated at the end of each month

What are the methods of underwriting, What are the Methods of Underwriting ...

What are the Methods of Underwriting An underwriting agreement may take any of the below three forms: (i) Standing behind the issue: Under this method, underwriter guarant

Gordeon''s Model, what is the price of the share net sales Rs.120lakhs ne...

what is the price of the share net sales Rs.120lakhs net profit margin 12.5% no. of equity shares 25,000 cost of equity shares 12% retention ratio 40% rate of interest(ROI) 16%

IS-LM, After read all the available information carefully, prepare a two pa...

After read all the available information carefully, prepare a two page (double-spaced) essay and answer the following questions: Assume that we have the following data: C=100+0.50Y

FASB, FASB Assignment

FASB Assignment

Head office and branch or subsidiary, Head Office and Branch or Subsidiary ...

Head Office and Branch or Subsidiary MNC has diverse operations set up in dissimilar geographical locations. The HQ acts like the principal and the subsidiary like an agent he

Bonferronis approach, We have 10.000 genes and 4.000 of them are annotated ...

We have 10.000 genes and 4.000 of them are annotated for a certain attribute of interest. a. If we have a single set of 10 genes, how many of them should be annotated to be cons

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