*SHOW WORK IN EXCEL*

Problem 4: 8 Points You have the plan locked in for the RV account. You want a fun car to tow behind it and are looking at a new Jeep. You need $47,000 in that account in 14 years. You are able to place $1,650 in to the account at the end of each year. No balance on year 0 . First deposit is on year 1. 4 But, you know that won't get you there. 5 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. 6 If you can get a 3.90% rate on you account (PYCY)... how much do you need from your bonds to make this work