Note: This Problem Requires Excel

question 3

Multiple Choice

Note: This problem requires Excel.
The marketing department has determined that the relationship between marketing expenditures (x) and sales can be modelled by the equation Sales = 100x − x2 + 20. Use a Nonlinear Solver tool to determine the level of marketing expenditure that will maximize sales.

• A) 40
• B) 50
• C) 60
• D) 70
• E) 80

---

Definitions:

Interest-Only

A loan payment option where the borrower is required to pay only the interest portion for a specific period.

Balloon Loan

A type of loan that typically requires small periodic payments and a large lump sum payment at the end of the loan term.

Amortized Loan

A loan with scheduled periodic payments that include both principal and interest.

Annuities

Financial products that provide a series of payments over time, often used for retirement income.