Calculate interest rate, Accounting Basics

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.

Posted Date: 3/18/2013 5:31:41 AM | Location : United States







Related Discussions:- Calculate interest rate, Assignment Help, Ask Question on Calculate interest rate, Get Answer, Expert's Help, Calculate interest rate Discussions

Write discussion on Calculate interest rate
Your posts are moderated
Related Questions
Cartwright inc has $1,000,000 of 10% bonds outstanding on December 31, 20x8. On January 1, 20x9 adams corp and 80% owned subsidiary of Cartright, inc purchases a $250,000 part of c

Q. What is Accrued expenses? Accrued expenses, accruals -- an expense that has been incurred though not yet paid for.Salaries are a good instance. Employees earn or accrue salar

Taxes are affected by the level of economic activity: When output increases, tax revenues typically increase, when output falls, tax revenues fall. Suppose a balanced- budget amend

UNITs UNIT COST UNIT SALE PRICE AUG 3 SALE 45 $ 83 8 PURCHASE 75 $ 52 21 SALE 70 $ 85 30 PURCHASE 10 $ 55 Decorative steel began August with 55 units of iron inventory th

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

Q. Example of Adjustments for deferred items? A real physical inventory a count of the supplies on hand at the end of the month showed only USD 900 of supplies on hand. Therefo

Q. What do you eman by Purchases account? In periodic inventory procedure a merchandising company uses the Purchases account to record the cost of merchandise bought for resale

The widget industry is perfectly competitive. The industry demand and supply functions for widgets are given below. Q d = 424 - 40P Q s  = 40 +   8P a.  What is the equi

Why to and by using in journal, trading a/c, p&l a/c and ledger?

Hugo Company has a five-day workweek and pays salaries of $35,000 each Friday. 1. Prepare the adjusting entry required on May 31, assuming that June 1 falls on a Wednesday. 2. Prep