In the run up to our planned Kickstarter of Lovecraftesque, I’ve been busily crunching numbers to make sure that the whole thing will fly financially. All of our figures have gone into a spreadsheet, where I can easily update the costs as I get better information, and tweak the prices of the rewards to reflect those costs. In turn the spreadsheet works out how much we need to ask for.
Anyway, having gone to the effort of creating it, it seemed like other people might find it useful. If you give it basic information about your crowdfunding campaign (like reward levels, costs and so on), it will work out your reward levels for you.
I’ve included instructions on how to use it (at the top and in comments on the relevant cells). In brief: fill in the yellow bits and then read off the information in the green bits.