1. What formula would you use to calculate the value in B5?

A.EFFECT

B.PMT

C.None of the provided answers

D.PAYMENT

E.RATE

What are the references you would need to use in the formula in B5?

A.(B2, B3, B1) * 12

B.B2/12, B3, B1

C.B2, B3, B1

D.B1, B2, B3

E.None of the provided answers

What formula would you use to calculate the value in E5?

A.EFFECT

B.PMT

C.None of the provided answers

D.RATE

E.PAYMENT

What are the references you would need to use in the formula in E5?

A.E2, E3, E1

B.E2/12, E3, E1

C.E1, E2, E3

D.(E2, E3, E1) * 12

E.None of the provided answers

What formula would you use to calculate the value in E6?

A.None of the provided answers

B.PAYMENT

C.RATE

D.PMT

E.EFFECT

What are the references you would need to use in the formula in E6?

A.(E5, 12) * 12

B.E5, 12

C.(E5, 12) / 12

D.None of the provided answers

E.E5, E2

Assume you are interested in taking out a student load for $10,000 and you have some options to consider. You should assume 12 payments per year and an annualized interest rate. Please refer to the following spreadsheet to answer the next 6 questions. E4 A B E F G 1 Loan Amount 2 Interest Rate 3 Number of Payments $10,000.00 6% D Loan Amount Number of Payments Monthly Payment Amount $ 10,000.00 60 60 -250 4 5 Monthly Payment Amount 6 Interest Rate Effective Annual Interest Rate 7 8 9 Sheet1 Sheet3 Sheet4 Sheets Ready Display Settings 1 + 100%