Project based on financial analysis-create a spreadsheet

Reference no: EM13313060

Perform a financial analysis for a project using the format provided in Figure 2-5. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $100,000 in Year 1 and $25,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $80,000 each year in Years 2, 3, and 4. Use an 8 percent discount rate. Create a spreadsheet (or use the business case financials template provided on the companion Web site) to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, explain whether you would recommend investing in this project based on your financial analysis

Reference no: EM13313060

Questions Cloud

Describe how health promotion-health prevention intervention : Describe how health promotion and health prevention interventions can be incorporated into parent and child teaching. Including in-text citations and references for each scholarly sources used.

Calculate the tension in the horizontal cable : A mass M=171 kg is suspended from the end of a uniform boom. The boom (mass=69.0 kg, length=3.60 m) is at an angle %u03B8=69.0 deg from the vertical, Calculate the tension in the horizontal cable

Determine the detention time in hours for the chemostat : Perform a material balance on substrate (S) around a chemostat (completely mixed reactor without recycle) assuming a first-order removal for a substrate with a rate constant of 0.5 hr-1.

Find the maximum current in the inductor : At the instant the current in the inductor is maximal, how much charge is on the capacitor plates, Find the maximum current in the inductor

Project based on financial analysis-create a spreadsheet : Perform a financial analysis for a project using the format provided in Figure 2-5. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $100,000 in Year 1 and $25,000 each year in Years ..

Determine unstretched length of each rod neglect the weight : The spring loaded supporting rods AB and AC in the figure below aer used as shock absorbers for transporting fragile loads. Knowing that the elastic spring constants for the rods AB and AC are kab = 1.2 kN/m and kac = 1.5 k N/m

Demonstrate why a database was required in the first place : A narrative description of the field chosen for the application being created. This should also include a description of the problem and addressing the weaknesses to be solved by the database.

How far down river does it land : A boat with speed of 10m/s, in still water, tries to cross a river with a current flow of 2.0m/s, and is 100m wide. how far down river does it land

Determine how much would expect to win from the game : You and your friend go into sports bar where a dart throwing competition is going on.you buy m darts at 1 dollar each.you throw these m darts at the board.Of these, N darts hit within the inner circle.

User Account

All Pages