Don

]]>Could you please share the VBA password?

Thank you

]]>Don ]]>

Very useful post. Is there anyway I can have the VBA password for it?? Regards, Sanjeev ]]>

Thank You ]]>

I am sending you an amortization schedule.

I’m not sure what you mean by “rolling forward”, but it depends on which prepayment method you are using.

The attached has an option for CPR or PSA prepayment models.

For CPR, all you need for a fixed rate loan going forward is the current balance. All the other inputs stay the same and it does not matter how old the loan is. CPR is a constant rate.

For PSA however, you need original payments and the age of the loan. That is because PSA ramps up .2% CPR each month until it gets to 6%, then stays a 6% CPR.

Look at the attached to see if that helps. ]]>

The securities make sense because they don’t grow but I’m stuck on how to apply this to a live loan portfolio.

Any guidance helps!

John

]]>I found what I sent Jess. I will email it to you

Don

]]>I would also be interested in the excel workbook you sent Jess back in July if you wouldn’t mind sharing – I have been trying for weeks to solve the puzzle on how to neatly track RMDs for all clients and so far it isn’t any neater 🙁

Amanda

]]>It is a little hectic around the holiday, but give me a few days and I will come up with something for you.

Don ]]>

Thank you very much for your spreadsheets online.

Perhaps you could help me wit a small change on your sheet: AmortzationChangeRate.xlsx.

My situation:

We are 2 persons about to buy property. We will be paying money into a joint account for the mortgage. We plan to make extra paymens when we have the money to do so.

The mortgage will be a variable rate over 40 years, and according to the advisor, the payments will always stay the same, but the term (years) will decrease when we make extra payments.

I need to make it fair for both of us, so the whoever pays more into his own share, the more interest would be saved on his account.

1) Is it possible to change the sheet to choose if you want to reduce the (a) Term, or (b) The monthly amount.

2) Is it possible to have more rows for the interest rate, as it might change quite a lot over 40 years.

3) Is it possible to have a tab to show “Years saved off original loan term”?

I saw another calculator which also would have worked IF it was possible to select different interest rates. See mortgagecalculator.org

Thank you for any help!

]]>Thank you for your comment. The RMD program is only set up to calculate your RMD at various stages after 70 1/2. The only way to use it before you are 70 1/2 is to estimate the size of your 401k/IRA when you become 70 1/2 and change your birthday to the date you will become 70 1/2. If it is helpful, I have another excel file online that has a future value calculator.

http://pistulka.com/Other/?p=2132

From the contents sheet, column A, number 11 is a link to the future value calculator. Enter the present value of your IRA, along with current and future dates to calculate the value of the IRA when you are 70 1/2.

Good Luck

Don

Also, ISTM that the spreadsheet setup assumes the user is already 70 and will need to calculate RMD beginning right away. Maybe I didn’t work it right, but when I entered into the yellow cells, the table gave me no results at all. Only when I lied to it and entered a birth-date in 1948 (rather the the true 1955) did it fill in the table. Is there a way to let it calculate balances accumulating before RMD kicks in?

That said, this is a LOT more useful than the Schwab or Vanguard online calculators I have been using! Great work, and thank you!

]]>Sure. Send the example to blog@pistulka.com.

Don

]]>