d3sign / Getty Images The formula for calculating simple interest is: The total amount ... that i = 9.86% using a financial calculator or Excel spreadsheet. Your initial investment (PV) of $ ...

When borrowing money, simple interest represents the percentage of your loan balance that you owe in fees to the lender. This ...

Nick David / Getty Images There is no specific formula in Excel or other spreadsheet applications ... as lenders charge higher interest or investors require higher returns for the risk they ...