TValue Tour

This document is designed to familiarize you with the features of TValue. Along the way, you will learn the basics of structuring a simple loan and printing an amortization schedule so you can get started right away. The ideas and procedures mentioned here are described in greater detail in other help documents accessed by links throughout.

Entering Sample Loan Information

Facts     Lockwood borrows $21,646 to finance the purchase of an auto on April 15, 2025. The annual interest rate is 8 percent, and the loan is to be repaid in 60 equal monthly payments beginning June 1, 2025.

Needed     The Monthly Payment Amount and an amortization schedule.

When you open TValue, the Guide Screen is displayed unless you have turned it off. If you have the Guide Screens turned off, when you open TValue you are taken to a blank document with some of the fields taking their system defaults.

Note: Factory default = the Guide Screen is turned on.

The Guide Screen can be turned off by unchecking the Show the guide screen when the application starts box at the bottom of the Guide Screen. It can be turned back on by checking the Show the guide screen when the application starts box in the Startup view which is accessed by choosing Options from the File tab's menu. The Guide Screen is also available by choosing New from the File tab's menu regardless of the state of the checkbox.

Tour Tip: The section below describes how to use the Auto loan Guide Screen. If you have the Guide Screen turned off and just want to start your tour from a blank document, skip to the Entering a Label section.

Using the Auto loan Guide Screen

1. Click the Auto loan button. The Auto loan dialog window is displayed.
2. The Start date defaults to the current date. As our example loan starts on April 15, 2025, click in the Start date field and enter 041525 or click the Calendar button and select April 15, 2025. Press [Tab].
3. In the Loan amount field, type 21646 and then press [Tab].
4. Choose 5 years from the drop-down list or type 5 in the Loan term field and then press [Tab].
5. Type 8 in the Interest rate field and then press [Tab].

   The Auto loan dialog should now appear as shown below.

** AUTO LOAN GUIDE HERE **

6. Click Create.

The pre-populated Cash Flow Data window should now appear as shown below. We can now further adjust the cash flow to fit our specific auto loan scenario

** CFM HERE **

Entering a Label

The Label is an optional field that lets you enter a description of the note you are working on. The description you type in the Label field will not appear on printed reports unless you choose to include it.

1. Type Lockwood automobile loan and press [Tab].

   If you make a mistake, click in the Label field and edit the text. To enter additional lines of text, click the expansion adorner at the lower right to add more lines.  Alternatively, [Ctrl]+[Enter] will also expand the Label field into multi-line mode.

Tour Tip: If you used the Auto loan Guide Screen, you can [Tab] through the fields of the cash flow matrix until you get to the Payment Event line (line 2) or simply click in the Payment Event field. Skip to the Entering the Payment Dates and Amounts section below..

Selecting a Compounding Period

1. Click in the Compounding Period field to display available choices.
2. Select Monthly as the Compounding Period and press [Tab].

Note: Factory default = Monthly. The Default compound period can be changed in the Cash Flow view which is accessed by choosing Options from the File tab's menu and then choosing the Cash Flow button from the menu on the left.

Entering an Interest Rate

1. In the Nominal Annual Rate field, type 8.
2. Click the expansion adorner at the lower right of the field to display a dialog of interest rates.

   Notice that TValue has calculated three other interest rates based on the Compounding Period chosen. You can enter any of the rates first and TValue will compute the others. Press [Enter] to get from one rate to another.

3. Click [Tab] to close the dialog of interest rates and move to the first cash flow line.

Entering the Loan Event, Date, and Amount

The details of the loan and payments are entered on individual cash flow lines which are numbered on the left hand side of the Cash Flow Matrix. You can enter and arrange information on cash flow lines in a logical progression.

The first cash flow line automatically appears in the Cash Flow Matrix.

1. Select Loan as the Event for the first cash flow line.

   Events include Loan, Payment, Deposit, Withdrawal, Rate Change, and User Events. User Events can be named to suit your needs by selecting the Event Names view which is accessed by choosing Options from the File tab's menu and then choosing the Event Names button from the menu on the left.

   Note: Factory default = Loan. If you work with Events other than Loans, such as Deposits or Leases, you can change the Default event type in the Cash Flow view which is accessed by choosing Options from the File tab's menu and then choosing the Cash Flow button from the menu on the left.

2. Press [Tab] or click in the Date field and type 041525.

   This is the date the auto loan starts to accrue interest. TValue will display 4/15/2025 when you move to the next field. You can also input dates with separators between characters such as 4-15-25 or 4/15/25. The year can also be entered as four digits.

   Note: The default is the current system date.

3. Press [Tab] or click in the Amount field and type 21646. This is the amount of the auto loan. TValue will display 21,646.00.

   Tip: From the Loan Amount field, you can access the Points & Fees details for entering loan charges and prepaid interest that are used to compute the Annual Percentage Rate (APR). To expand the cash flow line and access the Points & Fees details, click the Home ribbon's Loan Details menu button in the Details group or press [F2] in the Amount field.

4. Press [Tab] or click in the Number field. The Number field shows the number of times the Event occurs at regular intervals.

   Note: The default is 1.

5. Press [Tab] to accept 1 as the Number of Loans.

   The Number 1 will remain in the Number field. The Period and End Date fields are skipped because there is only one Loan. You can add a Memo to this cash flow line by clicking in the Memo field and typing in your memo.

Your Cash Flow Data window should now appear as shown below.

** CFM HERE **

Entering the Payment Dates and Amounts

Payment is the default Event on the second cash flow line because Loan is the first Event. If Deposit were the first Event, then Withdrawal would default here.

