If we were to invest $10,000 in an S&P 500 index fund, pay 0.2% annual fees, and add $100 a month to it for 40 years, receiving 10.4% annual returns, what, theoretically, would happen to our investment with 3.43% annual inflation? What would it be worth in terms of today's dollars? That's 10.4% - 0.2% - 3.43% = 6.77% over 40 years. Create an excelspreadsheet to show cash flow.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter12: Capital Investment Analysis
Section: Chapter Questions
Problem 3CMA
icon
Related questions
Question

Ef 446.

Short Case Study with Excel
If we were to invest $10,000 in an S&P 500 index fund, pay 0.2% annual fees, and add $100 a month to it for 40
years, receiving 10.4% annual returns, what, theoretically, would happen to our investment with 3.43% annual
inflation? What would it be worth in terms of today's dollars? That's 10.4% - 0.2% - 3.43 % = 6.77% over 40
years. Create an excelspreadsheet to show cash flow.
Transcribed Image Text:Short Case Study with Excel If we were to invest $10,000 in an S&P 500 index fund, pay 0.2% annual fees, and add $100 a month to it for 40 years, receiving 10.4% annual returns, what, theoretically, would happen to our investment with 3.43% annual inflation? What would it be worth in terms of today's dollars? That's 10.4% - 0.2% - 3.43 % = 6.77% over 40 years. Create an excelspreadsheet to show cash flow.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Investments
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College