Financial Template Rs
Financial Template Rs
Financial Template Rs
COGS P&L By Qtr Rs. 826,156.80 Rs. 0.20 Rs. 756,000.00 Rs. 0.25 Rs. 3,215,000.00 Rs. 0.25 Rs. 11,900,000.00 Rs. 0.27
Gross Margin Rs. 3,304,627.20 Rs. 0.80 Rs. 2,324,000.00 Rs. 0.75 Rs. 9,835,000.00 Rs. 0.75 Rs. 32,100,000.00 Rs. 0.73
Expenses
Engineering P&L By Qtr Rs. 1,326,625.00 Rs. 0.32 Rs. 3,475,275.00 Rs. 1.13 Rs. 7,212,187.50 Rs. 0.55 Rs. 12,205,975.00 Rs. 0.28
Marketing P&L By Qtr Rs. 710,750.00 Rs. 0.17 Rs. 1,810,750.00 Rs. 0.59 Rs. 3,239,350.00 Rs. 0.25 Rs. 5,300,000.00 Rs. 0.12
Sales P&L By Qtr Rs. 1,357,039.20 Rs. 0.33 Rs. 3,025,500.00 Rs. 0.98 Rs. 5,754,000.00 Rs. 0.44 Rs. 10,818,500.00 Rs. 0.25
G&A P&L By Qtr Rs. 964,575.00 Rs. 0.23 Rs. 1,817,750.00 Rs. 0.59 Rs. 3,117,000.00 Rs. 0.24 Rs. 5,308,500.00 Rs. 0.12
Operating Exp. Rs. 4,358,989.20 Rs. 1.06 Rs. 10,129,275.00 Rs. 3.29 Rs. 19,322,537.50 Rs. 1.48 Rs. 33,632,975.00 Rs. 0.76
Operating Profit -Rs. 1,054,362.00 -Rs. 0.26 -Rs. 7,805,275.00 -Rs. 2.53 -Rs. 9,487,537.50 -Rs. 0.73 -Rs. 1,532,975.00 -Rs. 0.03
COGS Sales Plan Rs. 344,232.00 Rs. 68,846.40 Rs. 68,846.40 Rs. 344,232.00 Rs. 108,000.00 Rs. 162,000.00 Rs. 216,000.00 Rs. 270,000.00
Gross Margin ### Rs. 275,385.60 Rs. 275,385.60 Rs. 1,376,928.00 Rs. 332,000.00 Rs. 498,000.00 Rs. 664,000.00 Rs. 830,000.00
Expenses
Engineering Expenses Rs. 169,375.00 Rs. 312,875.00 Rs. 378,000.00 Rs. 466,375.00 Rs. 576,037.50 Rs. 792,275.00 Rs. 965,162.50 Rs. 1,141,800.00
Marketing Expenses Rs. 111,250.00 Rs. 136,250.00 Rs. 185,125.00 Rs. 278,125.00 Rs. 330,600.00 Rs. 409,200.00 Rs. 470,737.50 Rs. 600,212.50
Sales Expenses Rs. 232,245.50 Rs. 229,899.10 Rs. 377,274.10 Rs. 517,620.50 Rs. 609,562.50 Rs. 697,687.50 Rs. 812,937.50 Rs. 905,312.50
G&A Expenses Rs. 173,700.00 Rs. 206,875.00 Rs. 284,325.00 Rs. 299,675.00 Rs. 388,150.00 Rs. 417,975.00 Rs. 492,300.00 Rs. 519,325.00
Operating Exp. Rs. 686,570.50 Rs. 885,899.10 Rs. 1,224,724.10 Rs. 1,561,795.50 Rs. 1,904,350.00 Rs. 2,317,137.50 Rs. 2,741,137.50 Rs. 3,166,650.00
Operating Profit Rs. 690,357.50 -Rs. 610,513.50 -Rs. 949,338.50 -Rs. 184,867.50 -Rs. 1,572,350.00 -Rs. 1,819,137.50 -Rs. 2,077,137.50 -Rs. 2,336,650.00
COGS Rs. 440,000.00 Rs. 627,500.00 Rs. 925,000.00 Rs. 1,222,500.00 Rs. 1,910,000.00 Rs. 2,625,000.00 Rs. 3,250,000.00 Rs. 4,115,000.00
Gross Margin Rs. 1,360,000.00 Rs. 1,947,500.00 Rs. 2,825,000.00 Rs. 3,702,500.00 Rs. 5,390,000.00 Rs. 7,125,000.00 Rs. 8,750,000.00 Rs. 10,835,000.00
Expenses
Engineering Rs. 1,504,125.00 Rs. 1,720,437.50 Rs. 1,940,500.00 Rs. 2,047,125.00 Rs. 2,622,512.50 Rs. 2,906,000.00 Rs. 3,193,237.50 Rs. 3,484,225.00
Marketing Rs. 607,812.50 Rs. 788,537.50 Rs. 793,450.00 Rs. 1,049,550.00 Rs. 1,013,775.00 Rs. 1,285,250.00 Rs. 1,336,712.50 Rs. 1,664,262.50
Sales Rs. 1,110,812.50 Rs. 1,313,687.50 Rs. 1,551,687.50 Rs. 1,777,812.50 Rs. 2,240,562.50 Rs. 2,540,687.50 Rs. 2,851,937.50 Rs. 3,185,312.50
G&A Rs. 661,450.00 Rs. 705,050.00 Rs. 849,300.00 Rs. 901,200.00 Rs. 1,090,050.00 Rs. 1,253,225.00 Rs. 1,364,475.00 Rs. 1,600,750.00
Operating Exp. Rs. 3,884,200.00 Rs. 4,527,712.50 Rs. 5,134,937.50 Rs. 5,775,687.50 Rs. 6,966,900.00 Rs. 7,985,162.50 Rs. 8,746,362.50 Rs. 9,934,550.00
Operating Profit -Rs. 2,524,200.00 -Rs. 2,580,212.50 -Rs. 2,309,937.50 -Rs. 2,073,187.50 -Rs. 1,576,900.00 -Rs. 860,162.50 Rs. 3,637.50 Rs. 900,450.00
Unit Sales
Total Units Rs. 1,434.30 Rs. 286.86 Rs. 286.86 Rs. 1,434.30
###
Revenue
Total COGS Rs. 344,232.00 Rs. 68,846.40 Rs. 68,846.40 Rs. 344,232.00
###
Engineering
CTO Input 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Programmer Input 4 8 10 12 15 20 25 30 40 45 50 60 65 70 75 80
Tech Writer Input - 1 1 2 2 4 4 4 5 5 5 5 6 6 6 6
Other Input - - - - - - - - - - - - - - - -
Total Eng 5 10 12 15 18 25 30 35 46 51 56 66 72 77 82 87
Marketing
VP Marketing Input 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Product Manager Input 1 1 2 2 3 3 4 4 5 5 5 5 6 8 10 12
Mar-Com Input - - 1 1 2 2 2 2 3 3 4 4 5 5 6 6
Other Input 1 1 1 2 2 2 3 3 3 4 4 4 5 5 6 6
Total Mktg 3 3 5 6 8 8 10 10 12 13 14 14 17 19 23 25
Sales
VP Sales Input 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Regional Sales Input 1 2 4 5 7 8 9 10 12 14 16 18 22 24 26 28
Sales Support Input 1 2 4 5 7 8 9 10 12 14 16 18 22 24 26 28
Sales Admin Input 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8
Total Sales 4 6 11 13 18 20 23 25 30 34 39 43 52 56 61 65
TOTAL EMP. 17 25 37 43 56 65 77 84 107 117 133 147 171 186 206 221
Annual Rev/Emp (000) 405 55 37 160 31 41 46 52 67 88 113 134 171 210 233 271
Marketing
Salaries & Benefits Staffing Plan Rs. 86,250.00 Rs. 86,250.00 Rs. 135,125.00 Rs. 158,125.00 Rs. 210,600.00 Rs. 214,200.00
Literature / PR input Rs. 5,000.00 Rs. 5,000.00 Rs. 10,000.00 Rs. 10,000.00 Rs. 20,000.00 Rs. 20,000.00
Trade Shows input Rs. - Rs. 25,000.00 Rs. - Rs. 50,000.00 Rs. - Rs. 50,000.00
Misc / Other input Rs. 20,000.00 Rs. 20,000.00 Rs. 40,000.00 Rs. 60,000.00 Rs. 100,000.00 Rs. 125,000.00
Total Marketing To P&L Rs. 111,250.00 Rs. 136,250.00 Rs. 185,125.00 Rs. 278,125.00 Rs. 330,600.00 Rs. 409,200.00
Sales
Salaries & Benefits Staffing Plan Rs. 122,187.50 Rs. 179,687.50 Rs. 309,062.50 Rs. 366,562.50 Rs. 504,562.50 Rs. 572,687.50
Travel (PP/PM) Rs. 3,000.00 input/formula Rs. 9,000.00 Rs. 18,000.00 Rs. 36,000.00 Rs. 45,000.00 Rs. 63,000.00 Rs. 72,000.00
Commission (% Rev) Rs. 0.05 input/formula Rs. 86,058.00 Rs. 17,211.60 Rs. 17,211.60 Rs. 86,058.00 Rs. 22,000.00 Rs. 33,000.00
Misc / Other input Rs. 15,000.00 Rs. 15,000.00 Rs. 15,000.00 Rs. 20,000.00 Rs. 20,000.00 Rs. 20,000.00
Total Sales To P&L Rs. 232,245.50 Rs. 229,899.10 Rs. 377,274.10 Rs. 517,620.50 Rs. 609,562.50 Rs. 697,687.50
Total Operating Expense Rs. 686,570.50 Rs. 885,899.10 Rs. 1,224,724.10 Rs. 1,561,795.50 Rs. 1,904,350.00 Rs. 2,317,137.50
Expenses Page 7
Departmental Expenses Q3 Q4
Year 2 Year 2
Engineering
Salaries & Benefits Rs. 685,162.50 Rs. 811,800.00
Tech Supplies (PP/PM) Rs. 180,000.00 Rs. 210,000.00
Misc / Other Rs. 100,000.00 Rs. 120,000.00
Total Engineering Rs. 965,162.50 Rs. 1,141,800.00
Marketing
Salaries & Benefits Rs. 270,737.50 Rs. 275,212.50
Literature / PR Rs. 50,000.00 Rs. 50,000.00
Trade Shows Rs. - Rs. 100,000.00
Misc / Other Rs. 150,000.00 Rs. 175,000.00
Total Marketing Rs. 470,737.50 Rs. 600,212.50
Sales
Salaries & Benefits Rs. 657,937.50 Rs. 730,312.50
Travel (PP/PM) Rs. 81,000.00 Rs. 90,000.00
Commission (% Rev) Rs. 44,000.00 Rs. 55,000.00
Misc / Other Rs. 30,000.00 Rs. 30,000.00
Total Sales Rs. 812,937.50 Rs. 905,312.50
Expenses Page 8
Departmental Expenses Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Year 3 Year 3 Year 3 Year 3 Year 4 Year 4 Year 4 Year 4
Engineering
Salaries & Benefits Rs. 1,078,125.00 Rs. 1,214,437.50 Rs. 1,354,500.00 Rs. 1,621,125.00 Rs. 1,790,512.50 Rs. 1,944,000.00 Rs. 2,101,237.50 Rs. 2,262,225.00
Tech Supplies (PP/PM) Rs. 276,000.00 Rs. 306,000.00 Rs. 336,000.00 Rs. 396,000.00 Rs. 432,000.00 Rs. 462,000.00 Rs. 492,000.00 Rs. 522,000.00
Misc / Other Rs. 150,000.00 Rs. 200,000.00 Rs. 250,000.00 Rs. 30,000.00 Rs. 400,000.00 Rs. 500,000.00 Rs. 600,000.00 Rs. 700,000.00
Total Engineering Rs. 1,504,125.00 Rs. 1,720,437.50 Rs. 1,940,500.00 Rs. 2,047,125.00 Rs. 2,622,512.50 Rs. 2,906,000.00 Rs. 3,193,237.50 Rs. 3,484,225.00
Marketing
Salaries & Benefits Rs. 332,812.50 Rs. 363,537.50 Rs. 393,450.00 Rs. 399,550.00 Rs. 488,775.00 Rs. 560,250.00 Rs. 686,712.50 Rs. 762,762.50
Literature / PR Rs. 75,000.00 Rs. 75,000.00 Rs. 100,000.00 Rs. 100,000.00 Rs. 125,000.00 Rs. 125,000.00 Rs. 150,000.00 Rs. 1,500.00
Trade Shows Rs. - Rs. 100,000.00 Rs. - Rs. 200,000.00 Rs. - Rs. 150,000.00 Rs. - Rs. 300,000.00
Misc / Other Rs. 200,000.00 Rs. 250,000.00 Rs. 300,000.00 Rs. 350,000.00 Rs. 400,000.00 Rs. 450,000.00 Rs. 500,000.00 Rs. 600,000.00
Total Marketing Rs. 607,812.50 Rs. 788,537.50 Rs. 793,450.00 Rs. 1,049,550.00 Rs. 1,013,775.00 Rs. 1,285,250.00 Rs. 1,336,712.50 Rs. 1,664,262.50
Sales
Salaries & Benefits Rs. 882,812.50 Rs. 1,023,937.50 Rs. 1,185,187.50 Rs. 1,334,562.50 Rs. 1,637,562.50 Rs. 1,797,187.50 Rs. 1,977,937.50 Rs. 2,145,812.50
Travel (PP/PM) Rs. 108,000.00 Rs. 126,000.00 Rs. 144,000.00 Rs. 162,000.00 Rs. 198,000.00 Rs. 216,000.00 Rs. 234,000.00 Rs. 252,000.00
Commission (% Rev) Rs. 90,000.00 Rs. 128,750.00 Rs. 187,500.00 Rs. 246,250.00 Rs. 365,000.00 Rs. 487,500.00 Rs. 600,000.00 Rs. 747,500.00
Misc / Other Rs. 30,000.00 Rs. 35,000.00 Rs. 35,000.00 Rs. 35,000.00 Rs. 40,000.00 Rs. 40,000.00 Rs. 40,000.00 Rs. 40,000.00
Total Sales Rs. 1,110,812.50 Rs. 1,313,687.50 Rs. 1,551,687.50 Rs. 1,777,812.50 Rs. 2,240,562.50 Rs. 2,540,687.50 Rs. 2,851,937.50 Rs. 3,185,312.50
Total Operating Expense Rs. 3,884,200.00 Rs. 4,527,712.50 Rs. 5,134,937.50 Rs. 5,775,687.50 Rs. 6,966,900.00 Rs. 7,985,162.50 Rs. 8,746,362.50 Rs. 9,934,550.00
Expenses Page 9
Cash Flow Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Year 1 Year 1 Year 1 Year 1 Year 2 Year 2 Year 2 Year 2
Beginning Cash Rs. - Rs. 4,195,429.50 Rs. 4,554,458.40 Rs. 3,307,119.90 Rs. 1,746,710.00 Rs. 9,067,288.00 Rs. 6,796,150.50 Rs. 4,405,013.00
Gross Margin Rs. - Rs. 1,376,928.00 Rs. 275,385.60 Rs. 275,385.60 Rs. 1,376,928.00 Rs. 332,000.00 Rs. 498,000.00 Rs. 664,000.00
Expenses -Rs. 686,570.50 -Rs. 885,899.10 -Rs. 1,224,724.10 -Rs. 1,561,795.50 -Rs. 1,904,350.00 -Rs. 2,317,137.50 -Rs. 2,741,137.50 -Rs. 3,166,650.00
Investment Rs. 5,000,000.00 Rs. - Rs. - Rs. - Rs. 8,000,000.00 Rs. - Rs. - Rs. -
Capital Expense -Rs. 118,000.00 -Rs. 132,000.00 -Rs. 298,000.00 -Rs. 274,000.00 -Rs. 152,000.00 -Rs. 286,000.00 -Rs. 148,000.00 -Rs. 78,000.00
Change in Cash Rs. 4,195,429.50 Rs. 359,028.90 -Rs. 1,247,338.50 -Rs. 1,560,409.90 Rs. 7,320,578.00 -Rs. 2,271,137.50 -Rs. 2,391,137.50 -Rs. 2,580,650.00
Ending Balance Rs. 4,195,429.50 Rs. 4,554,458.40 Rs. 3,307,119.90 Rs. 1,746,710.00 Rs. 9,067,288.00 Rs. 6,796,150.50 Rs. 4,405,013.00 Rs. 1,824,363.00
Gross Margin Rs. 830,000.00 Rs. 1,360,000.00 Rs. 1,947,500.00 Rs. 2,825,000.00 Rs. 3,702,500.00 Rs. 5,390,000.00 Rs. 7,125,000.00 Rs. 8,750,000.00
Expenses -Rs. 3,884,200.00 -Rs. 4,527,712.50 -Rs. 5,134,937.50 -Rs. 5,775,687.50 -Rs. 6,966,900.00 -Rs. 7,985,162.50 -Rs. 8,746,362.50 -Rs. 9,934,550.00
Investment Rs. - Rs. - Rs. - Rs. - Rs. - Rs. - Rs. - Rs. -
Capital Expense -Rs. 142,000.00 -Rs. 90,000.00 -Rs. 114,000.00 -Rs. 106,000.00 -Rs. 146,000.00 -Rs. 110,000.00 -Rs. 130,000.00 -Rs. 110,000.00
Change in Cash -Rs. 3,196,200.00 -Rs. 3,257,712.50 -Rs. 3,301,437.50 -Rs. 3,056,687.50 -Rs. 3,410,400.00 -Rs. 2,705,162.50 -Rs. 1,751,362.50 -Rs. 1,294,550.00
Ending Balance -Rs. 1,371,837.00 -Rs. 4,629,549.50 -Rs. 7,930,987.00 ### ### -Rs. 17,103,237.00 -Rs. 18,854,599.50 -Rs. 20,149,149.50