(Solved) : 7 Currently 5000 Savings Account Pays 05 Interest Month Add Another 200 Month Build Model Q44108789 . . .
(7) You currently have $5000 in a savings account that pays 0.5% interest each month. You add another $200 each month. Build this model in Excel on a single sheet with a flexible (“soft- coded”) interest rate. Then write answers to the following two questions in bold font: . With the 0.5% interest, how many months is it until you have at least 10000 in the account? • If there was no interest, how many months would it take have at least $10000 in the account? Show transcribed image text (7) You currently have $5000 in a savings account that pays 0.5% interest each month. You add another $200 each month. Build this model in Excel on a single sheet with a flexible (“soft- coded”) interest rate. Then write answers to the following two questions in bold font: . With the 0.5% interest, how many months is it until you have at least 10000 in the account? • If there was no interest, how many months would it take have at least $10000 in the account?
Expert Answer
Answer to (7) You currently have $5000 in a savings account that pays 0.5% interest each month. You add another $200 each month. B…
OR