1. n Excel, calculate the NPV and IRR of the two investment alternatives shown below. Use RANDBETWEEN to embed randomness for the annual savings and salvage values, where appropriate. For example, $75,000$10,000 can be modeled as RANDBETWEEN(65000,75000).
2. Press F9 several times. What do you observe? Does the risk profile of the investments change your preferences for one investment over the other?

Decide Between Two 5 Year Investments With NPV & IRR, With Monte Carlo Appeal OK ALA HI Mcdonald's ORDER HERE Lid sl Electronic Kiosks Dining Renovation . $300,000 Investment . $300,000 Investment $75,000 + $10,000 Annual savings . $60,000 + $20,000 Increased + increased revenues annual revenues $0 salvage Value . $150,000 + $50,000 Salvage Value