BUS 520 Module 3 SLP (Revisions)

profileantony34
module_3_slp_excel.xlsx
Home>Business & Finance homework help>Management homework help>BUS 520 Module 3 SLP (Revisions)

Raw data

Option A Option B Option C
Scenario NPV PR. NPV PR. NPV PR.
High 5,000,000 0.5 3,000,000 0.75 1,500,000 1
Medium 2,000,000 0.3 2,000,000 0.15 1,500,000 1
Low 0 0.2 1,000,000 0.1 1,500,000 1
Initial Investment 750,000 550,000 750,000

Decision tree

Value Measure U-Value
0.75 High
3,000,000 3000000
Invest 550,000 Option B 0.15 Medium
2,000,000 2000000
2650000 2650000
0.1 Low
1,000,000 1000000
0.5 High
5,000,000 5000000
4500000
4500000 Option A 0.3 Medium
2,000,000 2000000
3100000 3100000
0.2 Low
0 0
>>> Invest 750,000
4500000 4500000 1 High
1,500,000 1500000
>>> Option C 1 Medium
1,500,000 1500000
4500000 4500000
1 Low
1,500,000 1500000

Sheet 3