Custom Loan Amortization Table Creation
Budget: $10 – $30 USD
I need an Excel spreadsheet that outlines the amortization for a $450,000 loan over 20 years at a 3.9% interest rate. The total monthly payment will be $5,000 starting August 2024.
The project involves some intricate calculations and comparisons between two interest rates:
- I will be remitting payments calculated at a 5.45% rate. You will need to create a separate column indicating the difference between this rate and the 3.9% rate. This column should not influence the principal or interest.
- Develop a standard 3.9% amortization chart, and a standard 5.45% chart.
- Calculate the interest difference between the two charts, and create a new 3.9% chart. This chart should reflect roughly half of the excess overpayment (considering the total payment of $5,000) divided between additional principal payments and a side payment.
- The side payment, in conjunction with the 3.9% interest rate, should equate to the total interest of a conventional 5.45% chart.
I have provided a sample chart that I attempted to create, which was incorrect due to not utilizing a starting amount of $450,000.
Total interest paid needs to be $129,863.20 with part of that going towards the traditional 3.9% rate and the rest going toward the side payment.
Ideal skills for this job include:
- Proficiency in Excel, particularly with financial functions
- Strong understanding of loan amortization
- Attention to detail and ability to perform complex calculations
- Ability to create clear, organized spreadsheets
Please let me know if you have any questions or need further clarification.
The project involves some intricate calculations and comparisons between two interest rates:
- I will be remitting payments calculated at a 5.45% rate. You will need to create a separate column indicating the difference between this rate and the 3.9% rate. This column should not influence the principal or interest.
- Develop a standard 3.9% amortization chart, and a standard 5.45% chart.
- Calculate the interest difference between the two charts, and create a new 3.9% chart. This chart should reflect roughly half of the excess overpayment (considering the total payment of $5,000) divided between additional principal payments and a side payment.
- The side payment, in conjunction with the 3.9% interest rate, should equate to the total interest of a conventional 5.45% chart.
I have provided a sample chart that I attempted to create, which was incorrect due to not utilizing a starting amount of $450,000.
Total interest paid needs to be $129,863.20 with part of that going towards the traditional 3.9% rate and the rest going toward the side payment.
Ideal skills for this job include:
- Proficiency in Excel, particularly with financial functions
- Strong understanding of loan amortization
- Attention to detail and ability to perform complex calculations
- Ability to create clear, organized spreadsheets
Please let me know if you have any questions or need further clarification.