roll no.

name maths science sst gk english total maximum marks

1 NIKITA 45 66 66 57 66 300 66
2 MAYA 67 78 77 68 78 368 78
3 DIA 78 67 55 78 77 355 78
4 RACHNA 23 56 44 33 34 190 56
5 PRERNA 67 66 67 56 75 331 75
6 RAHUL 77 55 76 67 64 339 77

RANDOM PASTE SPECIAL

29.40411 27.43545388 19.50937749 8.828456 14.07569 38.373597108228
13.81111 13.8180269 6.161324204 21.20387 39.71328 1.6659123313476
22.61526 13.09564622 3.688077491 28.8119 7.392703 34.408029082489
21.96584 1.905038762 17.35607725 23.25419 30.52715 24.692304562263
15.17785 17.06164058 22.84245362 19.22608 2.804722 7.0687985231422
38.76484 20.74981393 27.00965895 4.655014 23.40749 11.910861969559

7-Sep

ROUND
5644763.32432

round of two decimal places= 5644763.32

Round to whole number = 5644763
MULTIPLE OF 10 = 5644760
MULTIPLE OF 100 = 5644800
MULTIPLE OF 1000= 5645000

ROUND UP
5644763.33
5644770

8-Sep
GENERATE A RANDOM WHOLE NUMBER B/W 50,100 =

generate 10 random nos. b/w 100 and 1000 which are multiple of 10 =

Generate 10 random nos. b/w 100 and 1000 which are multiple of 5 =
RAND BETWEEN =
MULTIPLE OF 10 =
minimum marks range percentage average pass/fail grades scholarship 40%
45 21 60 60 PASS A 1000 12000%
67 11 73.6 73.6 PASS A 1000 14720%
55 23 71 71 PASS A 1000 14200%
23 33 38 38 FAIL B 0 7600%
56 19 66.2 66.2 PASS A 1000 13240%
55 22 67.8 67.8 PASS A 1000 13560%

ROUND DOWN
5644763.32
5644760

95

990 810 570 270 360

400 840 250 120 800

955 850 745 390 120

815 310 955 450 825
487
870
 M/S ALPHA Ltd.
PAYROLL
0.5 0.41 0.3 0.08
IS HRA is to be paid
CODE NAME CAT basic DP DA HRA TA CCA GROSS IT
1 RAHUL A Y 25000 12500 15375 11250 5000 1000 70125 5610
2 MEENA B N 20000 10000 12300 0 4000 800 47100 3768
3 RIA A N 25000 12500 15375 0 5000 1000 58875 4710
4 RAJ C Y 15000 7500 9225 6750 3000 500 41975 3358
5 ROHAN A Y 25000 12500 15375 11250 5000 1000 70125 5610

TOTAL 110000 55000 67650 29250 22000 4300 288200 23056

 0.1

GPF TOTAL DED NET

7013 12623 57503
4710 8478 38622
5888 10598 48278
4198 7556 34420
7013 12623 57503

28820 51876 236324

 10 20 30 40 50
1 10 20 30 40 50
2 20 40 60 80 100
3 30 60 90 120 150
4 40 80 120 160 200
5 50 100 150 200 250
6 60 120 180 240 300
7 70 140 210 280 350
8 80 160 240 320 400
9 90 180 270 360 450
10 100 200 300 400 500

QUAN 2000 3000 4000 5000

PRICE
100 200000 300000 400000 500000
200 400000 600000 800000 1000000
300 600000 900000 1200000 1500000
400 800000 1200000 1600000 2000000
500 1000000 1500000 2000000 2500000
 BETA LTD
PAYROLL
0.3
0.22 0.2 0.2

EMPLOYEES TARGETS DISTANCE BASIC SALARY DA HRA BONUS TA GROSS PF NSC PPF
A 38576 9 40000 8800 12000 5786.4 5000 71586.4 9760 2400 1500
B 24746 24 40000 8800 12000 3711.9 7000 71511.9 9760 2400 1500
C 7770 16 33000 7260 9900 388.5 7000 57548.5 8052 2400 1500
D 41458 4 25000 5500 5000 10364.5 2000 47864.5 6100 2400 1500
E 25892 27 16000 4500 4000 3883.8 7000 35383.8 4100 2400 1500
F 41204 26 42000 9240 12600 10301 7000 81141 10248 2400 1500
G 37991 18 23000 5060 4600 5698.65 7000 45358.65 5612 2400 1500
H 31878 23 45000 9900 13500 4781.7 7000 80181.7 10980 2400 1500
I 21356 4 43000 9460 12900 3203.4 2000 70563.4 10492 2400 1500
J 41746 25 30000 6600 9000 10436.5 7000 63036.5 7320 2400 1500

0
 0.15

LIC PM TOTAL DED IT NET

4000 1000 18660 7940 44986.4 12 34000 43361
4000 1000 18660 7930 44921.9 11 8982
4000 1000 16952 6090 34506.5 2 18109
4000 1000 15000 4930 27934.5 8 37511
4000 1000 13000 3360 19023.8 5 25439
4000 1000 19148 9300 52693 5 9609
4000 1000 14512 4630 26216.65 11 31385
4000 1000 19880 9050 51251.7 11 13456
4000 1000 19392 7680 43491.4 4 35780
4000 1000 16220 7020 39796.5 7 10708
 M/S KRISNA Ltd
PAYROLL
0.1 0.25
EMPLOYEE
BASIC
IDENTIFICATION NAME CATEGORY DISTANCE DA TA HRA GROSS
PAY
(EmpID)
165 A B 21 43000 3000 4500 10750 61250
298 B C 1 27000 2700 3000 1000 33700
203 C B 19 35000 3000 4500 8750 51250
129 D A 28 31000 2000 4500 7750 45250
209 E C 30 34000 3400 4500 8500 50400
375 F B 6 30000 3000 3000 1000 37000
424 G A 13 43000 2000 4500 10750 60250
282 H B 24 31000 3000 4500 7750 46250
354 I C 24 37000 3700 4500 9000 54200
414 J A 28 41000 2000 4500 10250 57750
A Ltd
0.15
LIFE
PF TOTAL DED IT NET BASIC PAY
INSURANCE
EMPID
8510 15000 23510 5661 32079 27000 247
4610 15000 19610 1409 12681 40000 314
7010 15000 22010 4386 24854 30000 157
6110 15000 21110 3621 20519 37000 266
6890 15000 21890 4276.5 24233.5 28000 142
5100 15000 20100 1690 15210 44000 460
8360 15000 23360 5533.5 31356.5 31000 178
6260 15000 21260 3748.5 21241.5 32000 109
7460 15000 22460 4761 26979 40000 243
7990 15000 22990 5214 29546 40000 484
DISTANCE
18
28
28
4
6
26
7
26
5
23
 XYZ PVT. LTD.
PAYROLL

0.25
EMPLOYEES TARGETS no. of years CATEGORY BASIC SALARY
DA DP
A 11 B 14858 3710 2228.7
B 13 C 13090 3270 2618
C 6A 22348 5590 2234.8
D 4C 19253 4810 3850.6
E 7B 25326 6330 3798.9
F 2A 25556 6390 2555.6
G 12 B 21618 5400 3242.7
H 5C 25170 6290 5034
I 19 A 28651 7160 2865.1
J 10 A 15250 3810 1525
. LTD.
0.2
0.5 0.1
CHILD NO. of
GROSS PF IT Net salary
TA HRA ALLOW. children
5000 7429 5 5200
8000 6545 0 4580
3000 11174 4 7820
8000 9626.5 0 6740
5000 12663 2 8860
3000 12778 1 8950
5000 10809 0 7560
8000 12585 5 8810
3000 14325.5 2 10030
3000 7625 1 5340
experience no of child BASICPAY
16 5 11701
17 4 23465
7 2 24907
15 3 20334
11 5 15594
20 4 17916
5 4 18865
9 0 13274
5 4 26048
9 1 23425
4 27850
 M/S LUKE Ltd

0.5 0.27 0.5 0.15 0.15

DISTANCE
emp ID NAME COVERED No. of yrs BASIC PAY DP DA TA HRA INCENTIVE GROSS PF TOT DED
A 8 25 28482 14241 21930 3000 14241 40440
B 6 7 30785 15392.5 23700 3000 15392.5 43710
C 4 5 44737 22368.5 34450 3000 22368.5 63530
D 13 9 42924 21462 33050 4500 21462 60950
E 9 35 27905 13952.5 21490 3000 13952.5 39630
F 14 8 29312 14656 22570 4500 14656 41620
G 8 8 39053 19526.5 30070 3000 19526.5 55450
H 5 32 44652 22326 34380 3000 22326 63400
I 11 28 26834 13417 20660 4500 13417 38100
J 1 35 34842 17421 26830 3000 17421 49480
IT NET DISTANCE SERVICE
BASIC PAY YRS
10 27640 13
2 42772 5
11 28119 14
16 42350 15
2 26342 9
16 32903 15
4 43848 33
5 36478 24
18 29728 29
12 36867 24
P 200000
R 0.1
T 6 YRS
PERIODICITY 4 QUARTERLY
EFF RATE 0.025
NPER 24
INSTALLMENT ₹ 11,182.56

