Calculate Loan Interest & Amortization
Budget: $250 – $750 USD
I have a $1,775,000 note that will be repaid over 120 months with level installments of $10,000 beginning 30 days after signing, followed by a final balloon of $175,000 at the end of the term.
What I need from you is twofold: first, determine the single annual interest rate that makes those cash flows balance when interest is accrued on a 360-day basis using simple interest; second, build a complete amortization schedule in Excel that reflects that rate.
The workbook should show each monthly period, the day-count convention applied, interest and principal split, running balance, and the balloon payout in the final line. Please keep the file clean and formula-driven so I can adjust assumptions later if needed. A brief note or separate tab that explains the key formulas you used will help me follow your logic.
Once the calculation in Excel reproduces the $10,000 stream and the $175,000 balloon exactly, along with the correct annual rate, the job is done and ready for delivery.
What I need from you is twofold: first, determine the single annual interest rate that makes those cash flows balance when interest is accrued on a 360-day basis using simple interest; second, build a complete amortization schedule in Excel that reflects that rate.
The workbook should show each monthly period, the day-count convention applied, interest and principal split, running balance, and the balloon payout in the final line. Please keep the file clean and formula-driven so I can adjust assumptions later if needed. A brief note or separate tab that explains the key formulas you used will help me follow your logic.
Once the calculation in Excel reproduces the $10,000 stream and the $175,000 balloon exactly, along with the correct annual rate, the job is done and ready for delivery.
Related categories:
Accounting
Excel
Finance
Business Analysis
Financial Analysis
Financial Planning
Data Analysis
Financial Modeling