A mortgage amortization schedule can be useful for: comparing my loan-balance calculations to the mortgage company’s records; identifying when mortgage insurance should no longer be required; planning the payoff of the mortgage prior to retirement or another significant life change; recognizing how much of the payment goes to insurance, taxes, etc. and will continue even after the mortgage is paid; analyzing the impact of extra payments (and later comparing this impact to the benefit of using those funds for a purpose other than mortgage payoff). Inside, there’s a link to a downloadable schedule.
Thinking ahead about how investing can support financial goals is the purpose of planning. Naturally, there’s lots of talk about common planning targets: retirement and college. But there’s also consideration of how to achieve multiple goals at various stages of life — whether covering basic needs or leaving a legacy — and how taxes and tax planning could impact results. Articles in the planning category allow you to clarify how today’s decisions can impact efforts to grow, manage, and maintain wealth.
When I decide to start receiving benefits affects my monthly Social Security check for the rest of my life. That is, if I choose to collect checks prior to normal retirement, then the monthly amount is reduced; likewise, if I wait until I’m past regular retirement age, I receive a bigger monthly check. So, among the retirement decisions that I need to make, this one seems fairly significant.
When presented with general concepts or rules of thumb relating to personal finance, my brain resists automatic acceptance. My look-under-the-hood tendencies rebel when I hear a statement like “it’s always better to invest rather than pay off debt” or vice versa.
To truly understand an idea (and prove or disprove its claim), I love to design a spreadsheet. Using this tool, I can break down a concept and illustrate how it works or demonstrate where it falls apart.
In this article, I’ll explain the basics of setting up personal finance spreadsheets, including how to design formulas with financial functions like PMT (payment), FV (future value), and PV (present value).