Here's the excel. The first tab is based on book value growth and the bank specific tabs are based on a couple of key variables (growth in loans, growth in pretax preprovision profits, charge offs, etc). This obviously over simplifies reality, but the idea is to get a sense of returns under various scenarios - you can play with the variables in blue.
The BofA A warrant does not have the strike price reduction feature from dividends, so it needs this adjustment.
There's also some historical info on charge offs and aggregate banking system financials that can help as background. Also some info on the experiences from the early '90s on a few banks (note Wells Fargo actually recorded zero provisions in '95).
Of interest, in the last 3 majors charge off cycles (mid seventies, early nineties, early 2000s) it took exactly 4 years to go from peak to trough. If we assume that the peak was in the 4Q/2009 (the tab called 2010 shows this for the big banks ex Citi), then we're in for a slow and steady process of charge off reductions. This is at odds with what Walls Street is projecting for some major banks (e.g. COF); this cycle might be longer, but it's hard to see how charge offs will simply stay where they are, which is what they assume.
Finally, I did not have time to update data from the 3Q, but this can be easily done in tab 2010.