Irr

  • August 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Irr as PDF for free.

More details

  • Words: 1,786
  • Pages: 20
C

0

50.00 100.00 100.00 200.00 250.00 300.00 350.00 400.00 450.00 500.00 550.00 600.00 650.00 700.00 750.00 800.00 850.00 900.00 950.00 1000.00

No. Pro 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Op. NPVn cumu. npv n Year. NPV n

n

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

-75.96 -52.85 -30.62 -9.25 11.30 31.05 50.05 68.32 85.88 102.77 119.01 134.63 149.64 164.08 177.96 191.31 204.14 216.48 228.35 239.76

24.04 47.15 69.38 90.75 111.30 131.05 150.05 168.32 185.88 202.77 219.01 234.63 249.64 264.08 277.96 291.31 304.14 316.48 328.35 339.76

24.04 23.11 22.22 21.37 20.55 19.76 19.00 18.27 17.56 16.89 16.24 15.61 15.01 14.44 13.88 13.35 12.83 12.34 11.87 11.41

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

i 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04

c c 0

100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100

f

25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25

NPV

n

C.

Dis. rate

$4.07 $11.30 -$55.48 -$91.86 $2.33 -$155.81 -$187.79 -$219.76 -$251.74 -$283.71 -$315.69 $12.81 -$379.64 -$411.62 -$443.59 -$475.57 -$507.55 -$539.52 -$571.50 -$603.47

5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00

15.00 25.00 10.00 30.00 70.00 40.00 45.00 50.00 55.00 60.00 65.00 170.00 75.00 80.00 85.00 90.00 95.00 100.00 105.00 110.00

0.12 0.04 0.04 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12

f

Dis. rate

NPV

NPV - C0

IRR

No. Pr.

0.10 0.10 0.23 0.24 0.12 0.08

5,845.98 2,014.27 44.87 13.63 (24.07) 1,922.06

5,845.98 2,014.27 44.87 13.63 (24.07) 1,922.06

43% 24% 23% 24% 0% 10%

1 2 3 4 4 5

0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.12 0.12 0.10 0.10

0.00 4.41 13.40 17.76 27.45 21.89 10.89 4.58 (44.59) 4.24 7.23 20.10 4.87 1,616.48 1,288.61 (144.59) (59.46)

0.00 4.41 13.40 17.76 27.45 21.89 10.89 4.58 (44.59) 4.24 7.23 20.10 4.87 1,616.48 1,288.61 (144.59) (59.46)

10% 10% 12% 13% 15% 15% 17% 12% 8% 10% 11% 12% 11% 17% 19% 4% 8%

6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

0.10 1.08 0.10 8.82 0.10 3.13 0.10 0.01 0.10 495.87 0.10 495.87 0.10 32,600.92 0.10 16,986.54 0.10 (2.77) 0.10 196,047.21 0.10 221,306.29

1.08 8.82 3.13 0.01 495.87 495.87 32,600.92 16,986.54 (2.77) 196,047.21 221,306.29

10% 10% 10% 10% 14% 13% 12% 12% 10% 24% 29%

23 24 25 26 27 28 29 30 31 32 33

C.f3

C.f2

C.f1

C0

7000 3000 6000 3000 25 10000

5000 4000 5000 4000 25 9200

6000 6000 3000 6000 25 8000

(9,000.00) (9,000.00) (9,000.00) (9,000.00) (100.00) (40,000.00)

600000.00 (1000.00) 10000.00 30 30 30 40 40 40 50 50 50 60 60 60 70 70 70 20 50 60 60 50 20 30 30 30 40 40 40 50 50 50 60 60 60 70 70 70 9000 9000 9000 4700 4700 4700 30 30 30 40 40 40

(322,450.65) (200.00) (200.00) (200.00) (200.00) (200.00) (100.00) (100.00) (300.00) (300.00) (300.00) (300.00) (300.00) (20,000.00) (10,000.00) (400.00) (400.00)

50 60 70 4 0 3000 120000 110000 70 176400 229200

50 60 70 6 5000 4000 80000 110000 70 124000 172000

