Reference no: EM131085851
1) As a systems analyst, you are preparing a new information system project proposal for management that require you to create a costs-benefits analysis prior to project presentation. Assume that the project is expected to return monetary benefits of $55,000 per year, one-time costs of $75,000, and recurring costs of $15,000 per year. The project has a discount rate of 8% and a five-year time horizon.
a) Create a costs-benefits analysis spreadsheet.
b) Calculate net present value (NPV) of benefits for each year.
c) Calculate net present value (NPV) of costs for each year.
d) Calculate overall net present value (NPV) at the end of project life.
e) Calculate overall return on investment (ROI) at the end of project life.
f) Perform break-even analysis (BEA) for the project.
g) Calculate break-even point for this project.
2) You are also proposing a second project with variable costs and returns. Assume that the project is expected to return monetary benefits of $50,000 the first year, and increasing benefits of $10,000 until the end of project life (year 1 = $50,000, year 2 = $60,000, year 3 = $70,000, year 4 = $80,000, year 5 = $90,000). The project also has one-time costs of $35,000, and variable recurring costs of (year 1 = $25,000, year 2 = $30,000, year 3 = $35,000, year 4 = $40,000, year 5 = $45,000) until the end of project life. The project has a discount rate of 10% and a five-year time horizon.
a) Create a costs-benefits analysis spreadsheet.
b) Calculate net present value (NPV) of benefits for each year.
c) Calculate net present value (NPV) of costs for each year.
d) Calculate overall net present value (NPV) at the end of project life.
e) Calculate overall return on investment (ROI) at the end of project life.
f) Perform break-even analysis (BEA) for the project.
g) Calculate break-even point for this project.
|
Policy on equilibrium output in the goods market
: Consider a situation where, pressured by a conservative Congress to balance the budget, the government reduces public expenditure with no change in taxes. What would be the effects of this policy (the decrease in government spending) on equilibrium o..
|
|
Analyze the issue regarding going digital
: John is a manager in the Gardening department at ABC Hardware. Last week the general manager was fired for incompetence. The chief executive officer appointed John to be the new general manager. Provide a written analysis of how John should tackle th..
|
|
Analyze and solve the case and predict question
: I am sending the case, please use ITIL version 3 to analyze and solve the case and predict question and answers just wanted to make it clear that these four chapters should be used to predict questions from the case that i have sent you
|
|
Mandated overtime premium will result in scale effect
: An increase in the mandated overtime premium will result in a scale effect that:
|
|
Calculate net present value of costs for each year
: As a systems analyst, you are preparing a new information system project proposal for management that require you to create a costs-benefits analysis prior to project presentation. Create a costs-benefits analysis spreadsheet. Calculate net present v..
|
|
What is the electric field strength between the plates
: What is the electric field strength between the plates?
|
|
Which one of the following statements is true
: The difference between the gravitational force and air resistance is responsible for the downward velocity.
|
|
What type of relationship
: Do some research and find the inflation rate and the level of unemployment in the U.S. economy for the past 40 years. Is there a relationship between the two? If so, what type of relationship?
|
|
Research and discuss the benefits of using classes
: Research and discuss the benefits of using classes. Drawing from your research, sketch out a sample hierarchy of classes that could be used and what functions or properties would they include.
|