Calculate how much you would need to borrow for each purchase.

In cell C$16,$ enter a formula to calculate the price of the vehicle minus your available cash $($from cell A$3$ in the Data worksheet$).$ Use absolute references where appropriate$$you will be copying this formula across the row.