Business & Finance Homework Help

Suppose you deposit $1,000 per year in a bond fund and $2,000 per year in a stock fund and do so for 10 years.  The bond fund pays a return each year that is a random draw a uniform distribution of whole percentages from 1% to 5%. The stock fund pays a return each year that is a random draw from a normal distribution with a mean of 10% and a standard deviation of 6%.  Calculate the terminal value of the total of the two investments in year 10.  Simulate the total 100 times.  Dynamically graph the histogram of these terminal values using a range of $25,000 to $60,000 using bins of $2,500. (This spreadsheet should solve this specific problem only.)