FREQUENTLY ASKED QUESTIONS (FAQs)
The TimeValue Software™ FAQs section offers answers to the most common questions relating to TimeValue Software products. Please review the list of questions below - the answer you need may already be here.
If you do not find the answer to your question, please consult the experienced and knowledgeable TimeValue Software product experts at 1-949-727-1800 or toll-free at 1-800-426-4741 (within USA).
TValue™ Amortization Software
TValue™ Software version 4
TCalc™ Online Financial Calculators
TaxInterest™ IRS/State Interest and Penalty Software
File In Time™ Due Date Tracking and Task Management Software
Loan Modifications and Troubled Debt Restructurings
Financial Accounting Standards Board (FASB)
How can I download or reinstall the software to my computer without the original CD? back to top ^
If you are using the current release of TimeValue Software products, you can download the software from the website. You will need to email or call TimeValue Software to obtain your installation password. If you are not using the current release, there may be an upgrade charge or you may need to re-instate your subscription for the annual maintenance service.
If you send an email to support@TimeValue.com, please provide a contact name, company name (if applicable), phone number, and email address so we can verify your product registration. You can reach a TimeValue Software representative by calling 1-949-727-1800 or 1-800-426-4741 (within USA).
How can I pay my invoice? back to top ^
You can pay online; send payment to the TimeValue Software corporate office at 22 Mauchly, Irvine, CA 92618 USA; or call 1-949-727-1800 or 1-800-426-4741 (within USA) Monday–Friday, 7am–6pm Pacific Time.
Does TimeValue Software have a reseller program? Can I become a reseller? back to top ^
TimeValue Software maintains a limited reseller program. Please contact us at 1-949-727-1800, and ask to speak to a reseller manager to see if you would qualify as a TimeValue Software reseller.
TValue Loan and Lease Amortization Software
Why are my numbers different than what the bank says? back to top ^
There are many different computational methods that may affect the numbers. You can have different combinations between compound periods and the year length that can cause slightly different calculations. Although loans may have monthly payments, there are different ways to structure a loan. A common loan structure is monthly compounding with a 365 day year. Loans can also be structured with actual days over 365 days. In TValue software, you would set compounding to Exact days and use a 365 day year. You could have actual days over 360. The setting in TValue software would set compounding to Exact days and the year length would be 360 days. There are other variations but these would be the most common.
Can I have a payment(s) in advance? back to top ^
Yes, press F5 and select Same date as first cash flow line in the Input Setup window. If you want to have all payments in advance, you can click on Save setting… in the TValue Setup window. If you have already started the schedule, you can change the date as needed for the advanced payment.
How do I calculate the payoff? back to top ^
There are multiple ways to calculate the payoff of the loan:
- You can simply create a final payment and type “U” for the amount and click calculate. (You would need to delete any payments that weren’t made.)
- You can use the Balance function under the Compute menu, or click on Ctrl+B, to calculate the payoff at any point in time.
- You can enter a Payment event of $0 on the desired date. Then go to the Amortization schedule tab. On this payment, you would have the interest from the last event and a new balance which would be the payoff balance.
Can I calculate the yield on a bond? back to top ^
Yes, type “U” for Unknown for the Nominal Annual Rate. Enter the purchase price as Invest event. Enter interest payments as Return events. Enter face value of the bond as last Return event. Calculate. Nominal Annual Rate is the yield. (Please note that many Bonds are generally setup with a 360 day year.)
How do I enter an adjustable rate loan? back to top ^
After entering the basic loan information, e.g. Compounding Period, Nominal Annual Rate, Loan, go to the first column called Event and click on the dropdown menu to add a Rate Change to the loan. Once you changed the rate, all subsequent events will be calculated at the new interest rate.
Can TValue software create PDF files of amortization schedules? back to top ^
TValue software does not currently have the capability to create PDF files directly. However, there are a number of freely available printer drivers that can allow you to send your printed amortization schedules directly to a PDF file. One such program is called PDFCreator and is available at: http://sourceforge.net/projects/pdfcreator/. While we are aware of a number of customers who have used this program successfully to generate PDF files directly from TValue software, TimeValue Software does not produce or support these programs.
Is TValue software version 5 compatible with Windows 7 and Windows 8? back to top ^
TValue software version 5.20 and subsequent releases are fully compatible with Windows 7 and Windows 8. If you have version 5.06 or a prior release of version 5, you can upgrade to the current version.
Do you have a discounted price for existing customers that want to upgrade from TValue software version 4 to TValue software version 5? back to top ^
TimeValue Software offers upgrade discounts for our existing customers. Please contact our sales staff and ask for the TValue software upgrade discount.
Do you have a demo for TValue software? back to top ^
TimeValue Software offers any prospective customer a fully functional program for a 30-day trial, along with an invoice due in 30 days should you decide to keep the program. Please call our sales staff for the 30-day trial. We also offer a one-year, money back guarantee so all purchases are risk free.
What is your license policy for TValue software? back to top ^
Our licensing program is a "per user" policy. Each user of the program is responsible to have purchased a license for the program.
How do I install the TValue software Multi-user Edition? back to top ^
You can go to the TimeValue Software website and click on the Support tab and then Downloads. There you can find the TValue software network installation instructions in a PDF.
Does TValue software handle irregular payment periods? back to top ^
TValue software is an excellent program to handle irregular payments and will automatically make the proper allocation between interest and principal for each payment. You can either enter the irregular payments one by one or you can setup a normal payment schedule, then you can click the Expand icon and then edit the individual dates or amounts including a payment of zero.
Does TValue software compute net present value (NPV)? back to top ^
TValue software can calculate the present value or net present value. A common present value calculation is to compute the current value of the remaining payments of a payment stream. To do so with TValue software, you first enter the nominal annual rate and then put “U” for unknown for the Loan amount on the present value (valuation) date. Then enter the remaining payments (cash flows) after that date. When you are calculating a net present value, only the cash flows that remain after the valuation date are used in the calculation.
Can TValue software calculate a balloon payment? back to top ^
TValue software can easily handle balloon payments. There are a couple of different scenarios that would need a balloon. If you had a series of payments and you wanted to know the final payment, you could solve for the “unknown” and solve for the final payment. If you wanted to shorten a loan and pay it off or have a balloon after 10 years, you could solve for the payment amount for the full term, e.g. amortize the payments for 360 payments for a 30 year mortgage. Once you have the payments, you can shorten the terms to the balloon period, 10 years, and change the number of payments to 120 then calculate for the final balloon payment.
Does TValue software handle adjustable rates? back to top ^
TValue software has the capability to do a rate change. It is one of the Events. Once the rate change is done, all subsequent cash flows will be subject to the new rate.
Can I import an Excel file into TValue software? back to top ^
You cannot import files into TValue software. You can export files into Excel, Word, comma delimited files, tab delimited files, and XML files.
TValue Software version 4
I am having a problem with TValue 4 such as printing problems or issues running with my current operating system. Do you provide support for TValue 4? back to top ^
TimeValue Software no longer supports TValue™ amortization software version 4 so there are no fixes, patches, or replacement media available. TValue 4 was a 16-bit application and was last updated in 1997.
You can upgrade and order TValue amortization software version 5. Please call us for the TValue software version 5 at 1-800-426-4741 or order online at https://www.TimeValue.com/timevalueforms/orderform.aspx.
Can I open TValue software version 4 files in TValue software version 5? back to top ^
Yes you can. Go to My Computer. Your TValue™ amortization software version 4 files should be in a folder called TV4WIN on the “C” drive. The client files will have a .tv4 extension. After you install TValue software version 5, you can go into the TV4WIN folder and copy these files and paste them into the TVALUE5 folder. In TValue software version 5, go to Open. Where it says “TValue 5 Files (*.tv5)”, change the drop down to “All TValue Files (*.tv?)”. Once you open an old file, you will be able to save it as a TValue software version 5 file and get all of the new features of TValue amortization software version 5.
TCalc Online Financial Calculators
How long does it take to have TCalc calculators up and running on a website? back to top ^
Integrating TCalc calculators on any website traditionally takes no more than 10 to 30 minutes.
Will TCalc calculators work on my website? back to top ^
Yes, TCalc online calculators will work on any website.
What is the difference between TCalc online financial calculators and TValue amortization software? back to top ^
TCalc financial calculators are predetermined financial templates that reside on a website (typically used by visitors to a website) and are designed to answer questions individuals have regarding everyday financial issues. These popular financial calculators deal with personal financing, home financing, retirement and investment planning calculations and are for web application use only.
TValue amortization software is a professional financial tool for accurately amortizing loans, leases, and any time value of money calculations and is a desktop application. We also have the TValue Engine SDK which is offered as a software development kit (SDK) for software developers/programmers.
Do I need to be very technical to install the calculators into my website? back to top ^
No, TimeValue Software technical support team will walk anyone through the simple installation process in a matter of minutes. All you need is the ability to access your website in order to edit/add content.
If I buy TCalc calculators, can I use them on more than one website? back to top ^
Yes, TimeValue Software charges per website or URL address. Discounts apply for multiple URL purchases.
Do I have to have the “Presented by TimeValue Software” at the bottom of the calculator page? back to top ^
No, we can remove the “Presented by TimeValue Software” from the calculators for a small fee. However, TCalc online calculators are known as one of the most accurate and reliable calculator products on the market, and many customers feel it’s a benefit to be associated with the strong brand of TimeValue Software.
I like one of the bundles but I want to substitute two calculators, do I still get the bundle price? back to top ^
The bundle pricing is for a predetermined set of calculators. You can pick and choose your own calculators using our “choose your own” option.
How does it work if I want to purchase TCalc calculators but I do not have a website? back to top ^
TCalc online financial calculators only run on a website. You can use them on the TimeValue Software website or purchase TValue amortization software for your desktop to perform your desired calculations.
Is there a contract when I purchase TCalc calculators? back to top ^
No, there are no contracts. TimeValue Software bills you annually (in advance) for the following year and you can cancel any time.
Can everyone in my office use it or do I need to purchase more licenses? back to top ^
Since TCalc calculators are on the web, anyone who has access to the specified webpage will be able to use the tool online. There are no individual licenses for TCalc. If people in your office are using TCalc (e.g., loan officers), you may want to consider using TValue amortization software.
Does TimeValue Software develop custom calculators? back to top ^
As the leader in developing time-value-of-money calculations, TimeValue Software is always looking for new development opportunities. Give us a call if you have a need in this area and we may be able to help you.
Can I rename the fields within the calculators? (e.g., loan amount to purchase price)? back to top ^
You can customize the look and feel of the calculators as well as the name of each calculator but the text and field names inside the calculators cannot be changed.
Can I change the default interest rate or loan amount? back to top ^
Yes, you can change any default value in TCalc calculators as often as you like.
TaxInterest IRS/State Interest and Penalty Software
How do I compute interest on a refund? back to top ^
To compute interest on a refund, enter a Payment Event on the main screen to represent the refund amount. Whenever TaxInterest software determines that there is an overpayment, the program automatically uses the refund rate from the interest rate tables.
How do I start the large corporate underpayment interest rate? back to top ^
Click the Hot Interest button on the toolbar. When you enter the required applicable date information, TaxInterest software will automatically compute the 2% higher rate going forward (Section 6621).
How do I calculate the C Corporation refund rate? back to top ^
Click the C Corp Refund button on the toolbar. When you enter the required applicable date information, TaxInterest software will automatically compute the lower rate corporate refund rate of 1% and then the GATT refund rate of an additional 1.5% on amounts over $10,000 (Section 6621).
How do I compute an estimated tax penalty in TaxInterest software? back to top ^
TaxInterest software can compute the estimated tax penalty if you know the amount of the installment due on the installment due date. Generally, the estimated tax deposits are based on 100% of the prior year tax or 90% of the current year tax, whichever is lower. There are also exceptions to these parameters.
If you know the amount of the installments, you can calculate the penalty in the TaxInterest software. First, you need to click on Tables and choose either 2210.TB3 for individuals or 2220.TB3 for corporations. Then input four Tax events for the estimated tax deposit amounts on the tax deposit dates. Then calculate to the tax due date, e.g. 04/15/10. The estimated tax penalty is actually the interest calculation up to the tax due date.
How do I compute a payroll tax deposit penalty in TaxInterest software? back to top ^
TaxInterest software cannot compute payroll tax deposit penalties. The program will compute interest on payroll tax deposit penalties if you know the amount of the penalty. Use the Event Entered Penalty and use the date of the assessment and TaxInterest software will calculate the interest. To compute a payroll tax deposit penalty amount, use TimeValue Software’s Tax941 IRS payroll tax interest, penalty, and forms software.
How do I apply withholdings, estimated tax payments, or credits from prior years to a tax? back to top ^
Withholdings, estimated tax payments, and prior year credits are applied to the tax on the tax due date of the return. We recommend that you put the net tax amount on the tax due date from the tax, withholdings, estimated tax payments and prior year credits.
File In Time Due Date Tracking and Task Management Software
How do I get my tasks to show up with the correct due date after rollover? back to top ^
Before rolling tasks forward, go to the Options menu and select Use Automatic Date Setting. When the rollover is performed, the new due dates will be calculated based on the information in the Service Edit window.
How do I move the File In Time program from one computer to another? back to top ^
- Backup the current database. Go to the Tools menu and click on Backup Database.
- Install File In Time software on the new computer from either the CD or from a download.
- On the new computer, go to the Tools menu and select Restore from Backup.
Why does the File In Time program say I am already logged into the program when I try to log in? back to top ^
- The File In Time software was not shut down properly and is still seeing a user session open.
- Navigate to the directory (fitwin) where the File In Time software database is located and delete the file with the extension “.usr”. You can now start and log in to File In Time software.
How can I archive old data so I can remove it from my current database? back to top ^
- Print the Task View Report as a hard copy.
- Backup database for future reference. Go to Tools and Backup Database.
- Export the Task View to Excel and save it. Go to Tools and Display Task View in Excel
How do I retroactively create a task for last month and then extend it to the applicable extension date in the future? back to top ^
- Create a new task and then you can edit the due date of the task to the date of last month.
- Extend the due date as you normally would to the available extension date.
Why does the program start the old version after I installed the update? back to top ^
You might have installed the update to a different directory. Go to the Tools menu and choose Database information. The Program path is where the program should be installed.
You may not have permissions to copy the new program executable file within the “fitwin” directory. Consult your IT administrator for permissions.
How do I assign a task to a group of clients? back to top ^
- Click the New Task button and select the Service.
- Click the Client Groups button to select the group of clients.
Can I import my client information from my tax package? back to top ^
If you can export the client information as a comma or tab delimited file, you can import it into File In Time software.
How do I install File In Time software on my server? back to top ^
- Install the program to your network from any workstation. You must have a letter drive, e.g. T: drive. Each workstation that will access the application must be mapped to the appropriate network drive.
- From each workstation, run the newly created Workstationsetup.exe file located in the “fitwin” directory on the server.
When I have multiple entities under one company, how can I set them up to be related in File In Time software? back to top ^
Create and assign a Client Group under the main company name. Go to File and then to Client Groups. Then click on New and create your Client Group.
How do I roll over my completed tasks? back to top ^
- Filter all data in the Task View to show the completed tasks.
- Select all tasks (Ctrl+A) and then click on the Change button.
- Select Rollover to next due date and click the small Change button to start the rollover process.
Loan Modifications and Troubled Debt Restructurings
How do you determine if a loan modification is a TDR? back to top ^
Determining whether a loan modification is a TDR is a two-step process. Step one is to determine whether the borrower is experiencing financial difficulty. The key to that determination is that a restructuring is deemed “troubled” because of a borrower’s financial difficulty. Step two is to determine whether the creditor has granted a concession. It is important to note that not all loan modifications constitute a TDR.
As referenced in FASB Statement 15 (FAS 15), a TDR may include, but is not necessarily limited to, one or a combination of the following:
- Transfer from the debtor to the creditor of receivables from third parties, real estate, or other assets to satisfy fully or partially a debt;
- Issuance or other granting of an equity interest to the creditor by the debtor to satisfy fully or partially a debt unless the equity interest is granted pursuant to existing terms for converting the debt into an equity interest; or
- Modification of the terms of a debt, such as one or a combination of these changes:
- Reduction of the stated interest rate for the remaining original life of the debt;
- Extension of the maturity date or dates at a stated interest rate lower than the current market rate for new debt with similar risk;
- Reduction of the face amount or maturity amount of the debt as stated in the instrument or other agreement; or
- Reduction of the accrued interest.
- Historically, loan modifications made as part of a customer retention program have not been considered to be TDRs. However, whenever an interest rate is lowered on what is perceived as a healthy loan, creditors should be encouraged to perform new underwriting in order to ensure that the modified loan is at a market rate and that the borrower would have qualified for this “non-troubled” market-rate loan. Without the new underwriting, that modification might be considered a TDR.
- In determining whether a borrower is experiencing financial difficulty, the creditor should consider whether the borrower:
- Has defaulted on any debt;
- Has declared bankruptcy or is in the process of declaring bankruptcy;
- Cannot obtain funds to service the debt other than through the current creditors; or
- Has cash flows that will be insufficient to service the debt.
- A credit analysis should be performed for a restructured loan in conjunction with its restructuring to determine the borrower’s ability to repay the loan and any estimated credit loss. If the modified loan is considered to be a TDR, then the guidance in FASB Statement 114 (FAS 114), “Accounting by Creditors for Impairment of a Loan,” should be followed. TValue amortization software is an excellent tool to assist in structuring the TDR and perform a present value calculation of the relevant future cash flows at the effective interest rate to determine the allowance for loan losses (ALL) and the provision for loan losses subject to FAS 114.
- When available information confirms that a specific restructured loan, or a portion thereof, is uncollectible, the uncollectible amount should be charged off against the allowance for loan losses (ALL) at the time of the restructuring. Additionally, as is the case for all loans, the credit quality of restructured loans should be reviewed regularly. The creditor should periodically evaluate the restructured loan for impairment to determine whether any additional amounts should be charged off against the allowance for loan losses.
- If a creditor servicing system does not fully capture and account for all loan modification events, it may not be in compliance with the TDR GAAP rules. TimeValue Software TValue amortization software can be a critical asset in helping to determine the allowance for loan losses (ALL) or write off on a loan and to accurately document such losses.
How do I calculate a loss on a TDR? back to top ^
When available information reveals that it is probable that a creditor will be unable to collect all amounts due according to contractual terms of the loan agreement then that amount deemed unlikely to be collectible should be charged against the allowance for loan losses (ALL) at the time of the restructuring subject to FAS 114. You can use the fair-value method to determine the collateral value, including the basis of any adjustments made to appraised values and the costs of disposition, the observable market price, or the present value of the expected cash flows, discounted at the effective interest rate.
Calculating the TDR loss using appropriate present value methodology is a matter of developing two amortization schedules and calculating the difference between the two resulting loan balances. The first schedule will be the actual modified or restructured loan (TDR) based on the loan’s carrying value. It is important that this schedule agrees with the actual restructured note. The second schedule will use the actual cash flows from the modified loan or TDR, adjusted for any rates changes or interest only payments, and then calculate a present value (PV) of the future cash flows at the effective or original interest rate. TValue amortization software is a very flexible product both for modeling changed cash flows due to the restructuring and then performing the present value calculation of the future cash flows at the effective rate. TValue can handle any type of modification including interest only payments, rate changes, balloons, and more.
There are a handful of modifications that are being done to help the debtor that cover most of the TDRs. These modifications can include either one item or a combination of items and can include:
- Lowering the overall interest rate for the full term
- Doing interest only payments at a lesser rate for a period, e.g., 6 to 24 months, to reduce the initial payments and then amortizing the remaining loan at a discounted rate or the effective rate
- Creating a predetermined rates step up, e.g., 3% for 12 months, 4% for 12 months, and 5% for the remaining term, to reduce the initial payments in the early years
- Lowering the interest rate for a short term, e.g., 2 to 5 years, amortizing the loan over 30 years, and ballooning the loan at 10 years
- Increasing the term to lower the payments
Determining the best deal structure that both allows the debtor to handle the payments and allows the creditor to minimize the loss is critical. Doing the “what ifs” calculations is invaluable to understand the magnitude of the loss before closing the loan. TValue software is a program that can easily and quickly do the “what if” calculations. Different deal structures can be modeled in minutes and, similarly, the present value calculation(s) can be performed on a “real-time” basis during active restructuring negotiations.
What is the Interagency Policy Statement on the Allowance for Loan Losses (ALL)? back to top ^
In December 2006, the federal financial institution regulatory agencies issued a revised Interagency Policy Statement on the Allowance for Loan Losses (ALL). The policy statement revises and replaces the banking agencies' 1993 policy statement on the ALL to ensure consistency with GAAP and more recent supervisory guidance. In addition, the agencies issued a supplemental Frequently Asked Questions (FAQs) document to assist institutions in complying with GAAP and ALL supervisory guidance. Specifically, the revised policy statement:
- Requires an institution to maintain an ALL at a level that is appropriate to cover estimated credit losses on individually evaluated loans determined to be impaired, as well as estimated credit losses inherent in the remainder of the loan portfolio.
- Updates the previous guidance that describes the responsibilities of the boards of directors, management, and bank examiners regarding the ALL; factors to be considered in the estimation of the ALL; and the objectives and elements of an effective loan review system, including a sound credit grading system.
Because the revised policy statement reiterates key concepts and requirements included in GAAP and existing ALL supervisory guidance, the agencies expect that any enhancements needed to bring an institution's ALL processes and documentation into full compliance with the guidance contained in the revised policy statement will be made as soon as possible.
The policy statements do not change existing accounting guidance in, or modify the documentation requirements of, GAAP or guidance provided in the relevant joint interagency statements. The policy statements recognize that estimating an appropriate allowance involves a great degree of management judgment and is inevitably imprecise.
Therefore, a financial institution may determine that the amount of loss falls within a range. In accordance with GAAP, an institution should record its best estimate within the estimated range of loan losses.
The text of the policy statements can be found at the FDIC website at www.fdic.gov and the NCUA website at www.ncua.gov.
Financial Accounting Standards Board (FASB)
What is FASB Statement No. 5 (FAS 5)? back to top ^
This Statement establishes standards of financial accounting and reporting for loss contingencies. It requires accrual by a charge to income (and disclosure) for an estimated loss from a loss contingency if two conditions are met: (a) information available prior to issuance of the financial statements indicates that it is probable that an asset had been impaired or a liability had been incurred at the date of the financial statements, and (b) the amount of loss can be reasonably estimated. Accruals for general or unspecified business risks ("reserves for general contingencies") are no longer permitted. Accounting for gain contingencies under Accounting Research Bulletin No. 50, Contingencies, remains unchanged; they are recognized when realized. The FASB currently has a project on its active agenda to reassess the current provisions of FAS 5 for possible change or modification given the changes in the business and economic climate that have occurred since this pronouncement was released.
What is FASB Statement No. 15 (FAS 15)? back to top ^
The accounting and reporting standards for loan modifications and TDRs are primarily found in FAS 15, “Accounting by Debtors and Creditors for Troubled Debt Restructurings.” This Statement establishes standards of financial accounting and reporting by the debtor and by the creditor for a troubled debt restructuring. This Statement requires adjustments in payment terms from a troubled debt restructuring generally to be considered adjustments of the yield (effective interest rate) of the loan. As long as the aggregate payments (both principal and interest) to be received by the creditor are not less than the creditor's carrying amount of the loan, the creditor recognizes no loss, only a lower yield over the term of the restructured debt. Similarly, the debtor recognizes no gain unless the aggregate future payments (including amounts contingently payable) are less than the debtor's recorded liability.
What is FASB Statement No. 114 (FAS 114)? back to top ^
FAS 114 addresses “Accounting by Creditors for Impairment of a Loan.”--an amendment of FASB Statements No. 5 and 15 (Issued 5/93). This Statement addresses the accounting by creditors for impairment of certain loans. It is applicable to all creditors and to all loans, uncollateralized as well as collateralized, except large groups of smaller-balance homogeneous loans that are collectively evaluated for impairment, loans that are measured at fair value or at the lower of cost or fair value, leases, and debt securities as defined in FASB Statement No. 115, Accounting for Certain Investments in Debt and Equity Securities. It applies to all loans that are restructured in a troubled debt restructuring involving a modification of terms.
It requires that impaired loans that are within the scope of this Statement be measured based on the present value of expected future cash flows discounted at the loan's effective interest rate or, as a practical expedient, at the loan's observable market price or the fair value of the collateral if the loan is collateral dependent.
This Statement amends FASB Statement No. 5, Accounting for Contingencies, to clarify that a creditor should evaluate the collectability of both contractual interest and contractual principal of all receivables when assessing the need for a loss accrual. This Statement also amends FASB Statement No. 15, Accounting by Debtors and Creditors for Troubled Debt Restructurings, to require a creditor to measure all loans that are restructured in a troubled debt restructuring involving a modification of terms in accordance with this Statement.