Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedPlease 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Fundraising For Arts And Cultural Organizations

Authors: Carolyn S. Friedman, Karen B. Hopkins

2nd Edition

1573560294, 978-1573560290

More Books

Students also viewed these Finance questions