With the following information as a base, pasting lines from Excel into the cash flow matrix will make easy work of this advanced feature. The key to the pasting function is to layout the Excel schedule so its cells will paste into the TValue fields correctly. (To use the data from the TValue 6 amortization schedule in Excel and then paste data back into TValue 6 from Excel, you need to export the TValue 6 amortization schedule to CSV (comma-separated values) and then open it in Excel.)
Note: Only values can be pasted into TValue fields – not the results of a function or formula. (You may have to use the Paste Special option in Excel to get the actual values.)
- Unknowns - are allowed in the Nominal Annual Rate (NAR) field, an Amount field, and a Number field.
- Multiple Unknown Amount fields are allowed, but only 1 Unknown NAR and 1 Unknown Number field is allowed.
- End Date - is a calculated field so if pasted over it is ignored.
- TValue defaults - a Rate, Amount, or Number field left blank will default to Unknown. Any other field that is left blank will receive the TValue default.
- Columns/Headers - in Excel need to match the order of a TValue basic cash flow: Event | Date | Amount | Number | Period | End Date | Memo. When a Rate Change, Loan Details, and/or Special Series is added, additional columns may be needed.
Below are some examples of common problems including Points & Fees and use of each Special Series as they should look in Excel before pasting into a TValue cash flow matrix. Please note that the NAR and the Compounding Period would need to be input directly into TValue as would any field outside of the cash flow matrix.
Normal NAR = 5%
Normal - Irregular Cash Flow NAR = 4.360%; Compounding Period = Half-month
Rate Change NAR = 3%
Loan Details - Points & Fees NAR = 5%
Special Series - Amount Step NAR = 4%
Special Series - Percent Step NAR = 4%
Special Series - Interest Only NAR = 5%
Special Series - Fixed Principal Plus Interest NAR = 4%
Special Series - Skip Series NAR = 4%
Special Series - Monthly Skip NAR = 4%
Special Series - Principal First NAR = 4%
Special Series - Existing Fixed NAR = 10%; Compounding Period = Annual
