Subscribe via RSS

Stay up-to-date on everything MFTransparency has to offer by following our RSS Feeds. You can follow all MFT updates, or select between just receiving only News or Resources updates.

Follow on Twitter

Follow the conversation: @MFTransparency

Like us on Facebook

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

Leave a Reply