50 60 70 1 7000 4000 41000 110000 70 40000 120000

(400.00) (400.00) (400.00) (10.00) (10,000.00) (10,000.00) (400,000.00) (400,000.00) (500.00) (400,000.00) (400,000.00)

C.f8

C.f7

C.f6

C.f5

C.f4

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 14500

0 0 0 0 25 12000

0 30 40 0 0 0 0 0 30 40 50 60 0 0 0 30 40

0 30 40 0 0 0 0 0 30 40 50 60 0 0 0 30 40

0 30 40 50 0 0 0 0 30 40 50 60 70 0 0 30 40

0

(200000.00) 30 40 50 60 70 0 0 30 40 50 60 70 0 0 30 40

30 40 50 60 0 0 0 30 40 50 60 70 0 0 30 40

50 60 70 0 0 0 0 0 70 0 0

50 60 70 0 0 0 0 0 70 0 0

50 60 70 0 0 0 0 0 70 0 0

50 60 70 0.89 0 0 220000 110000 70 221444 129332

50 60 70 0.85 0 1903 150000 110000 70 274040 172120

C.f16 C.f15 C.f14 C.f13 C.f12 C.f11 C.f10 C.f9 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 30

0 0 0 0 0 0 0 0 30 40 0 0 0 0 0 30 40

0 0 0 0 0 0 0 0 30 40 0 0 0 0 0 30 40

0 0 0 0 0 0 0 0 30 40 0 0 0 0 0 30 40

0 30 0 0 0 0 0 0 30 40 0 0 0 0 0 30 40

0 30 0 0 0 0 0 0 30 40 0 0 0 0 0 30 40

0 30 0 0 0 0 0 0 30 40 50 0 0 0 0 30 40

0 30 0 0 0 0 0 0 30 40 50 0 0 0 0 30 40

0 0 0 0 0 30 40

50 0 0 0 0 0 0 0 0 0 0

50 0 0 0 0 0 0 0 0 0 0

50 0 0 0 0 0 0 0 0 0 0

50 0 0 0 0 0 0 0 70 0 0

50 60 0 0 0 0 0 0 70 0 0

50 60 0 0 0 0 0 0 70 0 0

50 60 0 0 0 0 0 0 70 0 0

50 60 70 0 0 0 0 0 70 0 0

C.f20 C.f19 C.f18 C.f17 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 30

0 0 0 0 0 0 0 0 30

0 0 0 0 0 0 0 0 30

0 0 0 0 0 0 0 0 30

0 0 0 0 0 30 40

0 0 0 0 0 30 40

0 0 0 0 0 30 40

0 0 0 0 0 30 40

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

50 0 0 0 0 0 0 0 0 0 0

‫ست‬ ‫‪0‬‬ ‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬ ‫‪4‬‬ ‫‪5‬‬ ‫‪6‬‬ ‫‪7‬‬ ‫‪8‬‬ ‫‪9‬‬ ‫‪10‬‬ ‫‪11‬‬ ‫‪12‬‬ ‫‪13‬‬ ‫‪14‬‬ ‫‪15‬‬ ‫‪16‬‬ ‫‪17‬‬ ‫‪18‬‬ ‫‪19‬‬ ‫‪20‬‬

‫البيان‬

‫حركه التدفقات‬

‫‪ $‬ر‪.‬المال الولي‬

‫‪-9000‬‬ ‫‪3000‬‬ ‫‪5000‬‬ ‫‪6000‬‬ ‫‪21000‬‬ ‫‪26000‬‬ ‫‪30000‬‬ ‫‪40000‬‬ ‫‪50000‬‬ ‫‪60000‬‬ ‫‪10000‬‬ ‫‪20000‬‬ ‫‪30000‬‬ ‫‪15000‬‬ ‫‪10000‬‬ ‫‪5000‬‬ ‫‪4000‬‬ ‫‪2000‬‬ ‫‪2000‬‬ ‫‪1000‬‬ ‫‪500‬‬

‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬ ‫‪ $‬صافي اليراد‬

‫مشروع رقم ‪1‬‬ ‫‪eturn‬‬ ‫س تشغيل‬ ‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬

