Charlie Brown, a 25-year-old professional, invests $200 a month in the XYZ Capital Opportunity Fund, which has a 10-year average return of 8.75%. Charlie wants to estimate what he will have for retirement when he Is 60 years old if the rate stays constant. Assume monthly compounding. If Charlie makes no further deposits and makes no withdrawals after age 60, how much will he have for retirement at age 65?
Charlie Brown, a 25-year-old professional, invests $200 a month in the XYZ Capital Opportunity Fund, which has a 10-year average return of 8.75%. Charlie wants to estimate what he will have for retirement when he Is 60 years old if the rate stays constant. Assume monthly compounding. If Charlie makes no further deposits and makes no withdrawals after age 60, how much will he have for retirement at age 65?
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 10P
Related questions
Question
- Charlie Brown, a 25-year-old professional, invests $200 a month in the XYZ Capital Opportunity Fund, which has a 10-year average return of 8.75%.
- Charlie wants to estimate what he will have for retirement when he Is 60 years old if the rate stays constant. Assume monthly compounding.
- If Charlie makes no further deposits and makes no withdrawals after age 60, how much will he have for retirement at age 65?
Expert Solution
Step 1 Part 1
Calculation of amount Charlie will have at the completion of 60 years is shown below:
Hence, the amount he will receive at the completion of 60 years is $552,540
Formula sheet of calculation of future value is shown below:
To open the "FV function" window - MS-Excel --> Formulas --> Financials --> FV.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning