Notice: MFTransparency is now a defunct organization. Click here for further information.

New Version of the Calculating Transparent Prices Tool Now Available

Published on June 2, 2011

by Jordan Filko

A new version of MFTransparency’s “Calculating Transparent Prices Tool” is now available. MFTransparency’s most popular resource, this Excel-based tool allows users to input loan terms to analyze the cost of a particular loan product, learn how various factors influence the cost of a loan and view borrower cash flow through graphs and repayment schedules.

The latest version of the tool, version 2.0, includes several new features such as:

  • Expanded Input Flexibility. Users can now enter loan product pricing terms with greater accuracy on the “Advanced Pricing Sheet”
  • “Transparency Index”. MFTransparency’s original scale of pricing transparency allows you to measure and compare the transparency level of different loan products.
  • Added Precision of Price Calculations. Add the exact dates and cash flow on each date of the loan term to calculate the true price more precisely.
  • Discounted Cash Flow Visualization. New educational tools for illustrating cash flow
  • Model Repayment Schedule. Loan documentation template showing best practices in communicating pricing information to clients
  • Quick Cost Curve Calculator. New feature that illustrates why there is a “cost curve” that necessitates a “price curve”

You can download the latest version of the Calculating Transparent Prices Tool Version here

We are happy to hear from you. Please send all feedback and questions to [email protected].

3 Comments

  1. BISWAJIT BHATTACHARJEE says:

    I want to know the method of calculation of Effective interest rate on daily basis, monthly, & yearly basis….
    how can i calculate those

    what is the formula?

  2. Jordan Filko says:

    Hello Biswahit,

    More information on calculating APRs and EIRs is available in this article:

    http://www.mftransparency.org/pages/wp-content/uploads/2011/05/UnderstandingAPRCalculations-2011-05.pdf

    You may also be interested in this blog post:

    http://www.mftransparency.org/pages/2010/10/26/calculating-interest-rates-using-cashflow-discounting/

    Feel free to be in touch with questions ([email protected])

    Thanks for the comment,

    Jordan

  3. Rajendra Gurung says:

    I want to know the method of calculation of Effective interest rate on daily basis, monthly, & yearly basis….
    how can i calculate those

    what is the formula?

    Reply