answer asap

In the Tatham capital budgeting model we supplied the NPV for each investment. Suppose instead that you are given only the streams of cash inflows from each investment shown in the file P14_50.xisx. This file also shows the cash requirements and the budget. You can assume that ( 1 ) all cash outflows occur at the beginning of year 1; (2) all cash inflows occur at the ends of their respective years; and (3) the company uses a 12% discount rate for calculating its NPVs. Which investments should the company make? Round your answer for the total NPV to the nearest whole dollar, if necessary. Investment 1 Investment 2 Investment 3 Investment 4 Investment 5 Investment 6 Investment 7 Investment 8 Investment 9 Investment 10 Total NPV Whinflows (all at ends of respectwe years-blanks mean no inflows in those years) Yeor investmen 1 investment 2 investment 3 investment 4 investment 5 investment 6 Investront 7 investment 8 investment 9 investment 10