financial reporting requirement template
TRANSCRIPT
Balance Sheet1.Total Assets
Year Cash In Hand Cash In Bank Finished Stocks Net InvestmentsQtr1 38035.00 39526.00 66080.00 18025.00 Qtr2 44582.00 50888.00 72066.00 21470.00 Qtr3 39380.00 40120.00 62500.00 19200.00 Qtr4 53758.00 58414.00 84836.00 25699.00
2.Total LiabilitiesYear Total Creditors Total Tax LiabilitieTotal External DebtTotal Other CreditorQtr1 39124.00 98812.00 42752.00 59226.00 Qtr2 49398.00 119050.00 52998.00 66356.00 Qtr3 39800.00 99840.00 41260.00 59900.00 Qtr4 54781.00 140017.00 60560.00 76911.00
3.Asset Based Solution
1.Asset Leveraged Solutions
Qtr1 Qtr2 Qtr3 Qtr4 0.00
100000.00
200000.00
300000.00
400000.00
500000.00
600000.00
700000.00
800000.00 Cash In Hand
Cash In Bank
Finished Stocks
Net Investments
Net Fixed Asset Investments
Net Tangible Assets
Net Intangibles
Total Assets
Qtr1 Qtr2 Qtr3 Qtr4 0.00
50000.00 100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
Total Creditors
Total Tax Liabilities
Total External Debt
Total Other Creditors Greater Than One Year
Total Liabilties
0
5000
10000
15000
20000
25000
30000
Leve
rage
d So
luti
ons
Qtr1 Qtr2 Qtr3 Qtr4
Quarter
5.Growing Talent Base: Gross and Net employee addition
0
5000
10000
15000
20000
25000
30000
Leve
rage
d So
luti
ons
Qtr1 Qtr2 Qtr3 Qtr4
Quarter
0
5000
10000
15000
20000
25000
30000
35000
Qtr1 Qtr2 Qtr3 Qtr4
Quarter
Cons
olid
ate
Gro
ss A
diti
ons,
Cons
olid
ated
Net
A
dditi
ons
Consolidate Gross Aditions
Consolidated Net Additions
Net Fixed Asset Investments Net Tangible Assets Net Intangibles Total Assets 97169.00 239346.00 66080.00 564261.00
117092.00 288188.00 72066.00 666352.00 99360.00 240760.00 62500.00 563820.00
136598.00 334479.00 84836.00 778620.00
Total Liabilties 239914.00 287802.00 240800.00 332269.00
4.Intellectual property strategy-Patents Filled and Granted
0
5000
10000
15000
20000
25000
30000
35000
Qtr1 Qtr2 Qtr3 Qtr4
Quarter
Pate
nts
Gra
nted
,Pat
ents
Fill
ed
Patents Granted
Patents Filled
0
5000
10000
15000
20000
25000
30000
35000
Qtr1 Qtr2 Qtr3 Qtr4
Quarter
Pate
nts
Gra
nted
,Pat
ents
Fill
edPatents Granted
Patents Filled
Cash Flow
Summary Cash Flow
2010Net Cash Provided by Operating Activities 44,177Consolidated Net Additions 47,315Net Cash Used in Investing Activities 44,177Net Cash used in financing Activities 47,315Net increase/(decrease) in cash and cash equivalents 49,311Exchange difference on translation of foreign currency cash and cash equivalents 48,311Cash and Cash equivalents at end of the year 41,829
Cash Flow from Different Activities
1.Cash Flow from Operating Activities
Profit before Taxes and exceptional items 84,394Add:Depreciation 97,587Effect of Working Capital changes 84,394Net Cash used in financing Activities 97,587Cash generation from Operations 89,361Others 91,361Tax Payments Made 84,394Net Cash Provided by Operating Activities 92,361
3.Cash Flow from Investing Activities
Purchase of Fixed deposit with banks (net) having maturity over three Months 85,535Acquisitions(Net of Cash acquired) 87,416Purchase/Sale of other Investmets including Dividents reinvetment 99,983Others 99,983Net Cash Used in Investing Activities 91,361
2011 Difference47,100 2,92349,272 1,95747,184 3,00750,272 2,95750,672 1,36151,086 2,77543,687 1,858
2.Cash Flow from Financing Activities
Proceed from the issue of shares by subsidiaries 85,516Proceeds/(Repayments) from/of Borrowings (Net) 84,394Interest paid 91,361Net Cash used in financing Activities 97,587Dividends paid to a minority shareholder of a subsidiary 91,361
010,00020,00030,00040,00050,00060,000
2010
2011
Difference
010,00020,00030,00040,00050,00060,000
2010
2011
Difference
1.Total Cash In for all Quarters
Year Operating Income Interest Expense Pre Tax Income Net IncomeQtr1 45620.00 41220.00 42020.00 45932.00 Qtr2 48418.00 45210.00 60074.00 48632.00 Qtr3 56480.00 54240.00 57600.00 54880.00 Qtr4 44684.00 49468.00 53048.00 56792.00 Grand Total 195202.00 190138.00 212742.00 206236.00
2.Total Cash Out For All Quarters
Year Marketing Payroll Misc Total Cash OutQtr1 63000.00 69080.00 73231.00 205311.00 Qtr2 76952.00 76320.00 80460.00 233732.00 Qtr3 56920.00 62800.00 69700.00 189420.00 Qtr4 82304.00 84362.00 71362.00 238028.00 Grand Total 279176.00 292562.00 294753.00 866491.00
Cash Flow in different Markets
1.Total Cash In from different Market
Market Operating Income Interest Expense Pre Tax Income Net IncomeCaliforniaConnecticut 38204.00 33384.00 53008.00 43718.00 Florida 45992.00 46896.00 45192.00 56588.00 Massachusett 48306.00 53070.00 54362.00 50366.00 New HampshireNew York 62700.00 56788.00 60180.00 55564.00 OregonUtahWashingtonGrand Total 195202.00 190138 212742 206,236
2.Total Cash out from different Market
Market Marketing Payroll MiscCalifornia 13170.00 14522.00 12171.00 Connecticut 55925.00 47265.00 45933.00 Florida 48651.00 72124.00 54945.00 Massachusetts 55350.00 52188.00 54444.00 New York 67846.00 64422.00 55419.00 Oregon 11157.00 17328.00 13291.00 Utah 13315.00 11695.00 28589.00 Washington 13762.00 13018.00 29961.00 Grand Total 279176.00 292562.00 294753.00
Sales COGS Total Cash In 481295.00 90412.00 746499.00
86270.00 88600.00 377204.00 86360.00 78020.00 387580.00
110296.00 107487.00 421775.00 764221.00 364519.00 1933058.00
Sales COGS Total Cash In 93459.00 35660.00 39706.00 34478.00 242498.00 48651.00 66257.00 309576.00 46364.00 49698.00 302166.00
302000.00 134446.00 68028.00 437706.00
47150.00 37694.00 30841.00 37294.00 23604.00 35410.00
766,221 364,519 1,935,058
Qtr1 Qtr2 Qtr3 Qtr4 0.00
100000.00
200000.00
300000.00
400000.00
500000.00
600000.00
700000.00
800000.00
Operating Income
Interest Expense
Pre Tax Income
Net Income
Sales
COGS
Total Cash In
Qtr1 Qtr2 Qtr3 Qtr4 0.00
50000.00
100000.00
150000.00
200000.00
250000.00
Marketing
Payroll
Misc
Total Cash Out
Californ
ia
Connecticu
t
Florid
a
Massach
usetts
New Ham
pshire
New Yo
rk
Oregon
Utah
Wash
ington
0.00 50000.00
100000.00 150000.00 200000.00 250000.00 300000.00 350000.00 400000.00 450000.00 500000.00
Operating Income
Interest Expense
Pre Tax Income
Net Income
Sales
COGS
Total Cash In
Total Cash Out 39863.00
149123.00 175720.00 161982.00 187687.00
41776.00 53599.00 56741.00
866491.00
Californ
ia
Connecticu
t
Florid
a
Massach
usetts
New Ham
pshire
New Yo
rk
Oregon
Utah
Wash
ington
0.00 50000.00
100000.00 150000.00 200000.00 250000.00 300000.00 350000.00 400000.00 450000.00 500000.00
Operating Income
Interest Expense
Pre Tax Income
Net Income
Sales
COGS
Total Cash In
Californ
ia
Connecticu
t
Florid
a
Massach
usetts
New Yo
rk
Oregon
Utah
Wash
ington
0.00 20000.00 40000.00 60000.00 80000.00
100000.00 120000.00 140000.00 160000.00 180000.00 200000.00
Marketing
Payroll
Misc
Total Cash Out
Qtr1 Qtr2 Qtr3 Qtr4 0.00
100000.00
200000.00
300000.00
400000.00
500000.00
600000.00
700000.00
800000.00
Operating Income
Interest Expense
Pre Tax Income
Net Income
Sales
COGS
Total Cash In
Californ
ia
Connecticu
t
Florid
a
Massach
usetts
New Ham
pshire
New Yo
rk
Oregon
Utah
Wash
ington
0.00 50000.00
100000.00 150000.00 200000.00 250000.00 300000.00 350000.00 400000.00 450000.00 500000.00
Operating Income
Interest Expense
Pre Tax Income
Net Income
Sales
COGS
Total Cash In
Californ
ia
Connecticu
t
Florid
a
Massach
usetts
New Ham
pshire
New Yo
rk
Oregon
Utah
Wash
ington
0.00 50000.00
100000.00 150000.00 200000.00 250000.00 300000.00 350000.00 400000.00 450000.00 500000.00
Operating Income
Interest Expense
Pre Tax Income
Net Income
Sales
COGS
Total Cash In
Californ
ia
Connecticu
t
Florid
a
Massach
usetts
New Yo
rk
Oregon
Utah
Wash
ington
0.00 20000.00 40000.00 60000.00 80000.00
100000.00 120000.00 140000.00 160000.00 180000.00 200000.00
Marketing
Payroll
Misc
Total Cash Out
Analysis of Revenue Growth
Volume 29.28%Price 8.44%Mix (Onsite/Offshore) 20.00%Exchange Rate 5.00%Total Growth 8.55%
Banking Financial Services & Insurance(BFSI)Telecom, Media & EntertainmentManufacturingOthersRetail and Cinsumer Packaged GoodsGrand Total
Revenue from Operations
21%
18%
21%
21%
18%
ContributionVolume Price Mix (Onsite/Offshore) Exchange Rate Total Growth
Banking Financial Services & Insurance(BFSI)22%
Telecom, Media & Entertainment19%
Manufacturing20%
Others20%
Retail and Cinsumer Packaged Goods19%
Contribution of industry segments
Volume 97,587Price 84,394Mix (Onsite/Offshore) 99,983Exchange Rate 99,983Total Growth 85,516
Revenue from Operations
97,58785,51691,36191,36185,516
451,341
21%
18%
21%
21%
18%
ContributionVolume Price Mix (Onsite/Offshore) Exchange Rate Total Growth
Banking Financial Services & Insurance(BFSI)22%
Telecom, Media & Entertainment19%
Manufacturing20%
Others20%
Retail and Cinsumer Packaged Goods19%
Contribution of industry segments
TopN Analysis
2.Top Market1. Top Products
Rank StateRank Category Sales 1 New Hampshire
1 Colas 410111.00 2 New York 2 Diet Drinks 266803.00 3 California 3 Root Beer 195054.00 4 Florida 4 Hershey Foods 161056.00 5 Oregon
1.Top Product based on Package Type BottleRank Category Sales
1 Root Beer 195054.00 2 Colas 165297.00 3 Diet Drinks 102481.00
Colas Diet Drinks Root Beer Hershey Foods
1 2 3 4
0.00
100000.00
200000.00
300000.00
400000.00
Top Products
Sales
New
Ham
pshi
re
New
Yor
k
Calif
orni
a
Flor
ida
Ore
gon
1 2 3 4 5
0.00 50000.00
100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
Top Market
Sales
Root Beer Colas Diet Drinks 1 2 3
0.00 20000.00 40000.00 60000.00 80000.00
100000.00 120000.00 140000.00 160000.00 180000.00 200000.00
Top Product based on Pkg Type Bottle
Sales
3.Top Products Caffeinated
Rank Category Sales 1 Diet Drinks 266803.00 2 Colas 244814.00 3 Root Beer 166827.00
Root Beer Colas Diet Drinks 1 2 3
0.00 20000.00 40000.00 60000.00 80000.00
100000.00 120000.00 140000.00 160000.00 180000.00 200000.00
Top Product based on Pkg Type Bottle
Sales
Diet Drinks Colas Root Beer 1 2 3
0.00
50000.00
100000.00
150000.00
200000.00
250000.00
300000.00
Top Products Caffeinated
Sales
2.Top Market
Sales
302000.00 3.Top Industry Segments 134446.00
93459.00 48651.00 47150.00
Rank BankingOther Manuf 1 ### ### ###
2.Top Product based on Package Type CanRank Category Sales
1 Colas 244814.00 2 Diet Drinks 164322.00
New
Ham
pshi
re
New
Yor
k
Calif
orni
a
Flor
ida
Ore
gon
1 2 3 4 5
0.00 50000.00
100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
Top Market
Sales
78000.00
80000.00
82000.00
84000.00
86000.00
88000.00
90000.00
92000.00
94000.00
96000.00
98000.00
Banking Financial Services & Insurance(BFSI)
Others
Manufacturing
Telecom, Media & Enter-tainment
Retail and Cinsumer Packaged Goods
Colas Diet Drinks 1 2
0.00
50000.00
100000.00
150000.00
200000.00
250000.00
Top Product based on Package Type Can
Sales
4.Top Products Non-Caffeinated
Rank Category Sales 1 Colas 165297.00 2 Root Beer 28227.00
Colas Diet Drinks 1 2
0.00
50000.00
100000.00
150000.00
200000.00
250000.00
Top Product based on Package Type Can
Sales
Colas Root Beer 1 2
0.00 20000.00 40000.00 60000.00 80000.00
100000.00 120000.00 140000.00 160000.00 180000.00
Top Products Non-Caffeinated
Sales
3.Top Industry Segments
Telecom, Retail and Cinsumer Packaged Goods### 85516.00
78000.00
80000.00
82000.00
84000.00
86000.00
88000.00
90000.00
92000.00
94000.00
96000.00
98000.00
Banking Financial Services & Insurance(BFSI)
Others
Manufacturing
Telecom, Media & Enter-tainment
Retail and Cinsumer Packaged Goods
Colas Diet Drinks 1 2
0.00
50000.00
100000.00
150000.00
200000.00
250000.00
Top Product based on Package Type Can
Sales
Colas Diet Drinks 1 2
0.00
50000.00
100000.00
150000.00
200000.00
250000.00
Top Product based on Package Type Can
Sales
Colas Root Beer 1 2
0.00 20000.00 40000.00 60000.00 80000.00
100000.00 120000.00 140000.00 160000.00 180000.00
Top Products Non-Caffeinated
Sales
Company Performance Trends
Year Total RevenueQtr1 481295.00 Qtr2 86270.00 Qtr3 86360.00 Qtr4 110296.00
Year Domestic RInternational revenuesQtr1 9804.00 19516.00 Qtr2 10811.00 27776.00 Qtr3 9930.00 19940.00 Qtr4 12213.00 30355.00
Quarter Banking FTotal OtherTelecom, MManufacturingQtr1 ### 59226.00 19608.00 ###Qtr2 ### 66356.00 21622.00 ###Qtr3 ### 59900.00 19860.00 ###Qtr4 ### 76911.00 24426.00 ###
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
40000.00
45000.00
9804.00 10811.00 9930.00 12213.00
19516.00
27776.00
19940.00
30355.00
International revenues Domestic Revenues
Qtr1 Qtr2 Qtr3 Qtr4 0.00
20000.00
40000.00
60000.00
80000.00
100000.00
120000.00
140000.00
160000.00
180000.00
Manufacturing
Telecom, Media & Enter-tainment
Total Other Creditors Greater Than One Year
Banking Financial Services & Insurance(BFSI)
Qtr1 Qtr2 Qtr3 Qtr4 0.00
100000.00
200000.00
300000.00
400000.00
500000.00
600000.00
481295.00
86270.00 86360.00 110296.00
Total Revenue
Qtr1 Qtr2 Qtr3 Qtr4 0.00
20000.00
40000.00
60000.00
80000.00
100000.00
120000.00
140000.00
160000.00
180000.00
Manufacturing
Telecom, Media & Enter-tainment
Total Other Creditors Greater Than One Year
Banking Financial Services & Insurance(BFSI)
0
50000
100000
150000
200000
250000
300000
350000
400000
450000
500000
Sale
s
Qtr1 Qtr2 Qtr3 Qtr4
Revenue From Different Regions
California
Connecticut
Florida
Massachusetts
New Hampshire
New York
Oregon
Utah
Washington
Company Performance Trends
Quarter Man PoweNon-Man PowTotal ExpenseQtr1 ### 7616.00 ###Qtr2 ### 8803.20 ###Qtr3 ### 7928.00 ###Qtr4 ### 10654.40 ###
Quarter Man PoweNon-Man Total ExpenseQtr1 50.62 49.38 38556.00 Qtr2 55.79 44.21 49784.00 Qtr3 50.15 49.85 39760.00 Qtr4 53.26 46.74 56991.00
Quarter Earning before Interest & TaxesQtr1 ###Qtr2 ###Qtr3 ###Qtr4 ###
Qtr1 Qtr2 Qtr3 Qtr4 0.00
20.00
40.00
60.00
80.00
100.00
120.00
50.62 55.79 50.15 53.26
49.38 44.21 49.85 46.74
Non-Man Power Expenses Man Power Expenses
Qtr1 Qtr2 Qtr3 Qtr4 0.00
20000.00
40000.00
60000.00
80000.00
100000.00
120000.00
19516.00 27776.00
19940.00 30355.00 7616.00
8803.20 7928.00
10654.40
38556.00
49784.00
39760.00
56991.00
Total Expense
Total Expense
Non-Man Power Expenses
Man Power Expenses
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
19516.00
27776.00
19940.00
30355.00
Earning before Interest & Taxes
Quarter Profit after TaxQtr1 ###Qtr2 ###Qtr3 ###Qtr4 ###
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
19516.00
27776.00
19940.00
30355.00
Earning before Interest & Taxes
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
20010.00
23112.00 20180.00
28059.00
Profit after Tax
Qtr1 Qtr2 Qtr3 Qtr4 0.00
20.00
40.00
60.00
80.00
100.00
120.00
50.62 55.79 50.15 53.26
49.38 44.21 49.85 46.74
Non-Man Power Expenses Man Power Expenses
Qtr1 Qtr2 Qtr3 Qtr4 0.00
20000.00
40000.00
60000.00
80000.00
100000.00
120000.00
19516.00 27776.00
19940.00 30355.00 7616.00
8803.20 7928.00
10654.40
38556.00
49784.00
39760.00
56991.00
Total Expense
Total Expense
Non-Man Power Expenses
Man Power Expenses
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
19516.00
27776.00
19940.00
30355.00
Earning before Interest & Taxes
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
19516.00
27776.00
19940.00
30355.00
Earning before Interest & Taxes
Qtr1 Qtr2 Qtr3 Qtr4 0.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
20010.00
23112.00 20180.00
28059.00
Profit after Tax