Only need help knowing how to do part A. Thanks!

F G HIILIKIM N. Mutual Fund Rate of Return: 10% Year a.) Deposit $6,000.00 New Balance $0.00 End Balance You are going to put money away every year into a mutual fund which returns 10% a year. You will deposit $6,000 in the first year and then increase your deposit by 3% every year (since your salary will be increasing also). Assume you start with $0 in the account and make the deposit at the beginning of the year so it always grows by 10% each year. a.) Create a spreadsheet which keeps track of this investment over 30 years. Format as currency with two decimal places. b.) b.) How long will it take you to get to $1 million? Give the year in which the ending balance goes above $1 million for the first time. UW BEDONOWN c.) Given your answer in part (b), determine what the value of that $1 million is in today's dollars by assuming a 3% inflation rate. In other words, what amount of money today would grow at 3% for the number of years in part (b) to equal 1 million? Format as currency with two decimal places. d.) What has a bigger impact on your ending balance after 30 years: increasing the rate of return by 50% to 15% or doubling the initial deposit to $12,000? To answer this, change the rate to 15% and look at the end 19 Instructions Questions O Type here to search