The new Borrowing Capacity Calculator (v2) brings enhanced features, improved accuracy, and a modern interface design. This guide will walk you through how to access the calculator, use its modules, validate your data, and generate clear lender results.
1. Accessing the new calculator
Accessing from an opportunity (Borrowing Capacity v2):
Open the CRM app.
Select opportunities from the left-hand menu.
Open the relevant opportunity record.
Select Calculations from the sub-menu.
Click the + Add drop-down.
Select Borrowing Capacity v2.
By using this option, your calculations will be saved within the selected opportunity and your client’s financial data will automatically sync with the calculator.
Accessing as a standalone calculator (outside an opportunity)
A. Via the the Mercury Nexus dashboard:
B. Via the the CRM dashboard:
C. Via the the Research app:
Important If you are accessing the calculator via the Mercury Nexus dashboard, CRM dashboard or the Reseach App (as a stanalone calculator outside an opportunity), you can find all your saved calculations in the Research App.
Read this Wiki article to learn how to save your results and attach them to an opportunity.
2. Understanding the calculator modules
Applicants
Enter details for up to four applicants (same as Apply Online).
New: Marital status determines household grouping if this is set in the contact of the opportunity.
Married applicants are treated as one household. Shared dependents, expenses, and liabilities are entered once - not duplicated. This makes data entry faster, cleaner, and more accurate.
Proposed loan
Enter the proposed loan amount and security value to generate the LVR (loan-to-value-ratio) based on your client's scenario.
You can also:
Link existing properties as security.
Add multiple securities (no restrictions).
Specify if a property is being refinanced.
Income & earnings
Add PAYG incomes.
Add self-employed income alongside PAYG.
Selecting self-employed activates the Business Income section for detailed entry.
Living expenses
Living expenses can now be entered per household based on marital status, not just per applicant.
Flexible options:
Enter one total monthly expense (e.g., $2,500).
Or itemise expenses by category.
3. Validation: Errors vs. warnings
One of the biggest improvements in the new calculator is built-in validation.
Errors:
Missing required data (e.g. income).
Must be fixed before lender results can be calculated.
Clicking an error scrolls you to the exact field.
Warnings:
Incomplete or optional details.
Don’t block calculations but may affect accuracy.
Clicking a warning also scrolls you to the field.
This ensures your results are accurate and reliable before proceeding further with the opportunity.
4. Lender results panel
The results panel has been redesigned for speed and flexibility.
Favourites & pinning
Pin or favourite lenders for quick access.
Favourites remain visible at the top or bottom of the panel as you scroll.
Filter results to show only your favourites for a simplified view.
Customising rates
Two ways to test scenarios:
1. Individual discounting
Edit a lender’s rate, save, and recalculate.
2. Generic discounting
Apply one discount across all lenders at once.
Generating reports
Create a lender comparison summary with modern visual formatting.
Includes rates, repayments, and other key data.
Works like a merge doc, but clearer and more client-friendly.
Note: Throughout the tool, you can expand or collapse sections. For example, if you want to focus only on lender results, collapse all other sections for a distraction-free view.
Feedback
Please use the Feedback button (located at the top right-hand corner of the calculator dashboard) to share comments or suggest improvements. This makes it easier for our product team to track and implement updates.
Troubleshooting and Optimization
Common Setup Issues and Resolutions
Loan Term Mismatch
If the loan term in Borrowing Capacity does not match the product applied to the opportunity, it is likely because no product has been applied from Product Comparison. To resolve this:
Go to Product Comparison and apply a product to the opportunity.
Confirm that a product appears in the Products tab. Once a product is applied, the loan term in Borrowing Capacity will align with the selected product.
Missing Lenders in Borrowing Capacity
If lenders are not displayed in the Borrowing Capacity calculator, check the primary applicant type. The calculator may fail to show lenders if the primary applicant is set to a company record instead of a person record. To fix this:
Change the primary applicant from the company to an individual person record.
Save the opportunity and recreate the borrowing capacity calculation.
Guarantor and Lender Details Not Showing
If guarantor income/details are missing, ensure guarantors are set as applicants. After switching guarantors to applicants, create a new Borrowing Capacity calculator and run the calculation again.
Procedural Guidance
Saving Calculations
Calculations are only saved when the Borrowing Capacity calculator is launched from within a CRM opportunity and you click Save. Saved results will appear under Opportunity >> Calculations. If the calculator is opened directly (outside an opportunity), saving and linking to a client file is not supported. Always start the calculator from the opportunity’s Calculations tab.
Transitioning to Borrowing Capacity V2
When creating a borrowing capacity calculation within an opportunity, always select Borrowing Capacity V2. This ensures you are using the latest version of the tool.
Handling Old Borrowing Capacity Records
You can keep both old and new borrowing capacity records in an opportunity. Add notes to explain the context if needed. The record marked as Default will be applied to the opportunity.
Specific Scenarios
Internal Refinance and the "Clearing" Option
For internal refinancing (refinancing an existing loan with the same lender):
Do not tick Clearing if the existing debt is not being repaid/cleared. Instead, manually add the existing mortgage as an expense under Other Loans, including interest rate, remaining term, and other details.
Tick Clearing only if the loan is being repaid or refinanced such that the debt is cleared. Note: Existing mortgages do not auto-populate into the calculator; you must enter them manually.
Loan Requested Field Greyed Out
If the "Loan requested" field is greyed out, update the Loan Size/Limit in the Assets section. Adjusting the loan amount there will set the correct "Loan requested" value in Borrowing Capacity.
Ownership Portion Field
The Ownership Portion field refers to the proposed loan, not the property.
FAQs and Troubleshooting Tips
Why Doesn’t the Borrowing Capacity Calculator Save My Calculation?
Ensure you launch the calculator from within a CRM opportunity and click Save. Calculations opened directly (outside an opportunity) cannot be saved.
Why Doesn’t Income Updated in the Calculator Appear in the CRM Opportunity?
Data saved in the Borrowing Capacity calculator does not sync back to the CRM. Update income and similar fields directly on the CRM person/opportunity record. CRM data will sync into the calculator, but not the other way around.
Why Does the CRM Calculator Show Different Outcomes Compared to Lender Worksheets?
Differences occur due to varying calculation models and assumptions. If the CRM calculator shows "Fail" while the lender’s calculator shows "Pass," proceed with the deal and add a note in the opportunity explaining the discrepancy, including evidence of the lender calculator’s "Pass."
Why Can’t I Edit the Loan Amount in the Old Borrowing Capacity Calculator?
The old calculator has been decommissioned, so its fields are now read-only. Create a new borrowing capacity calculator for the opportunity and save it to proceed.
