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.

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. Exercise 2: An appliance store is offering a $149956 " 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