|
|
|
|
Amortization Software for |
|
Prepaid
Expenses, Deferred Charges |
|
Deferred
Income, Unearned Revenue |
|
MBS, GNMA, LSBO Premiums,
Discounts |
|
Loan Fees Income and Expense |
|
|
|
Indirect Lending Dealer Fees |
|
FASB
91 Products Page |
| Bond Purchasers, Level Yield
Method |
|
Bond
Purchasers, Straight Line
Method |
|
Bond Issuers,
Level Yield or Straight Line |
|
Excel Worksheet Amortization
|
|
Allocation to Cost and Profit
Centers |
|
Fixed Assets, FF&E
Depreciation |
|
Home page |
|
About,
contact us |
GAAP, FASB compliant
|
|
Merchant Cash Advances
Discount on Proceeds, Other
Income and Expense Amortization
Software
Calculate all MCA records at the
same time:
FASB ASC 310-20 effective interest rates (IRR)
Net Present Value (Book Value)
Discount on Proceeds Balance (Deferred Income Balance)
Auditor schedules:
Month-by-month recognition,
supportive documentation
IRR, NPV independent
verification in seconds
Individual record and file totals as of:
Any month
Any year end
- designed to eliminate footnote
exceptions on Financial
Statements
"Freeze Schedule" date will calculate Reserves on a
deal gone bad
|
Hard to
find
accounting
solutions |
Related software:
Mortgage Loan Fees
Purchased Loan
Packages
Fees
Amortize MCA Discount on
Proceeds plus other income and expense
fees
IRR
Effective interest rate calculation for each
fee. each record.
Lifetime amortization schedule
for each fee, for each record.
% reductions for
Joint venture participations.
Freeze Schedule for when a deal goes
bad.
Clear up audit exceptions with a minimum
amount of effort.
PROSPECTIVE Schedules:
A schedule can be produced as if
all payments had been made in a timely
manner.
RETROSPECTIVE Schedules:
Current Face Value from the import
file will be included and, if different
than expected, the schedule will be
updated using a new Effective Interest
Rate.
|
|
About Daily Face Value Reductions
The amount by which Face Value is being
reduced each day by a PAYMENT.
PAYMENT is calculated by the system as:
Column H Original Face Value /
number of PAYMENT DAYS from and
including First Payment Date to and
including Final Payment Date
OR
Column H Current Face Value /
number of PAYMENT DAYS from and
including the first day following the
file YYYYMM import month through and
including the Final Payment Date.
PAYMENT DAYS represent all of the days
between either or the above dates,
excluding
Saturday
Sunday
And the observed day for
New Year's
Martin Luther King birthday
Memorial day
July 4th
Labor day
Veteran's day
Thanksgiving
December 25th
Exception: If a First Payment
date or Final Payment date falls on any
of the above, the First Payment date or
Final Payment will become a PAYMENT DAY.
Granted, you might have fewer PAYMENT
DAYS due to other federal, state and
local holidays.
It doesn't matter if you have a few
less PAYMENT DAYS.
Your PAYMENT amounts will be
HIGHER than what the system calculates
as a PAYMENT.
You also might not have a
PAYMENT DAY due to bounces, skips,
forbearance and other adjustments made
to accommodate the customer.
If Face Value
decreases by 1,000.00, it doesn't matter
whether the individual daily payments
consisted of:
20 daily
payments of 50.00 on certain days or
25 daily payments
of 40.00 of which most fall on the same
days.
They both
generate a 1,000.00 reduction to Face
Value. FASB 91 is most interested in
having a correct Column J, Carrying
Balance NPV, which our system provides.
The system
might be
distributing daily payments slightly
differently than actual, but this is
significantly easier to accomplish than
trying to determine actual PAYMENT DAYS.
(while we agree
the Effective Interest Rate (IRR) will
vary slightly, we don't agree that any
variance will significantly alter the
amortization results)
About Effective Interest Rates
The rate required to amortize column I
Deferral to zero over the Term in days.
Determined using the IRR calculation:
First value = Column J Beginning
Carrying Balance, as a negative value
and typically placed in Column B cell
immediately above the first PAYMENT row
regardless of whether or not a PAYMENT
is on that row.
Subsequent values are Column B
PAYMENTS for the life of the schedule.
=IRR(First value:Final Payment Row)*365
with cell formatted as % 0.00000
If no PAYMENT was due, column B is
blank.
If a PAYMENT was due but Face Value did
not decrease, column B is 0.00.
When calculating NPV using Column
B, conflicting results will occur
depending upon whether a cell contains a
blank value or 0.00.
Additionally, First PAYMENT and
Final PAYMENT will occur on each actual
date regardless of weekend or holiday
status.
About Carrying Balances
NPV calculation:
=NPV(Column L rate / 365, Column B First
Payment Row: Column B Final Payment
Row) with cell formatted as Number,
0.00
|
|
Price and free demo
Click to open and view
Price page
Price page
contains a link to download a free demo
right now.
For questions or more information,
please
Call 1-800-245-8444
(Florida, Eastern Time)
or
email
Support@fdssi.com
|
|
|