SR. NO. Opn. Balance INTEREST INSTALLMENT Clos. Balance

1 200000 5000 ₹ 11,182.56 ₹ 193,817.44
2 ₹ 193,817.44 ₹ 4,845.44 ₹ 11,182.56 ₹ 187,480.31
3 ₹ 187,480.31 ₹ 4,687.01 ₹ 11,182.56 ₹ 180,984.75
4 ₹ 180,984.75 ₹ 4,524.62 ₹ 11,182.56 ₹ 174,326.81
5 ₹ 174,326.81 ₹ 4,358.17 ₹ 11,182.56 ₹ 167,502.41
6 ₹ 167,502.41 ₹ 4,187.56 ₹ 11,182.56 ₹ 160,507.41
7 ₹ 160,507.41 ₹ 4,012.69 ₹ 11,182.56 ₹ 153,337.53
8 ₹ 153,337.53 ₹ 3,833.44 ₹ 11,182.56 ₹ 145,988.40
9 ₹ 145,988.40 ₹ 3,649.71 ₹ 11,182.56 ₹ 138,455.55
10 ₹ 138,455.55 ₹ 3,461.39 ₹ 11,182.56 ₹ 130,734.37
11 ₹ 130,734.37 ₹ 3,268.36 ₹ 11,182.56 ₹ 122,820.17
12 ₹ 122,820.17 ₹ 3,070.50 ₹ 11,182.56 ₹ 114,708.11
13 ₹ 114,708.11 ₹ 2,867.70 ₹ 11,182.56 ₹ 106,393.25
14 ₹ 106,393.25 ₹ 2,659.83 ₹ 11,182.56 ₹ 97,870.52
15 ₹ 97,870.52 ₹ 2,446.76 ₹ 11,182.56 ₹ 89,134.71
16 ₹ 89,134.71 ₹ 2,228.37 ₹ 11,182.56 ₹ 80,180.52
17 ₹ 80,180.52 ₹ 2,004.51 ₹ 11,182.56 ₹ 71,002.47
18 ₹ 71,002.47 ₹ 1,775.06 ₹ 11,182.56 ₹ 61,594.96
19 ₹ 61,594.96 ₹ 1,539.87 ₹ 11,182.56 ₹ 51,952.27
20 ₹ 51,952.27 ₹ 1,298.81 ₹ 11,182.56 ₹ 42,068.52
21 ₹ 42,068.52 ₹ 1,051.71 ₹ 11,182.56 ₹ 31,937.67
22 ₹ 31,937.67 ₹ 798.44 ₹ 11,182.56 ₹ 21,553.54
23 ₹ 21,553.54 ₹ 538.84 ₹ 11,182.56 ₹ 10,909.82
24 ₹ 10,909.82 ₹ 272.75 ₹ 11,182.56 ₹ 0.00
YEARLY
HALF YEARLY
QUARTERLY
BI MONTHLY
MONTHLY
P 200000 YEARLY
R 0.1 HALF YEARLY
T 6 YRS QUARTERLY
PERIODICITY 4 QUARTERLY BI MONTHLY
EFF RATE 0.025 MONTHLY
NPER 24
INSTALLMENT ₹ 11,182.56

SR. NO. Opn. Balance INTEREST INSTALLMENT Clos. Balance

