3 excel formulas for the 3 gray highlighted cells (exact calculation not needed)

=NPV() and =NPV() will be used

H 1 4 6 7 Job Y3 70,000 $ 8 Job Y4 75,000 B D E F G 1 2 Exercise 1: It is now January 1, and your friend is halfway through his senior year in high school. He plans to go to 3 college to study engineering following high school. He knows it will cost him $2500 right now to travel to colleges for interviews and visits. Also, he expect that it will cost $20,000 every year for his 4 years in college, and he expects that he 4 will be able to earn $50,000, $60,000, $70,000, and $75,000 in salary for his first 4 years after college. Use an 5 appropriate formula in cell B17 to calculate the net present value of his cash flows. You can assume that all cash flows 6 occur on January 1 of the respective years. 7 8 9 10 Years from now 1 2 5 11 Title Freshman Sophomore Junior Senior Job Y1 Job Y2 12 Inflow/Outflow $ (20,000) $ (20,000) $ (20,000) $ (20,000) $ 50,000 $ 60,000 $ 13 14 Initial Expenses $ (2,500) Incurred now 15 Discount Rate 4% 16 17 NPV 18 19 Exercise 2: An appliance store is offering a $1499 56" TV today for $999 after a $500 mail-in rebate. Use the XNPV 20 function to find the real cost of the TV to you, given the rebate date below. The amount paid now is the price including 21 tax entered as a negative number. 22 23 Original TV price $1,499 24 Sales tax rate 8.25% 25 Amount paid now Enter as negative number 26 Mail-in Rebate $500 27 Today's date 12/25/2020 28 Date rebate received 4/24/2021 29 Interest Rate 10% Use for discounting 30 31 NPV of the TV to you