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 term- reversing entries and interim statements, Explain the ter...

Explain the term- Reversing entries and Interim statements Reversing entries - Made the first day of new accounting period. They are exact opposite of the adjusting entries

What is the typical time span for long-range plans?, What is the typical ti...

What is the typical time span for long-range plans? A. More than 1 year C. 3-5 years B. 2-3 years D. About 25 years

An invoice for product x totals $1, An invoice for product X totals $1,200 ...

An invoice for product X totals $1,200 and is dated July 6, 2000 with terms 2/10-60X. If the invoice is paid on September 3, 2000, what is the net amount of payment? A. $912

Can you explain about liabilities, Q. Can you explain about Liabilities? ...

Q. Can you explain about Liabilities? Liabilities -- amounts owed by a company to others. Current liabilities are those amounts duewithin one year or less and generally include

What are accrued items explain with example, Q. What are Accrued items expl...

Q. What are Accrued items explain with example? Delayed items consist of two types of adjusting entries asset/expense adjustments and liability/revenue adjustments. For instanc

Effects of bias in terms of accounting, Q. Effects of bias in terms of acco...

Q. Effects of bias in terms of accounting? Where there is no correspondence the cause may be (a) bias or (b) lack of completeness. - Effects of bias. Accounting measuremen

Shareholders and investors, Shareholders and Investors: as shareholders an...

Shareholders and Investors: as shareholders and the other investors have invested their wealth in a business activity, they are interested in understanding periodically regarding

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 -

Describe the accounting procedures, Q. Describe the accounting procedures? ...

Q. Describe the accounting procedures? The demand for college professors differ greatly by discipline. In fields such like Fine Arts, English, Philosophy and Psychology there i

#ti, 10% preference share 336 ooo ordinary share capital 480 000 prepare a...

10% preference share 336 ooo ordinary share capital 480 000 prepare a statement of profit or loss

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