| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[newbie] financial accounting (2)
I'm trying to calculate a formula as follows:
Effective interest rate = principal amount / (principal amount - interest paid upfront - loan charges) - 1 I have updated this as: =(D60/(D60-D62+D63)) -1 Whe D60 = Principal amount, say ぎ100,000.00 D62 = interest paid upfront , say 10% of the principal amount, ぎ10,000.00 D63 = loan charges, say ぎ2000.00 I am getting a result of 8.7%, whilst when working it out with a calculator it comes out to around 14% (13.64%). Any ideas where my mistake is? MS Excel 2007 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
[newbie] financial accounting (2)
I figured out my math problem.
"Jon" wrote: I'm trying to calculate a formula as follows: Effective interest rate = principal amount / (principal amount - interest paid upfront - loan charges) - 1 I have updated this as: =(D60/(D60-D62-D63)) -1 Whe D60 = Principal amount, say ぎ100,000.00 D62 = interest paid upfront , say 10% of the principal amount, ぎ10,000.00 D63 = loan charges, say ぎ2000.00 I am getting a result of 8.7%, whilst when working it out with a calculator it comes out to around 14% (13.64%). Any ideas where my mistake is? MS Excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [newbie] financial accounting problem | Excel Discussion (Misc queries) | |||
| preparation of financial performance and financial position ? | New Users to Excel | |||
| ACCOUNTING | Excel Discussion (Misc queries) | |||
| Real Newbie newbie question | New Users to Excel | |||
| I need to do a Worksheet for my Financial Accounting Class. What . | Excel Worksheet Functions | |||
Linear Mode
