[go: up one dir, main page]
Scribd
Upload
68 views9 pages

Fin Model Projects Sensitivity

The document summarizes scenarios for changing cells and their impact on result cells. Under the current scenario, changing cells are valued at $3 million and $5%, resulting in a result cell value of $(319,429). The best case shows changing cells valued at $4 million and $8%, resulting in a positive result cell value of $1,824,770. The worst case has changing cells valued at $1 million and $2%, resulting in a negative result cell value of $(4,607,827).

Uploaded by

jagpreet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
68 views9 pages

Fin Model Projects Sensitivity

The document summarizes scenarios for changing cells and their impact on result cells. Under the current scenario, changing cells are valued at $3 million and $5%, resulting in a result cell value of $(319,429). The best case shows changing cells valued at $4 million and $8%, resulting in a positive result cell value of $1,824,770. The worst case has changing cells valued at $1 million and $2%, resulting in a negative result cell value of $(4,607,827).

Uploaded by

jagpreet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Scenario Summary

Current Values: Best Case Worst Case


Changing Cells:
$C$11 3,000,000 4,000,000 1,000,000
Result Cells:
$K$33 (319,429) 1,824,770 (4,607,827)
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Scenario Summary
Current Values: Best Case
Changing Cells:
$C$11 3,000,000 4,000,000
$C$13 5% 5%
Result Cells:
$K$33 (319,429) 1,824,770
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Worst Case Best Case_Rev Grwth Rate Worst Case_Rev_Grwth Rate

1,000,000 3,000,000 3,000,000


5% 8% 2%

(4,607,827) (171,715) (438,372)


Years 10 Interest 11% kd 7.70%

BIIB Investment 5,000,000 Rf 6% ke 12.25%


CLS:
Single
decimals Debt Weight 0.4 β 1.25 MRP 5%
pl!

Equity Weight 0.6 Tax Rate 30% WACC 10.43%

Revenue0 4,000,000 CM 40% SV 7,330,026

Rev Grwth Rate 5% WDV 10%

Working Capital 3 Amount 250,000

Working Capital 5 Amount 250,000

Working Capital 7 Amount 250,000


0 1 2 3 4 5 6 7
Y1 Y2 Y3 Y4 Y5 Y6 Y7

Revenues 4,200,000 4,410,000 4,630,500 4,862,025 5,105,126 5,360,383 5,628,402

VC's 2,520,000 2,646,000 2,778,300 2,917,215 3,063,076 3,216,230 3,377,041

EBITDA 1,680,000 1,764,000 1,852,200 1,944,810 2,042,051 2,144,153 2,251,361

DA 500,000 525,000 551,250 578,813 607,753 638,141 670,048

EBIT 1,180,000 1,239,000 1,300,950 1,365,998 1,434,297 1,506,012 1,581,313

I 220,000 220,000 220,000 220,000 220,000 220,000 220,000

PBT 960,000 1,019,000 1,080,950 1,145,998 1,214,297 1,286,012 1,361,313

Taxes 288,000 305,700 324,285 343,799 364,289 385,804 408,394

PAT 672,000 713,300 756,665 802,198 850,008 900,209 952,919

FCFF 576,000 604,800 385,040 666,792 450,132 735,138 521,895

DF's 0.906 0.820 0.743 0.672 0.609 0.551 0.499

PV(CI's) 521,597 495,950 285,920 448,376 274,097 405,365 260,600

CB's 6,824,770
ICO 5,000,000

NPV 1,824,770
Asset OB 5,000,000 5,250,000 5,512,500 5,788,125 6,077,531 6,381,408 6,700,478
Dep 500,000 525,000 551,250 578,813 607,753 638,141 670,048
Capex 750,000 787,500 826,875 868,219 911,630 957,211 1,005,072
Asset CB 5,250,000 5,512,500 5,788,125 6,077,531 6,381,408 6,700,478 7,035,502
8 9 10 11
Y8 Y9 Y10

5,909,822 6,205,313 6,515,579 6,841,357

3,545,893 3,723,188 3,909,347

2,363,929 2,482,125 2,606,231

703,550 738,728 775,664

1,660,378 1,743,397 1,830,567

220,000 220,000 220,000

1,440,378 1,523,397 1,610,567

432,114 457,019 483,170

1,008,265 1,066,378 1,127,397

810,490 851,014 9,217,925

0.452 0.409 0.371

366,481 348,460 3,417,924


7,035,502 7,387,277 7,756,641
703,550 738,728 775,664
1,055,325 1,108,092 1,163,496
7,387,277 7,756,641 8,144,473
Year
1
2
3
4
5
6
7
8
9
10

You might also like