{"id":24193,"date":"2024-05-04T05:19:27","date_gmt":"2024-05-04T05:19:27","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/outline-8-to-10-page-business-report-financial-analysis-in-excel-1-page-executive-summary\/"},"modified":"2024-05-04T05:19:27","modified_gmt":"2024-05-04T05:19:27","slug":"outline-8-to-10-page-business-report-financial-analysis-in-excel-1-page-executive-summary","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/outline-8-to-10-page-business-report-financial-analysis-in-excel-1-page-executive-summary\/","title":{"rendered":"Outline + 8- to 10-page Business Report + Financial Analysis in Excel + 1 Page Executive Summary"},"content":{"rendered":"

This Assessment requires submission of one 8- to 10-page report (excluding title page and references) as well as an accompanying Excel file for the financial performance analysis. <\/span><\/p>\n


<\/span><\/span><\/div>\n
SCENARIO<\/u><\/b>: <\/span><\/span><\/div>\n

<\/span><\/span><\/div>\n
You have been hired by a midsize copper smelting company in northern Canada to act as a consultant to help the executive team to determine its best course of action on a major decision. Due to some recent changes to the local environmental air quality laws, the company\u2019s large coal-fueled smelting furnace is now operating out of compliance due to high levels of pollutants in the exhaust gases. The regulatory agency has given the company 12 months to demonstrate compliance, after which it will be fined a $1,000 per day until the operations meets the regulation. The company has two alternatives. The first alternative is to install air-scrubbers to reduce the output pollutant levels. The second alternative is to convert the smelting furnace from coal to natural gas. Both alternatives will meet the current regulatory requirements, but there is a slight concern that the air-scrubber solution may not meet future regulatory restrictions. The executive team wants you to perform a financial performance analysis on both alternatives using several different capital budgeting methodologies. The team also is seeking guidance on non-financial considerations regarding the company\u2019s ethical and social responsibilities related to this decision.<\/span><\/span><\/div>\n

<\/span><\/span>The product of your financial performance analysis will be a report for the executive team. <\/span><\/span><\/div>\n

<\/span><\/span><\/div>\n
Instructions\/Prompts: <\/font><\/div>\n

<\/font><\/div>\n
A. PART ONE: The Financial Performance Analysis (1-2 pages, plus Excel template).<\/u><\/font><\/div>\n

<\/font><\/div>\n
\n

For the first part of your report, you will provide an analysis of the financial performance of both alternatives using net present value (NPV), accounting rate of return (ARR), internal rate of return (IRR), and payback. (Note:<\/strong> <\/span>ARR is also called Return on Investment, or ROI.) Your SME will provide you with the following financial information to use for this part of the Assessment, which will include the numerical values to replace the variables (i.e., \u201cX\u201d):<\/p>\n

\n\n\n\n\n\n\n\n\n\n
\n

 <\/p>\n<\/td>\n

\n

Air Scrubbers<\/strong><\/p>\n<\/td>\n

\n

Furnace Fuel Change<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Required Investment<\/p>\n<\/td>\n

\n

$X<\/p>\n<\/td>\n

\n

$X<\/p>\n<\/td>\n<\/tr>\n

\n

Annual Cash Flows<\/p>\n<\/td>\n

\n

X<\/p>\n<\/td>\n

\n

X<\/p>\n<\/td>\n<\/tr>\n

\n

Annual Net Income<\/p>\n<\/td>\n

\n

X<\/p>\n<\/td>\n

\n

X<\/p>\n<\/td>\n<\/tr>\n

\n

Project Life<\/p>\n<\/td>\n

\n

15 years<\/p>\n<\/td>\n

\n

15 years<\/p>\n<\/td>\n<\/tr>\n

\n

Average Book Value<\/p>\n<\/td>\n

\n

X<\/p>\n<\/td>\n

\n

X<\/p>\n<\/td>\n<\/tr>\n

\n

Cost of Capital<\/p>\n<\/td>\n

\n

X%<\/p>\n<\/td>\n

\n

X%<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To complete this part, address the following:<\/p>\n