NPV & IRR Assignment | Homework For You
Your Excel should the following attributes:-Sales, Revenues, Costs (both recurring and non- recurring, fixed and variable), Earnings before Interest and Taxes (EBIT), Interest Taxes, and Net Cash vs time, and the resulting Net Present Value (NPV) and Internal Rate of Return (IRR) of the Project. Your Presentation should clearly explain the following terms along with the respective formulas to be followed by demonstration on the excel spreadsheet.
1. NPV – Net Present Value
2. IRR – Internal Rate of Return
3. Relation Between NPV & IRR
4. MARR – Minimum Acceptable rate of return
The model needs to have the elements of the cash flow calculation vertically in the first column and the entries in the rows versus time with a total column on the right for each of the elements. These elements include sales, revenue, cost of goods sold, EBIT, interest earnings or cost, taxes, cash (earnings after interest and taxes), and cum cash all displayed versus time. Below this should be an entry for the cost of capital and the tax rate, the calculated Net Present Value, IRR, and ROI.
You should also be able to display a plot of cash and cum cash versus time to identify the breakeven point. You should have one version of the tool for time in years and one for time in months. When the time in months version is used the user should be able to enter an annual cost of capital and the tool should calculate the monthly equivalent compounded cost of capital that goes with the specified annual cost of capital The Team will then use this tool to develop and create a cash flow analysis of simple projects like the one provided in the example problem. Get Finance homework help today