Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create / solve the following using only excel: 1 . If you invest $ 1 0 , 0 0 0 today in the S&P 5

Create/solve the following using only excel:
1. If you invest $10,000 today in the S&P 500, assume an 8.25% return and never add or take any money out, how much will you have in 10 years? What about 20?30?40?50? Create a graph with these 5 data points (years and account balance).
2. On a new worksheet create a table showing the account balance for each individual year from year 0 to year 350(should have 2 columns; year and balance). Create a chart showing this and check axis titles, make sure it makes sense.
3. On a new worksheet, assume we have the initial investment of $10,000 and you will invest an additional $1000 at the end of each year, what is the account balance in 10,20,30,40 and 50 years? Solve this using excel functions in individual cells and create a table showing the account balance for each year.
4. Extend number 3 to 350 years, what is the account balance and create a chart/graph of this data.
5. Initial $10,000 investment and invest an additional $1000 per year but this $1000 will increase by 5% each year. Build a table with account balance from years 0 to 350.
6. Let's assume we invest in a triple-levered Nasdaq index fund instead of the S&P 500 and the annual returns are 13.4%, change this assumption and all of your models should update.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance The Markets And Financial Management Of Multinational Business

Authors: Maurice D. Levi

3rd Edition

0070376875, 978-0070376878

More Books

Students also viewed these Finance questions

Question

How does the "invisible hand" work in a competitive market system?

Answered: 1 week ago