Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need a excel to complete following the guide attached below. Thank you for your help. I need it get the reply before tomorrow night.
I need a excel to complete following the guide attached below. Thank you for your help. I need it get the reply before tomorrow night.
ACC340 External Financial Reporting Excel Assignment - Asset Impairment Excel is a powerful tool for financial modeling and analysis. Accordingly, it is vital for financial and accounting professionals to develop their skills with the software to enhance their efficiency and effectiveness. The objective of this assignment is to provide hands-on experience creating a financial model that will be used to perform an impairment test on an asset. For the purpose of this assignment, you are to assume that you work for Sustainability Energy Company and have been tasked with performing impairment tests on a number of the company's assets. One such asset is a 78 megawatt cogeneration power plant that is fueled by biomass. This particular plant generates high pressure steam used to generate electricity by burning the waste byproduct resulting from timber processing and paper manufacturing. Once high-pressure steam is used to generate electricity, the residual low-pressure steam is used by an adjacent paper mill to produce paper and heat its plant (the dual use of high and low pressure steam is referred to as cogeneration). Because of this relationship with the paper mill, the energy plant is able to purchase biomass fuel at lower than market rates. Due to declining energy rates and higher than expected curtailment (will be explained later), the plant's revenue has diminished and competitive forces in the energy market are expected to continue this trend. Accordingly, Sustainability Energy is concerned that the plant asset may be impaired. You have been tasked with creating a discounted cash flow model that can be used to determine if the asset is impaired and the sensitivity of the assumptions made too perform the test. The plant was permitted by the Federal Energy Regulatory Commission (FERC) to operate for 30 years. You are preparing the impairment test at the end of its eighteenth year of operation. The plant had an original cost of $320 million, $10 million of which was attributed to the land the plant is sited on. Depreciable assets ($310 million) are being depreciated for financial reporting purposes on a straightline basis over the plant's permitted life of 30 years with no residual value, and over 20 years for tax purposes. An asset retirement obligation was capitalized and has a current estimated value of $14 million. The plant's assets are evaluated together (including land) for the purposes of impairment testing and have a combined book value $140 million. Additional information about the plant will be provided in the instructions that follow. To get started with the impairment analysis, open a new Excel workbook and save it with the following name (\"YOUR LAST NAME - Sustainability Energy Asset Impairment Test \"). My project file name would be \"HUSTON - Sustainability Energy Asset Impairment Test\". Make sure that you save your file frequently as you work through this assignment. When you build a spreadsheet model, it is best to have one area in which you input the assumption variables used to derive the amounts in the rest of the model. This allows you to easily change your assumptions and evaluate the effect those changes had on your results. This is known as \"sensitivity analysis\". 1 ACC340 External Financial Reporting Excel Assignment - Asset Impairment You will notice that there are tabs at the bottom left of the screen that are currently labeled as \"Sheet 1\Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started