Reduce Debt - Use a lump sum inflow to partially repay (pay down) a debt

To model a large, one-off partial repayment of a mortgage (not a debt payoff, which is even easier to do):

1. First add two events to the timeline. You can add an event either by going to the Time screen or, on any of the data entry screens, select the Time panel > Event tab and click the New Event button.

2. Drag and drop an event onto the timeline in the year the overpayment is to occur. Name it "Mortgage Paydown", for example.

3. Place a second event in the following year of the plan. Name it "Resume Regular Mortgage Payment", for example.

 

4. Go to the Expenses > Basics screen.

5. Select the Mortgage Payment expense for the property.

This is the expense that the software creates automatically when a debt is entered into a plan.

6. First expand the Inflation panel and select Future Value.

Note: Normally it's best to leave this at the default, Present Value. In this case, however, the Future Value will ensure that the 'stepped' mortgage payment amounts will be applied exactly as entered and will not be inflated using the inflation rate, above, as will occur whenever Present Value is selected.

7. Next, expand the Step Up / Step Down panel.

8. Select the first of the two events to schedule the overpayment. Enter the stepped-up payment amount. Inflation rate can be left as is. Enter the full increased debt payment amount. 

Another set of fields will display automatically on the Step Up / Step Down panel allowing you to enter an additional step.

9. Select the second of the two events and enter the regular mortgage payment amount, stepping it down to the usual amount in the year following the overpayment.

10. Click Update to save these changes.

Check the details of the Let's See chart to verify that this is being modelled as expected.

 

Related Topics

Schedule a Debt Payoff - Use a lump sum inflow to pay off a debt

Is surplus income assumed spent or saved?

What happens to a lump sum inflow if it is not spent or reinvested? How can they be reallocated?

 

 

Other possible ways to use lump sum inflows proactively within a plan include: 

Transfer (deposit) a lump sum inflow into a savings account, investment or money purchase

Use a lump sum inflow to purchase an onshore / offshore life fund or discounted gift trust

Use a lump sum inflow to purchase a property or other asset

Use a lump sum inflow to pay off a debt

 

Further Reading

Cash Flow Basics - An introduction to the basics of cash flow in Voyant