👤

1. elena gonzalez works in the operations department of canyon transport, a company providing delivery and shuttle services in flagstaff, arizona. canyon transport is planning to offer shuttle services to the phoenix sky harbor airport, and elena is using an excel workbook to analyze the financial data for these expanded services. she asks for your help in making financial calculations in the workbook. go to the business plan worksheet. in the range a2:b29, elena has already entered expenses, assets, and other information for the new airport shuttle service. now she needs to make financial calculations in the range e4:h11. in cell e11, enter a formula with the pmt function that uses the rate per quarter (cell e10), the total payments (cell e8), and the business loan amount (cell e4) to calculate the quarterly payment amount for a 10-year loan at a 5.6 percent annual interest rate.