|
will (p*t*r)/100 work for you?
or you may have to just fine tune this basic formula.
if you can elaborate your requirement more, then i can explain with better clarity.
|
|
|
|
|
The only formaula that seems to work is one over 364 days.. Here is it:
=PMT(APR/364 x Number of payments x 1 x Amount finaned)x -1 - APR
But shouldn't it be 365 days? 
I did this on excel and that's all I can come up with. Let me know what you think.
Victoria
|
|
|
|
|
Vtoria wrote: HELP!?!?!?!?!
NO KIDDING! Who in the world is charging 240 APR interest??? 
BTW, at 240 APR, $252 won't even make the interest payment, let alone pay it off in a year! 
David
|
|
|
|
|
Hi David,
This is for an installment loan that is VERY high risk. No credit check, or anything like that. But that isn't the issue at stake. The issue is how are they coming up with the formula for equal bi-weekly payments at that APR?. To answer your question, YES, it does pay it off:
monthly principle interest balance
251.96 70.64 181.32 2,429.36
251.96 27.72 224.24 2,401.64
251.96 30.27 221.69 2,371.37
251.96 33.07 218.89 2,338.30
251.96 36.12 215.84 2,302.18
251.96 39.45 212.51 2,262.72
251.96 43.10 208.86 2,219.63
251.96 47.07 204.89 2,172.55
251.96 51.42 200.54 2,121.13
251.96 56.17 195.79 2,064.97
251.96 61.35 190.61 2,003.61
251.96 67.01 184.95 1,936.60
251.96 73.20 178.76 1,863.40
251.96 79.96 172.00 1,783.44
251.96 87.34 164.62 1,696.11
251.96 95.40 156.56 1,600.71
251.96 104.20 147.76 1,496.50
251.96 113.82 138.14 1,382.68
251.96 124.33 127.63 1,258.35
251.96 135.81 116.15 1,122.54
251.96 148.34 103.62 974.20
251.96 162.04 89.92 812.17
251.96 176.99 74.97 635.17
251.96 193.33 58.63 441.84
251.96 211.18 40.78 230.67
251.96 230.67 21.29 0.00
Victoria
|
|
|
|
|
OK, I missed the point about 26 payments. I thought you meant 12 monthly payments.
|
|
|
|
|
Use the same formula I provided earlier, but substitute 2.4/26 (the biweekly rate) into the formula for 'r' and 26 for 'n'.
It gives a different answer than 251.96, but I see that your first principle amount is very high in comparison, indicating that your first payment is being made before the full 2-weeks have expired. This will change your payment amount.
David
ps. is it really legal to charge that much interest where you live? I've heard of such things, but I think it's a disgrace. These kinds of loans are specifically designed to rape the poor.
|
|
|
|
|
Ok.. I'll try it.
Yes, it is legal, in most states. I can see where some people whould call them loan sharks, but I also see their side to it. These are companies that do not do any type of credit check. All they require is a valid drivers license, current paystub, ative checking account and phone bill. Who knows what they have out there. If I was going to lend someone $1000 who had a track history of late payment, I would want $1500 back in 6 months. These types of loans are so risky! Especially because more than half have bad credit. Now, let't say someone needs a loan until their bonus checks comes in in 2 weeks, and they need to make rent, car payment and extra money for food. (We all know that a lot of people live check to check). They take a loan for $1,000; in 2 weeks they pay $1,090.00! So it cost them $90.00 to take out a 2 week loan! NOT BAD. And it kept them from being negaitive in their accounts or get charged NSF fees, etc.. I say short term, it's worrth it. Long term.. NOT AT ALL!
Victoria
|
|
|
|
|
There's been exactly *one* actual study on this sort of lending. With the cooperation of a South African bank they took a group of people who were just under the approval threshold for a loans with average values of ~1000, and 4 monthly payments of ~360 (don't recall if values were in US or local currencies) and granted approval to half of them anyway. They then did a 6mo followup on both groups and found the ones that had been granted the loan were on average better off financially than those that had been denied. I read about it in a recent issue of The Economist, but since I don't save back issues I can't tell you which one it was.
--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.
|
|
|
|
|
see http://www.public.asu.edu/~subhro/pup622/localfinance/sld008.htm[^] but substitute the MONTHLY RATE for 'r' in the formula if you are using 'n' as the number of months.
Assuming you actually meant 23.99 APR, (which equates to ~ 2% per month) the formula gives: $236.40. I built a quick spreadsheet to verify that this payment amount will in-fact pay off the debt in 12 months, and it does. This payment number is slightly different than your number, so I'm wondering if your interest is being compounded differently.
David
|
|
|
|
|
Can you forward me that spreadsheet? Is it in Excel?
The APR is in fact 239.9961%.
Victoria
|
|
|
|
|
See your e-mail account you posted with CodeProject. I don't know how to post files.
David
|
|
|
|
|
I don't have anything. But you can send it to vtoriagarcia@aol.com
Thank you!
Victoria
|
|
|
|
|
Vtoria wrote: The APR is in fact 239.9961%
Sorry, but that is just insane...
Only an idiot would go with that.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
The interest is accrued daily on the principle balance; just like a mortgage.
Victoria
|
|
|
|
|
Take a look at this article from the FAQ of Dr. Math:
http://www.mathforum.org/dr.math/faq/faq.interest.html[^]
In an installment loan, a lender loans a borrower a principal amount P, on which the borrower will pay a yearly interest rate of i (as a fraction, e.g. a rate of 6% would correspond to i=0.06) for n years. The borrower pays a fixed amount M to the lender q times per year. At the end of the n years, the last payment by the borrower pays off the loan.
The amount of the fixed payment is determined by:
M = P * i / [ q (1 - [1+( i / q)]^(-n* q) ) ]
M = 2500 * 2.399961 / [26 (1 - [1+(2.399961/26)]^(-1*26) ) ]
674653127756771870877187207 (which, when rounded to 2 dp is $256.61)
The total amount paid by the borrower is Mnq, and the total amount of interest paid is I = Mnq - P:
I = M * n * q - P
I = 256.60 * 1 * 26 - 2500
I = 4171.7754098132167606864280686738 (which, when rounded is $4171.78)
That is a lot of interest!
Jerry
http://www.mathforum.org/dr.math[^]
|
|
|
|
|
My lad has just come home with this....
A lemming runs towards a cliff at 4m/s. He jumps of and falls at 25 m/s. Assume vertical drop, not inertia, etc. The whole distance travelled is 500m. The time taken = 41seconds. How tall is the cliff?
4m/s
A-------------B
|
|
| 25m/s
|
|
C
A to C = 500 meters. Time Taken = 41 seconds. We know the answer is 400 meters, but no idea how to get there. I've worked on S = D/T
41 = 4 + 25
----- --
500-x x
Any ideas? He won't just submit the answer - he will understand it - honestly!!
Cheers
Malc 'frustrated' Smart
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Malcolm Smart wrote: 41 = 4 + 25
----- --
500-x x
Not sure how to read this, it does not appear in my approach though:
say x = horizontal distance to reach cliff
say y = height of cliff
then total distance = x+y = 500 m
and total time = horizontal time + vertical time = 41 sec
so write down these times as an expression in x and y, you get a system of two
linear equations with two variables, that easily gets solved.
And indeed x=100, y=400 m
BTW: real lemmings would follow a parabola, with an increasing vertical speed due to
gravity, until air friction would stop the vertical acceleration...
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Thanks Luc
Can you go that one step further with the two linear equations (or at least one of them..?)
He's not submitting the homework as we've admitted defeat, so he isn't cheating - I wouldn't let him. Honest!! And it's now more for me than him.
We've got distance = speed / time.
and from that
distance x = 4ms / ?
distance y = 25ms / ?
but now stumped.
Cheers
Malc
....and if I ever saw a real lemming after swatting through this, it wouldn't follow a parabola - I'd stamp on it.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Malcolm Smart wrote: We've got distance = speed / time
that's a new kind of physics to me: the shorter you travel the farther you go?
as one of my professors repeated over and over: check the dimensions (units must match
on both sides).
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
OK - we've now got (after punching him repeatedly for using a made up formula....)
x = unknown time
total distance = (speed*time falling) + (speed*time running)
500 = 25x + 4(41-x) //41 - total time, x = time spent falling
500 = 25x + 164 - 4x
336 = 21x
x = 16.
25 * 16 = 400 - cool!!!
Thanks for not giving the answer - made us both think, and to realise something fundamental was wrong - distance = speed * time - doh.
I'll stick to C#, Higher Grade GCSE isn't my thing...  )
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Malcolm Smart wrote: Thanks for not giving the answer
You're welcome, always happy to help ... a little. 
Malcolm Smart wrote: I'd stamp on it.
Malcolm Smart wrote: after punching him repeatedly
Please keep violence against kids and animals down to the necessary levels. 
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Luc Pattyn wrote: say x = horizontal distance to reach cliff
say y = height of cliff
then total distance = x+y = 500 m
and total time = horizontal time + vertical time = 41 sec
so write down these times as an expression in x and y, you get a system of two
linear equations with two variables, that easily gets solved.
And indeed x=100, y=400 m
Hmmm, I have an Algebra test to administer next week, and I might just throw this at my students :->
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
Luc Pattyn wrote: BTW: real lemmings would follow a parabola, with an increasing vertical speed due to
gravity, until air friction would stop the vertical acceleration...
For something as small as a lemming terminal velocity would be reached very quickly so a constant linear velocity isn't a bad approximation.
--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.
|
|
|
|
|
That would depend on the fur condition, hence the season.
Anyway, initially it would not be 25m/s so the real cliff would not be as tall.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Luc Pattyn wrote: That would depend on the fur condition, hence the season.
Not much, even hairless they'd have a very low terminal velocity due to their low mass. The exact value might change slightly but that it would be very slow would remain a constant.
Luc Pattyn wrote: Anyway, initially it would not be 25m/s so the real cliff would not be as tall.
True, but with an initial acceleration of 9.8m/s/s, and the drag resulting in something similar (in appearance at least) to an exponential approach terminal velocity would be reached in 3ish seconds, with >90% of the fall near terminal velocity the initial conditions will have a fairly small impact on the result.
--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
