Calculate net present value of costs for each year

Assignment Help Business Economics
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. 

Reference no: EM131085851

Questions Cloud

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.

Reviews

Write a Review

 

Business Economics Questions & Answers

  Bureaucratic organizational structure

The bureaucratic form of government is so prevalent in public agencies and tends to result in a slower paced, less consumer oriented management

  Consider two labor markets-wages in labor market

Consider two labor markets, A and B. Wages in labor market A rise. This could be due to

  What is sub game-perfect equilibrium for five-period game

Glassworks and Clearsmooth compete in the local market for windshield repairs. The market size (total available profits) is $10 million per year. Suppose the two windshield-repair firms know they will compete for just one year. Write down the payoff ..

  Suppose a competitive market consists of identical firms

Suppose a competitive market consists of identical firms with a constant longrun marginal cost of $10. (There are no fixed costs in the long run.) Suppose the demand curve at any price, P, is given by Q = 1000 ? P.

  Compose the index of leading economic indicators

Economists forecast future economic conditions by studying variables that tend to fluctuate in advance of the overall economy. The most significant of these variables are known as leading indicators, and they compose the index of leading economic ind..

  Hypothetical demand and supply curve for cyber cafes

Draw a hypothetical demand and supply curve for cyber cafes - coffee houses with computers hooked up to the Internet with access to daily newspapers (among other things) at each table. Show how demand or supply is affected by the following:

  Monopolist''s marginal income can be upward-sloping

Give a numerical example to Explain how which a monopolist's marginal income can be upward-sloping over part of its range.

  Using the midpoint rule-cross price elasticity of demand

When the price of good A is $20, the quantity of good B purchased is 400. When the price of good A is $40, the quantity of good B purchased is 750. Using the midpoint rule, the cross price elasticity of demand between goods A and B is

  Find all the nash equilibrium in pure strategies

Bruce, Colleen, and David are all getting together at Bruce’s house on Friday evening to play their favorite game, Monopoly. They all love to eat sushi while they play. They all know from previous experience that two orders of sushi are just the righ..

  Ethics in practice case

Should those who labeled the product pink slime and questioned it unfairly be disciplined in any way? Or, is this just an example of the market at work and nothing should be done? What should Roth and his company do now? What further action should th..

  Q1 you are a monopolist suppose there are two types of

q.1. you are a monopolist. suppose there are two types of people who buy your product groups 1 and 2. their separate

  Discuss what measuring inequality involves

Briefly discuss what measuring inequality involves, and provide two examples for doing so. measuring income inequality means dividing up the population into various groups and then comparing the groups.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd