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

Create an adjusted trial balance & journal entries Bank charges of $932.70 were not recorded in the books for 2014. These were credit card fees charged by the bank for Edwards

Limitations of Funds Flow Statement : despite the a variety of uses of the announcement, it has convinced problems also.  They consist of the subsequent i) It cannot substitute

Difference between Income Statement and Balance Sheet Difference between the amounts of the columns in Income Statement and Balance Sheet should be the same amount. Words "Net

A high school counselor needs to show whether the teenage pregnancy rate at her school is disimilar from the rate nationwide. She knows that the rate nationwide is 15 %. She random

ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account. elaborate on the statement and explain why journal is neces

Q. Show the company's Balance sheet? Balance sheet the balance sheet Exhibit contains the liabilities, assets and stockholders' equity items taken from the work sheet. Note tha

What is OWNER'S EQUITY Difference between Liabilities and Assets is Owner's Equity. The can also be known as capital, proprietorship, or net worth.

Q. What is periodic inventory procedure? In the periodic inventory procedure the Merchandise Inventory account is updated periodically subsequent to a physical count has been m

I need help understanding my Accounting 205 class. Would some one please help me understand what I am having such a hard time comprehending.