Merchant Cash Advances, FAS 91  

Financial Data Support Systems, Inc. 
Amortization Software for
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
MBS, GNMA, LSBO Premiums, Discounts
Loan Fees Income and Expense
 Merchant Cash Advance Discounts
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
Your records - basic information on each deal

Scroll down for
     More images
     Free demo
 Software: Effective rates and Discount balances as of any month, year end

 Software is on your PC or network sharing system.
 Software: FASB 91 Audit schedules on demand with IRR and NPV

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

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.

     A schedule can be produced as if all payments had been made in a timely manner.
     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
     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
     And the observed day for
     New Year's
     Martin Luther King birthday
     Memorial day
     July 4th
     Labor day
     Veteran's day
     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)

  FASB 91 Merchant Lending Daily Drafts Amortization Software for Windows® PC, laptop, workstation and network sharing by
© 1995 - 2019 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map