Tata Steel
ASSETS
Rs. Crore
Gross fixed assets
Land & building
Plant & machinery
Other fixed assets
Capital WIP
Less: cummulative depreciation
Net fixed assets
Investments
In group / associate cos.
In mutual funds
Other investments
Marketable investment
I
Nos.
Company Name
Asian Paints (India) Ltd.
Bajaj Auto Ltd.
Bharat Heavy Electricals Ltd.
H C L Technologies Ltd.
Indian Oil Corpn. Ltd.
Indian Petrochemicals Corpn. Ltd.
Infosys Technologies Ltd.
National Thermal Power Corpn. Ltd.
Reliance Industries Ltd
INDIAN PETRO CHEMICALS LIMITED
Rs. Crores
ASSETS
Gross fixed assets
Land and building
Plant and machinery
Other fixed assets
Capital work-in-progress
Net fixed assets
Investments
Investment in group cos.
Investment in mutual funds
Other investments
Market
(1) Calculate HLL's equity beta using weekly
closing share price for HLL and Sensex from 10 Jan-92
to 26 Dec.-97. (2) Calculate HLLs beta based on weekly
share prices for two periods, 10 Jan-92 to 24 Dec-94
and 24 Dec-94 to 26 Dec-97.
(3) Do you obtain di
H C L Technologies Ltd.: Balance Sheet
Rs. Crore
ASSETS
Gross fixed assets
Land & building
Plant & machinery
Other fixed assets
Capital WIP
Less: cummulative depreciation
Net fixed assets
Jun 1999
Jun 2000
Jun 2001
Jun 2002
Jun 2003
64.65
12.83
0.00
49.97
Bank of Baroda (BoB): Beta Calculation
Assignment:
(1) Calculate BoB's equity returns based on the given
share price data.
(2)
Calculate the market return for the same period. (3)
Assume that BoB's equity return is dependent on the
market return. Draw a c
Asian Paints (India) Ltd.: Balance Sheet
ASSETS
Rs. Crores
Gross fixed assets
Land & building
Plant & machinery
Other fixed assets
Capital WIP
Less: cummulative depreciation
Net fixed assets
Mar-93
Mar-94
Mar-95
Mar-96
Mar-97
Mar-98
Mar 1999 Mar 2000 Mar
HEALTHCARE COMPANY LIMITED:
Financial Statement Analysis
The next three worksheets give the company's balance sheet
(BS), profit and loss statement (P&L) and per share data for
five years. You need to comment on the company's financial
performance. Specif
Beta Calculation are two methods of calculating intercept (alpha, ) and
Problem 1: There
beta () of the characteristic line for a firms equity share. The direct method
is to calculate covariance and variances. The Excel has a function,
Covariance, under i
OPTION VALUATION: Black-Scholes Model
An investor is interested in writing a three-month call option on
Infosystem's share. Infosystem's share is currently selling for Rs
210. The volatility (standard deviation) of the share returns is
estimated as 67 per
Valuation of a Firm
P Ltd. is thinking of acquiring Q Ltd. Ps P/E ratio is 12 and it has a weighted
average cost of capital of 14 percent. The financial manager of P has prepared the
forecasts for the Qs operations for the next 10 years. He was not sure a
Investment Analysis and Scenaio Building
A company is considering an investment project costing Rs 160 crore. It is
expected to have a useful life of 8 years and salvage value of Rs 12 crore.
The project cost will be depreciated at 25% WDV method on block
Healthy Food Ltd. Is considering to introduce a breakfast cereal in the market.
The estimated cost of the project is Rs 49 crore. The project cost can be
charged to profit and loss account onstraight line basis over seven years for tax
purposes. The estim
NPV and IRR Calculations
Ex.
1
A project will cost Rs 50,000 today. It is expected to generate cash flows of Rs 30,000, Rs 25,000
and Rs 15,000 each year through year 1 to 3. The discount rate is 18 percent. Calculate the
project's NPV and IRR.
IRR of An
Time Value of Money Excel Financial Functions
Future Value
FV(rate,nper,pmt,PV,Type)
Present value
PV(rate,nper,pmt,FV,type)
Annuity payment/receipt
PMT(rate,nper,PV,FV,type)
IRR (yield) of an annuity
Rate(nper,pmt,PV,FV,type,guess)
Present value of uneve
Treasury and Cash Management
1. A new manufacturing company is to be incorporated from 1 January 2000. Its
authorized capital will be Rs 2 crore divided into 20 lakh equity shares of Rs 10 each. It
intends to raise capital by issuing equity shares of Rs
Time Value of Money
1. A person is required to pay four equal annual payments of Rs 4,000 each in his
Deposit account that pays 10 per cent interest per year. Find out the future value of
annuity at the end of 4 years.
(IPCC, May 2007)
Hint:
(1 + i ) n
Meaning, Concept and Policies of Working Capital
1. A newly formed company has applied to the commercial bank for the first time for
financing its working capital requirements. The following information is available about
the projections for the current
Management of Receivables
1. The present credit terms of P Company are 1/10 net 30. Its annual sales are Rs 80 lakh, its average
collection period is 20 days. Its variable costs and average total costs to sales are 0.85 and 0.95 respectively
and its cost
Management of Inventory
1. C developed original specification of a product and founded C Manufacturing Ltd.
In 1997, the firm manufactured 980 Nos. at an average price of Rs 900 each. In 1998 due
to continuous price rise of the inputs, he raised his pric
Financing DecisionsCost of Capital and Structure
1. The Modern Chemicals Ltd requires Rs 25,00,000 for a new plant. This plant is
expected to yield earnings before interest and taxes of Rs 5,00,000. While deciding about
the financial plant, the company c
Financial Analysis and Planning
1. From the following information, prepare a summarized Balance Sheet as at 31 March 2002:
Working Capital
Bank overdraft
Fixed Assets to Proprietory ratio
Reserves and Surplus
Current ratio
Liquid ratio
Rs 2,40,000
Rs 40,
Capital Budgeting and Investment Decisions
1. Following are the data on a capital project being evaluated by the management of X
Ltd:
Project M
Rs 40,000
4 years
15%
1.064
?
?
?
0
Annual cost saving
Useful life
I.R.R.
Profitability Index (PI)
NPV
Cost of
Business Risk, Financial Risk and Leverage
1. The Net Sales of A Ltd are Rs 30 crores. Earnings before interest and tax of the
company as a percentage of net sales are 12%. The capital employed comprises Rs 10
crores of equity, Rs 2 crores of 13% Cumulat