1. In cell H4, enter a formula with the PV function that uses the rate per quarter (cell H10), the total payments (cell H8), and the quarterly payment amount (cell H11) to calculate the present value of the loan Canyon Transport can afford if the quarterly payments are $15,000 over a 10-year period. Is this the right formula: =PV(H10,H8,H11)
2. 

File ne 1 2 3 Undo H4 Home Insert Draw Page Layout S Paste Clipboard CANYON TRANSPORT N Gill Sans MT B I U Buses and vans 4 Shuttle stop construction 5 Miscellaneous expenses 6 Total expenses 7 8 Cash 9 Non-cash assets 10 Miscellaneous assets II Long-term assets Documentation Font 11 Expenses Formulas Data Review View fx =PV(H10, H8, H11) A Airport Shuttles Business Plan Assets G A^ A A Business Plan Loan Details N $ B Alignment 320,000 150,000 20,000 490,000 35,000 112,000 80,000 115,000 242.000 Buy or Lease Help N Custom $ % 9 00000 Depreciation Number D Business loan (pv) Future value (fv) Years Annual interest rate N Profit & Loss Conditional Formatting Format as Table Cell Styles Payments / year Total payments (nper) Annual rate Rate / quarter (rate) Quarterly payments (pmt) $ + $ $ Styles E I DN N Insert x Delete F Format Cells 27. 0. G V Editing 5.60% Payment amount Future value Payments Loan amount (pmt) (fv) (nper) 490,000 $490,000 $490,000 $ (650,921) $ 10.99 4 43.97 5.60% 1.40% Comments Analyze Data Analysis H (pv) $ 457,037 $ 10 10 10 4 4 4 40 40 40 5.60% 5.60% 5.60% 1.40% 1.40% 1.40% (16,082) $ (15,000) $(15,000) $ (15,000) Sensitivity Sensitivity Share