Now that you have the boat, you're going to need something to tow it with. The truck you want is a MODEST $$81,250.$

You are able to place $$2,800$ in to an account at the end of each year. No balance on year $0.$ First deposit is on year $1.$

But, you know that won't get you there. You are retiring in $14$ years.

You are expecing some bonds to mature soon $(6$ Years$).$ Start the savings account now.. $6$ years from now, you will have $$ from bonds to apply to this loan.

If you can get a $3\mathrm{.}75\%$ rate on you account $($PYCY$)...$ how much do you need from your bonds to make this work? SOLVE IN EXCEL FORMAT WITH EXCEL FORMULAS WORKED OUT NOT EQUATIONS