Assuming an 8% return on your "investment" is probably not realistic. In fact, trying to plan out ten years for a boat that you are assuming will be 60K is probably not realistic. As Omega points out, you didn't specify year 3, but I can tell you in a simple way that years 4-9 will require more than 2K per year.

Your formulation would be to take your base amount (6k) and multiply by 1.08 to get your assumed total for year one, then add 2k to that and multiply the result by 1.08.

This will give you your amount saved after two years. Subtract this amount from 60K to find out what you still need and divide by 7 to find out your yearly amount that must be added to your initial two years. multiply this number by .93 to give you an approximation of the 8 percent interest and you'll be in the ballpark

To have 60,000 in 10 years, you invest 6,000 for 9 yrs and 2,000 for 8 yrs.

The FV of 6,000, N 9, R 8%, is 11,994. The FV of 2,000, N 8, R 8%, is 3,702.

That's a total of 15,696, so you need an additional 44,304, saved in equal amounts over the last 6 yrs, from yr 4 thru yr 9. If the FV of an Annuity is 44,304, with N 6, R 8%, solve for the Annuity amount (PMT). Answer is 6,039.

What about year 3?

How do I solve this question using excel?

You want to buy a boat in 10 years. The boat will cost $60,000 in 10 years. You want to put down $6,000 in year 1, $2,000 in year 2, and then invest a fixed amount each year from years 4 to 9. What are the fixed amounts from years 4 to 9?

use 8% annual rate