個案總覽

Annie Anthony, the chief financial officer of Liz Motor Corp. (Liz), was attempting to use capital budgeting to evaluate an environmental, social, and governance (ESG) project using all the available quantitative and qualitative information. Anthony had planned an ESG project, which would help the company adopt solid-state battery technology for most Liz electric vehicles and reduce the carbon footprint of electric vehicle batteries by 39 per cent, to improve the company’s ESG and sustainability. The technology was so new that Liz would be the first major automaker to use it on a large scale. It would increase sales and the profit margin in the long run but would also require a heavy initial investment to allow Liz to adopt the technology. With all the information needed for a thorough capital budgeting analysis, Anthony believed she was ready to develop a framework to comprehensively evaluate this critical project. She also needed to do ten sensitivity analyses based on ten different scenarios.

Student Spreadsheet to accompany product W32397.

Instructor Spreadsheet to accompany product #W32398.

Annie Anthony, the chief financial officer of Liz Motor Corp. (Liz), was attempting to use capital budgeting to evaluate an environmental, social, and governance (ESG) project using all the available quantitative and qualitative information. Anthony had planned an ESG project, which would help the company adopt solid-state battery technology for most Liz electric vehicles and reduce the carbon footprint of electric vehicle batteries by 39 per cent, to improve the company's ESG and sustainability. The technology was so new that Liz would be the first major automaker to use it on a large scale. It would increase sales and the profit margin in the long run but would also require a heavy initial investment to allow Liz to adopt the technology. With all the information needed for a thorough capital budgeting analysis, Anthony believed she was ready to develop a framework to comprehensively evaluate this critical project. She also needed to do ten sensitivity analyses based on ten different scenarios.

Spreadsheet Supplement for Case W32397