|
dayna
Starting Member
Philippines
14 Posts |
 Posted - 12/09/2012 : 21:49:38
|
anybody here can help me how to compute IRR(Internal Rate of Return) using diminishing computation?
here is the data:
Loan Amount: 120,000.00
Monthly Installment: 11,173.65
Contractual Rate (Monthly) : 1.75%
No. of Monthly Installments: 12
OTHER CHARGES:
Regular Expenses : 2.92% = 3500.00 (charge)
life insurance : 0.46% = 550.00 (charge)
Installment | Gross | | |Other |
Period | Loan | Principal |Interest |Charges |
120,000.00 |
0 |13,410.00 |
1 | | 9,073.65 |2,100.00 | |
2 | | 9,232.44 |1,941.21 | |
3 | | 9,394.01 |1,779.64 | |
4 | | 9,558.40 |1,615.25 | |
5 | | 9,725.68 |1,447.98 | |
6 | | 9,895.88 |1,277.78 | |
7 | | 10,069.05 |1,104.60 | |
8 | | 10,245.26 |928.39 | |
9 | | 10,424.55 |749.10 | |
10 | | 10,606.98 |566.67 | |
11 | | 10,792.61 |381.05 | |
12 | | 10,981.48 |192.18 | |
Total | 120,000.00|14,083.83|13,410.00 |
continue:
| Cash Flows|| O/S |
| || Balance |
| ||120,000.00 |
| 106,590.00||120,000.00 |
| -11,173.65||110,926.35 |
| -11,173.65||101,693.91 |
| -11,173.65||92,299.90 |
| -11,173.65||82,741.49 |
| -11,173.65||73,015.81 |
| -11,173.65||63,119.94 |
| -11,173.65||53,050.88 |
| -11,173.65|| 42,805.62 |
| -11,173.65|| 32,381.07 |
| -11,173.65|| 21,774.08 |
| -11,173.65|| 10,981.48 |
| -11,173.65||0.00 |
FROM THE TABLE ABOVE I NEED TO GET THE IRR COMPUTATION.IF I WILL COMPUTATE THIS IN EXCEL FORMAT THE IRR(Internal Rate of Return)IS 3.72%.
BUT MY PROBLEM IS HOW CAN I COMPUTE IRR USING MY VB6 PROGRAMMING, THE IRR RESULT MUST BE 3.72% FOR 12 MONTHS. IM TRYING TO MAKE A CODE, THE RESULT IS NOT THE SAME WITH 3.72%
HERE IS THE CODE LOOK LIKE:
txtIRR.Text = ((((mcurApprovedAmount + txtUMTotInterest) / txtProCEEds)) ^ (1.347 / txtCompoundingPeriods) - 1) * 100
CAN U GIVE ME THE CORRECT COMPUTATION OF IRR USING VB6 PROGRAMMIN LANGUAGE?
THANKS A LOT FOR THE HELP...
|
|
IRR COMPUTATION
