Homework answers / question archive / Madhu and Suvo Banerjee have investments that they maintain in an Excel workbook, and want to track the amount they invest in a retirement account and the varying rates of return they receive on the account

Madhu and Suvo Banerjee have investments that they maintain in an Excel workbook, and want to track the amount they invest in a retirement account and the varying rates of return they receive on the account

Computer Science

Share With

Madhu and Suvo Banerjee have investments that they maintain in an Excel workbook, and want to track the amount they invest in a retirement account and the varying rates of return they receive on the account. They also want to analyze their portfolio of other investments. Suvo has asked for your help in creating an investment analysis that he and Madhu can use to keep track of their accounts and forecast the balance they can expect in 30 years.
Go to the Dashboard worksheet, which provides an overview of the Banerjees' investments. The charts and the value in cell F2 will be updated when you modify the other worksheets in the workbook. For now, change the color of the outside borders of the range B2:I5 to Blue-Gray, Accent 1 (5th column 1st row in the Theme colors palette) to match the borders of the charts.