dayna
Starting Member
14 Posts |
Posted - 2012-12-09 : 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: 12OTHER 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... |
|