Excel Loan Interest Schedule
Budget: $10 – $30 USD
I have a short-term note that was funded on January 29, 2025 and must be repaid in full by December 31, 2025. The principal accrues interest at 10.5 % per annum, compounded quarterly, which is above the current IRS AFR for a loan of this term.
What I need from you is a clean, well-labeled Excel workbook that automatically calculates:
• the opening principal for each quarter
• the interest accrued during that quarter (10.5 % annual rate, quarterly compounding)
• the total remaining balance at the end of each quarter
Please add a concise summary section beneath the table that displays the final balance as of December 31, 2025. All formulas should remain visible and editable so I can adjust the principal or dates later if required; no hard-coding of values except the given rate and dates.
If any underlying assumptions are needed—day-count basis, exact number of days per quarter, or a specific principal amount—set them up as clearly marked input cells so I can tweak them instantly. A quick turnaround is appreciated since I’d like to circulate the schedule with the other parties this week.
What I need from you is a clean, well-labeled Excel workbook that automatically calculates:
• the opening principal for each quarter
• the interest accrued during that quarter (10.5 % annual rate, quarterly compounding)
• the total remaining balance at the end of each quarter
Please add a concise summary section beneath the table that displays the final balance as of December 31, 2025. All formulas should remain visible and editable so I can adjust the principal or dates later if required; no hard-coding of values except the given rate and dates.
If any underlying assumptions are needed—day-count basis, exact number of days per quarter, or a specific principal amount—set them up as clearly marked input cells so I can tweak them instantly. A quick turnaround is appreciated since I’d like to circulate the schedule with the other parties this week.