What would the payment be on this financing deal?
Real problems with no formula named for you. You decide what to use.
A vendor contract renewal needs financing. The deal below lists which rep brought it in, which won't factor into this. Using the amount, the term, and the monthly rate, find what the regular monthly payment on this financing would be.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Contract | Rep | Amount | Term (months) | Monthly Rate |
| 2 | #4410 | Dana | 9000 | 18 | 0.005 |
| 3 | Monthly Payment |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
Whether it's called a "loan" or a "financing deal," the math behind a regular payment is identical: recognizing the shape of the problem, not just the label on it, is the real skill here.
More case studies
- When does this project actually finish?
- Which region needs attention?
- Who still owes on their invoice?
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →