Please follow the instructions on the attached Excel Spreadsheet and upload the completed file below.

Sheet1
    This Excel exercise is designed to find the present value of future cash flows. Assume there are two projects X & Y with cash flows at the end of the next three years as follows.
    Assume that the required rate of return on projects is equal to 10%.                            Required Return =        10%
            Today    Year 1    Year 2    Year 3
        Project X    -100    10    60    70
        Project Y    -100    80    40    20
    In the space below calculate the Net Present Values of projects X & Y by using the present value formula of Excel (=PV(rate,nper,pmt,[fv]).
    Note: because these are uneven cash flow streams the pmt = 0. We can then solve...