please do it through excel!

dude you do not need more imformation are you kidding

Create an Excel workbook that answers the questions below. Each question should be answered in a separate sheet. Please highlight your answer with fun colored text for each question so I know what your final answer is. Upload the finished Excel to Canvas. Hint: Pay attention to the time periods. Question 1: Phil Knight offers you a series of cash flows. In 2 years, he'll give you $500. In 4 years, you'll receive $900. In 7 years, you get $350. The interest rate is 5% annually. (a) What is the present value of this deal? (b) What is the future value of this deal 7 years from now? Question 2: You've won the Best University of Oregon Student award which earns you $1 million! It pays out $8,333.33 at the end of each month for 10 years. The current interest rate is 4% annually. What is the present value of the award? Question 3: You plan to save enough to have $200,000 in 20 years. Right now, you have $10,000 in the bank and are planning to make a deposit at the end of every year. Knowing that the interest rate is.3% monthly, what annual payment would you need to achieve your goal? Question 4: Thanks to the magic of Hogwarts, Harry Potter set up a stream of payment that lasts forever. He is earning $100 each year until the end of time. Current magical interest rates are 6% quarterly. What is the present value of Harry Potter's cash flows