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

Pro forma Financial Statements In accounting, a financial statement in which the amounts begin are fully or partially estimates; from the Latin for "as a matter of form."

Q. What is dividend? One idea of the statement of retained earnings is to connect the income statement and the balance sheet. The statement of retained earnings describes the c

Start in cell E3. Complete the series of substitution values ranging from 5 to 15 at increments of 1, vertically down column E.

Determine the specific citation for accounting for each of the following items: 1. Accounts receivables from related parties should be shown separately from trade receivables. 2. T

Q. Consistency in accounting principle? Consistency necessitates that a company use the same accounting principles and reporting practices through time. Consistency makes possi


what is the BRS

Based on the financial statements for Jackson Enterprises (income statement, statement of owner's equity, and balance sheet) shown below, prepare the following financial ratios. Al

Determine the terms of Recording sales of merchandise The SALES ACCOUNT is a temporary account with a normal credit balance. It's ONLY used to record sale of merchandise on