Scribd
Upload
49 views3 pages

Scenario Summary: Changing Cells

The document summarizes a scenario analysis for a business investment project. It provides current and changing values for key inputs used in three scenarios, and shows the resulting project net present value (NPV), internal rate of return (IRR), and net cash flows for each year over a 7 year period. The scenarios analyze different levels of production capacity and capital investment to determine their impact on project profitability.

Uploaded by

Gourav Chaudhary
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
49 views3 pages

Scenario Summary: Changing Cells

The document summarizes a scenario analysis for a business investment project. It provides current and changing values for key inputs used in three scenarios, and shows the resulting project net present value (NPV), internal rate of return (IRR), and net cash flows for each year over a 7 year period. The scenarios analyze different levels of production capacity and capital investment to determine their impact on project profitability.

Uploaded by

Gourav Chaudhary
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/ 3

Scenario Summary

Current Values:

Bad

good

Changing Cells:
$B$5
0.2
0.15
0.35
$D$4
0.45
0.5
0.5
$D$5
0.0109990491
0.2
0.1
Result Cells:
$B$20
0 -0.5303288027 0.0090860784
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.

d
All qty figs in Crores All cash flow figs in Rs cr
IntlCpcty
1 UnitP
0.5 Invstmnt
CpcBldRt
0.15 UnitVC
0.2 Deprt
FullCpcty
2 FCIntl
0.25 MaxDepYr
IncFrYrFC
0.03 TxRt

QtyPrdn
SlsRev
VCst
Fcst
BkVal
Deprcn
Tax
NetCF

NPV
IRR

0
0
0
0
0
1
0
0
-1

-0.530329
0%

1
1
0.5
0.2
0.25
0.85
0.15
0
0.05

0.18

1
0.15
0.15
0.48

2
3
4
5
6
1.15
1.3
1.45
1.6
1.75
0.575
0.65
0.725
0.8
0.875
0.23
0.26
0.29
0.32
0.35
0.2575 0.265225 0.273182 0.281377 0.289819
0.7
0.55
0.4
0.25
0.1
0.15
0.15
0.15
0.15
0.15
0
0 0.005673 0.023339 0.040887
0.0875 0.124775 0.156145 0.175284 0.194294

0.45
0.48
0.5
0.52
0.55

-0.530329
-0.745569
-0.611871
-0.530329
-0.453267
-0.348728

0%
-9.57%
-3.73%
-0.49%
2.43%
6.25%

-0.530329
0.15
0.12
0.1
0.09

0.45
-0.530329
-0.41842
-0.348728
-0.316122

0.48
-0.41842
-0.316122
-0.254358
-0.223476

0.5
-0.348728
-0.254358
-0.192594
-0.16578

7
1.9
0.95
0.38
0.298513
0
0.1
0.082314
0.189173

0
0.15
0.12
0.1
0.09

0.45
-0.457641
-0.34657
-0.276832
-0.243945

0.48
-0.34657
-0.243945
-0.178171
-0.145284

0.5
-0.276832
-0.178171
-0.112397
-0.083578

You might also like