1 200000 5000 ₹ 11,182.56 ₹ 193,817.44
2 ₹ 193,817.44 ₹ 4,845.44 ₹ 11,182.56 ₹ 187,480.31
3 ₹ 187,480.31 ₹ 4,687.01 ₹ 11,182.56 ₹ 180,984.75
4 ₹ 180,984.75 ₹ 4,524.62 ₹ 11,182.56 ₹ 174,326.81
5 ₹ 174,326.81 ₹ 4,358.17 ₹ 11,182.56 ₹ 167,502.41
6 ₹ 167,502.41 ₹ 4,187.56 ₹ 11,182.56 ₹ 160,507.41
7 ₹ 160,507.41 ₹ 4,012.69 ₹ 11,182.56 ₹ 153,337.53
8 ₹ 153,337.53 ₹ 3,833.44 ₹ 11,182.56 ₹ 145,988.40
9 ₹ 145,988.40 ₹ 3,649.71 ₹ 11,182.56 ₹ 138,455.55
10 ₹ 138,455.55 ₹ 3,461.39 ₹ 11,182.56 ₹ 130,734.37
11 ₹ 130,734.37 ₹ 3,268.36 ₹ 11,182.56 ₹ 122,820.17
12 ₹ 122,820.17 ₹ 3,070.50 ₹ 11,182.56 ₹ 114,708.11
13 ₹ 114,708.11 ₹ 2,867.70 ₹ 11,182.56 ₹ 106,393.25
14 ₹ 106,393.25 ₹ 2,659.83 ₹ 11,182.56 ₹ 97,870.52
15 ₹ 97,870.52 ₹ 2,446.76 ₹ 11,182.56 ₹ 89,134.71
16 ₹ 89,134.71 ₹ 2,228.37 ₹ 11,182.56 ₹ 80,180.52
17 ₹ 80,180.52 ₹ 2,004.51 ₹ 11,182.56 ₹ 71,002.47
18 ₹ 71,002.47 ₹ 1,775.06 ₹ 11,182.56 ₹ 61,594.96
19 ₹ 61,594.96 ₹ 1,539.87 ₹ 11,182.56 ₹ 51,952.27
20 ₹ 51,952.27 ₹ 1,298.81 ₹ 11,182.56 ₹ 42,068.52
21 ₹ 42,068.52 ₹ 1,051.71 ₹ 11,182.56 ₹ 31,937.67
22 ₹ 31,937.67 ₹ 798.44 ₹ 11,182.56 ₹ 21,553.54
23 ₹ 21,553.54 ₹ 538.84 ₹ 11,182.56 ₹ 10,909.82
24 ₹ 10,909.82 ₹ 272.75 ₹ 11,182.56 ₹ 0.00
P 1000000 YEARLY
R 12% HALF YEARLY
T 10 YRS QUARTERLY
PERIODICITY 2 HALF YEARLY BI MONTHLY
EFF RATE 0.06 MONTHLY
NPER 20
INSTALLMENT ₹ 87,184.56
principal in 20th installment =
SR NO. OB INTEREST INSTALLMENT CB
1 1000000.00 60000.00 87184.56 972815.44
2 972815.44 58368.93 87184.56 943999.81
3 943999.81 56639.99 87184.56 913455.24
4 913455.24 54807.31 87184.56 881078.00
5 881078.00 52864.68 87184.56 846758.13
6 846758.13 50805.49 87184.56 810379.06
7 810379.06 48622.74 87184.56 771817.24
8 771817.24 46309.03 87184.56 730941.72
9 730941.72 43856.50 87184.56 687613.67
10 687613.67 41256.82 87184.56 641685.93
11 641685.93 38501.16 87184.56 593002.53
12 593002.53 35580.15 87184.56 541398.12
13 541398.12 32483.89 87184.56 486697.45
14 486697.45 29201.85 87184.56 428714.74
15 428714.74 25722.88 87184.56 367253.07
16 367253.07 22035.18 87184.56 302103.70
17 302103.70 18126.22 87184.56 233045.36
18 233045.36 13982.72 87184.56 159843.53
19 159843.53 9590.61 87184.56 82249.58
20 82249.58 4934.97 87184.56 0.00
0.00
 PHASE 1
