Monday, 29 March 2010

DCF analysis Problem and solution 2

Question

A company has decided that one of its production facilities has reached the end
of its economically productive life, and it must therefore be upgraded or replaced.
Plan A, re-fitting and upgrading the existing facilities has been evaluated and the
results are:
NPV: € 1.2m
Payback: 1.8 years
Plan B, replacement of the production facilities has been estimated over the next
five years as follows:

Cost of dismantling/removal of existing plant 800,000
Scrap value of machinery (once out of the plant) 150,000
Cost of new plant 2,500,000
Installation time for new plant (i.e before production
can recommence) 1 year
Revenue per annum after restart 2,000,000
The new process will save on labour costs. It will, however, incur some
redundancy costs for those agreeing to leave when the refit begins.

Redundancy costs 300,000
Annual labour savings (from when the plant re-starts) 100,000
The allocated overhead charge for the facility under ‘Plan B’ would be € 150,000
a year or € 100,000 under ‘Plan A’. The actual indirect costs incurred by the
company will in fact be the same whichever Plan is chosen.
For ‘Plan B’ the estimated required return on capital is 8%; you may ignore tax
and inflation.

(a) Describe briefly the rules or criteria you would use to decide whether an item
should be included in a discounted cash flow analysis.
(4 marks)
(b) Giving your reasons, state whether the company should undertake Plan A or
Plan B
(12 Marks)
(c) In part (a) you were allowed, as a simplification, to “ignore tax”. Explain
briefly why, if you were to include taxation in your analysis of Plan B, you
would need to know something about the profitability of the whole company
(i.e. as well as of that of the project itself).
(3 Marks)
(d) A senior manager (but not finance expert) comments one day that:
“Discounted cash flow is all very well for assessing individual projects but to
value an entire company you have to use something like Book Value.”
Describe one point that would support the statement and one point that
would argue against the idea. State with one main reason whether you
agree or disagree with the manager’s view. There is not a ‘right’ or ‘wrong’
answer here – it is the link between your choice and your given reason
that is important.
(6 marks)

a)Sunk costs, opportunity costs, cash flows (Inflation and cost of capital), total time value of money(payment now or later? €100 value is only €80 in real terms), Assessment Horizon



Item

Project Plan B costs €000

Removal

-800

New plant

-2500

Scrap value (Assumed after 1 year)

150

Revenue per annum after delay of one year.

2000

Redundancy costs

-300

Annul labour saving after first year.

100

Overhead (Presumed throughout project)

-150


All the above costs are included as part of project B because they are within the time frame of the project and directly effect the cash flows.


b)

Plan A – NPV €1,2 million payback 1,8 years.

Plan B -



000

Year 0

Year 1

Year 2

Year 3

Year 4

Year 5

Fixed Cost

Removal and Resale

-800

150

0

0

0

0

New plant

-2500

0

0

0

0

0

Labour

-300

0

100

100

100

100

Variable cost wrong

0

0

0

0

0

0

Revenue

0

0

2000

2000

2000

2000

Net Cash flow

-3100

150

2100

2100

2100

2100

Discount rate

1.000

0.926

0.857

0.794

0.735

0.681

PV

-3100

138.9

1799.7

1667.4

1543.5

1430.1

Cumulative cash flow

-3100

-2961.1

-1161.4

506

2049.5

3479.6

NPV

3479.6







So Plan B has NPV of €3479600 making a payback in 2 years and (12* 134.25/1548.3= 1month) . Plan B take 5 months longer but has a payback of 70% more. The extra 5 months cash flow will have to be considered by the firm though. Liquidity vs Cash.


c)

As in a) in relevant values the tax savings would have to be related to the project profit. The time value of money would also be effected as the tax will only be paid a year after. So one would need to know how much and what the tax shield applies to or if it is related to general profits this would involve further allocation of project costs.


d)

For book value

Book value is the current fiscal value of a business at a certain point in time. (accounting view during time)

Can show the current levels of activities and possible corrections to activities that are needed

Shows a short term presentation of business health.


Against book value

Doesn't include items such as real value or intangibles.

Some values are speculative such as Fixed(current value of fixed asset) or current assets(Could sometimes be seen as a fixed asset).

Time value of money is not included (Unlike DCF)


DCF analysis Problem and solution 1

Question
(a) The discussion of the appraisal of projects in Block 4 notes that they and their associated cash flows involve risk. Five types of risk are described, as shown below: Operating or organisational risk Market risk Foreign exchange rate risk Interest rate risk Environmental risk, Select any three of these five types of risk and give a brief explanation of each one chosen. (6 marks)
Foreign exchange rate risk – The risk associated with the change of value of currency in such a way that the payment value of the buy/seller becomes less than the other buyer/seller agreed price. e.g. (when purchased 2€ = 1 pound but at transaction the value is 3€ = 1 pound )
Interest rate risk - The risk associated with a change in the rate of return (e.g base rate) is such a way that it becomes less or non competitive with inflation reducing the future value of money. e.g (Interest rate becomes less than bank base rate)
Environmental risk – The risk associated with Sociological, Technological ,Economical ,Environmental Political changes. e.g. (Flood reduces value of property)

(b)A company is considering investing in a new machine to increase sales. They can buy the machine now at a cost of E100,000 and sell it after 5 years for E15,000. The marketing department has forecast additional product sales of 5,000 units if the price of E25.00 per unit is held constant. Variable costs are E14.00 per unit and the fixed costs of maintaining and running the machine E20,000 per annum. The company uses a discount rate of 10% to assess such capital expenditure. Ignore tax and inflation. Year 0 1 2 3 4 5 Discount factor at 10% 1 0.909 0.826 0.751 0.683 0.621 Calculate Net Present Value and draw conclusions from your calculations. (12 marks)

(c) Describe briefly the two most important factors that an organisation should consider when setting a discount rate to be used for assessing a project. (7 marks)

Answer B
DCF(Discount cash flow) for purchase of new machine


























































































Year 0



Year 1



Year 2



Year 3



Year 4



Year 5



Year 6



Initial investment



(€100000)



0



0



0



0



0



€15000



Return from Sales



0



€125000



€125000



€125000



€125000



€125000



0



Variable costs



0



(€70000)



(€70000)



(€70000)



(€70000)



(€70000)



0



Fixed Costs



0



(€20000)



(€20000)



(€20000)



(€20000)



(€20000)



0



Net cash flow



(€100000)



€35000



€35000



€35000



€35000



€35000



€15000



Discount Rate(10%)



1.00



0.909



0.826



0.751



0.683



0.621



0.564



Present Value



(€100000)



€31815



€28910



€26285



€23905



€21735



€8460


NPV(Net present value) = €41110 - Payback= 2 years + (12*30/35) = 2 years and 10 months

Scenario analysis

Slow Growth in sales-Would make payback longer than 2 years and 10 months over 5 years. I.e (Already at more than 50% of timespan)

Fast growth in sales-Would make payback faster than 2 years and 10 months over 5 years.I.e (Already at more than 50% of timespan - Still long)

This project requires a large capital investment to be tied up for more than half the life of the project. Working capital will also be effected as there would be both an increase in current assets and current liabilities. To account for this the machine would have to be more productive. The NPV is still positive and with an overall gain of 41% more than the original E100 000 invested.

Answer C

The discount should account for the “The time value of money”. The current value of money and the future value using the discount rate is only an estimate which is effected by two factors:
Rate of return – Price of money is expected to increase when there is inflation.
Inflations rate - Prices are likely to change so managers have to estimate the future rate of inflation.
The “time exchange rate” of consumption is reflected in the interest rate where future consumption is expected to be greater. There are 2 ways that interest rates try to take into account the above 2 factors:
Nominal interest rate- Unadjusted rate that doesn't include inflation.
Real interest rate- Adjusted/deflated market interest rate that accounts for inflation.

Tuesday, 2 March 2010

Henna in Madrid

Buy a girl something she will never forget. Natural henna products in cnr calle tribulete and calle amparo, Madrid, Spain

Map
Website