Just enter the loan amount interest rate loan duration and start date into the Excel loan calculator and it will calculate each monthly principal and interest cost through the final payment. SI Simple interest. As an office automation tool it allows thousands of calculations to be made in just minutes and simplifies day-to-day work tasks.
Calculating interest in personal finances can help you estimate closing costs for a mortgage or evaluate options for savings and investment accounts.
As an office automation tool it allows thousands of calculations to be made in just minutes and simplifies day-to-day work tasks. Its in the upper-left side of the main Excel page. After one year you have 100 in principal and 10 in interest for a total base of 110. Business applications include calculating interest owed on late payments from customers or to vendors.