Calculate interest rate, Accounting Basics

I chose table 2-4 Loan Amortization Schedule, $100,000 at 6% for 5 years to discuss. Table 2-4 relates to the other two tables in that it is the opposite of the other two tables. Table 2-4 illustrates paying down an initial amount borrowed, where the other two tables illustrate either the present or future value of money invested.

If one were to use a calculator to solve the amortization of a loan, we would input N= length of the loan, I/YR= interest rate, initial loan amount, PV=100000, and the ending value or FV=0 (Brigham & Houston,2007).

If one were to use Microsoft Excel to solve the problem, I would list the length of the loan vertically and horizontally would be the Beginning amount, payment amount, interest, amount paid to principal and the ending balance.

My example: If I were to take out an auto loan for $16,000 at 5% and it had to be repaid in 4 years:


Beginning Amount



Repayment of Principal

Ending Balance

























Initially, I solved this problem using my financial calculator to find the payment amount. Then I figured out the interest on year one (16000x.05), I subtracted the interest from the payment amount to find the principal. I subtracted the principal payment from the beginning amount to get the ending balance. I then carried the ending balance to the next line to use as the starting figure and went from there.

Posted Date: 3/18/2013 5:31:41 AM | Location : United States

Related Discussions:- Calculate interest rate, Assignment Help, Ask Question on Calculate interest rate, Get Answer, Expert's Help, Calculate interest rate Discussions

Write discussion on Calculate interest rate
Your posts are moderated
Related Questions
Why to and by using in journal, trading a/c, p&l a/c and ledger?

If a customer payment data was lost and needed to be reconstructed what are some of the ethical considerations the business owner would need to consider? This may include internal

What is TRIAL BALANCE This statement is a listing on a certain date which demonstrates all accounts and their balances. This generally happen at the end of the month however it

#quthe books of deven verma could not be tallied.the accountant transferred the difference of Rs.1270 in the suspense account on the debit side the following mistakes were found la

How accounting helps in Internationalisation of businesses Internationalisation of businesses has created a need for accounting rules to have an international reach. It can no

State the term- Liabilities Current Liability is a debt which is due for payment within one year. Long-term liability is one NOT paid in a year. OWNER'S EQUITY Also

most consrvatism way of lower cost method

A firm has $200,000 in total assets and $120,000 in owner's equity. What are the total liabilities? A. $80,000 B. $200,000 C. $320,000 D. Cannot be determined from the info