Assignment due:4/27 by 11:59pm EST. You're to create your own Cash Flow Estimator in Excel. This must do all of the following: Linked cells - as you update data, cells should auto calculate based on...

Assignment due:4/27 by 11:59pm EST.

You're to createyour ownCash Flow Estimator in Excel. This must doall of the following:

1. Linked cells - as you update data, cells should auto calculate based on what you're putting in


2. WACC calculator (create a simple calculator that will calculate WACC). - Use this for your interest rate in for other calculations (again link cells).


3. Cash flow to go out to 5 years (for extra credit - make your sheet project cash flows per quarter for 5 years)


4. Need to show Revenue all the way down to Operating Cash Flow (meaning you have costs - fixed and variable - and taxes) - no need to do depreciation or amortization.


5. Need to have a section (or tab) for unit costs (break a single unit down into it's costs - materials, labor, R&D, marketing, etc.)


6. Need a section for project / cash flow analysis that must contain (automatically calculated)
   
   
   1. Net Present Value
   
   
   2. Internal Rate of Return
   
   
   3. Payback period (in months)
   
   
   
   

Multiple exercises exists in this project. First, Excel is a very powerful tool - this entire request can be done with very simple formulas and formulas that are already programmed in Excel. Second, it will serve you as something you can take from this class and use if you're ever asked to present something like this for your business. Lastly, this exercise will display how all of these concepts fit together.


***Work must be your own and original*** - DO NOT DOWNLOAD something someone else created and turn it in. I'm very interested to see everyone's approach to this. Maybe in the end, we will posts everyones to share and all can have access to the one they like most.


There is a portion of this that is extra credit. That extra credit will be worth 50 points to your grade at the end of class. Instead of doing annual cash flows, you will break them down into quarters for extra credit.


Lastly, remember, you can scale this concept down weeks, months, quarters, or years depending on your project. The concepts of estimating, figuring and calculating cash flows and analysis remains the same. This is an extremely important concept to understand as you move into your business career at any capacity.



Must submit in Excel format. If you use other database programs, you must convert it to MS Excel.