1. Press [Tab] or click in the Date field and type 060125. This is the date of the first payment.

   Note: Factory default = the Date will be one compound period later than the Date on the first cash flow line. This can be changed to Default second event date same as first in the Cash Flow view which is accessed by choosing Options from the File tab's menu and then choosing the Cash Flow button from the menu on the left.

2. Press [Tab] to move to the Amount field.
3. Press [U] to designate the Payment Amount as Unknown. The word "Unknown" will appear in the Amount field.

   Tip: From the Payment Amount field, you can display the Special Series expanded cash flow line detail to create special payments such as Interest Only or Fixed Principal Plus Interest. To display this detail, click the Home ribbon's Special Series menu button in the Details group or press [F2] in the Amount field.

4. Press [Tab] to move to the Number field.

5. Type 60 in the Number field and press [Tab]. This is the number of monthly payments during the 5 year period.

   The word "Monthly" will appear in the Period field. The Period is the length of time between the events on a given cash flow line. The End Date, in this case 05/01/2025, is the date of the last payment in the series and is calculated automatically.

Your Cash Flow Data window should now appear as shown below.

** CFM HERE **

Solving for the Unknown

Once you enter the details of the loan and payments, you can quickly calculate the value of any Unknown.

Calculating the Payment Amount

1. Press [F9], [Ctrl]+[U], or click the Calculate button in the ribbon's Compute group to compute the Unknown Payment Amount.

   Solution     The Monthly Payment Amount of $440.44 will appear in the Amount field.

2. Click the Rounding button in the Home ribbon's Compute group to check rounding.

    

This displays the Rounding dialog and gives you a chance to deal with any leftover rounding amounts.

** ROUNDING SCEEN SHOT HERE **

TValue has internally checked the amortization schedule for any rounding adjustments. A balance of 9 cents remains.

3. Click the Ignore (add to last interest amount) option to ignore the rounding adjustment and then click OK to close the dialog.

TValue will change the interest included in the last payment from $2.92 to $2.83 in order to make the final balance zero.

If you select the Last Payment option, the last payment will increase by 9 cents.

Displaying and Printing the amortization schedule

You can produce a detailed amortization schedule from the information you enter in the TValue schedule. The schedule shows the details of interest and principal and can be modified for your needs.

Displaying and Printing the amortization schedule

1. Click the Amortization Schedule button or press [F4].

    

The amortization schedule is displayed as shown below.

** AMORTIZATION SCHEDULE HERE **

2. Use the scroll bars or arrow keys to move to the end of the report. You will see the Grand Totals and the message "Last interest amount decreased by .09 due to rounding".

3. To print the amortization schedule, click the Print button on the Quick Access Toolbar or choose Print from the File tab's menu.

4. If you had entered any Points & Fees for the Loan, the APR disclosure would appear at the end of the amortization schedule by default.

You can also view the amortization schedule in PDF, WORD, EXCEL, CSV, or XML by clicking the appropriate button from the Export Schedule group of the Amortization Schedule Report ribbon. This action would automatically open the specific program with the data already exported in that format.

Saving Your Work

To save your data, you must give the file a name and store it on disk.

Saving a TValue File

1. From the Quick Access Toolbar, choose the Save button, or choose Save from the File tab's menu.

   If you are saving the schedule for the first time, TValue displays the Save As dialog.

   ** SCREEN SHOT HERE **

2. The text you typed in the Label field has defaulted to the File name field in the Save As dialog. The file will be saved in the open directory as Lockwood automobile loan.TV7. TValue will automatically add the .TV7 extension.

   To save the schedule so it can be read by TValue version 6, you can choose TValue 6 Files (*.tv6) from the Save as type field.

   Note: To change the default directory that TValue displays when you save a file, see Changing the Default Working Directory.

3. Click Save.

Additional things to know

Sending a TValue file

With TValue version 7, you now have the option of sending the TV7 file or a PDF of the amortization schedule via email.

Note: This only works if you have an email client configured and enabled on your system.

1. From the File tab's menu, choose Send To.

** SCREEN SHOT HERE **

2. Choose the Send as Attachment button to attach the current TV6 file to an email or choose the Send as PDF button to attach the amortization schedule report in PDF format to an email.

3. Type the email address of the recipient in the To... field. TValue populates the Subject:, Attached:, and Body fields of the email while the other fields default to your existing email client settings. Press Send.

Creating a New TValue Schedule

1. From the File tab's menu, choose New or click the New Blank Document button form the Quick Access Toolbar.

   TValue opens a new schedule in a window over the existing schedule(s). The new schedule is named Schedule#, where the # is the number of schedules you've opened since starting the current session of TValue. You can change the name when you save the file.

Opening a TValue File

1. From the File tab's menu, choose Open or click the Open button form the Quick Access Toolbar.

    

The Open dialog that appears will list all TValue 7 files in the current directory. To show TValue 4 or TValue 5, or TValue 6 files, select the appropriate file type from the drop-down list to the right of the File name field.

** SCREEN SHOT HERE **

2. Double-click a file name in the list or click a file name and click Open.

Deleting a TValue File

1. Click the Open button on the Quick Access Toolbar or Choose Open from the File tab's menu.
2. Select the drive and directory where the file is located.
3. Right-click on the file you wish to delete and choose Delete from the context menu. The program will ask you to confirm the delete.
4. Click Yes to delete the file or No to cancel the deletion request.
5. Click Cancel to close the Open dialog.

   The deleted file will be placed in the Windows Recycle Bin where it will remain until you empty the Recycle Bin.