=100000*0.05/(12*(1-(1+(0.05/12))^-48))=2,302.93

]]>How did you get payment $2302?

I’ve got 41666 by this calc 100000*5/(12*(1-pow((1+(5/12)),-48)))

]]>how did you get payment $2302?

is there anything wrong in my calculations 100000*5/(12*(1-pow((1+(5/12)),-48)))?

I get 41667 everytime

How did you get payment $2302?

this 100000*5/(12*(1-pow((1+(5/12)),-48))) gives me 41666.66895195165 not 2302

]]>If you use the search option on my site (use abbreviation’s and spell out the words) various posts will show. At the bottom of each post is a link to the accompanying excel workbook.

]]>NB: This is not a comment for publishing. I can write a separate recommendation that you can publish. I would truly appreciate your help!

]]>I am really enjoying your mortgage modeling. Would it be possible to see how the VBA calcs work with the password?

]]>Don ]]>

As I stated in my post, I have never used a modified internal rate of return calculation during my career, so I have no experience using it. My assumption was that if the present and future value formulas are adjusted for periodic payments and a variable base year, the MIRR could be adjusted for both. I would use “Annually” in cell I4 on the XIRR sheet. I do not see any reason those numbers would not work for you.

Don

]]>