ultra tec

28
CAPITAL BUDGETING WORKSHEET 5 Equity Analysis of a Project INPUT SHEET: USER ENTERS ALL BOLD NUMBERS INITIAL INVESTMENT CASHFLOW DETAILS DISCOUNT RATE Initial Investment= 5000.00 Revenues in year 1= 20501.86 Approach(1:Dir Opportunity cost (if any 1700.00 Var. Expenses as % of R 75% 1. Discount Lifetime of the investme 4 Fixed expenses in year 1014.63 2a. Beta Salvage Value at end of $0 Tax rate on net income= 34% b. Riskless Deprec. method(1:St.line 2.00 If you do not have the breakdown of fixed and c. Market r Tax Credit (if any )= 34% expenses, input the entire expense as a % of d. Debt Rat Other invest.(non-deprec 0 e. Cost of Discount rat WORKING CAPITAL Initial Investment in Wo 1334.85 Working Capital as % of 7% Salvageable fraction at 100% GROWTH RATES 1 2 3 4 Revenues DO not ente 0.60% 0.60% 0.60% Fixed Expenses Do not ente 0.60% 0.60% 0.60%

Upload: nas

Post on 14-Dec-2015

214 views

Category:

Documents


1 download

DESCRIPTION

ultra tech

TRANSCRIPT

CAPITAL BUDGETING WORKSHEET 5

Equity Analysis of a ProjectINPUT SHEET: USER ENTERS ALL BOLD NUMBERS

INITIAL INVESTMENT CASHFLOW DETAILS DISCOUNT RATE

Initial Investment= 5000.00 Revenues in year 1= 20501.86 Approach(1:Direct;2:CAPM)=

Opportunity cost (if any)= 1700.00 Var. Expenses as % of Rev= 75% 1. Discount rate =

Lifetime of the investment 4 Fixed expenses in year 1= 1014.63 2a. Beta

Salvage Value at end of project= $0 Tax rate on net income= 34% b. Riskless rate=

Deprec. method(1:St.line;2:DDB)= 2.00 If you do not have the breakdown of fixed and variable c. Market risk premium =

Tax Credit (if any )= 34% expenses, input the entire expense as a % of revenues. d. Debt Ratio =

Other invest.(non-depreciable)= 0 e. Cost of Borrowing =

Discount rate used=

WORKING CAPITAL

Initial Investment in Work. Cap= 1334.85

Working Capital as % of Rev= 7%

Salvageable fraction at end= 100%

GROWTH RATES

1 2 3 4

Revenues DO not enter 0.60% 0.60% 0.60%

Fixed Expenses Do not enter 0.60% 0.60% 0.60%

CAPITAL BUDGETING WORKSHEET 6

Default: The fixed expense growth rate is set equal to the growth rate in revenues by default.YEAR

0 1 2 3 4 5 6 7INITIAL INVESTMENTInvestment $5,000 - Tax Credit $1,700 Net Investment $3,300 + Working Cap $1,335 + Opp. Cost $1,700 + Other invest. $0 Initial Investment $6,335

SALVAGE VALUEEquipment $0 $0 $0 $0 $0 $0 $0 Working Capital $0 $0 $0 $1,365 $0 $0 $0

OPERATING CASHFLOWSLifetime Index 1 1 1 1 0 0 0Revenues $20,502 $20,625 $20,749 $20,873 $0 $0 $0 -Var. Expenses $15,376 $15,469 $15,561 $15,655 $0 $0 $0 - Fixed Expenses $1,015 $1,021 $1,027 $1,033 $0 $0 $0 EBITDA $4,111 $4,136 $4,160 $4,185 $0 $0 $0 - Depreciation $2,500 $1,250 $625 $313 $1 $0 $0 EBIT $1,611 $2,886 $3,535 $3,873 ($1) $0 $0 -Tax $548 $981 $1,202 $1,317 ($0) $0 $0 EBIT(1-t) $1,063 $1,904 $2,333 $2,556 ($1) $0 $0 + Depreciation $2,500 $1,250 $625 $313 $1 $0 $0 - ∂ Work. Cap $6 $14 $2 $8 $0 $0 $0 NATCF ($6,335) $3,557 $3,140 $2,956 $2,860 $0 $0 $0 Discount Factor 1 1.06905491054 1.14287840175 1.221799767541 1.306171041186 0 0 0Discounted CF ($6,335) $3,327 $2,748 $2,420 $3,235 $0 $0 $0

Investment MeasuresNPV = 5395.16IRR = 35.89%

CAPITAL BUDGETING WORKSHEET 7

ROC = 81.11%

BOOK VALUE & DEPRECIATIONBook Value (beginning) $5,000 $2,500 $1,250 $625 $0 $0 $0 Depreciation $2,500 $1,250 $625 $313 $1 $0 $0

CAPITAL BUDGETING WORKSHEET 8

BV(ending) $5,000 $2,500 $1,250 $625 $313 ($1) $0 $0

CAPITAL BUDGETING WORKSHEET 9

Equity Analysis of a Project

DISCOUNT RATE

Approach(1:Direct;2:CAPM)= 2

1. Discount rate = 10%

0.87

b. Riskless rate= 8.35%

c. Market risk premium = -0.01

22.17%

e. Cost of Borrowing = 7.41%

Discount rate used= 6.91%

CAPITAL BUDGETING WORKSHEET 10

8 9 10

$0 $0 $0 $0 $0 $0

0 0 0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

0 0 0$0 $0 $0

CAPITAL BUDGETING WORKSHEET 11

$0 $0 $0 $0 $0 $0

CAPITAL BUDGETING WORKSHEET 12

$0 $0 $0

Equity Analysis of a ProjectINPUT SHEET: USER ENTERS ALL BOLD NUMBERS

INITIAL INVESTMENT CASHFLOW DETAILS

Initial Investment= 5000.00 Revenues in year 1=

Opportunity cost (if any)= 1700.00 Var. Expenses as % of Rev=

Lifetime of the investment 4 Fixed expenses in year 1=

Salvage Value at end of project= 0.00 Tax rate on net income=

Deprec. method(1:St.line;2:DDB)= WDVM If you do not have the breakdown of fixed and variable

Tax Credit (if any )= 34% expenses, input the entire expense as a % of revenues.

Other invest.(non-depreciable)= 0

WORKING CAPITAL

Initial Investment in Work. Cap= -1334.85

Working Capital as % of Rev= -6.54

Salvageable fraction at end= 100%

GROWTH RATES

1 2 3 %

Revenues 0% 85.00% 85.00% 85.00%

Fixed Expenses 0% 85.00% 85.00% 85.00%

Default: The fixed expense growth rate is set equal to the growth rate in revenues by default.YEAR

0 1 2 3 4INITIAL INVESTMENTInvestment $5,000 - Tax Credit $1,700 Net Investment $3,300 + Working Cap ($1,335) + Opp. Cost $1,700 + Other invest. $0 Initial Investment $3,665

SALVAGE VALUEEquipment $0 $0 $0 $0 Working Capital $0 $0 $0 ($931,699)

OPERATING CASHFLOWSLifetime Index 1 1 1 1Revenues $22,500 $41,625 $77,006 $142,462 -Var. Expenses $16,875 $31,219 $57,755 $106,846 - Fixed Expenses $1,015 $1,877 $3,473 $6,424 EBITDA $4,610 $8,529 $15,779 $29,191 - Depreciation $2,500 $1,250 $625 $313 EBIT $2,110 $7,279 $15,154 $28,879 -Tax $718 $2,475 $5,152 $9,819

EBIT(1-t) $1,393 $4,804 $10,002 $19,060 + Depreciation $2,500 $1,250 $625 $313 - ∂ Work. Cap ($145,815) ($270,893) ($85,578) ($428,078)NATCF ($3,665) $149,708 $276,947 $96,205 $447,450 Discount Factor 1 1.111016767 1.234358256555 1.371392719518 1.523640305526Discounted CF ($3,665) $134,749 $224,365 $70,151 ($317,823)

Investment MeasuresNPV = 107776.44IRR = 41.63ROC = 363.96%

BOOK VALUE & DEPRECIATIONBook Value (beginning) $5,000 $2,500 $1,250 $625 Depreciation $2,500 $1,250 $625 $313 BV(ending) $5,000 $2,500 $1,250 $625 $313

Equity Analysis of a ProjectINPUT SHEET: USER ENTERS ALL BOLD NUMBERS

DISCOUNT RATE

22500.00 Approach(1:Direct;2:CAPM)= 2

75% 1. Discount rate = 10%

1014.63 2a. Beta 0.87

34% b. Riskless rate= 8.64%

If you do not have the breakdown of fixed and variable c. Market risk premium = 7.79%

expenses, input the entire expense as a % of revenues. d. Debt Ratio = 41.10%

e. Cost of Borrowing = 7.45%

Discount rate used= 11.10%

5 6 7 8 9 10

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

0 0 0 0 0 0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

0 0 0 0 0 0$0 $0 $0 $0 $0 $0

BOOK VALUE & DEPRECIATION$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Date Open High Low Close p1-p0/p020 Feb, 2015 3,119.00 3,125.10 3,005.65 3,014.10

19 Feb, 2015 3,112.60 3,128.90 3,008.10 3,062.30

18 Feb, 2015 3,082.30 3,127.50 3,082.00 3,110.00

17 Feb, 2015 3,078.80 3,078.80 3,078.80 3,078.80

16 Feb, 2015 3,123.00 3,150.00 3,070.15 3,078.80

13 Feb, 2015 3,071.10 3,144.75 3,068.00 3,112.50

12 Feb, 2015 3,007.00 3,095.00 3,000.50 3,035.10

11 Feb, 2015 2,975.00 3,019.95 2,975.00 3,008.00

10 Feb, 2015 2,951.10 3,025.95 2,941.10 2,966.20

9 Feb, 2015 2,961.05 2,990.00 2,941.00 2,962.75

6 Feb, 2015 3,030.00 3,050.00 2,995.00 3,008.35

5 Feb, 2015 3,109.90 3,109.90 3,041.00 3,064.10

4 Feb, 2015 3,125.40 3,126.40 3,068.10 3,096.90

3 Feb, 2015 3,070.00 3,188.00 3,060.00 3,107.55

2 Feb, 2015 3,149.80 3,169.15 3,039.00 3,087.05

30 Jan, 2015 3,162.35 3,185.00 3,097.00 3,140.35

29 Jan, 2015 3,135.00 3,175.00 3,113.10 3,162.75

28 Jan, 2015 3,130.00 3,189.95 3,125.00 3,139.75

27 Jan, 2015 3,199.90 3,199.90 3,105.45 3,121.45

26 Jan, 2015 3,147.90 3,147.90 3,147.90 3,147.90

23 Jan, 2015 3,168.00 3,185.75 3,130.00 3,147.90

22 Jan, 2015 3,062.00 3,144.25 3,059.00 3,122.45

21 Jan, 2015 3,109.00 3,115.90 3,041.30 3,054.80

20 Jan, 2015 3,100.00 3,127.95 3,085.05 3,096.45

19 Jan, 2015 3,099.00 3,139.95 3,066.50 3,088.50

16 Jan, 2015 3,100.20 3,139.95 3,045.75 3,070.10

15 Jan, 2015 2,920.00 3,102.30 2,898.40 3,083.05

14 Jan, 2015 2,829.00 2,918.80 2,829.00 2,908.85

13 Jan, 2015 2,735.00 2,851.25 2,715.05 2,818.50

12 Jan, 2015 2,727.70 2,735.00 2,690.00 2,700.30

9 Jan, 2015 2,760.00 2,760.00 2,711.00 2,729.35

8 Jan, 2015 2,675.00 2,732.30 2,660.30 2,727.45

7 Jan, 2015 2,675.00 2,692.95 2,612.25 2,660.05

6 Jan, 2015 2,737.70 2,739.00 2,651.00 2,670.60

5 Jan, 2015 2,748.00 2,775.40 2,726.00 2,747.70

2 Jan, 2015 2,669.50 2,752.50 2,667.25 2,742.10

1 Jan, 2015 2,678.90 2,678.90 2,651.20 2,662.50

31 Dec, 2014 2,640.00 2,698.00 2,630.00 2,676.05

30 Dec, 2014 2,650.75 2,660.00 2,610.00 2,629.80

29 Dec, 2014 2,619.00 2,657.00 2,608.00 2,645.40

26 Dec, 2014 2,647.00 2,649.40 2,590.00 2,602.95

25 Dec, 2014 2,620.55 2,620.55 2,620.55 2,620.55

24 Dec, 2014 2,590.00 2,664.00 2,572.10 2,620.55

23 Dec, 2014 2,518.00 2,550.00 2,516.00 2,544.50

22 Dec, 2014 2,503.20 2,529.95 2,498.05 2,517.00

19 Dec, 2014 2,450.30 2,514.70 2,450.00 2,498.35

18 Dec, 2014 2,457.00 2,465.00 2,418.80 2,446.55

17 Dec, 2014 2,487.00 2,517.80 2,430.90 2,439.30

16 Dec, 2014 2,534.00 2,560.00 2,480.00 2,484.85

15 Dec, 2014 2,517.00 2,572.00 2,488.05 2,536.70

12 Dec, 2014 2,490.00 2,525.45 2,490.00 2,511.50

11 Dec, 2014 2,505.10 2,541.65 2,468.25 2,484.45

10 Dec, 2014 2,468.00 2,524.85 2,461.00 2,515.75

9 Dec, 2014 2,503.35 2,511.75 2,465.60 2,481.75

8 Dec, 2014 2,492.00 2,525.00 2,478.85 2,512.10

5 Dec, 2014 2,460.00 2,514.00 2,460.00 2,485.25

4 Dec, 2014 2,480.00 2,484.00 2,455.00 2,464.65

3 Dec, 2014 2,468.00 2,491.90 2,463.00 2,474.10

2 Dec, 2014 2,472.00 2,482.00 2,455.05 2,473.00

1 Dec, 2014 2,490.00 2,501.65 2,470.10 2,478.20

28 Nov, 2014 2,472.00 2,514.00 2,472.00 2,484.25

27 Nov, 2014 2,472.00 2,498.00 2,462.00 2,475.20

26 Nov, 2014 2,485.00 2,519.65 2,452.10 2,476.45

25 Nov, 2014 2,518.00 2,523.55 2,451.65 2,467.20

24 Nov, 2014 2,510.00 2,543.95 2,475.20 2,522.10

21 Nov, 2014 2,471.00 2,510.40 2,467.00 2,490.70

20 Nov, 2014 2,519.00 2,519.00 2,458.00 2,466.35

19 Nov, 2014 2,542.00 2,545.00 2,480.00 2,494.75

18 Nov, 2014 2,573.00 2,581.65 2,521.00 2,530.10

17 Nov, 2014 2,617.00 2,636.60 2,543.00 2,561.45

14 Nov, 2014 2,590.00 2,627.00 2,574.00 2,616.00

13 Nov, 2014 2,630.40 2,642.00 2,570.00 2,577.20

12 Nov, 2014 2,660.00 2,669.00 2,620.00 2,624.60

11 Nov, 2014 2,589.00 2,651.80 2,582.00 2,646.60

10 Nov, 2014 2,575.00 2,586.45 2,550.30 2,581.10

7 Nov, 2014 2,540.00 2,571.00 2,540.00 2,561.90

6 Nov, 2014 2,535.30 2,535.30 2,535.30 2,535.30

5 Nov, 2014 2,584.90 2,599.00 2,519.95 2,535.30

4 Nov, 2014 2,559.95 2,559.95 2,559.95 2,559.95

3 Nov, 2014 2,564.90 2,586.00 2,542.00 2,559.95

31 Oct, 2014 2,520.00 2,560.00 2,515.00 2,548.45

30 Oct, 2014 2,479.30 2,526.35 2,479.30 2,512.15

29 Oct, 2014 2,474.00 2,488.35 2,452.50 2,479.30

28 Oct, 2014 2,448.40 2,484.90 2,435.20 2,464.85

27 Oct, 2014 2,450.00 2,454.95 2,405.25 2,430.60

24 Oct, 2014 2,401.20 2,401.20 2,401.20 2,401.20

23 Oct, 2014 2,401.20 2,401.20 2,401.20 2,401.20

22 Oct, 2014 2,417.00 2,428.85 2,397.50 2,401.20

21 Oct, 2014 2,468.90 2,469.00 2,390.00 2,400.00

20 Oct, 2014 2,400.00 2,455.00 2,390.00 2,450.25

17 Oct, 2014 2,320.10 2,355.05 2,297.20 2,317.75

16 Oct, 2014 2,475.00 2,480.00 2,301.00 2,317.60

15 Oct, 2014 2,467.00 2,467.00 2,467.00 2,467.00

14 Oct, 2014 2,491.00 2,497.50 2,457.00 2,467.00

13 Oct, 2014 2,470.00 2,499.00 2,446.00 2,481.90

10 Oct, 2014 2,550.00 2,550.00 2,477.00 2,481.35

9 Oct, 2014 2,563.05 2,589.90 2,551.05 2,570.80

8 Oct, 2014 2,573.70 2,588.00 2,527.00 2,549.10

7 Oct, 2014 2,620.10 2,627.20 2,550.00 2,556.70

6 Oct, 2014 2,648.75 2,648.75 2,648.75 2,648.75

3 Oct, 2014 2,648.75 2,648.75 2,648.75 2,648.75

2 Oct, 2014 2,648.75 2,648.75 2,648.75 2,648.75

1 Oct, 2014 2,643.00 2,660.00 2,623.10 2,648.75

30 Sep, 2014 2,615.35 2,654.00 2,603.00 2,631.65

29 Sep, 2014 2,650.10 2,660.00 2,614.55 2,646.65

26 Sep, 2014 2,556.00 2,665.00 2,556.00 2,646.00

25 Sep, 2014 2,623.00 2,627.25 2,552.75 2,574.00

24 Sep, 2014 2,602.10 2,658.70 2,602.10 2,630.65

23 Sep, 2014 2,608.00 2,669.00 2,590.25 2,601.30

22 Sep, 2014 2,641.00 2,666.00 2,596.90 2,617.25

19 Sep, 2014 2,650.50 2,666.10 2,625.00 2,641.55

18 Sep, 2014 2,573.90 2,662.00 2,573.80 2,645.95

17 Sep, 2014 2,555.00 2,605.00 2,535.00 2,599.85

16 Sep, 2014 2,593.90 2,620.50 2,520.75 2,551.20

15 Sep, 2014 2,630.00 2,639.35 2,575.00 2,589.15

12 Sep, 2014 2,676.05 2,686.25 2,605.00 2,639.35

11 Sep, 2014 2,705.00 2,709.00 2,660.00 2,686.55

10 Sep, 2014 2,690.00 2,714.95 2,676.40 2,680.40

9 Sep, 2014 2,710.00 2,767.00 2,687.00 2,694.90

8 Sep, 2014 2,674.05 2,724.95 2,670.80 2,718.05

5 Sep, 2014 2,708.00 2,728.40 2,666.50 2,670.75

4 Sep, 2014 2,690.10 2,732.90 2,655.00 2,710.60

3 Sep, 2014 2,719.50 2,742.55 2,700.65 2,713.15

2 Sep, 2014 2,632.10 2,743.00 2,632.10 2,719.25

1 Sep, 2014 2,585.00 2,651.75 2,560.25 2,643.50

29 Aug, 2014 2,550.05 2,550.05 2,550.05 2,550.05

28 Aug, 2014 2,590.80 2,609.30 2,541.80 2,550.05

27 Aug, 2014 2,612.10 2,623.25 2,585.00 2,594.50

26 Aug, 2014 2,649.00 2,649.00 2,578.00 2,610.85

25 Aug, 2014 2,668.00 2,668.00 2,608.85 2,629.25

22 Aug, 2014 2,654.70 2,671.45 2,644.50 2,651.35

21 Aug, 2014 2,682.00 2,689.95 2,630.20 2,644.90

20 Aug, 2014 2,718.00 2,724.50 2,674.00 2,684.35

19 Aug, 2014 2,671.10 2,733.30 2,655.05 2,718.60

18 Aug, 2014 2,630.35 2,670.00 2,630.35 2,665.15

15 Aug, 2014 2,632.55 2,632.55 2,632.55 2,632.55

14 Aug, 2014 2,600.00 2,640.00 2,587.50 2,632.55

13 Aug, 2014 2,606.00 2,640.00 2,576.00 2,608.10

12 Aug, 2014 2,544.00 2,625.00 2,536.15 2,613.10

11 Aug, 2014 2,491.00 2,549.65 2,480.00 2,532.65

8 Aug, 2014 2,521.90 2,525.00 2,440.00 2,474.55

7 Aug, 2014 2,550.00 2,586.80 2,530.05 2,544.25

6 Aug, 2014 2,599.00 2,605.00 2,535.00 2,546.65

5 Aug, 2014 2,480.00 2,618.90 2,470.05 2,603.30

4 Aug, 2014 2,483.00 2,511.00 2,464.25 2,470.60

1 Aug, 2014 2,420.00 2,511.95 2,371.00 2,471.60

31 Jul, 2014 2,463.00 2,487.90 2,413.10 2,420.85

30 Jul, 2014 2,410.00 2,479.90 2,372.50 2,467.30

29 Jul, 2014 2,410.35 2,410.35 2,410.35 2,410.35

28 Jul, 2014 2,480.00 2,480.00 2,392.00 2,410.35

25 Jul, 2014 2,485.00 2,496.10 2,450.35 2,475.50

24 Jul, 2014 2,447.00 2,490.00 2,419.00 2,484.40

24-Jul-14 9.00 Dividend

23 Jul, 2014 2,502.05 2,529.35 2,445.10 2,452.00

22 Jul, 2014 2,523.00 2,534.00 2,501.55 2,520.65

21 Jul, 2014 2,510.00 2,540.30 2,464.25 2,522.55

18 Jul, 2014 2,600.00 2,600.00 2,537.45 2,551.95

17 Jul, 2014 2,514.00 2,605.75 2,498.55 2,592.95

16 Jul, 2014 2,525.00 2,536.00 2,507.25 2,513.20

15 Jul, 2014 2,518.00 2,525.90 2,497.10 2,519.30

14 Jul, 2014 2,470.00 2,539.50 2,470.00 2,513.20

11 Jul, 2014 2,528.90 2,530.00 2,455.25 2,488.40

10 Jul, 2014 2,519.00 2,545.00 2,469.75 2,511.40

9 Jul, 2014 2,504.00 2,521.00 2,477.70 2,494.00

8 Jul, 2014 2,575.00 2,575.00 2,492.50 2,499.95

7 Jul, 2014 2,608.90 2,615.90 2,548.00 2,559.90

4 Jul, 2014 2,630.00 2,632.95 2,569.00 2,601.00

3 Jul, 2014 2,647.00 2,654.95 2,595.05 2,628.35

2 Jul, 2014 2,645.00 2,673.00 2,626.00 2,643.30

1 Jul, 2014 2,593.00 2,638.60 2,593.00 2,630.05

30 Jun, 2014 2,597.00 2,627.00 2,580.10 2,591.95

27 Jun, 2014 2,691.75 2,699.80 2,555.25 2,595.90

26 Jun, 2014 2,749.00 2,749.00 2,652.00 2,685.05

25 Jun, 2014 2,708.60 2,735.00 2,681.60 2,724.50

24 Jun, 2014 2,712.00 2,740.00 2,686.95 2,705.75

23 Jun, 2014 2,725.00 2,755.00 2,670.50 2,711.25

20 Jun, 2014 2,756.00 2,771.50 2,709.00 2,727.45

19 Jun, 2014 2,806.00 2,816.10 2,750.05 2,755.40

18 Jun, 2014 2,796.90 2,872.00 2,782.00 2,805.10

17 Jun, 2014 2,732.00 2,813.85 2,713.45 2,796.90

16 Jun, 2014 2,773.00 2,784.00 2,686.00 2,746.65

13 Jun, 2014 2,760.00 2,826.25 2,750.00 2,768.00

12 Jun, 2014 2,768.00 2,803.00 2,719.95 2,768.70

11 Jun, 2014 2,783.10 2,810.00 2,763.00 2,775.50

10 Jun, 2014 2,803.70 2,814.00 2,760.15 2,797.90

9 Jun, 2014 2,708.00 2,847.00 2,700.05 2,800.00

6 Jun, 2014 2,640.00 2,709.00 2,596.55 2,674.70

5 Jun, 2014 2,572.00 2,658.90 2,559.45 2,632.50

4 Jun, 2014 2,535.00 2,586.00 2,535.00 2,571.85

3 Jun, 2014 2,437.35 2,580.00 2,437.35 2,553.50

2 Jun, 2014 2,399.50 2,458.80 2,345.90 2,450.30

30 May, 2014 2,398.00 2,431.00 2,175.00 2,382.20

29 May, 2014 2,386.00 2,472.60 2,375.00 2,392.10

28 May, 2014 2,284.90 2,399.95 2,265.25 2,375.55

27 May, 2014 2,215.00 2,279.55 2,214.00 2,265.45

26 May, 2014 2,289.00 2,357.05 2,186.30 2,236.40

23 May, 2014 2,269.00 2,282.80 2,235.50 2,270.10

22 May, 2014 2,271.00 2,289.90 2,220.00 2,265.05

21 May, 2014 2,359.90 2,359.90 2,250.50 2,270.95

20 May, 2014 2,338.70 2,360.00 2,302.00 2,345.80

19 May, 2014 2,335.00 2,371.65 2,293.20 2,338.65

16 May, 2014 2,251.50 2,554.00 2,231.20 2,334.15

15 May, 2014 2,250.00 2,259.25 2,196.60 2,230.70

14 May, 2014 2,240.00 2,250.00 2,225.00 2,240.60

13 May, 2014 2,188.00 2,235.00 2,164.90 2,220.55

12 May, 2014 2,079.60 2,185.00 2,076.00 2,159.15

9 May, 2014 1,976.00 2,085.65 1,961.60 2,079.60

8 May, 2014 1,961.00 1,984.70 1,950.50 1,980.05

7 May, 2014 2,010.50 2,025.90 1,959.80 1,968.90

6 May, 2014 2,034.00 2,039.00 2,017.05 2,023.80

5 May, 2014 2,040.00 2,049.85 2,003.40 2,030.80

2 May, 2014 2,046.80 2,050.00 2,015.00 2,035.95

1 May, 2014 2,027.15 2,027.15 2,027.15 2,027.15

30 Apr, 2014 2,051.25 2,110.00 2,012.60 2,027.15

29 Apr, 2014 2,076.00 2,113.90 2,021.00 2,066.50

28 Apr, 2014 2,087.60 2,090.00 2,043.00 2,050.75

25 Apr, 2014 2,199.45 2,220.00 2,066.70 2,079.60

24 Apr, 2014 2,169.70 2,169.70 2,169.70 2,169.70

23 Apr, 2014 2,204.00 2,219.00 2,155.00 2,169.70

22 Apr, 2014 2,222.60 2,229.90 2,196.00 2,202.10

21 Apr, 2014 2,220.00 2,239.80 2,210.45 2,219.25

18 Apr, 2014 2,217.60 2,217.60 2,217.60 2,217.60

17 Apr, 2014 2,202.35 2,226.55 2,182.45 2,217.60

16 Apr, 2014 2,224.00 2,235.90 2,186.90 2,200.00

15 Apr, 2014 2,260.00 2,260.00 2,203.30 2,212.15

14 Apr, 2014 2,259.25 2,259.25 2,259.25 2,259.25

11 Apr, 2014 2,210.10 2,280.00 2,210.10 2,259.25

10 Apr, 2014 2,222.00 2,255.95 2,205.05 2,245.80

9 Apr, 2014 2,227.00 2,238.00 2,212.00 2,223.65

8 Apr, 2014 2,225.55 2,225.55 2,225.55 2,225.55

7 Apr, 2014 2,152.10 2,238.80 2,152.10 2,225.55

4 Apr, 2014 2,160.00 2,166.00 2,116.55 2,150.20

3 Apr, 2014 2,130.00 2,174.70 2,114.00 2,147.50

2 Apr, 2014 2,160.35 2,177.35 2,106.35 2,128.60

1 Apr, 2014 2,186.00 2,186.00 2,132.35 2,158.05

31 Mar, 2014 2,160.00 2,195.00 2,159.80 2,186.95

28 Mar, 2014 2,064.00 2,161.80 2,064.00 2,147.10

27 Mar, 2014 1,980.35 2,084.95 1,962.30 2,058.75

26 Mar, 2014 1,986.10 1,994.00 1,982.00 1,989.45

25 Mar, 2014 1,976.50 1,998.00 1,971.60 1,980.20

24 Mar, 2014 1,964.05 1,980.00 1,962.00 1,973.10

21 Mar, 2014 1,952.00 1,965.00 1,931.00 1,955.30

20 Mar, 2014 1,965.05 1,982.10 1,936.60 1,944.55

19 Mar, 2014 1,965.40 1,987.75 1,965.40 1,978.85

18 Mar, 2014 1,979.95 1,983.60 1,960.65 1,968.20

17 Mar, 2014 1,969.95 1,969.95 1,969.95 1,969.95

14 Mar, 2014 1,952.00 1,983.80 1,935.60 1,969.95

13 Mar, 2014 1,970.25 2,017.80 1,950.00 1,958.40

12 Mar, 2014 2,003.30 2,003.30 1,952.40 1,964.45

11 Mar, 2014 1,990.00 2,019.90 1,973.05 2,003.30

10 Mar, 2014 1,952.55 2,009.00 1,952.55 1,989.75

7 Mar, 2014 1,942.30 1,998.00 1,942.30 1,973.75

6 Mar, 2014 1,895.10 1,967.65 1,895.10 1,960.05

5 Mar, 2014 1,888.90 1,910.00 1,855.35 1,897.95

4 Mar, 2014 1,829.25 1,885.90 1,823.55 1,877.55

3 Mar, 2014 1,834.80 1,845.90 1,820.40 1,826.75

28 Feb, 2014 1,851.75 1,864.00 1,826.15 1,839.20

27 Feb, 2014 1,844.10 1,844.10 1,844.10 1,844.10

26 Feb, 2014 1,853.20 1,863.00 1,818.25 1,844.10

25 Feb, 2014 1,838.00 1,879.00 1,834.00 1,865.75

24 Feb, 2014 1,786.00 1,845.00 1,771.15 1,838.15

21 Feb, 2014 1,700.00 1,813.30 1,690.05 1,799.95

20 Feb, 2014 1,693.40 1,716.00 1,675.25 1,702.05

DATE SHARE PRICE NIFTY20-Feb-14 1702.05 8833.621-Feb-14 1799.95 8895.324-Feb-14 1838.15 8869.125-Feb-14 1865.75 8809.3526-Feb-14 1844.1 8805.528-Feb-14 1844.1 8711.553-Mar-14 1839.2 8627.44-Mar-14 1826.75 8565.555-Mar-14 1877.55 8526.356-Mar-14 1897.95 8661.057-Mar-14 1960.05 8711.710-Mar-14 1973.75 8723.711-Mar-14 1989.75 8756.5512-Mar-14 2003.3 8797.413-Mar-14 1964.45 8808.914-Mar-14 1958.4 8952.3518-Mar-14 1969.95 8914.319-Mar-14 1969.95 8910.520-Mar-14 1968.2 8835.621-Mar-14 1978.85 8761.422-Mar-14 1944.55 8729.524-Mar-14 1955.3 8695.625-Mar-14 1973.1 8550.726-Mar-14 1980.2 8513.827-Mar-14 1989.45 8494.1528-Mar-14 2058.75 8277.5531-Mar-14 2147.1 8299.41-Apr-14 2186.95 83232-Apr-14 2158.05 8284.53-Apr-14 2128.6 8234.64-Apr-14 2147.5 8102.17-Apr-14 2150.2 8127.359-Apr-14 2225.55 8378.410-Apr-14 2225.55 8395.4511-Apr-14 2223.65 8282.715-Apr-14 2245.8 8248.2516-Apr-14 2259.25 8246.317-Apr-14 2259.25 8200.721-Apr-14 2212.15 8174.122-Apr-14 2200 826723-Apr-14 2217.6 832425-Apr-14 2217.6 8225.228-Apr-14 2219.25 8159.329-Apr-14 2202.1 8029.830-Apr-14 2169.7 8067.62-May-14 2169.7 8219.65-May-14 2079.6 8224.16-May-14 2050.75 8292.97-May-14 2066.5 8355.658-May-14 2027.15 8340.79-May-14 2027.15 8438.2512-May-14 2035.95 8538.313-May-14 2030.8 8564.414-May-14 2023.8 8537.6515-May-14 1968.9 8524.716-May-14 1980.05 8555.9

19-May-14 2079.6 8588.2520-May-14 2159.15 8494.221-May-14 2220.55 8475.7522-May-14 2240.6 8463.123-May-14 2230.7 8530.1526-May-14 2334.15 8477.3527-May-14 2338.65 8401.928-May-14 2345.8 8382.329-May-14 2270.95 8425.930-May-14 2265.05 8430.752-Jun-14 2270.1 8389.93-Jun-14 2236.4 8357.854-Jun-14 2265.45 8383.35-Jun-14 2375.55 8362.656-Jun-14 2392.1 8344.259-Jun-14 2382.2 833710-Jun-14 2450.3 8338.311-Jun-14 2553.5 8324.1512-Jun-14 2571.85 8322.213-Jun-14 2632.5 8169.216-Jun-14 2674.7 8090.4517-Jun-14 2800 8027.618-Jun-14 2797.9 7991.719-Jun-14 2775.5 8014.5520-Jun-14 2768.7 7995.923-Jun-14 2768 7927.7524-Jun-14 2746.65 7879.425-Jun-14 2796.9 7779.726-Jun-14 2805.1 7748.227-Jun-14 2755.4 786430-Jun-14 2727.45 7884.251-Jul-14 2711.25 7859.952-Jul-14 2705.75 7960.553-Jul-14 2724.5 7842.74-Jul-14 2685.05 7852.47-Jul-14 2595.9 7945.558-Jul-14 2591.95 7964.89-Jul-14 2630.05 7958.910-Jul-14 2643.3 7968.8511-Jul-14 2628.35 7911.8514-Jul-14 2601 8002.415-Jul-14 2559.9 8017.5516-Jul-14 2499.95 8146.317-Jul-14 2494 8121.4518-Jul-14 2511.4 8114.7521-Jul-14 2488.4 7975.522-Jul-14 2513.2 7932.923-Jul-14 2519.3 804224-Jul-14 2513.2 8105.525-Jul-14 2592.95 8085.728-Jul-14 2551.95 8094.130-Jul-14 2522.55 8152.9531-Jul-14 2520.65 8173.91-Aug-14 2452 8086.854-Aug-14 2484.4 8095.955-Aug-14 2475.5 8114.66-Aug-14 2410.35 8083.05

7-Aug-14 2410.35 8027.78-Aug-14 2467.3 7954.3511-Aug-14 2420.85 7936.0512-Aug-14 2471.6 7904.7513-Aug-14 2470.6 7906.314-Aug-14 2603.3 7913.218-Aug-14 2546.65 7891.119-Aug-14 2544.25 7875.320-Aug-14 2474.55 7897.521-Aug-14 2532.65 7874.2522-Aug-14 2613.1 7791.725-Aug-14 2608.1 7739.5526-Aug-14 2632.55 7727.0527-Aug-14 2632.55 7625.9528-Aug-14 2665.15 7568.551-Sep-14 2718.6 7649.252-Sep-14 2684.35 7672.053-Sep-14 2644.9 7746.554-Sep-14 2651.35 7683.655-Sep-14 2629.25 7602.68-Sep-14 2610.85 7721.39-Sep-14 2594.5 7791.410-Sep-14 2550.05 7748.711-Sep-14 2550.05 7790.4512-Sep-14 2643.5 7830.615-Sep-14 2719.25 7795.7516-Sep-14 2713.15 7767.8517-Sep-14 2710.6 7684.218-Sep-14 2670.75 7663.919-Sep-14 2718.05 7640.4522-Sep-14 2694.9 7624.423-Sep-14 2680.4 7526.6524-Sep-14 2686.55 7454.1525-Sep-14 2639.35 7459.626-Sep-14 2589.15 7567.7529-Sep-14 2551.2 758530-Sep-14 2599.85 7623.21-Oct-14 2645.95 7787.157-Oct-14 2641.55 7751.68-Oct-14 2617.25 7714.89-Oct-14 2601.3 7725.1510-Oct-14 2630.65 7634.713-Oct-14 2574 7611.3514-Oct-14 2646 7508.816-Oct-14 2646.65 7493.217-Oct-14 2631.65 7569.2520-Oct-14 2648.75 7580.221-Oct-14 2648.75 7493.3522-Oct-14 2648.75 7511.4523-Oct-14 2648.75 7540.727-Oct-14 2556.7 7558.228-Oct-14 2549.1 7631.729-Oct-14 2570.8 7533.5530-Oct-14 2481.35 7542.131-Oct-14 2481.9 7649.93-Nov-14 2467 7626.855-Nov-14 2467 7656.4

7-Nov-14 2317.6 7654.610-Nov-14 2317.75 7583.411-Nov-14 2450.25 7474.112-Nov-14 2400 7402.2513-Nov-14 2401.2 7415.8514-Nov-14 2401.2 7362.517-Nov-14 2401.2 7229.9518-Nov-14 2430.6 7235.6519-Nov-14 2464.85 7329.6520-Nov-14 2479.3 731821-Nov-14 2512.15 7359.0524-Nov-14 2548.45 7367.125-Nov-14 2559.95 7276.426-Nov-14 2559.95 7252.927-Nov-14 2535.3 7275.528-Nov-14 2535.3 7263.551-Dec-14 2561.9 72032-Dec-14 2581.1 7123.153-Dec-14 2646.6 7108.754-Dec-14 2624.6 7108.755-Dec-14 2577.2 7014.258-Dec-14 2616 6858.89-Dec-14 2561.45 6659.8510-Dec-14 2530.1 6652.5511-Dec-14 2494.75 6715.312-Dec-14 2466.35 6699.3515-Dec-14 2490.7 6694.816-Dec-14 2522.1 6696.417-Dec-14 2467.2 6715.2518-Dec-14 2476.45 6761.2519-Dec-14 2475.2 6782.7522-Dec-14 2484.25 6840.823-Dec-14 2478.2 6815.3524-Dec-14 2473 6817.6526-Dec-14 2474.1 6779.429-Dec-14 2464.65 6675.330-Dec-14 2485.25 6733.131-Dec-14 2512.1 6776.31-Jan-15 2481.75 6796.42-Jan-15 2515.75 6796.25-Jan-15 2484.45 6695.056-Jan-15 2511.5 6694.357-Jan-15 2536.7 6736.18-Jan-15 2484.85 6752.559-Jan-15 2439.3 6721.0512-Jan-15 2446.55 6704.213-Jan-15 2498.35 6695.914-Jan-15 2517 6641.7515-Jan-15 2544.5 6601.416-Jan-15 2620.55 6589.7519-Jan-15 2620.55 6583.520-Jan-15 2602.95 6493.221-Jan-15 2645.4 6483.122-Jan-15 2629.8 6524.0523-Jan-15 2676.05 6516.6527-Jan-15 2662.5 6504.228-Jan-15 2742.1 6493.1

29-Jan-15 2747.7 6516.930-Jan-15 2670.6 6511.92-Feb-15 2660.05 6537.253-Feb-15 2727.45 6526.654-Feb-15 2729.35 6401.155-Feb-15 2700.3 6328.656-Feb-15 2818.5 6297.959-Feb-15 2908.85 6221.4510-Feb-15 3083.05 6276.9511-Feb-15 3070.1 6238.812-Feb-15 3088.5 6200.0513-Feb-15 3096.45 6186.116-Feb-15 3054.8 6155.4518-Feb-15 3122.45 6091.4519-Feb-15 3147.9 3062.3

ULTRATEC NIFTY

0.0575188742986399 0.006984694801666240.0212228117447707 -0.002945375647813890.0150150967004869 -0.00673687296343485

-0.0116039126356694 -0.0004370356496223180 -0.0106694679461701

-0.0026571227156878 -0.00965958985484783-0.0067692474989126 -0.007169019635116070.0278089503216094 -0.004576472030400720.0108652232963171 0.01579808476077090.0327195131589346 0.00584802073651595

0.00698961761179564 0.001377457901442890.00810639645345155 0.003765604044155410.00680990074129914 0.00466507928350782-0.0193930015474467 0.00130720440130038-0.0030797424215429 0.01628466664396240.00589767156862743 -0.00425028065256621

0 -0.000426281368138752-0.000888347419985279 -0.00840581336625326

0.00541103546387555 -0.00839784508126225-0.0173332996437325 -0.003640970621133570.00552827132241393 -0.003883383928059980.00910346238428883 -0.01666359998159980.00359839845927735 -0.004315436163121320.00467124532875467 -0.00230801757147216

0.0348337480208098 -0.02549990287433120.0429143897996357 0.002639669950649690.0185599180289693 0.00284357905390756

-0.0132147511374287 -0.00462573591253154-0.0136465790876024 -0.006023296517593050.00887907544865174 -0.01609064192553370.00125727590221179 0.00311647597536441

0.0350432517905313 0.03088952733670870 0.00203499474840078

-0.000853721551975957 -0.01342989357330460.00996109999325437 -0.004159271735062330.00598895716448473 -0.000236413784742306

0 -0.00552975273759123-0.0208476264246984 -0.00324362554416091

-0.00549239427706082 0.01136516558397860.00799999999999996 0.00689488327083585

0 -0.01186929360884180.00074404761904766 -0.0080119632349366

-0.00772783598062413 -0.015871459561482-0.0147132282820944 0.00470746469401482

0 0.018840795279885-0.0415264783149744 0.000547471896442649-0.0138728601654164 0.008365657032380350.00768011703035475 0.0075667136948474-0.0190418582143721 -0.00178920849963784

0 0.01169566103564440.00434106997508816 0.0118567238467691

-0.00252953166826302 0.00305681458838415-0.00344691747094741 -0.00312339451683714

-0.0271271864808775 -0.001516810832020390.00566306059220878 0.00365995284291517

0.0502765081689856 0.00378101660842230.0382525485670322 -0.01095100864553310.0284371164578654 -0.00217207035388862

0.00902929454414434 -0.00149249328967934-0.00441845934124792 0.00792262882395331

0.0463755771730848 -0.006189809088937390.00192789666473877 -0.00890018696880520.00305731939366733 -0.00233280567490691-0.0319080910563562 0.00520143635994898

-0.00259803166075855 0.0005756061667003360.00222953135692357 -0.00484535776769568

-0.014845161006123 -0.003820069369122310.01298962618494 0.00304504148794234

0.0485996159703372 -0.002463230470101230.00696680768664087 -0.00220025948712425

-0.00413862296726729 -0.000868861791053720.0285870204013099 0.000155931390188230.0421172917601926 -0.00169698859479746

0.00718621499902092 -0.0002342581524839060.0235822462429769 -0.01838456177453090.0160303893637226 -0.009639866816824170.0468463752944256 -0.0077684183203653

-0.000749999999999968 -0.00447207135382936-0.00800600450337757 0.00285921643705349-0.00245000900738612 -0.00232701773649182

-0.000252826236139639 -0.00852311809802519-0.00771315028901731 -0.00609883005897012

0.0182950139260554 -0.01265324770921640.00293181736923015 -0.0040489993187398-0.0177177284232291 0.0149454066750988-0.0101437177905205 0.00257502543234995-0.0059396139250948 -0.0030820940482608

-0.00202858460119871 0.01279906360727490.00692968677815763 -0.0148042534749484-0.0144797210497338 0.00123681895265659-0.0332023612223236 0.0118626152513882

-0.00152163026310731 0.00242273977257710.0146993576264976 -0.000740759341100912

0.00503792703560769 0.00125017276256778-0.00565580902659565 -0.00715285141519793

-0.0104057678771853 0.0114448580294115-0.0158016147635524 0.00189318204538645-0.0234188835501388 0.0160585216182001

-0.00238004760095195 -0.003050464628113420.00697674418604655 -0.000824975835595838

-0.00915823843274667 -0.01716010967682310.00996624336923313 -0.005341357908595120.00242718446601956 0.0137528520465404

-0.00242130750605341 0.007896045759761250.031732452650008 -0.00244278576275371

-0.0158121059025434 0.00103887109341189-0.0115206018926702 0.0072707280611803

-0.000753206081148081 0.00256962203864857-0.0272350385813183 -0.01064975103683670.0132137030995106 0.00112528363948873

-0.0035823538882628 0.00230362094627567-0.0263179155726116 -0.00388805363172555

0 -0.006847662701579280.0236272740473376 -0.00913711274711305

-0.0188262473148787 -0.0023006279582870.0209637110932111 -0.00394402757039083

-0.000404596212979447 0.0001960846326576020.0537116489921478 0.000872721753538272

-0.0217608420082204 -0.00279280190062168-0.000942414544597841 -0.00200225570579516

-0.0273951066129507 0.002818940230848330.0234790163868178 -0.002943969610636280.0317651471778571 -0.0104835381147411

-0.00191343614863572 -0.006693019495103720.00937464054292407 -0.00161508098016035

0 -0.01308390653612960.0123834305141402 -0.007526931070882920.0200551563701855 0.0106625443446895

-0.0125983962333554 0.00298068438082167-0.0146962951925046 0.009710572793451560.00243865552572869 -0.00811974362780858-0.0083353763177249 -0.010548372192903

-0.00699819340116006 0.0156130797358798-0.00626232836049559 0.00907878207037668

-0.0171323954519174 -0.005480401468285520 0.00538800056783719

0.0366463402678378 0.005153745932520020.0286551919803291 -0.00445048910683733

-0.00224326560632524 -0.00357887310393479-0.000939866944326772 -0.0107687455344787

-0.0147015420940013 -0.002641784440800630.0177103809791258 -0.0030597998408121

-0.00851713544636783 -0.00210066161024549-0.00538053360050466 -0.01282068097161740.00229443366661696 -0.00963243939867006-0.0175690011352851 0.000731136346867279-0.0190198344289313 0.0144980964126762-0.0146573199698744 0.00227940933566780.0190694575101913 0.005036255767963060.0177317922187818 0.0215067163395949

-0.00166291880043071 -0.00456521320380361-0.00919914444171043 -0.00474740698694465

-0.0060941828254847 0.001341577228184720.0112828201283973 -0.0117085105143589

-0.0215346017144052 -0.003058404390480240.027972027972028 -0.0134732997431468

0.000245653817082423 -0.00207756232686985-0.00566754198704022 0.01014920194309510.00649782455873688 0.00144664266605011

0 -0.01145748133294630 0.002415475054548290 0.00389405507591743

-0.0347522416234073 0.00232073945389685-0.00297258184378297 0.009724537588314680.00851280844219539 -0.0128608304833785-0.0347946164618019 0.00113492311061852

0.000221653535373963 0.0142931013908592-0.00600346508723159 -0.00301311128250033

0 0.00387446980076955

-0.060559383867045 -0.0002350974348256726.47221263376299E-05 -0.00930159642567877

0.0571675115952972 -0.014413060104966-0.0205081114172023 -0.00961319757562788

0.000499999999999924 0.001837279205646980 -0.007194050580850520 -0.0180033955857386

0.0122438780609696 0.0007883871949321670.0140911709043035 0.0129912309191296

0.00586242570541829 -0.001589434693334560.013249707578752 0.00560945613555619

0.0144497740978842 0.001093891195195060.0045125468421982 -0.0123114929891003

0 -0.0032296190423836-0.00962909431824826 0.00311599498131787

0 -0.001642498797333490.0104918550072969 -0.00833614417192698

0.00749443772200313 -0.01108565875329730.0253767773429933 -0.00202157753241187

-0.00831255195344971 0-0.0180598948411187 -0.01329347634956920.0150550985565731 -0.0221620273015646

-0.0208524464831805 -0.0290065317548259-0.0122391614124812 -0.00109612078350116-0.0139717797715505 0.00943247326213257-0.0113839062030264 -0.002375173112146860.0098728890871125 -0.0006791703672744640.0126068976592926 0.000238991456055365

-0.0217675746401808 0.002814945343766850.00374918936446174 0.00685008004169614

-0.000504754790122958 0.003179885376224810.00365627020038792 0.00855847554458003-0.0024353426587502 -0.00372032510817446

-0.00209829715115803 0.0003374734973257830.000444803881924751 -0.0056104376141339-0.00381957075300102 -0.01535534118063540.00835818473211203 0.00865878687100208

0.0108037420782617 0.00641606392300721-0.0120815254169818 0.002966220503814690.0137000100735368 -2.94273438879139E-05

-0.0124416178078109 -0.01488331714781780.0108877216285295 -0.0001045548576933430.0100338443161457 0.00623660250808518

-0.0204399416564828 0.00244206588381999-0.0183310863834838 -0.004664904369460430.00297216414545156 -0.00250704874982337

0.0211726717214035 -0.00123802989170970.00746492685172217 -0.00808703833689267

0.0109257052046087 -0.006075206082734270.0298879937119278 -0.00176477716847936

0 -0.000948442657156948-0.00671614737364308 -0.0137161084529506

0.016308419293494 -0.00155547341834526-0.00589702880471759 0.00631642269901742

0.0175868887367861 -0.00113426475885386-0.00506343304497307 -0.00191049081966959

0.0298967136150234 -0.00170658958826596

0.002042230407352 0.00366542945588383-0.0280598318593733 -0.00076723595574583

-0.00395042312588921 0.003892873047804840.0253378695889174 -0.0016214769207236

0.000696621386276592 -0.0192288540062666-0.0106435598219355 -0.01132608984323130.0437729141206532 -0.004850955575043620.0320560581869789 -0.0121468096761645

0.05988620932671 0.00892074998593576-0.0042003859814146 -0.00607779255848774

0.005993290120843 -0.006211130345579280.00257406508013593 -0.00224998185498501-0.0134508873064314 -0.004954656407106340.0221454759722403 -0.01039729020624

0.00815065093115991 -0.4972789729867270.655281976034731

RM-RF

0.06 -0.6888153051983340.02 -0.6987453756478140.02 -0.702536872963435

-0.01 -0.6962370356496220.00 -0.706469467946170.00 -0.705459589854848

-0.01 -0.702969019635116 0.03 -0.700376472030401 0.01 -0.6800019152392290.03 -0.6899519792634840.01 -0.694422542098557 risk in month0.01 -0.6920343959558450.01 -0.691134920716492 ULTRATEC

-0.02 -0.6944927955987 NIFTY0.00 -0.6795153333560380.01 -0.7000502806525660.00 -0.6962262813681390.00 -0.7042058133662530.01 -0.704197845081262

-0.02 -0.6994409706211340.01 -0.699683383928060.01 -0.71246359998160.00 -0.7001154361631210.00 -0.6981080175714720.03 -0.7212999028743310.04 -0.693160330049350.02 -0.692956420946092

-0.01 -0.700425735912532-0.01 -0.7018232965175930.01 -0.7118906419255340.00 -0.6926835240246360.04 -0.6649104726632910.00 -0.6937650052515990.00 -0.7092298935733050.01 -0.6999592717350620.01 -0.6960364137847420.00 -0.701329752737591

-0.02 -0.699043625544161-0.01 -0.6844348344160210.01 -0.6889051167291640.00 -0.7076692936088420.00 -0.703811963234937

-0.01 -0.711671459561482-0.01 -0.6910925353059850.00 -0.676959204720115

-0.04 -0.695252528103557-0.01 -0.687434342967620.01 -0.688233286305153

-0.02 -0.6975892084996380.00 -0.6841043389643560.00 -0.6839432761532310.00 -0.6927431854116160.00 -0.698923394516837

-0.03 -0.697316810832020.01 -0.692140047157085

0.05 -0.6920189833915780.04 -0.7067510086455330.03 -0.6979720703538890.01 -0.6972924932896790.00 -0.6878773711760470.05 -0.7019898090889370.00 -0.7047001869688050.00 -0.698132805674907

-0.03 -0.6905985636400510.00 -0.69522439383330.00 -0.700645357767696

-0.01 -0.6996200693691220.01 -0.6927549585120580.05 -0.6982632304701010.01 -0.6980002594871240.00 -0.6966688617910540.03 -0.6956440686098120.04 -0.6974969885947980.01 -0.6960342581524840.02 -0.7141845617745310.02 -0.7054398668168240.05 -0.7035684183203650.00 -0.700272071353829

-0.01 -0.6929407835629470.00 -0.6981270177364920.00 -0.704323118098025

-0.01 -0.701898830058970.02 -0.7084532477092160.00 -0.69984899931874

-0.02 -0.680854593324901-0.01 -0.69322497456765-0.01 -0.6988820940482610.00 -0.6830009363927250.01 -0.710604253474948

-0.01 -0.694563181047343-0.03 -0.6839373847486120.00 -0.6933772602274230.01 -0.6965407593411010.01 -0.694549827237432

-0.01 -0.702952851415198-0.01 -0.684355141970588-0.02 -0.693906817954614-0.02 -0.67974147838180.00 -0.6988504646281130.01 -0.696624975835596

-0.01 -0.7129601096768230.01 -0.7011413579085950.00 -0.682047147953460.00 -0.6879039542402390.03 -0.698242785762754

-0.02 -0.694761128906588-0.01 -0.688529271938820.00 -0.693230377961352

-0.03 -0.7064497510368370.01 -0.6946747163605110.00 -0.693496379053724

-0.03 -0.699688053631726

0.00 -0.7026476627015790.02 -0.704937112747113

-0.02 -0.6981006279582870.02 -0.6997440275703910.00 -0.6956039153673420.05 -0.694927278246462

-0.02 -0.6985928019006220.00 -0.697802255705795

-0.03 -0.6929810597691520.02 -0.6987439696106360.03 -0.7062835381147410.00 -0.7024930194951040.01 -0.697415080980160.00 -0.708883906536130.01 -0.7033269310708830.02 -0.685137455655311

-0.01 -0.692819315619178-0.01 -0.6860894272065480.00 -0.703919743627809

-0.01 -0.706348372192903-0.01 -0.68018692026412-0.01 -0.686721217929623-0.02 -0.7012804014682860.00 -0.6904119994321630.04 -0.690646254067480.03 -0.7002504891068370.00 -0.6993788731039350.00 -0.706568745534479

-0.01 -0.6984417844408010.02 -0.698859799840812

-0.01 -0.697900661610245-0.01 -0.7086206809716180.00 -0.70543243939867

-0.02 -0.695068863653133-0.02 -0.681301903587324-0.01 -0.6935205906643320.02 -0.6907637442320370.02 -0.6742932836604050.00 -0.700365213203804

-0.01 -0.700547406986945-0.01 -0.6944584227718150.01 -0.707508510514359

-0.02 -0.698858404390480.03 -0.7092732997431470.00 -0.69787756232687

-0.01 -0.6856507980569050.01 -0.694353357333950.00 -0.7072574813329460.00 -0.6933845249454520.00 -0.691905944924083

-0.03 -0.6934792605461030.00 -0.6860754624116850.01 -0.708660830483379

-0.03 -0.6946650768893820.00 -0.681506898609141

-0.01 -0.69881311128250.00 -0.69192553019923

-0.06 -0.6960350974348260.00 -0.7051015964256790.06 -0.710213060104966

-0.02 -0.7054131975756280.00 -0.6939627207943530.00 -0.7029940505808510.00 -0.7138033955857390.01 -0.6950116128050680.01 -0.682808769080870.01 -0.6973894346933350.01 -0.6901905438644440.01 -0.6947061088048050.00 -0.70811149298910.00 -0.699029619042384

-0.01 -0.6926840050186820.00 -0.6974424987973330.01 -0.7041361441719270.01 -0.7068856587532970.03 -0.697821577532412

-0.01 -0.6958-0.02 -0.7090934763495690.02 -0.717962027301565

-0.02 -0.724806531754826-0.01 -0.696896120783501-0.01 -0.686367526737867-0.01 -0.6981751731121470.01 -0.6964791703672750.01 -0.695561008543945

-0.02 -0.6929850546562330.00 -0.6889499199583040.00 -0.6926201146237750.00 -0.687241524455420.00 -0.6995203251081740.00 -0.6954625265026740.00 -0.7014104376141340.00 -0.7111553411806350.01 -0.6871412131289980.01 -0.689383936076993

-0.01 -0.6928337794961850.01 -0.695829427343888

-0.01 -0.7106833171478180.01 -0.6959045548576930.01 -0.689563397491915

-0.02 -0.69335793411618-0.02 -0.700464904369460.00 -0.6983070487498230.02 -0.697038029891710.01 -0.7038870383368930.01 -0.7018752060827340.03 -0.6975647771684790.00 -0.696748442657157

-0.01 -0.7095161084529510.02 -0.697355473418345

-0.01 -0.6894835773009830.02 -0.696934264758854

-0.01 -0.697710490819670.03 -0.697506589588266

0.00 -0.692134570544116-0.03 -0.6965672359557460.00 -0.6919071269521950.03 -0.6974214769207240.00 -0.715028854006267

-0.01 -0.7071260898432310.04 -0.7006509555750440.03 -0.7079468096761640.06 -0.6868792500140640.00 -0.7018777925584880.01 -0.7020111303455790.00 -0.698049981854985

-0.01 -0.7007546564071060.02 -0.706197290206240.01 -1.19307897298673

-0.69937008409424

-0.363111293725121-0.00150045989-0.54766786037

0.6958

0.988338517573044 98.8338517573-1.29769606342903 -129.769606343