Hi Guys -- first, thanks for this awesome site. HUGE fan.
I've attached a sample business case for a project I'm working on in school. Long story short, I want to see how the PV/I, IRR and NPV (Cells C121:C124) changes when the actual new customers added (Cells D30:H30) is multiplied by the risk factors (Cells D127:D131).
Basically if you present a business case and someone says...well what's the risk of getting only 85% of your assumption? 90%? etc....
Excel file attached and thank you again for your help!
Bookmarks