‫‪23%‬‬

‫مشروع رقم ‪1‬‬ ‫‪IRR-Internal Rate of Return‬‬ ‫س تشغيل‬

‫س تشغيل‬

‫س تشغيل‬

‫س تشغيل‬

‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬ ‫‪4‬‬ ‫‪5‬‬

‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬ ‫‪4‬‬ ‫‪5‬‬ ‫‪6‬‬ ‫‪7‬‬ ‫‪8‬‬ ‫‪9‬‬

‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬ ‫‪4‬‬ ‫‪5‬‬ ‫‪6‬‬ ‫‪7‬‬ ‫‪8‬‬ ‫‪9‬‬ ‫‪10‬‬

‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬ ‫‪4‬‬ ‫‪5‬‬ ‫‪6‬‬ ‫‪7‬‬ ‫‪8‬‬ ‫‪9‬‬ ‫‪10‬‬ ‫‪11‬‬ ‫‪12‬‬ ‫‪13‬‬ ‫‪14‬‬ ‫‪15‬‬ ‫‪16‬‬ ‫‪17‬‬ ‫‪18‬‬ ‫‪19‬‬ ‫‪20‬‬

‫‪70%‬‬

‫‪85%‬‬

‫‪85%‬‬

85%

‫مشروع رقم ‪1‬‬ ‫‪al Rate of Return‬‬

‫ست‬ ‫‪0‬‬ ‫‪1‬‬ ‫‪2‬‬ ‫‪3‬‬ ‫‪4‬‬ ‫‪5‬‬ ‫‪6‬‬ ‫‪7‬‬ ‫‪8‬‬ ‫‪9‬‬ ‫‪10‬‬ ‫‪11‬‬ ‫‪12‬‬ ‫‪13‬‬ ‫‪14‬‬ ‫‪15‬‬ ‫‪16‬‬ ‫‪17‬‬ ‫‪18‬‬ ‫‪19‬‬ ‫‪20‬‬

‫البيان حركه التدفقات‬ ‫س تشغيل س تشغيل‬ ‫‪ $‬ر ‪.‬المال الولي ‪-1000‬‬ ‫‪0%‬‬ ‫‪ $‬صافي اليراد‬ ‫‪1‬‬ ‫‪1‬‬ ‫‪200‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0% 2‬‬ ‫‪2‬‬ ‫‪800‬‬ ‫‪ $‬صافي اليراد‬ ‫‪3‬‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪4‬‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪5‬‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬ ‫‪ $‬صافي اليراد‬ ‫‪0‬‬

1‫م‬ IRR-Internal Rate of Retu

0%

‫س تشغيل‬

‫س تشغيل‬

‫س تشغيل‬

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

1 2 3 4 5 6 7 8 9 10

1 2 3 4 5 6 7 8 9

0%

0%

IRR

Data

Initial cost of a business

###

Net Net Net Net Net

income income income income income

for for for for for

the the the the the

first year second year third year fourth year fifth year

$12,000 $15,000 $18,000 $21,000 $26,000

Investment's internal rate of return after four years

-2%

Internal rate of return after five years

9%

To calculate the internal rate of return after two years, you need to include a guess (in this example, -10%).

-44%

NPV 1 Annual discount rate Initial cost of investment one year from today Return from first year Return from second year Return from third year

Net present value of this investment Net present value of this investment with a loss

3000 in three years

Data 0.1 -10000 3000 4200 6800

### ($741.75)

NPV 2

Data

Annual discount rate. This might represent the rate of inflation or the interest rate of a competing investment.

0.08

Initial cost of investment

-40000

Return from first year

8000

Return from second year

9200

Return from third year

10000

Return from fourth year

12000

Return from fifth year

14500

Net present value of this investment

$1,922.06

Net present value of this investment, with a loss in the sixth year of

9000

($3,749.47)

Related Documents

Irr
August 2019 20
Irr
November 2019 19
Irr
August 2019 19
Irr Bp220
December 2019 15
Irr Calculation
June 2020 15
Irr Simulations
June 2020 12