I added another calculator to the Taxes spreadsheet. The sheet is call “Withdrawals”. It is a simple calculator, but someone might find it helpful. I was asked by a friend (over 59 years old) how much he would need to withdraw from his IRA to pay for his monthly rent, net of taxes. So I decided to make a calculator.

The formula is simple,

Withdrawal = Amount Required/(1-Effective Marginal Rate)

but you do need to have your marginal tax brackets. This is usually a guess for the current year compared to last year, because there may be changes in your income and deductions or changes in the tax code. You need to know if nondeductible contributions were made to the account, and how much. Also, if there were nondeductible contributions, you need to know the market value of the account at the end of the previous year.

It is also important to know that if you don’t itemize on your tax return, you won’t get the benefit of deducting state and local taxes from federal taxes, which could increase the amount of taxes you will pay.

As usual in my spreadsheets, the light yellow cells are the only input cells. The rest should be self-explanatory:

Download __Taxes__

FredNeat spreadsheets. How about one to help figure out the net yield on a loan portfolio to determine if a portfolio segment is meeting management’s income goals.

Thanks again for the cool spreadsheets.

Don PistulkaPost authorThanks Fred,

This sounds like an accounting problem. If you have all of the portfolio’s actual cash flows received (principal and interest) for a given month, you could simple divide that amount, by the beginning principal balance each month. Then you would annualize that monthly return and compare it with expectations.The monthly returns could also be linked together for a time weighted rate of return.

Don

Don PistulkaPost authorFred,

Take a look at my post on time and dollar weighted rates of return.Time & Dollar Weighted Rates of Return Calculator

Don

Time & Dollar Weighted Rates of Return Calculator