Calculate interest rate, Accounting Basics

Assignment Help:

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.


Related Discussions:- Calculate interest rate

Adjustments, 2 deprecation on equipment is calculated at 10% per annum on c...

2 deprecation on equipment is calculated at 10% per annum on cost price new equipment for R400 was purchased on 1 December 2012 and has been recorded

Describe about post-closing trial balance, Q. Describe about post-closing t...

Q. Describe about post-closing trial balance? A post-closing trial balance is trial balances taken subsequent to the closing entries have been posted. The only accounts that mu

What do you mean by inventory turnover, Q. What do you mean by Inventory tu...

Q. What do you mean by Inventory turnover? Inventory turnover -- a ratio which indicates amount of inventory a company uses tosupport a given level of sales. Formula is: Invent

What are adjusting entries, Q. What are adjusting entries? When you sta...

Q. What are adjusting entries? When you start to analyze business transactions you saw that the evidence of the transaction is typically a source document. It is any printed or

Antidilution of ownership, Antidilution of Ownership The right of an i...

Antidilution of Ownership The right of an investor is to continue the same percentage ownership of an organizations main stock in the event that the organization issues more s

What do you mean by cross-indexing, Q. What do you mean by Cross-indexing? ...

Q. What do you mean by Cross-indexing? Usually, accountants should check and trace the origin of their transactions so they provide cross indexing. Cross-indexing is the insert

What is inventory, Q. What is Inventory? Inventory -- Supply or stock o...

Q. What is Inventory? Inventory -- Supply or stock of products and goods that a company has for sale. Amanufacturer may have 3 kinds of inventory: raw materials waiting to be c

Explain merchandise in transit, Q. Explain Merchandise in transit? Mer...

Q. Explain Merchandise in transit? Merchandise in transit is merchandise in the hands of a shipment company on the date of a physical inventory. As stated above buyers should

Example on gross margin method, Q. Example on gross margin method? To d...

Q. Example on gross margin method? To demonstrate the gross margin method of computing inventory assumes that for several Years Field Company has maintained a 30 per cent gross

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd