Assessment 3: Business Case Studies 2 Your total assignment submission will consist of a word document and a spreadsheet, submitted via separate links. The assignment is based on the case information...

1 answer below »
Please see attached case study


Assessment 3: Business Case Studies 2 Your total assignment submission will consist of a word document and a spreadsheet, submitted via separate links. The assignment is based on the case information below. While the company and financial data in the case are fictitious, the context is not. Many companies face similar investment decisions as well as challenges and opportunities to run more environmentally and socially responsible businesses. Case Information ABC Limited is a large agricultural producer that owns around one million hectares of land, most of which is used to run cattle bound for global markets. Recently, the Board and managers of ABC have been closely watching the rapid growth in popularity of meat alternatives, including imitation meat, and see it as a reflection of broader societal trends towards healthier lifestyles and reducing carbon footprint. The Board are concerned about the potential long-term negative impact of these trends on the company’s value and it has led them to reconsider the company’s strategy. Given the size of the company’s land holdings, several alternative land use options have been considered. A move to the production of non-meat agricultural products has been ruled out because most of the company’s land is not suitable for the viable production of such products. Mining ventures have also been ruled out because none of the land contains a profitable level of resources except coal, which the Board has decided is not appropriate to deal with their aim to become a more environmentally responsible business. Coal is a hotly debated topic in energy and climate policy. The most recent proposal being examined by ABC is renewable energy production. Renewables are considered crucial in the transition to a low-carbon, sustainable future according to The International Energy Agency: In 2018, renewable electricity generation rose 7%, with wind and solar PV technologies together accounting for 65% of this increase. Although the share of renewables in global electricity generation reached 25% in 2018, renewable power as a whole still needs to expand significantly to meet the SDS [Sustainable Development Scenario] share of almost half of generation by 2030. This requires the rate of annual capacity additions to accelerate…[footnoteRef:1] [1: International Energy Agency (2019) Tracking power, https://www.iea.org/reports/tracking-power-2019. 2 A video exemplifying onshore wind farm construction can be found at https://youtu.be/gyHkIDI9CiI. ] Specifically, ABC are considering a wind farm2. The company is now close to the final investment decision stage and the CEO has asked you to put together a financial analysis of the project. You will submit a summary of this analysis, along with your recommendations on the project, in a short memo. The company owns several parcels of land that a wind study has indicated are suitable for power generation by wind turbines. One parcel in particular has been singled out as the best based on wind, geology, grid connection access, minimal environmental impact, local government consent and positive community attitudes in the area towards wind towers. Cattle currently run on this land but the company believes this activity would not be severely impacted by the wind farm. The stock would need to be removed during construction of the wind towers but existing stocking rates could be resumed once the wind towers are operational. Costs associated with this disruption in current activities during wind tower construction are estimated to be $0.2million net of tax effects. In addition to the wind study, the company has incurred other project development costs, including for a geological study and environmental impact assessment, engaging the services of several relevant professionals, holding community consultations and receiving local government development approval. These project development costs have totalled $0.8m. The wind farm will consist of ten, 2MW turbines, giving the wind farm a total rated capacity[footnoteRef:2] of 20MW. Each turbine will cost $2.2 million and related installation costs (including construction and grid connection, which are all depreciable) will be an additional $0.5 million for each turbine tower. The plant and equipment will be depreciated to a zero book value on using the prime cost method over 20 years. A proportion of the financing for the plant and equipment will be via a new 20-year debt issue, resulting in interest costs of $2 million payable at the end of each year. At the end of 20 years, the wind farm will be decommissioned and the plant and equipment sold for an estimated market value of $4 million. Estimated decommissioning costs are $3 million. [2: Rated capacity is the peak hourly production of a wind turbine when conversion efficiency is near its maximum. This requires optimal wind speed, amongst other conditions. ] The rated capacity of the wind farm per hour (20MW) will not be available at all times due to winds that are lighter or stronger than the optimal wind speed range. Engineers from the turbine supplier have therefore suggested assuming a capacity factor[footnoteRef:3] of 40%, which means that the farm would be expected to produce 70,080 MW hours (MWh)[footnoteRef:4] of electricity each year, assuming continual operation. However, this is an uncertain estimate due to the variability of wind and the potential for repair and maintenance outages. Global capacity factors for onshore wind have been increasing over time, as seen in the graph on the next page, but the 2018 global average capacity factor was lower than the estimate provided by the turbine supplier’s engineers and there has been a wide range of achieved capacity factors each year. [3: Capacity factor is average power generated divided by rated capacity. For example, if a wind turbine with a 2MW rated capacity produces power at an average of 1MW, its capacity factor is 50% (1÷2). ] [4: Calculated as rated capacity x 365 days x 24 hours x capacity factor = 2MW x 365 days x 24 hours x 40%. This assumes the wind turbines are always operational. ] ABC has negotiated a 10-year Power Purchase Agreement (PPA) that gives a guaranteed $40 per MWh. After this agreement expires, ABC assumes it will sell the electricity in the open market, starting with an estimated average price of $70 per MWh in the first year and increasing 3% per year after that. However, electricity prices are extremely volatile with a standard deviation of 40% of average price. Source: International Renewable Energy Agency (IRENA) 2019, Renewable Power Generation Costs in 2018, IRENA, Abu Dhabi, p. 19. In addition to revenue from selling electricity, ABC will qualify for a government scheme providing green certificates at a rate of one certificate per MWh of renewable energy produced. These certificates have value in the market for retailers who need to meet certain renewable targets. ABC will sell their certificates at the end of each year for an estimated $20 each. Based on expert opinion, ABC predicts that the government will end the scheme after 10 years when it is forecast to meet its renewable energy targets. The contract with the turbine supplier specifies that most service and maintenance of the turbines will be the supplier’s responsibility for 20 years. Therefore, operational costs are expected to be low. Variable operating costs are forecast to be $2 per MWh in the first year and increase at a rate of 2% throughout the life of the project. An additional $1 million annually in administration, insurance and general expenses (excluding depreciation) directly related to the project will also be incurred. ABC has a 8% weighted average cost of capital and is subject to a 30% tax rate on its income. After some research and calculations, you have determined that ABC has a higher unlevered beta, adjusted for cash, then a pure play wind electricity generating company, listed on the same stock market as ABC. Unlevered beta adjusted for cash is a measure of business risk. Required: Prepare (1) a spreadsheet financial analysis of the proposed project and (2) a memo to ABC’s CEO that briefly explains and justifies your chosen methods, inputs and any assumptions made, summarises your findings, and presents your recommendations on the proposed options. Ensure you not only analyse base case (expected) cash flows but also analyse and discuss potential uncertainty. Recommendations should address the decision to be made, along with any further follow up or other matters the company should consider prior to making a final decision. Instructions: Submit your spreadsheet separately in the provided spreadsheet submission link in the BCS2 section of the unit site. By submitting the spreadsheet, you are confirming that it is entirely your own work. Save the spreadsheet with your details in the file name using the following format (failure to do so could result in your spreadsheet not being considered in marking): Student ID_Full_name_ACC00716A3 For example: 13579246_Jennifer_Harrison_ACC00716A3 Submit the memo as a word document via the Turnitin assignment link in the BCS2 section of the unit site. Include your name, student ID, unit code (ACC00716), assessment number (A3) and word count at the beginning of the document. The remainder of the document should be set up as a formal memo and include an appendix with a screen shot(s) of your base case figures from the spreadsheet. To ensure this appendix is readable, show only the first 3 years and last two years of cash flows by hiding the columns in the middle. This will be sufficient to present the key elements in the cash flows without the reader needing to go to the spreadsheet. Also in an appendix, include a table with two columns listing the time period in the first column and your final base case net cash flows in the second column. Within the memo body, you may provide tables and figures that are discussed in the text and assist decision makers understand your methods, findings and their implications for decision-making. The word document submission must not exceed 1,000 words (excluding the screen shot appendix and reference list). This is an individual assessment exercise. The unit teaching team is very experienced at marking such assessments and recognising the differences between individual and “group” work, as well as data, facts, statements and ideas of others that have not been appropriately acknowledged. To avoid any potential for academic misconduct investigation, ensure that every aspect of your work is your own and that you acknowledge all sources you have directly drawn upon in your submitted work by referencing. Quotations should be shown with quotation marks and referenced. Assessment 3: Business Case Studies 2 ACC00716 S1 2020 Assessment 3: Business Case Studies 2 ACC00716 S1 2020 Assessment 3: Business Case Studies 2 ACC00716 S1 2020 1 1 1 Assessment 3: Business Case Studies 2 ACC00716 S1 2020 MARKING CRITERIA
Answered Same DayMay 07, 2021ACC00716Southern Cross University

Answer To: Assessment 3: Business Case Studies 2 Your total assignment submission will consist of a word...

Vasudha answered on May 10 2021
150 Votes
GTI pessimistic case
    Chapter 11, section 11.2b example, GTI
    Pessimistic case
    General assumptions
    Initial (depreciable) investment
    Asset life in years    5
    Straight line depr'n per year    $0
    Industry total unit sales year 1
    Growth in market size per year
    GTI market share year 1
    Additional market sh
are per year
    Selling price year 1
    Growth in selling price per year from year 2
    Production costs as % of selling price
    Income tax rate    30%
    Discount rate
    Sales data        0    1    2    3    4    5
    Sales price per unit            $0.00    $0.00    $0.00    $0.00    $0.00
    Market size in units            0    0    0    0    0
    Market share            0%    0%    0%    0%    0%
    Market share in units            0    0    0    0    0
    Net income        0    1    2    3    4    5
    Revenues            $0    $0    $0    $0    $0
    – Cost of goods sold            $0    $0    $0    $0    $0
    – SG&A expenses
    – Depreciation expense            $0    $0    $0    $0    $0
    Taxable income            $0    $0    $0    $0    $0
    – Taxes            $0    $0    $0    $0    $0
    After-tax income            $0    $0    $0    $0    $0
    Working Capital        0    1    2    3    4    5
    Cash
    Accounts receivable
    Inventory
    – Accounts payable
    Net working capital        $0    $0    $0    $0    $0    $0
    Annual Net Cash Flow Estimates        0    1    2    3    4    5
    Investment in fixed assets        $0    $0    $0    $0    $0    $0
    CF due to change in net working capital        $0    $0    $0    $0    $0    $0
    Net income        $0    $0    $0    $0    $0    $0
    Add back depreciation (non-cash expense)        $0    $0    $0    $0    $0    $0
    Net cash flows during forecast period        $0    $0    $0    $0    $0    $0
    NPV         $0.00
GTI optimistic case
    Chapter 11, section 11.2b example, GTI
    Optimistic case
    General assumptions
    Initial (depreciable) investment    $6,000,000
    Asset life in years    5
    Straight line depr'n per year    $1,200,000
    Industry total unit sales year 1    550,000
    Growth in market size per year    8%
    GTI market share year 1    7%
    Additional market share per year    2%
    Selling price year 1    $225
    Growth in selling price per year from year 2    0%
    Production costs as % of selling price    58%
    Income tax rate    30%
    Discount rate    12%
    Sales data        0    1    2    3    4    5
    Sales price per unit            $225.00    $225.00    $225.00    $225.00    $225.00
    Market size in units            550,000    594,000    641,520    692,842    748,269
    Market share            7%    9%    11%    13%    15%
    Market share in units            38,500    53,460    70,567    90,069    112,240
    Net income        0    1    2    3    4    5
    Revenues            $8,662,500    $12,028,500    $15,877,620    $20,265,617    $25,254,076
    – Cost of goods sold            $5,024,250    $6,976,530    $9,209,020    $11,754,058    $14,647,364
    – SG&A expenses
    – Depreciation expense            $1,200,000    $1,200,000    $1,200,000    $1,200,000    $1,200,000
    Taxable income            $2,438,250    $3,851,970    $5,468,600    $7,311,559    $9,406,712
    – Taxes            $731,475    $1,155,591    $1,640,580    $2,193,468    $2,822,014
    After-tax income            $1,706,775    $2,696,379    $3,828,020    $5,118,091    $6,584,698
    Working Capital        0    1    2    3    4    5
    Cash
    Accounts receivable
    Inventory
    – Accounts payable
    Net working capital        $0    $0    $0    $0    $0    $0
    Annual Net Cash Flow Estimates        0    1    2    3    4    5
    Investment in fixed assets        -$6,000,000    $0    $0    $0    $0    $0
    CF due to change in net working capital        $0    $0    $0    $0    $0    $0
    Net income        $0    $1,706,775    $2,696,379    $3,828,020    $5,118,091    $6,584,698
    Add back depreciation (non-cash expense)        $0    $1,200,000    $1,200,000    $1,200,000    $1,200,000    $1,200,000
    Net cash flows during...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here