Deliverables:
1. Excel spreadsheet analysis, with an NPV Profile graph, and NPV Scenario / Risk Analysis Grids (see template). The NPV Scenario / Risk Analysis Grids will present 25 different NPV values associated with changing values of the cost of capital, cost of goods sold percentage (CoGS %), and sales. Use the Excel template provided for this assignment for completing the Excel analysis. At a minimum, your Excel spreadsheet analysis should include:
a. the date of your analysis;
b. your NPV Profile,
c. use of Excel’s NPV and IRR functions.
2. Word document professional report that provides an overview of capital budget and your specific capital budgeting analysis, including items noted below. Your Word report should be of the quality that you would be proud to submit to your Board of Directors or investors (or other clients) regarding your firm’s capital budgeting processes and your capital budgeting analysis of this particular project. Your materials should NOT refer to “the assignment” but rather it should address the case as though it is your firm’s project. Similarly, your reports (Word & PPT) should have a table of contents (Word) and agenda (PPT) for all the appropriate sections, and should NOT address the items below in an “A, B, C… “ format, but rather you should integrate the items into your report and your sections as appropriate.:
2A. At a minimum, your Word report and PPT presentation should include: the names of all team members who contributed to the work, the date of your analysis; a table of contents (PPT agenda); an overview and summary of the general capital budgeting process and how it is implemented within organizations; how CFs are modeled along with the complete CF Model for the project; the key capital budgeting decision tools, how they are computed, their pros & cons, and how they are used to make a decision regarding projects; an NPV Profile and discussion of the NPV profile.
In addition to the thorough overview of the capital budgeting process, tools, technique, and key terms in general, your Word report and PPT should provide specific information regarding the case analysis, such as input data/assumptions, cash flow modeling (tables to illustrate), analysis & decision tools applications and results (tables of results), NPV Profile and discussion, etc.
2B. A glossary of capital budgeting concepts and terms (alphabetical) with definitions and comments regarding the implications of the concepts. Provide this in an appendix (at the end), and refer to it within your review of capital budgeting key concepts, processes, and applications. These definitions MUST BE WRITTEN IN YOUR OWN WORDS and CANNOT BE COPIED DIRECTLY FROM ANY SOURCE. You should provide a meaningful definition, as well as some discussion/comments regarding the use and application of the concept.
At a minimum, the key concepts and terms should include:
1. ATSV,
2. Cash flow analysis (time zero initial investment cash flows, operating life cash flows, terminal period end of project cash flows),
3. cash flow timeline,
4. conventional cash flow stream, non-conventional cash flow stream,
5. discount rate & cost of capital concept (and implications to valuation)
6. independent projects,
7. IRR - multiple IRRs,
8. IRR,
9. mutually exclusive projects,
10. NPV = 0 meaning and implications,
11. NPV Profile,
12. NPV,
13. opportunity cost,
14. Payback Period,
15. profitability index,
16. ranking conflict of NPV vs. IRR,
17. sunk cost,
2C. REMINDER: As noted in 2A, thoroughly address your capital budgeting analysis, including tables and graphs illustrating the analysis and the results of the analysis.
2D. Based on your NPV Scenario / Risk Analysis Grids, is NPV more sensitive to changing cost of capital or changing Cost of Goods Sold (CoGS) percentages? How do you determine this? Discussions of items 2D & 2E can be relatively brief.
2E. Based on your NPV Scenario / Risk Analysis Grids, is NPV more sensitive to changing cost of capital or changing year one sales level assumptions? How do you determine this?
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
