Class Questions - Cap Budgeting
Class Questions - Cap Budgeting
Class Questions - Cap Budgeting
CASE
DPL is a fast growing profitable company. The company is situated in Gujarat. Its
sales are expected to grow about 3 times from Rs. 360 million in 2003 –04 to Rs.
1, 100 million in 2004 –05. The company is considering of commissioning a 35
km pipeline between two areas to carry gas to the state electricity board. The
project will cost Rs. 250 million. The pipeline will have a capacity of 2.5 MMSCM.
The company will enter into a contract with State Electricity Board to supply gas.
The revenue from the sale to SEB is expected to be Rs. 120 million per annum.
The pipeline will also be used for transportation of LNG to other users in the
area. This is expected to bring additional revenue of Rs. 80 million per annum.
The company management considers the useful life of the pipeline to be 20
years. The finance manager estimates cash profit to sales ratio of 20% per
annum for the first 12 years of the project operations and 17% per annum for the
remaining life of the project. The project has no salvage value. The project is in a
backward area is exempt from paying any taxes. The company requires a rate of
return of 15% from this project.
Investment data
(Rs. In ‘000)
0 1 2 3 4 5 6
Year
Initial 1000
Investmen
t
Dep 250 188 141 105 79 59
Acc Dep 250 438 579 684 763 822
BV 1000 750 562 421 316 237 178
NWC 20 30 50 70 70 30 0
Total 1020 780 612 491 386 267 178
Salvage 100
Value
Summarized P & L
(Rs. In ‘000)
1 2 3 4 5 6
Year
Revenues 550 890 1840 2020 1680 1300
Expenses - 300 - 472 - 958 - 1075 - 890 - 680
Dep - 250 - 188 - 141 - 105 - 79 - 59
Taxable 0 230 741 840 711 561
Profit
Tax ( .35 ) 0 81 259 294 249 196
PAT 0 149 482 546 462 365
Q.3. Sandals Inc. is considering the purchase of a new leather cutting machinery
to replace an existing machine that has a Book Value of Rs. 3000/= and can be
sold for Rs. 1500/=. The estimated salvage value of the old machine in 4 years
would be zero and it is depreciated on a straight line basis. The new machinery
will reduce costs by Rs. 7000/year. The new machine has a 4 year life, costs Rs.
14000 and can be sold for an expected amount of Rs. 2000 at the end of the
fourth year. Assuming SLD and 40% tax rate, define the cash flows and check
the feasibility @ 10%.
The project has a life of 5 years. Plant and Machinery are depreciated at the rate
of 15% per annum as per the WDV method. The expected annual net sales is
Rs. 350 lakhs. Cost of sales( including depreciation, but excluding interest) is
expected to be Rs. 190 lakhs per year. The tax rate is 60%. At the end of 5 years
Plant and Machinery will fetch a value equal to the Book Value and there will be a
full recovery of Working Capital. Short Term Advance from Commercial Bank will
be maintained at Rs. 60 lakhs and carry an interest of 18% per annum and it will
be fully liquidated. Trade Credit will be maintained at Rs. 36 lakhs and will be fully
paid at the end of the fifth year. Evaluate the project from the long term funds
suppliers point of view.
Year 1 2 3 4 5 6 7
Capacity 40 40 50 75 100 100 100
Utilisation
The terminal value of the project is expected to be 20% of its original cost. The
corporate tax rate is 35% and profit from the sale of asset is taxed as ordinary
income. The inflation rate is expected to be 5%.
Q.6. A project costs Rs. 6000 and it has cash inflows of Rs. 4000, Rs. 3000, Rs.
2000 and Rs.1000 in years through 1 – 4. Assume that the associated (Certainty
Equivalent) CE factors are Year 0 = 1.00, Year 1 = 0.90, Year 2 = 0.70, Year 3 =
0.50 and Year 4 = 0.30 and the risk free discount rate is 10%. What is the Net
Present Value? (Hint: Multiply each cash flow by CE and calculate NPV)