Exercise: Please develop an Excel-based calendar-year cash flow projection for a New Venture Fund project, "Innovation Project". Show revenue, expenses and cash balance by month. The project is planning on launching a grantmaking program in July. Please assess how much in funding they would likely have available for that program and draft a brief email to them

Exercise: Please develop an Excel-based calendar-year cash flow projection for a New Venture Fund project, "Innovation Project". Show revenue, expenses and cash balance by month. The project is planning on launching a grantmaking program in July. Please assess how much in funding they would likely have available for that program and draft a brief email to them. Assumptions: Innovation Project is expecting revenue from the following sources: Ideas Foundation - $100,000 received in January New Projects Foundation - $50,000 expected in March Great Thoughts Foundation - $150,000 grant expected in July for a two-year grant period, with 50% received this year, and the balance received after one-year. Corporate Foundation - $100,000 received in February Ideas Foundation expected to renew $100,000 grant in January of next year. Innovation Project has two employees, Employee A and Employee B. All salary costs total $125,000 annually. Benefits are 20% of salaries, but expected to rise by 25% at the beginning of Q2. Innovation Project has developed the following contracts with vendors and contractors: Vendor A: $2,000/month from January 1 - April 30 Vendor B: $180/month service fee for website maintenance Contractor A: $3000/month, compensation cap of $36,000 Contractor B: $12,000 contract, payable in four equal installments over calendar-year. First payment is paid up-front. Innovation Project projects that employee expenses related to travel will cost approximately $500 per month Innovation Project is a new project that began with no cash on January 1st