(a) In cell A6, type 1. Rather than copying the numbers 2 to 25, we can fill down based on the formula in cell A7 which is = A6+1. Locate A7 (Since this is where the formula begins) by clicking on the center of the cell. Go to the far lower right hand corner of cell A7 and hold down the left mouse button when you see the cursor change. Holding the left mouse button down, drag the cell down to year 40 and let go off the mouse button. Couple A opens a bank account and decides to deposit $1900.00 at the end of each year for 8 years in an account which earns 8% interest compounded annually for 40 years. Year 8 is the last time they deposit any money meaning there is no deposit value for years 9 to 40. Remember that the Interest column is for the Interest formula, do not just put in the interest rate. When the couple opens the bank account (the first year), there is no money in Beginning Balance. Set up your spreadsheet for Couple A accordingly. You should get $23572.47 for your ending balance for year 10. What is the ending balance for Couple A after 40 years? $ How much did Couple A actually deposit? $ What is the total amount of interest earned by Couple A? $ (b)Couple B decides to "live it up" for the first 8 years, meaning there is no deposit value for years 1 to 8. At the end f year 9, they deposit $1900.00 at the end of each year in an account which earns 8% interest compounded annually. Set up your spreadsheet for Couple B, showing their financial status for 40 years. You should get $3952.00 for your ending balance for year 10. What is the ending balance for Couple B after 40 years? $ How much did Couple B actually deposit? $ What is the total amount interest earned by Couple B? $ (c)At what year has Couple B's account exceeded Couple A's account? (d)At the year couple B's account exceeded couple A's account (your answer from part c), in total how much more had couple B deposited than couple A. $
(a) In cell A6, type 1. Rather than copying the numbers 2 to 25, we can fill down based on the formula in cell A7 which is = A6+1. Locate A7 (Since this is where the formula begins) by clicking on the center of the cell. Go to the far lower right hand corner of cell A7 and hold down the left mouse button when you see the cursor change. Holding the left mouse button down, drag the cell down to year 40 and let go off the mouse button. Couple A opens a bank account and decides to deposit $1900.00 at the end of each year for 8 years in an account which earns 8% interest compounded annually for 40 years. Year 8 is the last time they deposit any money meaning there is no deposit value for years 9 to 40. Remember that the Interest column is for the Interest formula, do not just put in the interest rate. When the couple opens the bank account (the first year), there is no money in Beginning Balance. Set up your spreadsheet for Couple A accordingly. You should get $23572.47 for your ending balance for year 10. What is the ending balance for Couple A after 40 years? $ How much did Couple A actually deposit? $ What is the total amount of interest earned by Couple A? $ (b)Couple B decides to "live it up" for the first 8 years, meaning there is no deposit value for years 1 to 8. At the end f year 9, they deposit $1900.00 at the end of each year in an account which earns 8% interest compounded annually. Set up your spreadsheet for Couple B, showing their financial status for 40 years. You should get $3952.00 for your ending balance for year 10. What is the ending balance for Couple B after 40 years? $ How much did Couple B actually deposit? $ What is the total amount interest earned by Couple B? $ (c)At what year has Couple B's account exceeded Couple A's account? (d)At the year couple B's account exceeded couple A's account (your answer from part c), in total how much more had couple B deposited than couple A. $
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Transcribed Image Text:(a) In cell A6, type 1. Rather than copying the numbers 2 to 25, we can fill down based on the formula in cell A7 which is = A6+1. Locate A7 (Since this is where the formula begins) by clicking on the center of the cell. Go to the far lower right
hand corner of cell A7 and hold down the left mouse button when you see the cursor change. Holding the left mouse button down, drag the cell down to year 40 and let go off the mouse button. Couple A opens a bank account and decides to
deposit $1900.00 at the end of each year for 8 years in an account which earns 8% interest compounded annually for 40 years. Year 8 is the last time they deposit any money meaning there is no deposit value for years 9 to 40. Remember
that the Interest column is for the Interest formula, do not just put in the interest rate. When the couple opens the bank account (the first year), there is no money in Beginning Balance. Set up your spreadsheet for Couple A accordingly. You
should get $23572.47 for your ending balance for year 10.
What is the ending balance for Couple A after 40 years? $
How much did Couple A actually deposit? $
What is the total amount of interest earned by Couple A? $
(b) Couple B decides to "live it up" for the first 8 years, meaning there is no deposit value for years 1 to 8. At the end of year 9, they deposit $1900.00 at the end of each year in an account which earns 8% interest compounded annually. Set
up your spreadsheet for Couple B, showing their financial status for 40 years. You should get $3952.00 for your ending balance for year 10.
What is the ending balance for Couple B after 40 years? $
How much did Couple B actually deposit? $
What is the total amount of interest earned by Couple B? $
(c)At what year has Couple B's account exceeded Couple A's account?
(d)At the year couple B's account exceeded couple A's account (your answer from part c), in total how much more had couple B deposited than couple A.
$
Submit Answer
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 16 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education