You have a great product idea, but is it an excellent investment? Use this spreadsheet to find out.
Understanding the ROI of your product development project is just as important, if not more so than understanding the technology or market. Without a positive ROI, the product may be successful, but the business will fail.
Product development is an investment. You are going to spend money today, and hope to receive a series of payments in the future. If the sum of all the payments is higher than the initial investment, then the investment has a positive ROI. Since the payments will be received in the future, we must take into account the time value of money or the cost of capital.
If all this sounds a little complicated, rest easy, we have done all the hard work for you. Using this spreadsheet, you need to fill in the information you already know – project cost, sales price, sales volume, etc. The spreadsheet then calculates all the key metrics – making you look like a real pro.
Here are some tips for when completing the template: