74% of employees feel they are not achieving their full potential. With Linux Academy, not only will you strengthen your team's core competencies but also their knowledge of of the newest IT topics.
With new material every week, we'll make sure that you stay ahead of the game.
Course Of The Month
3 days, 12 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Work Out APR in Vb.
Posted on 2014-03-07
I need help to work out APR
I can work out monthly repayments based on knowing the interest rate and number of repayments but now I need to work out the APR rate.
Total repayable: £89,160
Loan : £70,000
Annual rate: 6.75%
Gross loan: £75,495
Can anyone give me some vb code to work out the APR from the information above?
Thanks
I can work out monthly repayments based on knowing the interest rate and number of repayments but now I need to work out the APR rate.
Total repayable: £89,160
Loan : £70,000
Annual rate: 6.75%
Gross loan: £75,495
Can anyone give me some vb code to work out the APR from the information above?
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
Don't need to be that complex for a loan with a single payment level. Use the Rate() method. The VB documentation gives a pretty clear example of how to use it. Note that the money in one direction or the other (payment or initial value) needs to be negative, and that you'll probably want to get a rate per month (assuming payments are made monthly), which then needs to be multiplied by 12.
I can't give you an exact formula, because you haven't provided all the information needed: We need to know the length of time the loan lasts and the payment per month (or other payment period).
I can't give you an exact formula, because you haven't provided all the information needed: We need to know the length of time the loan lasts and the payment per month (or other payment period).
Active 4 days ago
Here are the full details. I want to work out the apr with the below variables on a button click event. Thanks
Loan Advance: £70,000.00
Term: 5 years
Monthly Payment: £1,486.00
Total Repayable: £89,160.00
Lender Fees: £500.00
Broker Fee: £4,995.00
Gross Loan: £75,495.00
Annual rate: 6.75%
Loan Advance: £70,000.00
Term: 5 years
Monthly Payment: £1,486.00
Total Repayable: £89,160.00
Lender Fees: £500.00
Broker Fee: £4,995.00
Gross Loan: £75,495.00
Annual rate: 6.75%
Assuming the first payment is due one month after the loan is made:
Dim APR As Double = Rate(5 * 12, 1486, -70000, 0, DueDate.EndOfPeriod) * 12
gives a result of .0996244, or 9.962%.
If you want to be able to solve for this based just on the loan, fees, and stated interest rate, then you first need to calculate the payment, and feed that into this function:
Dim LoanPmt As Double = Math.Round(Pmt(0.0675 / 12, 5 * 12, -75495), 2)
Dim APR As Double = Rate(5 * 12, LoanPmt, -70000) * 12
Dim APR As Double = Rate(5 * 12, 1486, -70000, 0, DueDate.EndOfPeriod) * 12
gives a result of .0996244, or 9.962%.
If you want to be able to solve for this based just on the loan, fees, and stated interest rate, then you first need to calculate the payment, and feed that into this function:
Dim LoanPmt As Double = Math.Round(Pmt(0.0675 / 12, 5 * 12, -75495), 2)
Dim APR As Double = Rate(5 * 12, LoanPmt, -70000) * 12
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month3 days, 12 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.