Google Answers Logo
View Question
 
Q: jd2005 ( Answered,   0 Comments )
Question  
Subject: jd2005
Category: Business and Money > Finance
Asked by: jd2005-ga
List Price: $150.00
Posted: 25 Feb 2005 08:39 PST
Expires: 27 Mar 2005 08:39 PST
Question ID: 480747
Dear 
I have an exam and found some problems in solving extra exercises such
as following pls. help before March 5nd 2005

Ex. 1:
A company has an annual turnover of $50 million before taking into
account bad debts of $500.000. All sales made by the company are on
credit and at present, credit terms are negotiable by the customer. On
average, the settlement period for trade debtors is 60 days. The
company is currently reviewing its credit policies to see whether more
efficient and profitable methods could be employed. Two major schemes
have so far been put forward concerning the management of trade
credit. These are as follows:
Scheme A 
The credit control department has proposed that customers should be
given a 2.5% discount if they pay within 30 days. For those who do not
pay within this period, a maximum of 50 days credit should be given.
The credit department believes that 60% of customers will take
advantage of the discount by paying at the end of the discount period
and the remainder will pay at the end of 50 days. The credit
department believes that all bad debts can be effectively eliminated
by adopting the above policies and by employing stricter credit
investigation procedures costing an additional $100,000 per annum. As
less time will be spent chasing debtors, savings of $120,000 in the
credit control administration can be made if the new policies are
adopted. The credit department is confident that these new policies
will not result in any reduction in sales.

Scheme B  
The company is also considering whether it should factor its trade
debts. The accounts department has recently approached a factoring
company which has agreed to provide an advance equivalent to 80% of
trade debtors (based on an average settlement period of 40 days) at an
interest rate of 12%. The factoring company will undertake collection
of the trade debts and will charge a fee of 2% of sales turnover for
this service. The factoring service is also expected to eliminate bad
debts and will lead to credit administration savings of $260,000. The
settlement period for trade debtors will be reduced to an average of
40 days, which is equivalent to that of its major competitors.

The company currently has an overdraft of $10.4 million at an interest
rate of 14% per annum. The bank has written recently to the company
stating that it would like to see a reduction in the overdraft of the
company.
(a) Calculate for each proposal the net annual cost (savings) to the
company of changing its existing credit policies and either (i)
adopting the proposals of the credit control department or     (ii)
factoring the debts of the company (b) Explain which of the two
proposals (if either) you would support and why?






Ex. 2:

Accounts of the company appear as: 

Profit and loss Data		
	                            31.12.2003	        31.12.2002
	                              Millions $	Millions $
Sales	                                 73.6	         66.2
Profit before interest and tax	         17.2	          14.2
interest	                         7.8	           7.8
Profit before tax	                 9.4	          6.4
Taxation	                         3.6	          2.8
Profit After taxation	                  5.8	           3.6
Dividend	                          0.6	           0.6
Retained	                          5.2	            3
           Balance sheet data		
Fixed assets	                          108	            87
Less: Depreciation	                   21	            18
	                                   87	            69
		
Current assets		
Stock	                                    4	             3
Debtors	                                    12.2	   7.8
Cash		                             0               0
	                                    16.2	   10.8
		
Less Creditors		
(Amount due in under 1 year):		
Trade creditors                            3.6	      3.6
taxation	                           3.6	            2.8
Dividents	                           0.6	            0.6
	                                   7.8	              7
		
Net current assets	                   8.4	            3.8
Total assets less current liabilities	   95.4	            72.8
Less: Loans (Due in over 1 year)	   62.4	            44.8
		
Net assets	                           33	             28
		
Capital and reserves		
Share capital  (Sp shares)	            3	             3
Reserves	                            30	             25
	                                    33	             28

Profit before tax for 2004 is forecast at $12.2 million and after tax
at $6.6 million.
Similar hotel groups have price earnings ratios of approximately 17
times and dividend yields of approximately 4.
If the group went public, it would anticipate paying out 2/3rds its
income as dividends.
An analyst has forecast the cash flows of the company to be:
            2005 2006  2007   2008   2009    2010
$ millions 13.8  14.8 15.6    16.8   17.4    18.6
The company's cost of capital is 12 net of tax.
A surveyor has recently valued the fixed assets of the group at $186 million.
Questions 
(a) Calculate the value of one Sp share in the company on each of the
following bases, commenting on the practical and theoretical merit of
each basis used.
1)Net assets  2)Prospective price earnings ratio  3) Dividend yield
4)Free cash flow
(b) Select the share price from the above calculations at which the
company  shares should be issued, with your reasons for selection,
(c) Calculate how many shares need to be issued to reduce the
company's gearings so that it has the same amount of long-term debt as
equity.


Ex 3:
In January 2000 a comapny plan to invest $200,000 cash to purchase
100,000  1$ shares each in the company. Of this $120,000 is to be
invested in new goods in January. These goods are to be depreciated
over 3 years on the straight-line basis ? salvage value is zer. A
half-year's depreciation is to be charged in the first six months. The
sales and purchases forecast for the company are as follows:
 USD	Jan	Feb	Mar	Apr	May	Jun	Total
thousands	 	 	 	 	 	 	 
Sales	40.8	122.4	122.4	163.2	163.2	204	816
Purchases	80	120	100	100	120	120	640
Others	36	36	36	36	36	36	216

These include wages but exclude depreciation. 
The sales will all be made by credit card. The credit card company
will take one month to pay and will deduct its fee of 2% of gross
sales before paying amounts due to Osmond Limited. One month's credit
is allowed by suppliers. Other costs shown above do not include rent
and rates of $40,000 per quarter, payable on 1 January and 1 April.
All other costs will be paid in cash. Closing stock at the end of June
is expected to be $232,000.
You should ignore taxation. For your convenience you are advised to
work to the nearest $'000.
Required:
(a) Prepare a cash forecast for each of the six months to 30 June 200
(b) Prepare a forecast profit and loss account for the same period.
(c) Prepare a forecast balance sheet at 30 June 2000.
(d) Comment briefly on the financial prospects of this company (refer
both to its    profitability and liquidity.)

Thank you in advance

Clarification of Question by jd2005-ga on 03 Mar 2005 01:52 PST
Question ID: 480747 
Dear all
Kindly tell me can I have help or not?

Clarification of Question by jd2005-ga on 21 Mar 2005 05:01 PST
answer pls till 5th april
Answer  
Subject: Re: jd2005
Answered By: leapinglizard-ga on 26 Mar 2005 18:24 PST
 
Dear jd2005,

I have worked out the exercises below. If you feel that any part of my
answer requires correction or elaboration, please let me know through
a Clarification Request so that I may fully meet your needs before you
assign a rating.

Regards,

leapinglizard




Ex. 1



(a)


i.

Based on the credit department's forecast, 60% of the annual accounts
receivable of $50 million will be collected with a 2.5% discount. We
can calculate the annual loss due to the discount as follows.

  .60 * $50 million * 0.025  =  $30 million * 0.025
                             =  $750,000

Credit investigation procedures will cost an additional $100,000 annually,
but there will be savings of $120,000 in administrative costs. We also
project savings of $500,000 in bad debts.

  $750,000 + $100,000 - $120,000 - $500,000  =  $230,000

The new policies would therefore result in a net annual cost of $230,000.


ii.

The factoring company charges as its fee 2% of the accounts receivable.

  .02 * $50 million  =  $1 million

A further cost is the 12% interest on 80% of the debt for an average of
40 days.

  .80 * $50 million * 40/365*0.12  =  $40 million * 0.01315 =  $526,000

Offsetting these costs are administrative savings of $260,000 and
eliminated defaults of $500,000.

  $1 million + $526,000 - $260,000 - $500,000 =  $766,000.

The net annual cost of factoring would therefore be $766,000.



(b)


The net annual cost of factoring is $536,000 greater than that of adopting
the proposals of the credit control department. However, factoring makes
customer payments available sooner.

The average settlement period is currently 60 days, a period that would
drop to 40 days with factoring. Yet the 40-day period would apply to only
20% of customer payments, with the remaining 80% advanced immediately by
the factoring company. Let us suppose that the company takes advantage
of these advances by applying them toward the overdraft for 60 days or
20 days, respectively. Recall that the overdraft interest is 14% annually.

  0.8 * $50 million * 60/365*0.14  =  $40 million * 0.02301
                                   =  $921,000
  0.2 * $50 million * 20/365*0.14  =  $10 million * 0.00767
                                   =  $77,000
  $766,000 - $921,000 - $77,000  =  -$232,000

Taking into account interest savings on the overdraft, the company would
save $232,000 in the first year by factoring its trade debts.

Let us perform a similar calculation for the proposals of the credit
control department, which would result in a 30-day advance in 60% of
cases and 10 days in the remaining 40%.

  0.6 * $50 million * 30/365*0.14  =  $30 million * 0.01151
                                   =  $345,000
  0.4 * $50 million * 10/365*0.14  =  $20 million * 0.00384
                                   =  $77,000
  $230,000 - $345,000 - $77,000  =  -$192,000

By applying the advanced cash toward the overdraft, the company aould
save $192,000 in the first year by factoring its trade debts.

Although factoring results in only $40,000 greater overall savings in
the first year, and smaller savings in subsequent years as the overdraft
diminishes, it is still the better choice. If the overdraft does shrink
dramatically due to other causes, the company can always switch over to
the credit control department's proposals. But for the time being, given
the urgency of reducing the overdraft, factoring is the superior option.




Ex. 3



(a)


1) Net assets

We know that there are 3 million Sp shares outstanding and that the net
assets of the company are stated as $33 million in 2003, the most recent
year for which we have a financial statement.

  $33 million / 3 million  =  $11

On the basis of net assets, the value of one Sp share is $11.

Shares are easily calculated on the basis of net assets because the
requisite figures are made available by the company in its annual
financial statement, which is subject to audit. However, the value
of fixed assets is easily manipulated, and asset valuations can
fluctuate so rapidly that the most recent annual figures are generally
outdated. Company valuations calculated on this basis therefore tend
to be inaccurate, except in cases where asset valuation can be done
rapidly and precisely. This is true if a company's primary holdings
are financial instruments or properties traded on an open market. If
a company's value resides in its personnel or intellectual property,
net assets are not at all a good basis for share valuation.


2) Prospective price earnings ratio

The after-tax net income of the company is $5.8 million. It has 3 million
shares outstanding.

  $5.8 million / 3 million  =  $1.93  

Thus, earnings per share amount to $1.93. Under a prospective price
earnings ratio of 17, we can calculate the share price as follows.
  
  17  =  P / $1.93
  P  =  17 * $1.93
     =  $33

The price earning ratio is a mixed model that reflects figures from
the company's financial statement as well as subjective information
from the market's pricing of the company stock. If the price earnings
ratio of similar firms is used as a basis for valuing a given company,
the resulting estimate may not take into account strengths and weaknesses
that are unique to that company. Even if it is currently viewed as being
comparable to other firms within its sectors, the company may fall out of
favor with analysts in the near future, which would skew its prospective
price earning ratio away from the current value. On this basis, then,
market turbulence can cause the company's estimated value to fluctuate
more rapidly than is warranted by changes in its sales or assets.


3) Dividend yield

The latest annual dividend was $0.6 million, distributed over 3 million
shares.

  $0.6 million / 3 million  =  $0.20

Hence, the dividend per share is $0.20. Let us employ in our share
valuation the dividend yield of similar hotel groups, which is 4%.

  0.04  =  $0.20 / P
  P  =  $0.20 / 0.04
     =  $5

On the basis of dividend yield, each share has a value of $5.

The chief advantage of valuing shares on this basis is that it uses
a readily available figure, namely the company's annual dividend. The
dividend yield, however, is obtained by comparison with other firms, which
has the pitfalls we have noted above. Furthermore, the dividend itself
is generally not a good reflection of the company's value, since it is
highly subject to the whims of management. Often, a firm with a strong
market position and steady cash flow will adopt a policy of paying small
or no dividends for reasons of fiscal policy. This is true, for example,
at Microsoft, which recently made a large one-time dividend payment but
otherwise eschews dividends. Thus, the dividend yield is a good basis
for company valuation only from the perspective of those buyers whose
chief interest in holding a company stock is the prospect of future
dividends. Most investors have other reasons for purchasing shares.


