We will discuss engineering economics in Chapter 20. Using Excel, create a table that ca...

We will discuss engineering economics in Chapter 20. Using Excel, create a table that can be used to look up monthly payments on a car loan for a period of five years. The monthly payments are calculated from

where

A = monthly payments in dollars

P = the loan in dollars

i = interest rate, e.g., 7, 7.5, . . . , 9