Using the Excel Function or other techniques (i.e., Steve's Way) to solve for NPV, calculate NPV for an inv if the cash in-flow are as follows starting at $235,000, $295,000, $188,000, and $156,000 the last four years have cash in-flows of $110,000 each year. The firm requires an 9.8% return for projects of this level of risk. Enter the required information below and determine NPV. (5 points). Show investment as a negative. Year Cash flow 0 1 2 3 4 5 6 7 Enter required return as decimal 8 a. Net Present Value using Excel Function b. Should they proceed with the project based on the calculation? You have just won the New Jersey $25 million sweepstakes. The money is paid out in equal annual installments over 25 years. If the appropriate discount rate is 5%, how much is the sweepstakes worth today? Use the appropriate formula to solve the problem. (3.5 points). Present value of sweepstakes per payout arrangement Hint:Ordinary annuity , calculate NPV for an investment of $935,000 000 the last four . (5 points). Ordinary annuity