Details: Project Data Students.xlsx

Hi there, can anyone please help to solve this problem in the "spreadsheet / Excel" by showing how to do it step by step. It would be very helpful for me. Thanks!

Scenario It is 31 December 2017. Your team of two people form a financial analysis team at City Credit Finance (CCF), a renowned financial institution. Your team has been asked by the executive management team of CCF to carry out a special project for its client Global Energy Limited (GEL), culminating in preparing a business report. This report will be presented to CCF executive management and also to the senior management of GEL GEL is an energy provider. GEL is considering a replacement/ upgrade of a critical part of its existing machinery and has engaged CCF to evaluate this replacement/upgrade project. GEL has already undertaken some initial exploratory study, investigating several options. This study has cost S5,000. GEL is currently utilizing Machine A. When Machine A was purchased and installed, it was considered that Machine A would have a useful life of 5 years. However today, two years after the initial purchase, GEL's electrical engineers have determined that there are significant problems with the use of Machine A, and have established that there are only two alternatives: 1) Recondition Machine A. Taking this option will provide a life of a further4 years for Machine A. At the end of this 4 years, Machine A would be replaced by Machine B Immediately replace Machine A with Machine B. Machine B has a useful life of 3 years. For both the options, at the end of the three years' service from Machine B, it will be replaced by a similar machine, with the same 3 years expected useful life. Further details regarding these two options are provided immediately below. Scenario It is 31 December 2017. Your team of two people form a financial analysis team at City Credit Finance (CCF), a renowned financial institution. Your team has been asked by the executive management team of CCF to carry out a special project for its client Global Energy Limited (GEL), culminating in preparing a business report. This report will be presented to CCF executive management and also to the senior management of GEL GEL is an energy provider. GEL is considering a replacement/ upgrade of a critical part of its existing machinery and has engaged CCF to evaluate this replacement/upgrade project. GEL has already undertaken some initial exploratory study, investigating several options. This study has cost S5,000. GEL is currently utilizing Machine A. When Machine A was purchased and installed, it was considered that Machine A would have a useful life of 5 years. However today, two years after the initial purchase, GEL's electrical engineers have determined that there are significant problems with the use of Machine A, and have established that there are only two alternatives: 1) Recondition Machine A. Taking this option will provide a life of a further4 years for Machine A. At the end of this 4 years, Machine A would be replaced by Machine B Immediately replace Machine A with Machine B. Machine B has a useful life of 3 years. For both the options, at the end of the three years' service from Machine B, it will be replaced by a similar machine, with the same 3 years expected useful life. Further details regarding these two options are provided immediately below