P 350000
T 5 years
P1 280000 0.8
R1 10%
T1(change after) 3 yrs
periodicity 1 12 monthly
NPER 1 36
EFF RATE 1 0.008333333333
INSTALLMENT 1 ₹ 9,618.15
TOTAL NO. OF INSTALLMENTS 44
PERIOD OPENING BAL. INTEREST DUE INSTALLMENT CLOS BAL.
1 ₹ 350,000.00 ₹ 2,916.67 ₹ 9,618.15 ₹ 343,298.52
2 ₹ 343,298.52 ₹ 2,860.82 ₹ 9,618.15 ₹ 336,541.20
3 ₹ 336,541.20 ₹ 2,804.51 ₹ 9,618.15 ₹ 329,727.56
4 ₹ 329,727.56 ₹ 2,747.73 ₹ 9,618.15 ₹ 322,857.14
5 ₹ 322,857.14 ₹ 2,690.48 ₹ 9,618.15 ₹ 315,929.47
6 ₹ 315,929.47 ₹ 2,632.75 ₹ 9,618.15 ₹ 308,944.07
7 ₹ 308,944.07 ₹ 2,574.53 ₹ 9,618.15 ₹ 301,900.46
8 ₹ 301,900.46 ₹ 2,515.84 ₹ 9,618.15 ₹ 294,798.15
9 ₹ 294,798.15 ₹ 2,456.65 ₹ 9,618.15 ₹ 287,636.66
10 ₹ 287,636.66 ₹ 2,396.97 ₹ 9,618.15 ₹ 280,415.49
11 ₹ 280,415.49 ₹ 2,336.80 ₹ 9,618.15 ₹ 273,134.14
12 ₹ 273,134.14 ₹ 2,276.12 ₹ 9,618.15 ₹ 265,792.11
13 ₹ 265,792.11 ₹ 2,214.93 ₹ 9,618.15 ₹ 258,388.90
14 ₹ 258,388.90 ₹ 2,153.24 ₹ 9,618.15 ₹ 250,923.99
15 ₹ 250,923.99 ₹ 2,091.03 ₹ 9,618.15 ₹ 243,396.88
16 ₹ 243,396.88 ₹ 2,028.31 ₹ 9,618.15 ₹ 235,807.04
17 ₹ 235,807.04 ₹ 1,965.06 ₹ 9,618.15 ₹ 228,153.95
18 ₹ 228,153.95 ₹ 1,901.28 ₹ 9,618.15 ₹ 220,437.09
19 ₹ 220,437.09 ₹ 1,836.98 ₹ 9,618.15 ₹ 212,655.92
20 ₹ 212,655.92 ₹ 1,772.13 ₹ 9,618.15 ₹ 204,809.91
21 ₹ 204,809.91 ₹ 1,706.75 ₹ 9,618.15 ₹ 196,898.51
22 ₹ 196,898.51 ₹ 1,640.82 ₹ 9,618.15 ₹ 188,921.19
23 ₹ 188,921.19 ₹ 1,574.34 ₹ 9,618.15 ₹ 180,877.38
24 ₹ 180,877.38 ₹ 1,507.31 ₹ 9,618.15 ₹ 172,766.55
25 ₹ 172,766.55 ₹ 1,439.72 ₹ 9,618.15 ₹ 164,588.13
26 ₹ 164,588.13 ₹ 1,371.57 ₹ 9,618.15 ₹ 156,341.55
27 ₹ 156,341.55 ₹ 1,302.85 ₹ 9,618.15 ₹ 148,026.25
28 ₹ 148,026.25 ₹ 1,233.55 ₹ 9,618.15 ₹ 139,641.65
29 ₹ 139,641.65 ₹ 1,163.68 ₹ 9,618.15 ₹ 131,187.19
30 ₹ 131,187.19 ₹ 1,093.23 ₹ 9,618.15 ₹ 122,662.27
31 ₹ 122,662.27 ₹ 1,022.19 ₹ 9,618.15 ₹ 114,066.31
32 ₹ 114,066.31 ₹ 950.55 ₹ 9,618.15 ₹ 105,398.72
33 ₹ 105,398.72 ₹ 878.32 ₹ 9,618.15 ₹ 96,658.89
34 ₹ 96,658.89 ₹ 805.49 ₹ 9,618.15 ₹ 87,846.24
35 ₹ 87,846.24 ₹ 732.05 ₹ 9,618.15 ₹ 78,960.14
36 ₹ 78,960.14 ₹ 658.00 ₹ 9,618.15 ₹ 70,000.00
37 ₹ 70,000.00 ₹ 1,750.00 ₹ 9,762.71 ₹ 61,987.29
38 ₹ 61,987.29 ₹ 1,549.68 ₹ 9,762.71 ₹ 53,774.25
39 ₹ 53,774.25 ₹ 1,344.36 ₹ 9,762.71 ₹ 45,355.90
40 ₹ 45,355.90 ₹ 1,133.90 ₹ 9,762.71 ₹ 36,727.08
41 ₹ 36,727.08 ₹ 918.18 ₹ 9,762.71 ₹ 27,882.54
42 ₹ 27,882.54 ₹ 697.06 ₹ 9,762.71 ₹ 18,816.89
43 ₹ 18,816.89 ₹ 470.42 ₹ 9,762.71 ₹ 9,524.60
44 ₹ 9,524.60 ₹ 238.11 ₹ 9,762.71 ₹ 0.00
 PHASE 2

P2 70000
R2 10%
T2 2 yrs
periodicity 2 4 quaterly
NPER 2 8
EFF RATE 2 0.025
INSTALLMENT 2 ₹ 9,762.71
yearly 1
half yearly 2
quaterly 4
bi monthly 6
monthly 12
 PHASE 1 PHASE 2
