Overhaulin'

MEC04102607.jpg

Summary: Now that you have the range of B1:B4 working, copy those cells and paste several times in columns C through F. Change the prices, terms, or interest rates to see the effect on the payment. Using Goal Seek What if you know that you want your payment to be $525? You can use the Goal Seek function. Put the cell pointer in cell G4. From the menu, select Tools - Goal Seek. In the

Image Dimensions: 432 x 113