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
The Development Stage Entities Topic specifies the guidelines for identifying an entity in the development stage, addresses the applicability of generally accepted accounting princ

The owner's equity of Logan's company is equal to one quarter of the total assets. Liabilities equal $60,000. What is the amount of owner's equity?

Q. Explain about business entity concept? A business entity perhaps made up of several different legal entities. For example a large business such as General Motors Corporation

A business may perhaps engage in thousands of transactions during a year. An accountant summarizes and classifies the data in these transactions to create useful information.


Fixed Assets An additional categorization other than current or long-term is as well used for property. A "fixed asset" is an asset which is planned to be of a lasting nature a

Q. Explain Vertical analysis? Vertical analysis demonstrates the percentage that each item in a financial statement is of some significant total such as total assets or sales.

Money payable by customers (individuals or corporations) to the other entity in exchange for goods or services that have been given or used, but not yet paid for. Receivables typic

at the end of May he has a voucher for expenditure of $270 and a balance in hand of $30. explain what the imprest amount is

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy fou