Complete each problem in excel. Submit your excel worksheet in EXCEL format so I can see how you solved the problems. Please MARK or Outline your answers so I can tell where they are. Create a CASH Flow chart and answer the following questions. The equipment will cost $620,000 and lasts the entire 11 year project. At the end of 11 years, the equipment will be sold for $91,000 in salvage. Operating costs start at $108000 and go up by 3.9% every tear. Benefits begin at $190000 and go up by 6.1% every year. The MARR value is 14% Use a MARR of 14% BUILD the CASH FLOW chart for this project. 3a. Determine the NPW 3b. Determine the AW 3c. Determine the FW
Complete each problem in excel. Submit your excel worksheet in EXCEL format so I can see how you solved the problems. Please MARK or Outline your answers so I can tell where they are.
Create a CASH Flow chart and answer the following questions.
The equipment will cost $620,000 and lasts the entire 11 year project.
At the end of 11 years, the equipment will be sold for $91,000 in salvage.
Operating costs start at $108000 and go up by 3.9% every tear.
Benefits begin at $190000 and go up by 6.1% every year.
The MARR value is 14%
Use a MARR of 14% BUILD the CASH FLOW chart for this project.
3a. Determine the NPW
3b. Determine the AW
3c. Determine the FW
3d. Determine the
3e. Graph the NPW versus MARR
3f. Are we making or losing money at 14% MARR?
How can you tell?
Step by step
Solved in 5 steps with 3 images
