Wesley dreams of being a cyclist in international competitions 10 years from now. Her father, who is fond of this sport, is interested in knowing how much it would cost to send a bicycle for her with the following components:

Compare the total current value of all items versus the total value 10 years from now considering inflation. Determine the average inflation rate of total costs during that period.

You must use Excel to solve these problems and display all your computations. Include comments and annotations when you deem it necessary (for example, to make a presumption).

PLEASE USE EXCEL ONLY AND THIS FUNCTIONS. It's very important to my class. Thanks a lot!

Item Current cost Bicycle frame Rubbers Gear system Braking system Saddle Finish $3,500 $1,200 $1,800 $1,250 $250 $400 Cost will inflate a rate X% per year 4.5% 7% 5% 3% 2.5% 8%