Question: Macy opens a savings account with $ 3 , 5 0 0 . She then continues depositing $ 1 , 2 0 0 every quarter.

Macy opens a savings account with $3,500. She then continues depositing $1,200 every quarter. How much will she have saved at the end of 20 years if the account pays interest at an APR of 5% compounded:
a.12 times a year?
b.52 times a year?
c.365 times a year?
I need to know how to set this up and solve in excel, so plese show step by step including formulas in excel. Screenshots would be very helpful.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Amaury, a citizen of France with no trade or business activities in the United States, sells at a gain 200 shares of Gage, Inc., a U.S. company. The sale takes place through Amaury's broker in Paris....

Q:

Exercise 5.1: Macy opens a savings account with $3,500. She then continues depositing $1,200 every quarter. How much will she have saved at the end of 20 years if the account pays interest at an APR...

Q:

INSTANT UPVOTE!!! Head of Evtel Kitchen Appliances Milos wants to work with a start-up specializing in smart home technologies to expand EvTel's business. He asks Tolga, a new graduate hire from the...

Q:

Please Help Me I give You Upvote Don't make excuses for the question when you can't solve it, I've updated the pictures, solve it now please Head of Evtel Kitchen Appliances Milos wants to work with...

Q:

SHOW FORMULA FOR ANSWERS B J K L Part 4 15 C D E F G H Eyll opens a savings account in FIBABANKA with a monthly interest rate of 2 %, solve the questions below accordingly. Assume that the savings...

Q:

do whatever parts u can do and ill be thankfull expected to increase by 9% each year. expand EvTel's business. He asks Tolga, a new graduate hire from the R&D department, to research start-up...

Q:

SOLVE AND PART 3 SHOW FORMULA USED IN EXCEL FORMAT. a Search the web a FD: XIUM S023159_13 - Microsoft Excel (Product Activation Tailed) Filc Home Insert Page Layout Formulas Data Reviw View Calibri...

Q:

please put in an excel table like the example shown. Using the Excel spreadsheet, Practice Problems * [7b1] After consulting with your financial advisor, you figured that you need to invest $20,000...

Q:

First, complete page one of the worksheet first by closely following the directions of each question. Much of the assignment is subjective based on your own financial goals, but the math is objective...

Q:

Hi, please help me step by step complete scenario 2. A friend of yours opens a savings account and immediately invests R15,000 in the account. Thereafter your friend decides to invest an amount of...

Q:

Hi, please help me step by step complete scenario 3. . Home Insert Page Layout Formulas Data Review View A1 B C D E F G K M N R O Q A friend of yours opens a savings account and immediately invests...

Q:

W.L Gore & Associates, founded by Bill Gore became a great innovative company and the best place to work for its employees. The company became a great place to work for about 10,000 employees. He...

Q:

Q.1) Consider the Solow Model with the production function Y = K *L* which states that output depends on the capital stock and labor force. Assume that = 1/2, 30% of the output is saved, 10% of...

Q:

Which of the following types of debt protect a bondholder against an increase in interest rates? Question 1 options: a) Floating rate debt. b) Bonds that are redeemable ("putable") at par at the...

Q:

the critcal activties in a cpm analysis are found by locating the actiyives times with non zero slack

Q:

What is the difference between a traditional interview question and a behavioral interview question? (Objective 3)

Q:

Technology. Use a website to locate salary information for a beginning accountant, administrative assistant, computer programmer, and finance manager in the largest city in your state. In an e-mail...

Q:

Go to the Student Resources section of the website for Chapter 17. Retrieve and print two copies of the employment application form. Read the directions carefully and then complete the entire form....