Loan pay off diff
https://www.reddit.com/r/googlesheets/comments/144ihla/various_helper_toolsformulas_information/?share_id=o3WJP15HOQLMtQtROqQdj&utm_content=2&utm_medium=android_app&utm_name=androidcss&utm_source=share&utm_term=1
Content article
In this analysis of a loan payoff plan, we examine a principal loan amount of $1,200,000 with an interest rate of 6.5% over a 30-year term, beginning on August 1, 2023. The monthly payment is set at $8,054.82, which includes an escrow amount of $470.
As of September 2023, the remaining balance on the loan is $1,198,915.18, with an interest payment of $6,494.12 and a principal payment of $1,090.70. By October 2023, the balance decreases slightly to $1,197,824.48, with an interest payment of $6,488.22 and a principal payment of $1,096.60. This trend continues into November 2023, where the remaining balance is $1,196,727.88, with interest and principal payments of $6,482.28 and $1,102.54, respectively.
Each month, the balance decreases, with December 2023 showing a remaining balance of $1,195,625.34, an interest payment of $6,476.30, and a principal payment of $1,108.52. The monthly payments remain consistent, with the interest component gradually decreasing while the principal component increases. For instance, by January 2024, the loan balance is $1,194,516.82, with an interest payment of $6,470.30 and a principal payment of $1,114.52.
Moving into early 2024, the loan balance continues to decline. In February, the balance is $1,193,402.30, with interest at $6,464.26 and a principal payment of $1,120.56. March 2024 sees a balance of $1,192,281.74, with similar trends in interest and principal payments. By April 2024, the remaining balance is $1,191,155.11, with an interest payment of $6,452.09 and a principal payment of $1,132.73.
The data reveals a consistent pattern of decreasing balances and changing payment compositions. For example, by August 2024, the balance is $1,186,587.24, with interest at $6,427.35 and a principal payment of $1,157.47. As the months progress into 2025, the remaining balance continues to decline, with notable figures such as $1,164,687.54 in April and $1,164,411.44 in May.
As the year unfolds, the loan balance in January 2026 drops to $1,137,623.02, with an interest payment of $6,162.12 and a principal payment of $1,422.70. By March 2026, the balance is $1,134,769.92, with similar interest and principal payments. The trend continues with decreasing balances, such as $1,131,885.83 in June and $1,059,030.90 in April 2027.
The final entries show a balance of $1,049,688.23 in September 2027, with an interest payment of $5,685.81 and a principal payment of $1,899.01. This data illustrates the gradual reduction of the loan balance over time, highlighting the impact of consistent monthly payments on the overall loan structure.