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 the schedule of accounts payable, Schedule of Accounts Payable  ...

Schedule of Accounts Payable  Lists the balances of accounts payable ledger, and Accounts Payable controlling account demonstrates the total amount owed to ALL creditors. Th

Calculate the wacc, The capital structure of Wild West Inc. is as follows: ...

The capital structure of Wild West Inc. is as follows: -            Debts: $5,000,000 (face value) bonds with coupon rate at 8.00% and current price at par -

Explain about matching principle, Q. Explain about matching principle? ...

Q. Explain about matching principle? The matching principle need that expenses incurred in producing revenues is deducted from the revenues they generated during the accounting

Revaluation model, Is there nay depreciation needed to perform when the rev...

Is there nay depreciation needed to perform when the revaluation model is applied to the asset?

Income statement, A company pays rates annually/yearly in advance on 1 Apri...

A company pays rates annually/yearly in advance on 1 April every year. $4000 is paid by them on 1 April 2009 and $4800 on 1 April year 2010. The company's accounting year end is 31

Calculate current ratio, Compute each of the following amounts Company repo...

Compute each of the following amounts Company reported current assets of $80,000, non-current assets of $350,000, current liabilites of $32,000 and long term liabilities of $120,00

Non performing asset?, An asset or account of borrower, which has been clas...

An asset or account of borrower, which has been classified by a bank or financial institution as sub-standard, doubtful or loss assets as per the guidelines issued by RBI. An

Accounts show the amount of money owed to the firm, __________ accounts sho...

__________ accounts show the amount of money owed to the firm by customers. A. Supply B. Prepaid C. Receivables D. Payables

Explain accrual basis of accounting, Q. Explain accrual basis of accounting...

Q. Explain accrual basis of accounting? In certain circumstances companies may perhaps use the cash basis for income tax purposes. All through the text we use the accrual basis

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