QUESTION 1 Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. M
Posted: Tue Apr 26, 2022 8:54 pm
QUESTION 1 Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. Make sure that there are no random deposits or withdrawals. What is the monthly interest) rate (round to hundredths of a percent)? [p]% 2 points Save Answer QUESTION 2 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. Make sure that there are no random deposits or withdrawals. How much interest did you earn in month 35? $[d]
QUESTION 3 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. Make sure that there are no random deposits or withdrawals. What is your balance 40 years after starting the account? $[d] 2 points Save Answer QUESTION 4 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. Make sure that there are no random deposits or withdrawals. How much interest did you earn in those 40 years? $[d]
QUESTION 5 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the yearly interest rate to 6.5%. Make sure that there are no random deposits or withdrawals. How much money did you deposit total? $[d] 2 points Save Answer QUESTION 6 Change your spreadsheet so that you have an additional deposit of $1000 at the end of each year (months 12, 24, 36, etc.). Now what is your balance 40 years after setting up the account?
QUESTION 7 Change your spreadsheet (with the additional $1000 deposits) so that you had $3000 to start, and in month 320 you withdrew $10,000. Now what is your balance 40 years after setting up the account?
QUESTION 3 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. Make sure that there are no random deposits or withdrawals. What is your balance 40 years after starting the account? $[d] 2 points Save Answer QUESTION 4 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the Annual Interest Rate to 6.5%. Make sure that there are no random deposits or withdrawals. How much interest did you earn in those 40 years? $[d]
QUESTION 5 Same situation: Set the initial deposit to $0 and the regular monthly deposit to $50. Set the yearly interest rate to 6.5%. Make sure that there are no random deposits or withdrawals. How much money did you deposit total? $[d] 2 points Save Answer QUESTION 6 Change your spreadsheet so that you have an additional deposit of $1000 at the end of each year (months 12, 24, 36, etc.). Now what is your balance 40 years after setting up the account?
QUESTION 7 Change your spreadsheet (with the additional $1000 deposits) so that you had $3000 to start, and in month 320 you withdrew $10,000. Now what is your balance 40 years after setting up the account?