Remember Me?

#1
 jw Posts: n/a
Annual interest rate

Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.

Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.

#2
 JE McGimpsey Posts: n/a

One way:

=(Y/X)^n - 1

where n is the number of periods per year (in this case, 2)

In article .com,
"jw" wrote:

Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.

Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.

#3
 David Billigmeier Posts: n/a

=(Y/X)^2-1 to get the effective annual interest rate (what you are actually
paying yearly taking into account compounding of interest)

=(Y/X-1)*2 to get the APR
--
Regards,
Dave

"jw" wrote:

Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.

Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post John Excel Worksheet Functions 4 April 4th 23 12:45 PM Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM Linda Adams Excel Worksheet Functions 2 May 5th 05 06:14 AM sts111 Excel Discussion (Misc queries) 1 February 1st 05 01:26 PM Dean Strudwick Excel Discussion (Misc queries) 1 December 6th 04 11:36 PM

All times are GMT +1. The time now is 09:16 AM.