Excel Sheet - Loan Calculator - Presentation

I am looking to create a loan calculator that will be specific to a business loan. I would like to be able to input the interest rate and the calculator should then generate a loans terms and payment frequency. I prefer the output of the calculation to be in a graphical dashboard format, so I can get the correct visuals when working with this assessment.