Course Intermediate loan-schedule
Build a loan schedule
A business is borrowing 12,000 over two years and wants to see how the loan is paid off month by month. Build the repayment schedule: every month a fixed payment is made, part of it is interest on what is still owed, and the rest reduces the loan.
Sheet What it is for Filled cells
Parts
Part What to do Done
1 The monthly payment Not done yet
2 The first month Not done yet
3 The rest of the schedule Not done yet
4 What the loan costs Not done yet
Part 1 of 4 · The monthly payment
In B4, work out the fixed monthly payment for this loan, as a positive number.
Loading spreadsheet…
- =
- start a formula
- ↑ ↓ ← →
- move, or pick cells
- Ctrl D
- fill down
- Alt =
- AutoSum
- Ctrl Enter
- check
- ?
- all shortcuts