Is there a formula to calculate loan payments?

Answered - Pending Review

I need to calculate the periodic payment of a amortizing loan with level payments and a constant rate of interest. Is there a formula that I can use in Smartsheet to make this calculation?


  • Hi Jimmy,

    There is no specific formula for loan payments. However, you can create a simple sheet with basic formulas. Given below link to a published sheet with some basic calculations. The numbers will vary based on the initial loan amount, percentage of interest, and the monthly payment amount.



    Associate Director

    Copernicus Consulting Pte. Ltd.

    P: +65 9230 5657 | E: [email protected]

    Feel free to reach out for licenses, services, and training on Smartsheet

Sign In or Register to comment.