Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Now that your family is growing, you and your spouse are looking towards the future and considering adding additional long-term investments to your financial plan.

Now that your family is growing, you and your spouse are looking towards the future and considering adding additional long-term investments to your financial plan. Be sure to complete all three parts below.\ \ Part One: \ In this Excel file, compute the following:\ \ Savings:\ You will place $5,000 into a savings account that pays 1% compounded yearly. Calculate the compounded yearly interest up to 10 years, 20 years and 30 years. \ \ Stocks:\ You will place $5,000 into a mutual fund for stocks. Calculate the compounded yearly interest rates beginning with 10 years at 11%, the next 10 years at 14% and the final 10 years at 8%. \ \ Bonds:\ You will place $5,000 into bonds. Calculate the compounded yearly interest rates beginning at 10 years at 2.4%, the next 10 years at 2.1% and the final 10 years at 3.1%. \ \ How much will you have after 30 years in each account?\ Based on your personal risk tolerance, which of these would you prefer and why?\ \ Show your calculations by using Excel formulas. You should not use a calculator. Note, calculating compound interest in this scenario will be to simply add the interest earned that year into your initial deposit and calculate the next years interest rate on the new total.

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

Financing California Real Estate Spanish Missions To Subprime Mortgages

Authors: Lynne P. Doti

1st Edition

184893601X, 978-1848936010

More Books

Students also viewed these Finance questions

Question

What does a mean of 4.08 and standard deviation of 2.82 signify

Answered: 1 week ago