Jacob Is Using Excel to Track the Installment Loan He

question 25

Essay

Jacob is using Excel to track the installment loan he used to buy a new boat. He has entered the purchase price in Cell B5, the interest rate in Cell B6, the down payment percent in Cell B7, and the years for the loan in Cell B8. Formulas will be entered to calculate amount financed in Cell B9, finance charge in Cell B10, and monthly payment in Cell B11.
Jacob needs help to write the formula to determine the monthly payment. How would you explain to Jacob what he needs to calculate so that explanation can turn into an Excel formula? What is the formula?

---

Definitions:

Distributive Bargaining

A negotiation strategy focused on dividing a limited amount of resources where one party's gain results in another party's loss.

Strategies

Approaches or plans developed to achieve objectives efficiently.

Tactics

Carefully planned strategies or actions aimed at achieving a specific goal.

Opportunity To Retreat

The option or possibility for an individual or group to withdraw from an uncomfortable, challenging, or dangerous situation safely.