Description
CFLend allows the user to structure and price virtually any fixed rate loan or non-tax lease. Although CFLend is an entry level program it still offers a host of advanced features including the ability to save and open data files, create templates, easily access recently viewed files, and the ability to set system wide variables and preferences. Most importantly, CFLend includes a proprietary algorithm called StructureIQ that ensures that every payment structure generated by the program conforms to real world lease or loan repayment conventions. CFLend provides a full range of reports that prove all calculations. The reports include Average Life, Day Count, Amortization, Present Value of Rent, and Purchase Price and are fully exportable to Microsoft Excel as “Live” spreadsheets complete with all applicable cell formulas. The Live spreadsheet option means that all of CFLend’s calculations are effectively proved by Excel. If the user’s job involves structuring loans and leases or creating amortization tables for the same, then CFLend is an ideal solution.
-
Structure any non-tax lease or loan using six (6) payment types including Balloon, Daily Equivalent Next, Interest Only, Payment, Principal, and Residual.
-
Multiple preset lease and loan structures including, First and Last, High-Low, Low-High, Seasonal Payments, Skip Payments, Escalation, and Term-Amortization.
-
State-of-the-art Amortization Schedule that includes subtotals based on quarterly, semiannual, or annual frequencies and fiscal month endings.
-
End-of-Month Rule allowing for payments to occur on the last actual day of the applicable month.
-
Calculate the purchase price of loan or lease given a buy rate or calculate the buy rate given a purchase price with proof report.
-
Calculate PV of rents at the implicit rate or at a specified discount rate with proof report. Calculate maximum residual guaranty for 90% test.
-
Calculate the average life of loan or lease with proof report.
-
Calculate the outstanding balance of any loan or leases for any scheduled payment or non-scheduled payment date with proof report.
-
Several Day Count methods for calculating interest, including 30/360, Actual/365, Actual/360, ISDA and Excel Euro methods.
-
Email current pricing file via Outlook with one-click.
-
Save files as templates and ability to set default loan or lease parameters at startup.
-
View most recent files list.
-
Print a summary report of the loan or lease, including statistics, inputs, payment schedule, totals, purchase price details, lessee or borrower paid fees
-
Ability for user to set global variables and system preferences.
-
Access to training videos that are 2 to 4 minutes in length.