Calculations
- Matthew Garrett
The Calculations screen is used to prepare the detailed financial information about an application for finance. The Calculations screen is the essence of The Finance Shop in its ability to provide an accurate quotation for finance.
From the sidebar, select Application then Calculations.
Press Ctrl + L
Click on the icon.
The Solve button(s) is used to update the calculations for a particular field.
When a calculation status warning appears at the bottom of The Finance Shop screen (e.g. ), update your calculations to resolve any repayment issues.
Defines the core structure of the finance, including calculation method, lender, and finance type.
Field | Description |
---|---|
Calculation Method | Type of finance applied to the finance application. Click the Calculation Method popup button to select. The Select Finance dialog is used to select finance details such as:
Once a calculation method is chosen, the following fields are automatically populated:
|
Financier | Financial institution supplying finance for the application. |
State | Australian state in which the finance is organised. |
Finance Type | Type of finance. Examples: Asset Purchase, Lease, Mortgage, etc. |
Arrears/Residual | Calculations have changed due to a new calculation method when an application has a residual and is calculated in arrears. The residual can be paid:
|
The Cost of Goods group will be pre-filled based on the details entered for the application. If supplying a quote, the fields must be entered manually.
Clicking the Copy button on the Cost of Goods group label updates the value of the goods from the Goods Details screen (see Goods Details). Alternatively, the value can be automatically synchronised if Preference -216 (Synchronise - Goods Asset from Calculations?) is set to Yes (see TFS Administration Tool User Guide).
Field | Description |
---|---|
Net | Net value of the goods. Example: An applicant purchasing a vehicle worth $45,000. Clicking the Net drop-down list allows you to enter a series of amounts, just like a calculator. Example: To reset the value, highlight the Net field type 0 and click Enter. |
GST | GST amount for the cost of goods. Clicking the GST button enables you to manually enter an amount. The GST field will also display an Unclaimable field when the goods are marked as luxury goods. The Unclaimable field displays the portion of GST that cannot be claimed back via input tax credits. |
Total | Gross value of the goods. Clicking the Total button enables you to manually enter an amount. |
Additional Fees | Additional fees applied to the item. Example: Registration for a motor vehicle. |
Additional Taxes | Additional taxes applied to the item. Example: Luxury car tax. |
The Deposit group allows you enter any trade-in values received for an item. This affects the total amount financed whereby the deposit Total is subtracted from the total amount financed.
Field | Description |
---|---|
Cash | Deposit amount paid by the client for the item. |
Trade-In | Trade-in value for the item. |
Total | Total deposit amount. |
The Revenue (Fees) group contains all other fees and costs associated with the financing of the goods. Some can be entered manually whilst others, such as stamp duty, are calculated by The Finance Shop.
Clicking the Manage Revenue button allows you to add additional fees using the Application Revenue dialog.
Field | Description |
---|---|
Count | Financed: Total number of financed fees. Unfinanced: Total number of unfinanced fees. |
Total | Financed: Total amount of the financed fees. Unfinanced: Total amount of the unfinanced fees. |
Stamp Duty/Financed? | Stamp Duty: Stamp duty levied on documents. The stamp duty amount is calculated using the calculation method settings selected in the Finance group. Stamp duty applies where the finance type is one of the following:
Note: Currently only NSW still has stamp duty on Specific Security Agreements.
Financed?: Indicates whether the stamp duty amount is financed. |
T/C GST/Financed? | T/C GST: These fields are locked and calculated by The Finance Shop when repayments are calculated. As the GST on asset purchase is considered an extra fee and can affect the total amount financed, the T/C GST (Term Charges GST) value is copied from the Term Charges group (see Term Charges Group). Financed?: Indicates whether the GST amount on term charges is financed. |
Account Fee (Net) | A fee that occurs each payment period. It is not a typical upfront fee as no interest or GST is calculated on the value. This fee is not added to the total amount financed but is added to the regular payments. Example: A $5 per month account fee. |
The Revenue (Fees) group contains all other fees and costs associated with the financing of the goods. Some can be entered manually whilst others, such as stamp duty, are calculated by The Finance Shop.
Clicking the Manage Revenue button allows you to add additional fees using the Application Revenue dialog.
Field | Description |
---|---|
Count | Financed: Total number of financed fees. Unfinanced: Total number of unfinanced fees. |
Total | Financed: Total amount of the financed fees. Unfinanced: Total amount of the unfinanced fees. |
Stamp Duty/Financed? | Stamp Duty: Stamp duty levied on documents. The stamp duty amount is calculated using the calculation method settings selected in the Finance group. Stamp duty applies where the finance type is one of the following:
Financed?: Indicates whether the stamp duty amount is financed. |
T/C GST/Financed? | T/C GST: These fields are locked and calculated by The Finance Shop when repayments are calculated. As the GST on asset purchase is considered an extra fee and can affect the total amount financed, the T/C GST (Term Charges GST) value is copied from the Term Charges group (see Term Charges Group). Financed?: Indicates whether the GST amount on term charges is financed. |
Account Fee (Net) | A fee that occurs each payment period. It is not a typical upfront fee as no interest or GST is calculated on the value. This fee is not added to the total amount financed but is added to the regular payments. Example: A $5 per month account fee. |
The Brokerage group allows you to enter the amount of brokerage made on the deal. A brokerage is a fee or commission charged by the broker and is typically hidden within the repayments and interest.
Field | Description |
---|---|
Financed? | Indicates whether the brokerage amount is financed as part of the application. The brokerage amount will be added to the total amount financed. |
Percentage | Percentage of the total amount financed that the broker will charge as a fee or commission. |
Net | Fee or commission value charged by the broker. This amount can be entered manually. Tip: The locked percentage cell to the right of the Net field displays the exact percentage of the total amount financed for the manually entered Net amount. Solve Button: To calculate the Net amount in the Brokerage group using the Solve button, the following fields must be populated:
|
GST/Unclaimable GST | Note: The GST/Unclaimable GST amounts are only relevant when the ITC Level in the Finance group is not set at 100%.
Example: Let's say the ITC Level is set to 75% and the GST on the brokerage is $200. The financier can only claim 75% of the GST back ($150) so there is $50 of GST that is unclaimable from the ATO. This unclaimable GST amount is therefore added to the Total amount financed. |
Displays the total amount financed excluding the brokerage. The total amount financed is the cost of goods plus any financed fees and taxes.
Field | Description |
---|---|
Excluding Brokerage | Amount financed, excluding brokerage. This field is updated by modifying other fields in this dialog. |
Total | Total amount financed. This field is updated by modifying other fields in this dialog. Solve Button: To calculate how much the applicant can afford to borrow using the Solve button, the following fields must be populated:
|
The borrow can elect to pay a lump sum to the financier at the end of a loan term after all regular repayments have been made. This allows a borrower to repay only part of the principal of their loan over its term, reducing their repayments in exchange for owing the financier a lump sum at the end of the loan term.
Example: A new car buyer borrows $40,000 over 5 years and elects to have a $10,000 (25%) Residual Value/Balloon Payment on their loan. Their repayments will be lower than if they had no Residual Value/Balloon Payment, however, the client will still owe the financier $10,000 at the end of the 5 year loan.
The amount of a Residual Value/Balloon Payment may be represented as an absolute dollar value or a percentage of the borrowed amount.
Field | Description |
---|---|
Percentage | Percentage value for the residual/balloon payment. Entering this field will automatically populate the Amount value. |
Amount | Value of the residual/balloon payment. Note: The Amount is the net value of the residual and does not include any GST that might be applicable. GST is only applicable when the Finance Type is a lease type. Solve Button: To calculate how much residual the applicant would pay for a set repayment amount each payment period using the Solve button, the following fields must be populated:
|
Allows brokers to enter the wholesale and effective rates.
Field | Description |
---|---|
Wholesale/Base | Interest rate set by the financier for lending. Solve Button: To determine the wholesale interest rate using the Solve button, the following fields must be populated:
|
Effective | An interest rate that takes into account the effect of compound interest and fees. Note: |
GST | GST rate for calculation purposes. This percentage will affect the Cost of Goods GST, the Repayment GST (if any) and the Brokerage GST. |
Stamp Duty | Stamp duty levied on a repayment. |
Defines the core structure of the repayment schedule including the period and length.
Field | Description |
---|---|
In Advance? | Indicates whether repayments are made in advance or in arrears.
|
Period | Period of the repayment schedule. Click the Period popup button to select. Example: Weekly, Fortnightly, Monthly, Quarterly, Half Yearly, Yearly. |
Term | Length of the repayment period. Click the Term button to modify the terms or enter a manual period. |
Structure | Repayment structure. Options include:
The most common use for custom payments is for Special Input Payback where the Asset GST (input tax credit) is paid back in a lump sum at the start of the loan. This reduces the overall interest paid.
|
This group is enabled if Structure is set to Single Payments.
Typically, enter all details on the calculator and click the Solve button to populate the amounts in this group.
Field | Description |
---|---|
Net | Net value of a single repayment. Click the Solve button to determine the single repayment details, including Net and Total amounts. |
GST | GST portion of a single repayment. This field is automatically updated when a single payment is solved. |
Stamp Duty | Stamp Duty portion of the single repayment. This field is automatically updated when a single payment is solved. |
Account Fee (Net) | Account fee portion of the single repayment. This field is automatically updated when a single payment is solved. |
Total | Total amount of a single repayment. |
Displays the total amounts across the term of the loan.
Field | Description |
---|---|
Net | Total Net portion of all repayments over the term of the loan. |
GST | Total GST portion of all repayments over the term of the loan. |
Stamp Duty | Total Stamp Duty portion of all repayments over the term of the loan. |
Total (exc Residual) | Total of all repayments over the term of the loan, excluding any residual amount. |
Total (inc Residual) | Total of all repayments over the term of the loan, including any residual amounts. |
Field | Description |
---|---|
Term Charges | All costs associated with the finance application, including fees, interest, GST, etc. Term charges are typically determined by the calculation method selected as different financiers calculate term charges differently. |
GST on AP T/Charges | Asset purchase type applications can have their GST on AP Term Charges set as financed, unfinanced, or they are not applicable.
|
Unfinanced GST Inc. | This field can only be selected if the GST on AP T/Charges is set to Unfinanced. Lists the GST to be excluded from the loan.
|
Term Charges GST | GST portion of the term charges. |
GST Financed (exc Bkg) | Sum of Cost of Goods GST, GST on Term Charges, and any GST on financed fees that are financed into the loan. |
To enter the calculations for an application for finance:
- Select the Calculation Method. This involves entering the financier, the Australian state, and the type of finance.
- Enter the cost of goods.
- Enter any deposit.
- Enter any revenue (fees).
- Enter any brokerage.
- The Amount Financed group summarises the amount of money being financed by the application (both excluding and including brokerage).
- Enter any residual or balloon amounts.
- Enter the wholesale interest rate.
- Enter the term (weekly, fortnightly, or monthly) of the finance. Indicate if the term is in advance or arrears.
- Select the structure of the application (Single, Group, or Custom Payments).
- Click the Solve button (next to the Structure field) to calculate the custom or group or click the Solve button (next to the Net amount in the Single Repayment group) to calculate the single repayment amount.
- The All Repayments group summarises the details of all repayments over the term showing Net, GST, Stamp Duty and Term Charges.