B32 fx A B 1 2 3 4 5 6 7 8 9 E Exercise 1: It is now January 1, and your friend is halfway through his senior year in high school. He plans to go to 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 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 appropriate formula in cell B17 to calculate the net present value of his cash flows. You can assume that all cash flows occur on January 1 of the respective years. H J K L M N 10 Years from now 11 Title 12 Inflow/Outflow 13 1 2 3 4 $ Freshman Sophomore (20,000) $ Junior (20,000) $ (20,000) $ Senior (20,000) $ 5 Job Y1 50,000 $ 6 Job Y2 60,000 $ 7 Job Y3 70,000 $ 8 Job Y4 75,000 14 Initial Expenses $ 15 Discount Rate 16 (2,500) 4% < Incurred now 17 NPV 121,413 18 19 20 Exercise 2: An appliance store is offering a $1499 56" TV today for $999 after a $500 mail-in rebate. Use the XNPV function to find the real cost of the TV to you, given the rebate date below. 21 22 23 Original TV price 24 Sales tax rate $1,499 8.25% 25 Amount paid now ($1,623) Enter as negative number 26 Mail-in Rebate $500 27 Today's date 4/19/22 28 Date rebate received 8/17/22 29 Interest Rate 10% Use for discounting 30 31 NPV of the TV to you $ (1,139) 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47