Watch the mini-lecture above, taking careful notes. Then, respond to the following in the Create a Monte Carlo in Excel thread: 1. In 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 What do you observe? Does the risk profile of the investments change your preferences for one investment over the other? 2. Offer encouragement feedback or suggestions to another student. You may use text, video, Gif, etc. to respond. Proofread your comments for responsiveness to the prompts, originality, spelling grammar, punctuation and professionalism before pressing "Submit". Decide Between Two 5 Year Investments With NPV & IRR, With Monte Carlo 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 Watch the mini-lecture above, taking careful notes. Then, respond to the following in the Create a Monte Carlo in Excel thread: 1. In 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 What do you observe? Does the risk profile of the investments change your preferences for one investment over the other? 2. Offer encouragement feedback or suggestions to another student. You may use text, video, Gif, etc. to respond. Proofread your comments for responsiveness to the prompts, originality, spelling grammar, punctuation and professionalism before pressing "Submit". Decide Between Two 5 Year Investments With NPV & IRR, With Monte Carlo 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