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:

Year

Beginning Amount

Payment

Interest

Repayment of Principal

Ending Balance

1

$16,000

$4512.19

$800

$3712.19

$12287.81

2

12287.81

$4512.19

614.39

3897.80

8390.01

3

8390.01

4512.19

419.50

4092.69

4297.32

4

4297.32

4512.19

214.87

4298.32

$0

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
They are likely to tests for tact, diplomacy, and with descriptive skills.


what are the stages of operational research

Cash  Flow Analysis:   As per the Institute of Cost and Works Accountants of India (AICWAI), a Cash Flow Statement is a declaration setting out the flow of cash under different

In addition, assume that Anheuser-Busch InBev sold 200 million barrels of beer during the year. Assume that variable costs were 75% of the cost of goods sold and 40% of selling,

There is almost not, any organization that does not have an accountant. His task is all pervasive and he is included in a broad range of activities, particularly in a huge and comp

Q. What are simple journal entries? To understand the cross-indexing and posting process trace the entries from the general journal to the general ledger. The ledgers accounts


Q. Sales Returns and Allowances account? The Sales Returns and Allowances account is the contra revenue account to Sales that records the selling price of merchandise returned

How the use of different accounting policies affect the financial performance of different entities operating within the same industry