This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
| Amortization Schedule | {42} | ||||
|---|---|---|---|---|---|
| Month | Date | Payment | Interest | Principal | Balance |
| 11/01/24 | - | - | - | $ 50,000.00 | |
| 1 | 12/01/24 | 500.00 | 500.00 | 0.00 | 50,000.00 |
| 2 | 01/01/25 | 500.00 | 500.00 | 0.00 | 50,000.00 |
| 3 | 02/01/25 | 500.00 | 500.00 | 0.00 | 50,000.00 |
| 4 | 03/01/25 | 500.00 | 500.00 | 0.00 | 50,000.00 |
| 5 | 04/01/25 | 500.00 | 500.00 | 0.00 | 50,000.00 |
| 6 | 05/01/25 | 50,500.00 | 500.00 | 50,000.00 | 0.00 |
| Balloon Payment Due | 05/31/25 | 0.00 |
Line 6 should show a payment of $500 and the balloon payment is due 5/31 fo $50,000 for interest only payments. The formula in the prior row for 500 is =IF(B116="","",IF(B116=$D$78,G115+E116,$C$96))
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you share a test file to check your formula? Then I can help you correct it.
For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.
*Please make sure you have removed any sensitive or private information in the sample file before uploading.