Ed
asked on
Work Out APR in Vb.
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
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).
ASKER
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%
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, Thankyou
http://stephenhaunts.com/2013/05/22/how-to-calculate-annual-percentage-rates-apr/