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

Explain business entity concept, Q. Explain business entity concept? Su...

Q. Explain business entity concept? Suppose for instance that you own two businesses 1) a physical fitness centre and 2) a horse stable. As per to the business entity concept y

Determine about the purchasing procedures, Determine the Purchasing Procedu...

Determine the Purchasing Procedures Alarge company would use a "purchasing agent" who heads purchasing department. Small companies would use manager/owner, etc. Seller recei

Explain the meaning of payroll deductions, Explain the meaning of Payroll D...

Explain the meaning of Payroll Deductions There are numerous deductions taken from an employee's earnings. These are deducted by employer before employee receives a check. D

Define auditing, Q. Define Auditing? Auditing A business in quest of a ...

Q. Define Auditing? Auditing A business in quest of a loan or attempting to have its securities traded on a stock exchange typically must provide financial statements to suppor

Uses of technology in accounting, Q. Uses of technology in accounting? ...

Q. Uses of technology in accounting? The computers of persons in a given building or department are frequently connected in a Local Area Network (LAN). These persons are able t

Components of profit and loss account, Components of Profit and Loss Accoun...

Components of Profit and Loss Account The Profit & Loss Account intend to check profit. It has three parts. 1) The Trading Account: These account the money in (revenue)

Ledger, ledger is said to be the principal book entry and the transactions ...

ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account. elaborate on the statement and explain why journal is neces

Hawkeye electric company engaged in the following, Hawkeye Electric Company...

Hawkeye Electric Company engaged in the following transactions during July. Journalize the preceding transactions on the books of Hawkeye Electric Company using the perpetual sys

Explain about closing process, Q. Explain about closing process? Expens...

Q. Explain about closing process? Expense, revenue and dividends accounts are nominal (temporary) accounts that are merely sub classifications of a real (permanent) account Ret

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