a. Open e07h2Salary_LastFirst and save it as e07h3Salary_LastFirst , replacing h2 with h3. Click the 3-Finance worksheet tab . You will calculate the periodic interest rate and number of payment periods before you can calculate the present value of the loan.

b. Click cell E3 , type = B3/B5 , and then press Enter . The periodic rate, 0.438%, is the result of dividing the APR by the number of payments per year.

c. Type =B4*B5 in cell E4 and press Enter

a. Open e07h2Salary_LastFirst and save it as e07h3Salary_LastFirst , replacing h2 with h3. Click the 3-Finance worksheet tab . You will calculate the periodic interest rate and number of payment periods before you can calculate the present value of the loan.

b. Click cell E3 , type = B3/B5 , and then press Enter . The periodic rate, 0.438%, is the result of dividing the APR by the number of payments per year.

c. Type =B4*B5 in cell E4 and press Enter

a. Open e07h2Salary_LastFirst and save it as e07h3Salary_LastFirst , replacing h2 with h3. Click the 3-Finance worksheet tab . You will calculate the periodic interest rate and number of payment periods before you can calculate the present value of the loan.

b. Click cell E3 , type = B3/B5 , and then press Enter . The periodic rate, 0.438%, is the result of dividing the APR by the number of payments per year.

c. Type =B4*B5 in cell E4 and press Enter

c. Type =B4*B5 in cell E4 and press Enter