Sensitivity Simulations

  • Uploaded by: Saurabh Suman
  • 0
  • 0
  • June 2020
  • 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 Sensitivity Simulations as PDF for free.

More details

  • Words: 781
  • Pages: 10
Project simulations Initial investment Variables for a given project Traffic volume Toll rate for entire stretch Life of project

10000 Pessimistic Expected Optimistic 750 1000 1250 13.5 15 16.5 3 5 7

Expected variables P&L Statement 1

2

3

4

5

15000 3333 11667 5834 5834

15000 2222 12778 6389 6389

15000 1481 13519 6760 6760

15000 988 14012 7006 7006

15000 658 14342 7171 7171

0

1

2

3

4

5

PAT+Depreciation

-10000

9167

8611

8241

7994

7829

NPV

31,962

1

2

3

4

5

11250 3333 7917 3959 3959

11250 2222 9028 4514 4514

11250 1481 9769 4885 4885

11250 988 10262 5131 5131

11250 658 10592 5296 5296

0

1

2

3

4

5

PAT+Depreciation

-10000

7292

6736

6366

6119

5954

NPV

24,854

1

2

3

4

5

13500 3333

13500 2222

13500 1481

13500 988

13500 658

Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

0 -10000

Pessimistic traffic P&L Statement Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

0 -10000

Pessimistic toll rates P&L Statement Investment Revenue Depreciation

0 -10000

Profit before tax Tax PAT Cash Flow Statement

10167 5084 5084

11278 5639 5639

12019 6010 6010

12512 6256 6256

12842 6421 6421

0

1

2

3

4

5

PAT+Depreciation

-10000

8417

7861

7491

7244

7079

NPV

29,119

1

2

3

4

5

15000 3333 11667 5834 5834

20625 2222 18403 9202 9202

0 1481 -1481 -741 -741

0 988 -988 -494 -494

0 658 -658 -329 -329

0

1

2

3

4

5

PAT+Depreciation

-10000

9167

11424

741

494

329

NPV

18,330

1

2

3

4

5

18750 3333 15417 7709 7709

18750 2222 16528 8264 8264

18750 1481 17269 8635 8635

18750 988 17762 8881 8881

18750 658 18092 9046 9046

0

1

2

3

4

5

PAT+Depreciation

-10000

11042

10486

10116

9869

9704

NPV

39,070

1

2

3

4

5

Pessimistic Project life P&L Statement Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

0 -10000

Optimistic Traffic P&L Statement Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

0 -10000

Optimistic Toll rates P&L Statement 0

Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

-10000 16500 3333 13167 6584 6584

16500 2222 14278 7139 7139

16500 1481 15019 7510 7510

16500 988 15512 7756 7756

16500 658 15842 7921 7921

0

1

2

3

4

5

PAT+Depreciation

-10000

9917

9361

8991

8744

8579

NPV

34,805

1

2

3

4

5

15000 3333 11667 5834 5834

15000 2222 12778 6389 6389

15000 1481 13519 6760 6760

15000 988 14012 7006 7006

15000 658 14342 7171 7171

0

1

2

3

4

5

PAT+Depreciation

-10000

9167

8611

8241

7994

7829

NPV

40,243

Optimistic project duration P&L Statement Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

0 -10000

Summary: NPV

Traffic volume Toll rate for entire stretch Life of project

Pessimistic Expected 24,854 29,119 31,962 18,330

Optimistic 39,070 34,805 40,243

6

7

15000 439 14561 7281 7281

15000 293 14707 7354 7354

6

7

7720

7647

6

7

11250 439 10811 5406 5406

11250 293 10957 5479 5479

6

7

5845

5772

6

7

13500 439

13500 293

13061 6531 6531

13207 6604 6604

6

7

6970

6897

6

7

0 439 -439 -220 -220

0 293 -293 -147 -147

6

7

220

147

6

7

18750 439 18311 9156 9156

18750 293 18457 9229 9229

6

7

9595

9522

6

7

16500 439 16061 8031 8031

16500 293 16207 8104 8104

6

7

8470

8397

6

7

15000 439 14561 7281 7281

15000 293 14707 7354 7354

6

7

7720

7647

Project simulations Initial investment Variables for a given project Traffic volume Toll rate for entire stretch Life of project NPV

10000 Expected Scenario assumptions 1000 1250 15 13.5 5 5 31,962 35,516

Expected variables P&L Statement 1

2

3

4

16875 3333 13542 6771 6771

16875 2222 14653 7327 7327

16875 1481 15394 7697 7697

16875 988 15887 7944 7944

0

1

2

3

4

PAT+Depreciation

-10000

10104

9549

9178

8932

NPV

35,516

Investment Revenue Depreciation Profit before tax Tax PAT Cash Flow Statement

0 -10000

5

6

7

16875 658 16217 8109 8109

16875 439 16436 8218 8218

16875 293 16582 8291 8291

5

6

7

8767

8657

8584

Possible event

Optimistic Traffic Growth Expected traffic growth Pessimistic traffic growth

Year 1 Cash flow 11042 9167 7292

Expected Cash flow NPV

Probability

Year 2 Cash flow Probability

Expected value 0.2 0.5 0.3

2208 4583 2187 8979

11,907

10486 8611 6736

0.3 0.5 0.2

Year 3 Expected value Cash flow Probability Expected value 3146 4306 1347 8799

10116 8241 6366

0.4 0.4 0.2

4046 3296 1273 8616

Related Documents

Gender Sensitivity
November 2019 20
Physics Simulations
November 2019 16
Sensitivity Analysis
May 2020 13

More Documents from "Md. Din Islam Asif"