P 350000
T 5 YRS
P1 280000 0.8 P2 70000
R1 10% R2 10%
T1(change after) 3 yrs T2 2 YRS
periodicity 1 2 half yearly
yearly 1
half yearly 2
quaterly 4
bi monthly 6
monthly 12
client id name of borrower principal amount rate of interest period in yrs.
1 a 400000 10% 10
2 b 500000 11% 12
3 c 20000 10% 15
4 d 4000000 11% 20
5 e 5000000 10% 10
6 f 3000000 11% 3
TOTAL
 1 2 3 4 5 6 7 8
₹ 10,000.00
₹ 13,750.00
₹ 500.00
₹ 110,000.00
₹ 125,000.00
₹ 82,500.00
9 10
COST of asst 200000
life of FIXED asset 12
salvage value 5000
months IN THE 1ST
YEAR 10
PERIOD DB METHOD SLN METHOD
1 $36,805.83
2 $34,413.33
3 $25,293.33
4 $18,590.83
5 $13,664.17
6 $10,043.33
7 $7,381.67
8 $5,425.83
9 $3,987.50
10 $2,930.83
11 $2,154.17
12 $1,583.33
 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
 Here, x is independent and y is dependent. STATS is
q4 y^=a+bx independent and MATHS IS DEPENDENT.
maths in stats(X) marks in maths(Y) projected output
68 69 73.411258139047 105
70 78 75.371770636421
75 79 80.273051879857 85
78 79 83.213820625919
79 83 84.194076874606
73 86 78.312539382483 65
82 88 87.134845620668
86 89 91.055870615417 45
87 90 92.036126864104
89 98 93.996639361479
94 98.897920604915 25
slope(b) 0.98025624868725
intercept(a) 6.7538332283134 5
correlation 0.8813896228581
65 70 75 80 85 90
-15
endent. STATS is
PENDENT.

marks in maths(Y)
projected output

80 85 90 95 100
x y Y^=A+Bx
32 26 31.87886 44 91
90
34 23 32.62207 97 34
51 69 38.93943 40 54 80
61 21 42.65552 34 91 70
70 51 46 67 50 60
83 77 50.83092 86 51
50
87 38 52.31735 61 75
92 44 54.1754 28 72 40 y
93 74 54.54701 88 51 Y^=A+Bx
30
97 37 56.03344 100 60
20
55 84
intercept= 19.98737 29 30 10
SLOPE = 0.371609 68 72 0
80 38 20 30 40 50 60 70 80 90 100 110
24 35
57 51
48 39
84 58
57 24
59 23
 y
Y^=A+Bx

100 110
y x x^=a+by
129 76 75.5087
136 85 85.77283 115
138 90 88.70543
110
139 93 90.17174
142 90 94.57065 105
146 97 100.4359
149 109 104.8348 100

95
intercept = -113.6446 x
SLOPE = 1.466304 90 x^=a+by

85

80

75

70
125 130 135 140 145 150 155
x
x^=a+by
YEARS (X) Y Y^=A+BX
1985 122 109.8222 111
1986 99 110.5056 91 125
1987 114 111.1889 120
120
1988 99 111.8722 116
1989 123 112.5556 116
115
1990 122 113.2389 104
1991 93 113.9222 96
110
1992 119 114.6056 121
1993 122 115.2889 113 105

INTERCEPT = -1246.594 100

SLOPE = 0.683333
95

90
1984 1985 1986 1987 1988 1989 1990 1991 1992 1993
 Y
Y^=A+BX

988 1989 1990 1991 1992 1993 1994

 PROJECT A PROJECT B
RATE OF INTEREST 12% 12%
CASH OF PROJECT -500000 -550000
CASH INFLOW YEAR 1 400000 20000
YEAR2 60000 500000
YEAR3 50000 60000
YEAR4 70000 70000
YEAR5 80000 80000
NPV ₹ 30,443.92 ₹ -958.69
IRR 16% 12%

RATE OF RETURN 10% 11% 12% 13% 14%

NPV OF PROJECT £48,273.53 £39,204.55 £30,443.92 £21,976.72 £13,788.93
 15%
£5,867.38
Projects A B
Rate of interest 12% 12%
initial investments 150000 300000
Expected cash flow 40000 80000
year2 56000 112000
year3 60000 120000
year 4 45000 90000
year5 65000 130000
NPV ₹ 338,545.02