ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
From this year's income statement
2
Operating Income =₹27,801.00
3
Taxable Income =₹25,737.00
4
Taxes Paid =₹7,981.00
5
Net Income =₹16,999.00
6
Interest income on cash (if avaliable)₹187.00
7
Interest expenses on debt =₹2,251.00
8
9
From previous year's Balance Sheet: Asset Side
10
Cash & Marketable Securities₹6,550.00
11
Goodwill₹20,651.00
12
Do you have R&D expenses that you want to captialize?No
13
14
From previous year's Balance Sheet: Liability Side
15
Short term interest bearing Debt₹4,047.00
16
Long term interest bearing debt₹47,079.00
17
Shareholder Equity₹71,315.00
18
Minority Interest (if consolidated in shareholder equity, separate it)₹4,446.00
19
Does the firm have any operating lease commitments?Yes
If yes, please fill in the lease converter worksheet using last year's commitments
20
If yes, enter the pre-tax cost of debt to use in converting leases₹0.03
21
22
Questions
23
The effective tax rate is usually used to compute after-tax operating income. But using a marginal tax rate will yield a more robust (albeit understated) value
24
Do you want to use your effective tax rate to compute after-tax operating income?Yes
25
If yes, the rate used will be₹0.31
26
If no, enter tax rate to use
27
28
Goodwill is generally not included in invested capital on the assumption that it is paid for growth assets
29
Do you want to stay with this assumption?Yes
30
If no, enter the portion of goodwill that you want to leave in invested capital (as %)₹0.50
31
32
Cash is usually netted out of invested capital. It sometimes makes sense to leave a portion of the cash in capital, if it is needed for operations
33
Do you want to stay with this assumption?No
34
If not, enter the portion of cash you want to leave in invested capital (as %)₹0.20
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100