please provide in excel terms showing formulas used

1) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%? 2) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year. If this investment is going to cost you $70,000 today what rate of return would you be earning? 3) You are planning on making the following deposits into an account that will earn 4%. $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all deposits will be made at end of each year? How much will you end up with at the end of the six year? 4) You are looking at three savings accounts. Account 1 pays 5.25%, with daily compounding, account 2 pays 5.3% with semiannual compounding, and account 3 pays 5.24% with continues compounding. What is the effective annual rate for each of the three accounts? (Your answers must be formatted as percentages with two decimal places) Bonus: Rework problem 1 assuming your opportunity cost is 11% with monthly compounding. Please format your answers to two decimal places. Highlight and label all answers