This model is geared to someone who is in a situation where they want to invest in something but they have some debt with varying terms, remaining balances, and interest rates. So, they need to think about what makes more sense:
1. Paying off all the debt and investing what they have left in the investment they want.
2. Paying off the debt over time and investing a lot more money in the investment now.
As you start to dive into the mechanics here, you will see that the expected annual rate of return on the investment vs. the total debt and mechanics of that debt will play a huge role in the results.
The biggest assumption of this model is that in the scenario where you will pay off all the debt at once and then invest whats left, you will then invest the money you would be using for the monthly debt service of those loans into the investment going forward.
In #2 above you would be able to use the difference between the total starting debt service and what is remaining (so as you start to pay that debt down) as contributions to the running investment you have.
Once all the debt is finally paid off, there are no more assumed contributions.
The model goes out for a period of 42 years.
The measure of what ‘wins’ is what situation has a higher net investment position (investment value less current debt owed) at a given year in the future.
The investment will compound interest every month.
You will see it is not as easy as just saying you will pay off the debt if it has a higher interest rate than the investment. There are a lot of other factors that have a material impact on what results in having a higher investment value sooner.
|Summary||A sophisticated way to score the decision to pay off debt or invest as it relates to the ability to grow the investment amount.|
|Screenshots / Pictures||
|Use Cases||Amortization, Cash Flow Analysis, Cash Flow Projections, CFO, Debt Amortization, Debt Schedule, Excel, Financial Feasibility, Financial Projections, Forecast, Forecasting, Loans, Personal finance, ROI, Sensitivity Analysis|