Loan Calculator

Hi Diana Flores,

I've done something like this before in the Leads and Opps module in order to help size/qualify prospects in retail banking environments.

First step is to break down all the inputs - use something like https://www.bankrate.com/loans/personal-loans/how-to-calculate-loan-payments/ to point all the questions (fields) that your loan officer would capture from a user (or some might have been prepopulated from web form submissions)

That same site also gives you the formula - which you can use SugarLogic with. This is likely to become relatively complex - so from a best practice pov, I'd often use hidden fields to capture the components of the formula.

Two other learnings I had:

• End users (your customers' customer) are used to doing this on the web, e.g. https://www.commbank.com.au/digital/home-buying/calculator/home-loan-repayments - where they get instant answers and often pretty graphics to go with. Sugar doesn't do that. The above is all internal staff facing.
  
  
• Your customer (and indeed, lots of teams) use Excel to calculate this internally when on the phone etc - e.g. https://support.microsoft.com/en-us/office/using-excel-formulas-to-figure-out-payments-and-savings-11cb708f-c137-4ef8-bcf3-5137aaeb4b20 - whatever you design within Sugar will be compared to this in terms of usability

Hope this helps!

Adam

Hi Adam,

Thank you!! I really appreciate all the information you provided!

Hi Adam,

Thank you!! I really appreciate all the information you provided!