•
Simply
Copy an Excel worksheet (as if copying everything
to another worksheet)
Paste to the software
Set calendar calculation month
• Calculate, report and account for
Premium and discount amortization
A detailed lifetime recognition schedule is provided for each record
Interest accruals
Par amortization, accretion
• All monthly reports:
View, print, export
Subsidiary listing trial balance
Detailed records plus accounting subtotals
Journal voucher with general ledger debit and credit summary recap
• General ledger posting file preparation
Supports any chart of accounts
• Premiums and discounts
Monthly recognition to income, expense
Accumulated
Deferral balance
Carrying amount (Accretion balance)
• Interest accruals
Calculate an accrual for the current month only
Calculate a total accrued using an "accrue from" date
Supports accrue and accrual reversal functions
Projections: Calculate interest accrual through end of year, other
period
• Par amortization for sinking fund, other
tracking purposes
Monthly amortized recognition
Accumulated
Par balance
• Period calculations
Fiscal and calendar years
Determine all balances "as of" a future month, EOY period
Determine income, expense spanning multiple months
• Graphs
Contrast one value within another
Examples:
Par within maturity months for cash flow projections
Par grouped by nominal rate (nearest quarter)
Copy a graph to Excel
Copy the data and use Excel graph functions
• Allocation capabilities
Distribute income, expense to revenue and cost centers
• Download a free demo and try the software
today |