Please use excel to do this and show a formula, thankyou! I will give a good rate

4. This question deals with a daily interest account. These are bank accounts that calculate interest daily using simple interest (calculated on the minimum daily balance), and then, at the end of each month, the calculated interest is added to your account. Below are 4 scenarios for which you will need to calculate the final balance in the account at the end of the day on December 31 , along with calculating the total interest earned during the year. Be sure to show the interest that was calculated for each month and your accumulated balance at the end of each month. (2.5 for each scenario =10 marks total) What you need to do is set up your spreadsheet to solve for the first scenario, but set it up in such a way that all you need to do is change the amount of the initial investment, the amounts of the deposits/withdrawals, and the interest rates for the other three scenarios and your values should change automatically (note: I have kept the exact same dates - that makes the question a bit easier, as changing the dates would require a bit more work to make your spreadsheet be able to change the values when the dates changed). 4. This question deals with a daily interest account. These are bank accounts that calculate interest daily using simple interest (calculated on the minimum daily balance), and then, at the end of each month, the calculated interest is added to your account. Below are 4 scenarios for which you will need to calculate the final balance in the account at the end of the day on December 31 , along with calculating the total interest earned during the year. Be sure to show the interest that was calculated for each month and your accumulated balance at the end of each month. (2.5 for each scenario =10 marks total) What you need to do is set up your spreadsheet to solve for the first scenario, but set it up in such a way that all you need to do is change the amount of the initial investment, the amounts of the deposits/withdrawals, and the interest rates for the other three scenarios and your values should change automatically (note: I have kept the exact same dates - that makes the question a bit easier, as changing the dates would require a bit more work to make your spreadsheet be able to change the values when the dates changed)