I need a MATH major!!

DiscoWeb Message Board: General - Non Tech: I need a MATH major!!
  Subtopic Posts   Updated


Top of pagePrevious messageNext messageBottom of pageLink to this message   By William Turner (Wturner) on Thursday, December 13, 2001 - 03:40 pm: Edit

I am trying to figure out the formula for determining the payout/principal for a car loan given the APR, number of months, times compounded per year, ect.

I think it almost looks similar to this...
P=Principal
.1075=APR (sucks, I know)

[P+(.1075P/365)*????]/48(months)=monthly payment

But, I know my monthly payment, I want to figure my principal every month after I make the payment.

Does anyone know the equation I am looking for???

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Ron Ward (Ronward) on Thursday, December 13, 2001 - 03:48 pm: Edit

William,

Give me the principal (loan) amount and it can be calculated easily on my 12C for both prin and int amounts.

Ron Ward

Top of pagePrevious messageNext messageBottom of pageLink to this message   By William Turner (Wturner) on Thursday, December 13, 2001 - 04:07 pm: Edit

Pay off as of today is $15,014.47 Next(9th) payment of $443.09 is due 12/21.

I have a 4 year loan so a total of 48 pmts. 40 more if I drag it out.

I can always call the bank and get the amount, I just would like the equation so I could do it whenever.

Top of pagePrevious messageNext messageBottom of pageLink to this message   By KJ on Thursday, December 13, 2001 - 04:08 pm: Edit

William,

You are looking for an amortization schedule. Go to edmunds.com or fool.com and look for the links to their calculators. You should be able to print it out once you plug in all the details.

Karen :)

Top of pagePrevious messageNext messageBottom of pageLink to this message   By William Turner (Wturner) on Thursday, December 13, 2001 - 04:08 pm: Edit

Initial principal was $17218.05

Top of pagePrevious messageNext messageBottom of pageLink to this message   By William Turner (Wturner) on Thursday, December 13, 2001 - 04:26 pm: Edit

Karen,

I went there and they didn't have the info I was looking for.

Thanks anyway :)

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Kent Westbrook on Thursday, December 13, 2001 - 04:57 pm: Edit

William,

I quit using formulas in college, work with a calculator now. You're in school, right? Don't they let you use financial calculators? Or do your teachers want you to learn it the old fashioned way? I could probably figure out a way to run you an amort. schedule on Excel if you're interested, could e-mail to you. Let me know.

Kent

Top of pagePrevious messageNext messageBottom of pageLink to this message   By William Turner (Wturner) on Thursday, December 13, 2001 - 05:30 pm: Edit

Kent,

Yes I am in school, but this is for my own amusment. I am a weirdo about this sort of thing. I don't have a finance calc nor will I probably ever get one (ME major, not finance).

The program in excel would be real cool.

My e-mail at work (where I have excel) is william.turner@amd.com

Thanks

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Mike Rupp (Mike_Rupp) on Thursday, December 13, 2001 - 06:51 pm: Edit

William:

Use the =pv formula in Excel. Go to help to get the details.

Mike
Finance Major '91

Top of pagePrevious messageNext messageBottom of pageLink to this message   By charlie on Thursday, December 13, 2001 - 07:02 pm: Edit

Try to use =PMT on excel if you are trying to figure out the payment.

HP12C rules!!!

---Charlie

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Ron on Thursday, December 13, 2001 - 07:04 pm: Edit

17B

12c is for oldtimers

Ron

Top of pagePrevious messageNext messageBottom of pageLink to this message   By charlie on Thursday, December 13, 2001 - 07:13 pm: Edit

Can't believe I have just became the oldtimer at 28 years old.
I guess my prof. my peers, and my mentors(if any) are all old timers

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Ron on Thursday, December 13, 2001 - 07:15 pm: Edit

hehehehe

You should "upgrade" to what us young turks use. More features and easier to do complicated things too.

Ron

Top of pagePrevious messageNext messageBottom of pageLink to this message   By charlie on Thursday, December 13, 2001 - 07:18 pm: Edit

