Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Column

Insert excerpt
The Finance Shop Knowledgebase Menu
The Finance Shop Knowledgebase Menu
nopaneltrue


Column

Maclease has a couple of areas where they perform their calculation differently to other lenders. This article shows how to enter a balanced transaction for Maclease


Below is a quote from Maclease, There are 2 financed fees (Shown in the red box)

...

Image Added


The amount financed shown in

...

their calcs is $140875  ((asset cost  140000) + (Lodgement fee 180 ) + (Origination fee 695) = 140875)


Amount Financed

I recreate the application in TFS and add the two financed fees

 Image Modified


The Amount Financed (Excluding Brokerage) matches.

Brokerage

The brokerage is shown as 2% and worked out to be 2800

 Image Modified

...


Their brokerage is calculated on the (COGs-Deposit)  excluding the financed fees

TFS Calculation of brokerage includes the financed fees so by default it gets the following if you enter 2%

Image Modified


Interim Solution

Calculate the brokerage excluding financed fees and enter it manually

(Total COG-Deposit  = 140000)  \ 100 * 2 = 2800

Image Modified


Balloon Analysis

The Balloon is shown as 30% of the total cost of goods.  TFS is calculating the balloon as 30% of the amount financed excluding brokerage

Interim Solution

Manually enter the residual value in the Amount  field

Image Modified


Transaction Overview

Below is the complete transaction entered for Maclease


Image Added