Prepare spreadsheet financial analysis of proposed options

Assignment Help Finance Basics
Reference no: EM132305768 , Length: word count:1000

Finance Assignment - Business Case Studies

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.

DuoLever Limited operates in the personal care (e.g. skin and hair care products) industry. All its products are sold in plastic packaging and a significant proportion in multi-layer sachets (or pouches).

Managers at DuoLever are acutely aware of the increase in world production of plastic and the environmental impact of plastic waste ending up in landfills, rivers and oceans. For example, it is estimated that 8 million metric tons entered the ocean in 2010 and this annual amount is predicted to more than double by 2025, accumulating as show in the following graph:

1626_figure.png

To help develop a closed-loop system related to the company's products, DuoLever has invested around $50 million in soft plastic recycling research, development and pilot testing. The outcome is a new and efficient method for recycling sachet waste. In fact, their recycling method is more energy efficient than producing virgin sachet plastic, reducing energy usage by 83%. The output plastic is of such high quality it can be used in food grade packaging applications. Currently, no other recycling method in the market can achieve this.

The company now faces a decision: should it (1) add production of recycled sachet plastic to the company's portfolio of businesses or (2) license use of the patented method? The CEO has asked you to undertake a financial analysis of the options and present your recommendations in a short memo.

Option 1:

The recycling production option requires an upfront investment in plant and equipment of $20 million, which will be depreciated to a zero book value on a straight-line basis over 5 years. The plant will provide sufficient capacity to meet the company's forecast plastic packaging needs over the period of its life. After this, it is expected that the plant will have no salvage value and will be updated using new and better technology. Financing for the plant and equipment will be via a new 5 year debt issue, resulting in interest costs of $1.4 million payable at the end of each year.

Producing recycled plastic has several financial benefits for the company. First, sales revenue of the company's existing products, which will be packaged in the recycled plastic, is predicted to increase due to consumer demand for environmentally responsible products. Excluding this benefit, the company's forecast sales revenue for the coming year is $200 million and this is expected to grow by 4% each year after that. The benefit of recycled packaging is expected to increase these sales forecasts 2% during the 5 year life of the project.

The second benefit is that the cost of plastic packaging for the company's existing products will decrease. The recycled plastic will be cheaper than buying virgin plastic due to lower energy costs and avoiding a supplier margin. The reduced energy costs will shave 15% off total variable packaging costs, currently (without recycling) estimated at $22 million for the coming year and expected to grow by 3% per year after that. Avoiding a supplier margin will reduce total variable packaging costs by 10%. However, the benefits of avoiding the current supplier margin will be offset by the need to pay a new partner, Clean World Ltd, who will set up a plastic waste collection system to supply sufficient raw material for the recycling plant. Apart from these changes, it is expected that variable costs and net working capital will be equivalent to existing forecasts. However, an additional $2 million annually in selling, administrative and general expenses directly related to the project (excluding depreciation) will be incurred.

Option 2:

Option 2 involves licensing use of the patented recycling method to another company, Clean World Ltd, which has shown interest in taking on the entire project, not just supply of raw material. Initial negotiations between DuoLever and Clean World have reached some agreement on what the terms of the arrangement would involve. Clean World would produce recycled plastic using DuoLever's method for the next 5 years and all output during that time would be supplied exclusively to DuoLever for the same cost as DuoLever's existing virgin plastic supply forecasts. This means that Clean World would capture the energy savings associated with the new recycling method, along with a supplier margin. The benefits for DuoLever would be no initial outlay for plant and equipment and locked in packaging materials supply costs for the next 5 years. DuoLever would also retain the ability to market the environmentally responsible characteristics of its recycled packaging and so retain the expected additional sales revenue benefits of Option 1. Annual selling, administrative and general expenses would be just $1 million annually under Option 2, as no additional production administration would be required.

Other information: DuoLever has an 8% weighted average cost of capital and is subject to a 25% tax rate on its income.

Required -

Prepare (1) a spreadsheet financial analysis of the proposed options and (2) a memo to DuoLever'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 address base case cash flows but also analyse 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.

Attachment:- Assignment File.rar

Reference no: EM132305768

Questions Cloud

Firms do not risk the loss of management control : Which types of firms do not risk the loss of management control? what entry modes should such firm employ.
Specific information about the servant leadership principles : Examples of how implementing servant leadership principles has helped the organization achieve success while having a positive impact on people.
Initial step of discovering customer base for product : The initial step of discovering the customer base for a product or service is having some kind specialty or idea
Identify all key information that is needed for the rfp : Identify all key information that is needed for the RFP, and the data collection tool will be sent to managers across the U.S. and globe.
Prepare spreadsheet financial analysis of proposed options : ACC00716 Finance Assignment - Business Case Studies, Southern Cross University, Australia. Prepare spreadsheet financial analysis of proposed options
How is advocacy advanced effectively : How does a doctorally prepared advanced practice nurse advocate for patients as well as the nursing profession? Is there a symbiotic relationship.
Research information about current considerations : Research information about current considerations and challenges related to the financial and budgetary systems in health care organizations.
Websites and social media networks and assess its online : Identify Ben&Jerry various websites and social media networks and assess its online and social media presence.
Explain in detail the accreditation process for a hospital : If you were an administrator, what do you think would be your biggest challenges with the accreditation process?

Reviews

len2305768

5/14/2019 11:12:07 PM

Word Count: 1000 words. This assignment has a 25% weighting in your overall mark for this unit and focuses on content from Weeks 6, 7 and 8. The assignment will be marked out of 25 and marks will be allocated as indicated in the rubric. Your total assignment submission will consist of a word document and a spreadsheet. Instructions: Submit your spreadsheet separately in the provided spreadsheet 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).

len2305768

5/14/2019 11:11:58 PM

Accurate estimation of relevant base case cash flows and decision criteria - All relevant base case cash flows have been accurately incorporated into the analysis and net cash flows and decision criteria are correct (12 marks). Accurate and appropriate analysis of uncertainty - You have accurately analysed project uncertainty using appropriate techniques. You have shown insight by judicious input choices that are well-articulated and linked to case facts. The analysis is easy to follow (5 marks).

len2305768

5/14/2019 11:11:51 PM

Appropriate interpretation and recommendations based on the project analysis - You have accurately interpreted the results of your financial analysis and made appropriate and insightful recommendations with the basis of those recommendations clearly and concisely explained. Recommendations go further than simply accepting or rejecting the project by recognising the subtleties of project decision making and needed additional analysis or considerations. Use of language makes meaning consistently clear; no or very few grammar, syntax and spelling errors (8 marks).

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd