Financial Plan

Contract duration: 2-3-5 years with resp. 2 year payment-annual payment or per month Extension: always the same term Churnrate: 5% what if this becomes 10-25% Commercial persons: new customers between 50 and 100 per year (average of 2 users). What if they only find 20 new offices? What if they find 300,400,500 new users, ie 150,200,250 new offices number of commercial people: 1 - 2 - 3 - 4 what if we work with 1 commercial person? What if with 2? 3? max 4? First line support: 1 person per 300 users Start-up costs and data migration € 250 per office = half a day of work Cost of Commercial person € 75,000 per year Cost of First line Support € 50,000 per year Cost of Programmer € 70,000 per year (required 2) Rent building / workplace € 400 per month per employee Fixed (variable?) Costs per 1000 users € 2000 per month for server hosting Costs accounting and administration € 1000 per month Initial cost design and programming of application € 200,000 (one-off) Initial cost APP for customer € 50,000 (one-off) with € 5,000 improvement / adjustments per year Unforeseen costs € 30,000 per year Corporate income tax 34%. What if tax falls to 20% or rises to 40% Discount rate 10% Expected return 13% (how much turnover do we need to achieve and when do we get this?) What about cash flow? Payback? NPV? Worst case and best case scenario ?