GSOE9830 Questions on Week 3 Topics Display mode Display replies in nested form Picture of Guy Allinson GSOE9830 Questions on Week 3 Topics by Guy Allinson - Wednesday, 12 June 2024, 7:27 AM Number of replies: 0 Dear Students Before the next lecture I invite you to write down your answers to the questions set out below. Please do not attempt to submit your answers. They are intended for you to self-assess your understanding of some of the material discussed in the previous lecture. I will discuss these questions with you in the next lecture. Regards, Guy 1. Give the Excel NPV function for the net cash flow below. Assume a discount rate of 10%. Time End1 End2 End3 End4 End5 NCF($) -100 150 100 70 -50 Cells A6 B6 C6 D6 E6 2. Give two different versions of the Excel NPV formula for the net cash flow below. Assume a discount rate of 10%. Time 0 End1 End2 End3 End4 NCF($) -100 150 100 70 -50 Cells A6 B6 C6 D6 E6 3. What is the future value at the end of year 7 of $100 received today? Assume a compound rate of 10%