TValue can compute the balance on an investment or loan as of a chosen date. It will also compute the date when a certain balance is reached. When you click the Home ribbon's Balance button in the Summarize group, the Balance dialog will appear.
Between payment dates, the balance is computed using a prorated approach in Rule of 78 mode, and a stub-period approach in all other computation modes. The stub-period approach is equivalent to removing all payments after the balance date and solving for a single unknown payment at that date.
To calculate a balance as of a particular date or the date when a specified balance is reached
- From the Home ribbon's Summarize group, click the Balance button. The Balance dialog will appear.
- You have two options
- Enter the Date and click Get Balance. The Balance will be calculated and displayed.
- Alternatively, enter the amount of the Balance and click Get Date. The Date will be calculated and displayed. If the Date you enter falls after the last scheduled cash flow, the Create Balloon button will be enabled. If you click that button, TValue will add a final Payment or Withdrawal on the Date shown in the Balance dialog that will pay off the loan or withdraw the final balance.
- To leave the Balance dialog, choose Done.
Learn about How TValue Calculates a Balance.