Solved

Compount Interest VB.Net

Posted on 2014-03-11
3
253 Views
Last Modified: 2014-03-11
Hi

I recently had help with some vb in working out APR. The code is correct however I've just realised that it is slightly inaccurate as it needs to consider ' Compound Interest'


I was working out APR with this


 
       Dim LoanPmt As Double = Math.Round(Pmt(0.119 / 12, 300, -17044), 2)
        Dim APR As Double = Rate(300, -LoanPmt, 15000)

        Label1.Text = ((APR * 12) * 100)

Open in new window



What I've been told by the lender is that I now need to consider compound interest.

To do this I need to include this(below) into my formula. Can someone help me do this.  Thanks

= (1+Rate) ^12-1 

Open in new window

0
Comment
Question by:edjones1
  • 2
3 Comments
 

Author Comment

by:edjones1
Comment Utility
Apparently I'm not considering the compound interest. What I'm doing wrong is multiplying the rate by 12.. I need  to change the formula to: = (1+Rate) ^12-1
0
 
LVL 74

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
Comment Utility
I always thought the CI formula was this (https://qrc.depaul.edu/StudyGuide2009/Notes/Savings%20Accounts/Compound%20Interest.htm):

A = P(1 + (r/n))^nt

...where:

P = principal amount (the initial amount you borrow or deposit)
r  = annual rate of interest (as a decimal)
t  = number of years the amount is deposited or borrowed for.
A = amount of money accumulated after n years, including interest.
n  =  number of times the interest is compounded per year

How did you come up with your formula?
0
 

Author Closing Comment

by:edjones1
Comment Utility
Answered my question, thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now