Not exact matches
Imagine their surprise when investors in a small business I once worked for received the company's internal
loan repayment
spreadsheet, showing that the business owner was pulling out bucks by paying his family exorbitant
interest on
loans while investor
loans were repaid at rock - bottom rates over as long a time period as possible.
This is a commercial use license of our
Interest - Only
Loan spreadsheet.
A commercial use version of this
Interest - Only
Loan calculator is included as a bonus
spreadsheet when you purchase the
Loan Amortization Schedule.
By plugging all of your student
loan information into a
spreadsheet, you'll have all the critical information handy — your current
interest rate, lenders, monthly payments, balances, etc. — as you begin to research the refinancing options available to you.
The Vertex42 ™
Interest - Only
Loan Calculator is a very powerful
spreadsheet based on our popular
Loan Amortization Schedule.
For a revolving line of credit (such as a credit card or HELOC),
interest normally accrues daily, so this
spreadsheet is like the «simple
interest loan» calculator except that it allows you to include additional draws besides the initial
loan amount.
You didn't say how you setup your test
spreadsheet, but since IPMT is defined as «calculates the
interest payment, during a specific period of a
loan or investment that is paid in constant periodic payments, with a constant
interest rate,» (emphasis added) I think you could be making mistakes in how you use it.
Calculate the monthly payments, total
interest, and the amount of the balloon payment for a simple
loan using this Excel
spreadsheet template.
This
spreadsheet calculates
interest using a compound daily
interest formula, which is often used to calculated
interest on private student
loans.
Federal student
loans use a simple daily
interest formula, and we will post a separate
spreadsheet to help you calculate the benefits of making bi-weekly payments on your federal
loans.
The auto
loan calculators in our
spreadsheet let you specify a cash rebate and the annual
interest rate.
Get organized by gathering all of your important student
loan details in an easy - to - access
spreadsheet, keeping track of your
interest rates, monthly payments, and login details.
Accounting Clerks review and maintain accounting records for their clients by entering balances and calculating
interest on
loans, bank accounts, and credit accounts using accounting
spreadsheets and databases.