At least I know 12C is CFA approved and 17b is not :)
12C still rules :)

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Ron on Thursday, December 13, 2001 - 07:24 pm: Edit

For the test you mean?

Ron

Top of pagePrevious messageNext messageBottom of pageLink to this message   By charlie on Thursday, December 13, 2001 - 07:43 pm: Edit

yep

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Anonymous on Thursday, December 13, 2001 - 07:59 pm: Edit

from a 17 year old high schooler who's taken this in the past few years....
use the PERT formula where P = e^r * t
where e a constant
just my thoughts....

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Ron Ward (Ronward) on Thursday, December 13, 2001 - 08:21 pm: Edit

12C rules indeed. However, as I worked late this evening, AND my new shocks, steering damper and rear brake pads arrived today from RN, I ran out of the office in a hurry and left the 12C behind. You're on your own for the night, Bro.

Ron Ward

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Roverine on Thursday, December 13, 2001 - 08:45 pm: Edit

I've got 2 old 12C's! ... (does this mean I'm a double old timer?)

Kim
... it does when I can't think of how to calculate it right now ...:(

Top of pagePrevious messageNext messageBottom of pageLink to this message   By KJ on Thursday, December 13, 2001 - 10:38 pm: Edit

William,

Try this link:

http://www.fool.com/calcs/calculators.htm#auto

After you plug in the numbers, click through the various screens and you'll get to a mort schedule at the end.

Karen :)

Top of pagePrevious messageNext messageBottom of pageLink to this message   By KJ on Thursday, December 13, 2001 - 10:40 pm: Edit

P.S. Click on the link for "How much will my payments be", and go from there.

Karen

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Kent Westbrook on Thursday, December 13, 2001 - 11:35 pm: Edit

Geez Ron,

Guess I'm an oldtimer too. My 12C has served me well for damn near 20 years! In "calculator years" that would make it as ancient as your Noah!!

William,

Looks like others have given you some good hints since I last posted. But I'll see what I can come up with.

Kent

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Kyle Beckman (Kbeckman) on Thursday, December 13, 2001 - 11:49 pm: Edit

I had a 32S that got me through all of my Mech E classes. After college I loaned it to my sister, who promptly lost. This was 4 years ago, and she still hasn't replaced it! But I'm not holding a grudge.

Kyle

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Ron on Friday, December 14, 2001 - 12:48 am: Edit

Kent,

You up for the spacer install, I have some free time. Email me at the yahoo address if you want to give it a shot.

12C is allright just the 17B can do so much more that required extra steps with the 12C

Did not mean to offend the old timers :)

My father still has a slide rule if that makes you feel better.

Ron

Top of pagePrevious messageNext messageBottom of pageLink to this message   By Glenn Guinto (Glenn) on Friday, December 14, 2001 - 10:16 am: Edit

William,

I work for a credit union so I had one of the loan folks figure it out for you. If you took this loan out today and your first payment date is the Dec 31st for 48 months, with a 10.75 APR, here is what it would look like:

For 2001:

PmtPaymentPaymentInterestPrincipalCDICLIBalance
#DateAmountPaidPaidPremiumPremiumRemaining
---------------------------------------------------------------
112/31/01441.1486.21354.9316863.12
YearEnd Totals441.1486.21354.9300


For 2002:

PmtPaymentPaymentInterestPrincipalCDICLIBalance
#DateAmountPaidPaidPremiumPremiumRemaining
---------------------------------------------------------------
21/31/02441.14153.96287.1816575.94
32/28/02441.14136.69304.4516271.49
43/31/02441.14148.56292.5815978.91
54/30/02441.14141.18299.9615678.95
65/31/02441.14143.15297.9915380.96
76/30/02441.14135.9305.2415075.72
87/31/02441.14137.64303.514772.22
98/31/02441.14134.87306.2714465.95
109/30/02441.14127.82313.3214152.63
1110/31/02441.14129.22311.9213840.71
1211/30/02441.14122.29318.8513521.86
1312/31/02441.14123.46317.6813204.18
YearEnd Totals5293.681634.743658.9400


For 2003:

PmtPaymentPaymentInterestPrincipalCDICLIBalance
#DateAmountPaidPaidPremiumPremiumRemaining
---------------------------------------------------------------
141/31/03441.14120.56320.5812883.6
152/28/03441.14106.25334.8912548.71
163/31/03441.14114.57326.5712222.14
174/30/03441.14107.99333.1511888.99
185/31/03441.14108.55332.5911556.4
196/30/03441.14102.11339.0311217.37
207/31/03441.14102.42338.7210878.65
218/31/03441.1499.32341.8210536.83
229/30/03441.1493.1348.0410188.79
2310/31/03441.1493.03348.119840.68
2411/30/03441.1486.95354.199486.49
2512/31/03441.1486.61354.539131.96
YearEnd Totals5293.681221.464072.2200


For 2004:

PmtPaymentPaymentInterestPrincipalCDICLIBalance
#DateAmountPaidPaidPremiumPremiumRemaining
---------------------------------------------------------------
261/31/04441.1483.38357.768774.2
272/29/04441.1474.94366.28408
283/31/04441.1476.77364.378043.63
294/30/04441.1471.07370.077673.56
305/31/04441.1470.06371.087302.48
316/30/04441.1464.52376.626925.86
327/31/04441.1463.23377.916547.95
338/31/04441.1459.78381.366166.59
349/30/04441.1454.49386.655779.94
3510/31/04441.1452.77388.375391.57
3611/30/04441.1447.64393.54998.07
3712/31/04441.1445.63395.514602.56
YearEnd Totals5293.68764.284529.400


For 2005:

PmtPaymentPaymentInterestPrincipalCDICLIBalance
#DateAmountPaidPaidPremiumPremiumRemaining
---------------------------------------------------------------
381/31/05441.1442.02399.124203.44
392/28/05441.1434.66406.483796.96
403/31/05441.1434.67406.473390.49
414/30/05441.1429.96411.182979.31
425/31/05441.1427.2413.942565.37
436/30/05441.1422.67418.472146.9
447/31/05441.1419.6421.541725.36
458/31/05441.1415.75425.391299.97
469/30/05441.1411.49429.65870.32
4710/31/05441.147.95433.19437.13
4811/30/05440.993.86437.130
YearEnd Totals4852.39249.834602.5600


And the final tally is:

PmtPaymentPaymentInterestPrincipalCDICLIBalance
#DateAmountPaidPaidPremiumPremiumRemaining
---------------------------------------------------------------
GrandTotal21174.573956.5217218.05


CDI stands for Credit Disability Insurance, should you get disabled, your loan gets paid and CLI stands for Credit Life Insurance, should you die, your loan gets paid. I know there's a difference on your payment versus the payment we calculated. You probably pay extra for a CDI or CLI. If you have any other questions, I'll try to answer them for you!

Glenn
-your friendly neighborhood lender

Top of pagePrevious messageNext messageBottom of pageLink to this message   By William Turner (Wturner) on Friday, December 14, 2001 - 12:18 pm: Edit

I don't have either. The way I see it is the CDI, well that is a gamble on the fact that I am 21, and am more unlikely to get disabled.

The CLI, well if I am dead, then chances are I am not going to give a shit about that loan :)

Top of pagePrevious messageNext messageBottom of pageLink to this message   By SOLO on Friday, December 14, 2001 - 01:08 pm: Edit

Now I know why I became a Business Management Major and not a Finance major....too many numbers.

Larry


Add a Message


This is a public posting area. If you do not have an account, enter your full name into the "Username" box and leave the "Password" box empty. Your e-mail address is optional.
Username:  
Password:
E-mail:
Post as "Anonymous"

Administrator's Control Panel -- Board Moderators Only
Administer Page | Delete Conversation | Close Conversation | Move Conversation