Help please show work with formulas and calculations in excel - 4.1 &4.2

CHAPTER 9: TIME VALUE ANALYSIS Homework Problem 4.1 Find the following values for a lump sum assuming annual compounding: a. The future value of $500 invested at 8% for one year b. The future value of $500 invested 8% for five years c. The present value of $500 to be received in one year when the opportunity cost rate is 8% d. The present value of $500 to be received in five years when the opportunity cost rate is 8% Homework Problem 4.2 Find the following values assuming a regular, or ordinary, annuity: a. The present value of $400 per year for 10 years at 10% b. The future value of $400 per year for 10 years at 10% c. The present value of $200 per year for five years at 5% d. The futrue value of $200 per year for five years at 5%