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

Financial reporting about the economic resources, Q. Financial reporting ab...

Q. Financial reporting about the economic resources? The third financial reporting should provide information about the economic resources of an enterprise the claims to those

Stocks, Please help journalize: -On January 1, 2017 Harmony issued 1,500 sh...

Please help journalize: -On January 1, 2017 Harmony issued 1,500 shares of $22 par, 8% preferred stock for $43,700. -On January 1, 2017 Harmony also issued 2,000 shares of common s

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

Principal x Rate x Time, 10,000 dollar loan at a Maturity of 3 months, an 8...

10,000 dollar loan at a Maturity of 3 months, an 8% interest rate

Excess payment to supplier, What process for excess payment to supplier I w...

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

What are the various means of calculating depreciation, 1. Double declining...

1. Double declining method 2. Units of production method 3. Sum of year digit method 4. Straight-line method Depreciation Fund Method Insurance Method Annualy Method

Equity segment of a corporate balance sheet, Q. Equity segment of a corpora...

Q. Equity segment of a corporate balance sheet? The stockholders' equity segment of a corporate balance sheet can become more complex as you will see later in the text. But the

Use the following information to answer questions, The Bayside Company uses...

The Bayside Company uses the LIFO cost flow method to value inventory. In the current year, profit at Bayside is running unusually high. The corporate tax rate is also high this ye

calculate wacc and rate of return, Calculate WACC and Rate of Return ...

Calculate WACC and Rate of Return Capital Structure: 50% debt and 50% equity financing Current cost of debt is 2% above prime (Prime is currently 2.5%) cost of equity is e

Enumerate about the income summary account, INCOME SUMMARY ACCOUNT This...

INCOME SUMMARY ACCOUNT This is a temporary account which used to summarize the balances of temporary revenue and expense accounts. This is also known as a clearing account. The

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