4) Free cash flow

The free cash flow of a company is composed of its earnings before
interest, taxes, depreciation, and amortization. For the most recent
reported year, this amounts to $17.2 million.

  $17.2 million / 3 million  =  $5.73

On this basis, the company is worth $5.73 per share.

Cash flow analysis is a valuation method that overlooks secondary costs
such as taxation and depreciation in favor of the earning power of the
company. It provides a good estimate of a company's ability to produce and
sell its products at a profit, even though taxation and capital costs may
end up taking a large bite out of the earnings pie. Thus, although free
cash flow is not the best indicator of a company's financial prospects, it
offers potential investors a good sense of its core production power. In
the case of a firm whose worth resides mostly in financial instruments
or property holdings rather than the sale of goods or service, it is
not an accurate basis for company valuation.



(b) Select the share price from the above calculations at which the
company shares should be issued, with your reasons for selection.


Net assets are the most accurate basis for calculating the value of
this company's shares. We therefore value its shares at $11 each. This
is because the hotel group's worth is concentrated in its physical
assets, namely the hotels themselves. The location and condition of
these holdings are accurately appraised by the real-estate market,
which is a better source of valuation than any fiscal measure. It is
true that real estate markets are subject to volatility, but this makes
it all the more sensible to base the share value on net assets. This is
because the hotel group's value to a buyer is inextricably linked to
its real-estate valuation. Even though hotel patrons are not directly
affected by this market, the real-estate value of the hotel property
is a reflection of its desirability to guests. Net assets do not take
into account the quality of a hotel's management and service, but these
are difficult to measure and are subject to fluctuations that are not
immediately reflected in market share.



(c) Calculate how many shares need to be issued to reduce the company's
gearings so that it has the same amount of long-term debt as equity.


The hotel group currently owes $62.4 million in long-term loans. Let us
value its equity on the basis of net assets.

  3 million * $11  =  $33 million

Equity is currently worth $33 million.

  $62.4 million - $33 million  =  $29.4 million

In order to equalize long-term debt and equity, we must make up a
shortfall of $29.4 million.

  $29.4 million / $11  =  2.67 million

This will entail issuing 2.67 million Sp shares at $11 each.




Ex. 3



(a)


Because collections are delayed by one month but payments to suppliers
may also be delayed by one month without penalty, we shall assume that
all monthly transactions are performed at the end of each month.

All figures below are in thousands.


                        Jan     Feb     Mar     Apr     May     Jun     
Revenue                 $41     $122    $122    $163    $163    $204

Costs
    collection fees      1       2       2       3       3       4
    rent and rates      40                      40
    others              36      36      36      36      36      36
total                   77      38      38      79      39      40

Cash Flow               -36     78      78      78      118     158



(b)


The profit/loss account is very similar to the cash flow projection,
with the difference that it includes depreciation.

With a salvage value of zero, the full $120,000 in new goods is to be
depreciated over 36 months.

  $120,000 / 36  =  $3333

The goods will therefore depreciate at the rate of $3333 a month. All
figures below are in thousands.


                        Jan     Feb     Mar     Apr     May     Jun
Revenue                 $41     $122    $122    $163    $163    $204

Costs
    collection fees      1       2       2       3       3       4
    rent and rates      40                      40
    others              36      36      36      36      36      36
    depreciation         3       3       3       3       3       3
total                   80      41      41      82      42      43
  
Profit (Loss)           (39)        81      81      81      121     161


  
(c)


All we know is that the company has $100,000 in equity and $232,000
in assets.

                30 June 2000
Assets          $232,000
Equity          $100,000



(d)


This company has favorable financial prospects. Its sales are forecast
to reach a level comparable with its assets, which means it will
have high liquidity. The steadily increasing sales also indicate high
profitability. We therefore conclude that the company's finances are in
good order.
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy