FacebookTwitter
Hatrack River Forum   
my profile login | search | faq | forum home

  next oldest topic   next newest topic
» Hatrack River Forum » Active Forums » Books, Films, Food and Culture » Alright for VB/Math Gurru's I humbly request some help.

   
Author Topic: Alright for VB/Math Gurru's I humbly request some help.
Blayne Bradley
unregistered


- posted            Edit/Delete Post 
I need to know what the mathamatical forumlai is for determine monthly payment and the sum of all payments.

example: I buy a car and i decide to pay in monthly payments and I choose the rate and the # of month's what is the formulai?

And the sum of all payments would be I geuss the average monthly payment * the # of months?
IP: Logged | Report this post to a Moderator
twinky
Member
Member # 693

- posted      Profile for twinky   Email twinky         Edit/Delete Post 
In the monthly installment case, is there interest?
Posts: 10886 | Registered: Feb 2000  |  IP: Logged | Report this post to a Moderator
Blayne Bradley
unregistered


- posted            Edit/Delete Post 
umm yes I think I mentioned "rate".

Months = 48
MonthlyPay = Months * (Finance * (Rate / 12) * (1 + (Rate / 12) ^ 12)) / (((1 + (Rate / 12)) ^ 12) - 1)
lblMonthlyPay.Caption = Format(MonthlyPay, "currency")
SumPay = MonthlyPay * Months
lblSumPay.Caption = Format(SumPay, "currency")

Here's what i gots so far.

The problem I'm a small percantage of money below the total cost of the vehical (base price + options + taxes.

My payment looks right but I don't think is right my sum of payment should be higher not lower then my original.
IP: Logged | Report this post to a Moderator
Dagonee
Member
Member # 5818

- posted      Profile for Dagonee           Edit/Delete Post 
Look up the Pmt() function.
Posts: 26071 | Registered: Oct 2003  |  IP: Logged | Report this post to a Moderator
Blayne Bradley
unregistered


- posted            Edit/Delete Post 
And thus google was invented... odd shows up as a negative, the number I think is right but looks... all negative.
IP: Logged | Report this post to a Moderator
Dagonee
Member
Member # 5818

- posted      Profile for Dagonee           Edit/Delete Post 
There's a technical financial reason for that - just multiply by -1 and go with it. [Smile]
Posts: 26071 | Registered: Oct 2003  |  IP: Logged | Report this post to a Moderator
Blayne Bradley
unregistered


- posted            Edit/Delete Post 
kk, I handed it in and now I'm home as soon as I find a server I'll upload it and share my little program. I worked long and hard on it.
IP: Logged | Report this post to a Moderator
   

   Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
- Printer-friendly view of this topic
Hop To:


Contact Us | Hatrack River Home Page

Copyright © 2008 Hatrack River Enterprises Inc. All rights reserved.
Reproduction in whole or in part without permission is prohibited.


Powered by Infopop Corporation
UBB.classic™ 6.7.2