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
OBJECTIVES OF FINANCIAL STATEMENT ANALYSIS Financial Statements are analyzed by dissimilar users for dissimilar purposes. Some of the purposes are as under- 1. To recognize

what would be the entry for-"rent recieved in advance"

Q. Explain about Long-term assets? Long-term assets are assets that a business has on hand or else uses for a relatively long time. Examples include plant, property and equipme

Q. Fundamental manual accounting system? Those planning on a public accounting career must do more than just learn accounting. To develop the essential skills a broad education

Question: You have decided to borrow $20,000 so that you can consolidate the loans you currently have with other lenders. You have agreed to repay the loan in 8 equal semi-annu

What process for excess payment to supplier I would like know without adjusting invoice that means how supplier will send back surplus amount how do in oracle apps?          Ans

Worthington Company issued 1,000,000 face value, 10% bonds on July 1 2012, when the market rate of interest was 12%. Interest payments are due every July 1 and January 1. Worthin

what are the basic theory of accounting

SCENARIO In May of the current year, your employer received a PIER report from the CRA that identified Canada Pension Plan (CPP) contribution deficiencies for employees in the org

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