Income Statement Dec 31, 2010
Statement of retained earning Dec 31, 2010
Dec 31, 2010
Rs. Dec 31, 2010
Studio revenue 165,000 Rs.
Balance of retained earning 40000
Gross profit 165,000
Net income -36000
Expenses
Rent expense -12000 Dividends -6000
Supply expense -3900
Insurance expense -1900
Advertisement expense -500 Balance of retained earning -2,000
Salries -85000
EBITDA 61,700
Deprecition -1800
EBIT 59,900
Interest -900
EBT 59,000
Income tax -23000
Net income 36,000
Balance Sheet
Dec 31, 2010
ASSETS
NON-CURRENT ASSETS
Equipment 18000
Accumulated depritiation -7200
10,800
CURRENT ASSETS
Cash 171100
Unexpired insurance 7200
Account recivable 9400
Pre-paid studio rent 3000
Supplier 500
191,200
202,000
EQUITY AND LIABILITIES
CURRENT LIABILITIES
Accounts Payable 3200
Salaries payable 4000
Unearned studion revenue 8800
Income tax payable 6000
Notes payable 10000
32,000
EQUITY
capital stock 100000
retained earning 70000
170000
202,000
PARTICULARS CASE A
Revenues 200000
Expenses 160000
Net income 40000
Retained earnings, Jan 1 300000
Dividents paid 70000
Retained earnings, Dec 1 270000
Current assets , Dec 31 80000
Non current assets,Dec 31 850000
Total assets, Dec 31 930000
Current liabilities, Dec 31 40000
Non current liabilities, Dec 31 100000
Total liabilities, Dec 31 140000
CS and capital in excess of par, Dec 31 520000
Total stockholders equity, Dec 31 790000
return on equity 0.191183679 0.99728913 0.99943617 0.99819844
4. current market price of common stock
2009 2007 2006 2005
price earning ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0!
dividend yield ratio 1.062182362 0.79740583 0.71592242 1.67685518
PARTICULARS CASE B
Sales 500000
COGS 200000
Gross profit 300000
Operatin expense 60000
Operating income (EBIT) 240000
Interest expense 10000
Income before Taxes (EBT) 230000
Tax expense (40%) 92000
Net income 138000
PARTICULARS CASE A
Revenues 110000 PARTICULARS CASE B
Expenses 70000
Net income 40000 Sales 250000
Retained earnings, Jan 1 100000 COGS 100000
Dividents paid 30000 Gross profit 150000
Retained earnings, Dec 1 110000 Operatin expense 60000
Current assets , Dec 31 230000 Operating income (EBIT) 90000
Non current assets,Dec 31 180000 Interest expense 10000
Total assets, Dec 31 410000 Income before Taxes (EBT) 80000
Current liabilities, Dec 31 60000 Tax expense (40%) 32000
Non current liabilities, Dec 31 140000 Net income 48000
Total liabilities, Dec 31 200000
CS and capital in excess of par, Dec 31 100000
Total stockholders equity, Dec 31 210000
Income Statement Dec 31, 2009
Dec 31, 2009
EPS = NI / No. Of shares
Millions of Dollars 2.44
Net sales 2850 DPS = Total dividends / No. Of shares
Operating cost -2497 1.06
Gross profit 353
BVPS = Total equity / No. Of shares
EBITDA 353 17.6
Deprecition -90
CFPS = (NI + Depreciation + Amortization) / No. Of shares
EBIT 263 4.24
Interest -60
NCF = NI + Depreciation + Amortization
EBT 203 1310000000
Income tax -81.2
Net income 122
Common Dividends -53
Retained earning addition 69
Income Statement Dec 31, 2009
Dec 31, 2009 EPS = NI / No. Of shares
2.36
Millions of Dollars
DPS = Total dividends / No. Of shares
Net sales 3000 1.15
Operating cost -2616.2
Gross profit 384 BVPS = Total equity / No. Of shares
18.8 CFPS= NI + Dep. + Amortiz
EBITDA 384 4.35
Deprecition -100 CFPS = NI + Depreciation + Amortization
EBIT 284
Interest -88 NCF = NI + Depreciation + Amortization
218000000
EBT 196
Income tax -78.3 NOWC = TCA - TCL
690000000
Net income 118
TOC = NOWC + Net fixed assets
Common Dividends -57.5 1690000000
Retained earning addition 60
NOPAT =
OCF = NOPAT + Depreciation + Amortization OCF :
FCF =
MVA = MVA:
EVA = CFPS :
NOWC:
NOPAT :
FCF :
CFPS= NI + Dep. + Amortization
4.35
OCF = NOPAT + Dep. + Amortization
-21837.74
MVA= 1150 - 6500
-5350
CFPS= NI + Dep. + Amortization
117500000 + 100000000 + 0 / 50000000
4.35
NOWC= TCA - TCL
1000000000- 310000000
6.9E+08
NOPAT = EBIT (1- tax)
283.8 (1-78.3)
-21937.74
FCF= OCF - Gross investment in fixed assests
-21837.7 -1100
-22937.74
