$4.$ In cell H$4,$ enter a formula with the PV function that uses the rate per quarter $($cell H$10),$ the total payments $($cell H$8),$ and the quarterly payment amount $($cell H$11)$ to calculate the present value of the loan Canyon Transport can afford if the quarterly payments are $$15,000$ over a $10-$year period.