Financial Forecasts using Excel

Financial Sheet in Excel Make the following sheets from the one excel file I have. In the excel file I have I have not devided into assumptions cost and revenue and I have not made the assumptions explicit. Also in the excel file I have some of the function are not correct. Sheet 1: Assumptions Divided into assumption about: • Cost • Website usage • Revenue State all the formulas and assumed values here for cost and for revenue Show in website usage how marketing leads to visitors and that leads to test takers and that leads to registrants. Sheet 2: Website Usage Website Usage over the first 3 years Detailed analysis how we get the visitors and how that leads to users Sheet 4: Costs for the first year Detailed analysis of the whole cost Sheet 5: Revenue for the first year Detailed analysis of the whole revenue Sheet 6: Profit & Loss Statement for the first year Only mention the major cost and revenue heading and compare them Sheet 7: Graphics 1. Bar graph of cost over the first year 2. Bar graph of revenue over the first year 3. line graph profit & loss Sheet 8: Costs for the first year Detailed analysis of the whole cost Sheet 9: Revenue for the first year Detailed analysis of the whole revenue Sheet 10: Profit & Loss Statement for the first year Only mention the major cost and revenue heading and compare them Sheet 11: Graphics 4. Bar graph of cost over the first year 5. Bar graph of revenue over the first year 6. line graph profit & loss Sheet 12: Costs for the first year Detailed analysis of the whole cost Sheet 13: Revenue for the first year Detailed analysis of the whole revenue Sheet 14: Profit & Loss Statement for the first year Only mention the major cost and revenue heading and compare them Sheet 15: Graphics 7. Bar graph of cost over the first year 8. Bar graph of revenue over the first year 9. line graph profit & loss The assumptions are a bit complicated sometimes as they included formulas for function that increase at a decreasing rate (economies of scale) and if then function. Some od the cost assumptions are listed here: Costs Website Programming • 15,000 minimum costs • Goes up slightly as we have more active users • Goes up slightly as revenue goes up • So that after 6 month it might be 20,000 • After 10 month it might be 22,000 • (user active users^(1/1,X) and revenue^(1/1,Y)) E-diagnostics • Constant at 2000 Design • Constant at 1500 Hosting • Goes up proportionately as active users go up and as test takers go up • 30,000 active users = 200,000 test takers per month = $600 in server costs • 1/1,000 * test takers + 2/100 * active users Server admin • As hosting goes up server admin cost go up but not as much • (user hosting costs^(1/1,X)) Community moderation • Related but proportional to the number of active users • Related but proportional to the number of new registrants • 10 cent per new registrant 6 cent per active user Content Creation • 3000 minimum • Goes up very slightly as programming goes up (1/1,x) • Goes up as kinds of newsletters go up: $1,000/kind of newsletter Marketing Email sending costs • The friend invitations * price • Email sending price 0.1 and 0.3 cent depending on volume • If volume under 500,000 – 0.3, if volume under 1,000,000 0.2 if volume above 0.1 Google AdWords • We spend 10,500 minimum • We spend a certain small percentage of our revenue in addition Facebook Social Ad • We spend 5000 minimum • We spend a certain small percentage of our revenue in addition SEO • We spend a certain fixed amount plus a small percentage of the revenue • The first month spending on SEO is a little bigger PR • 3500 plus a little percentage of revenue • But economies of scale thus less than proportional Sales VP of Sales • 7000 fixed • Plus a certain percentage not proportionally related to sales • So that after 18 month total earning about 9000 Account Manager • One account manager does two things: Sales and Client Support o Support: depends on how many clients we have  Company profile $ 10  One active company costs $200  One partner costs $350  One premium partner cost $450 o Sales: depends on active members but not proportionately  E.g 30,000 active members: 5000  60,000 active members 7,5000  100,000 active members 10,000  300,000 active member 25,000 Trade fairs • We spend fixed of $250 on trade fairs • The expense goes up slightly as our revenue goes up but not proportional Overhead Management & Admin • Is a certain fixed amount plus a portion related to • Website, Marketing and sales • Should more or less double over 18 months Office • 1000 fixed plus • Percentage but not proportional of sales • Percentage but not proportional of website expense Legal and Accounting • $200 plus percentage of number of active companies Equipment • Related to office Office Supply • Related to equipment