Prepare spreadsheet financial analysis of proposed options

Assignment Help Financial Management
Reference no: EM132318488

Finance Assessment - Business Case Studies

The assignment is based on the attached case information. 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.

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.

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: EM132318488

Questions Cloud

What is current definition of the term hermeneutics : What is current definition of the term hermeneutics? What is hermeneutic problem, hermeneutic research and hermeneutic circle
Calculate the total manufacturing cost for december : The company's manufacturing overhead budget for the year totaled $5,000,000, and the company planned to use 1,000,000 machine hours during the year.
Conduct a study and prepare a research project : You are required to conduct a study and prepare a research project. It must be written in clear language so anyone can use this document to complete the project
Identify how the enrolled nurse applied conduct statement : HLTENN008 - Apply legal and ethical parameters to nursing practice - Think Education, Australia - how the enrolled nurse applied the Standards for Practice
Prepare spreadsheet financial analysis of proposed options : ACC00716 Finance Assessment - Business Case Studies, Southern Cross University, Australia. Prepare spreadsheet financial analysis of proposed options
What is the target cost at a market price : If Pet Designs wants to preserve the existing gross margin percentage, what is the target cost at a market price of $77?
Calculate net cash flows from financing activities : A loan for $100,000 was made to one of Dristell's suppliers. The supplier plans to repay Dristell this amount plus 10% interest within 18 months.
Identify and explain at least three security vulnerabilities : COIT20249 - Professional Skills in Information Communication Technology - Explain what is cybersecurity and why it is important for ABCT
Prepare a report on social development across countries : FIN60003 Business Modelling and Analysis Assignment, Swinburne University of Technology, Australia. Prepare a report on social development across countries

Reviews

len2318488

6/8/2019 1:36:47 AM

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 on page 4. Your total assignment submission will consist of a word document and a spreadsheet. 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): Student ID_Full_name_ACC00716A3 For example: 13579246_Jennifer_Harrison_ACC00716A3.

len2318488

6/8/2019 1:36:41 AM

The memo will be submitted as a word document via a Turnitin assignment link in the BCS2 section of the unit site and 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. 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).

len2318488

6/8/2019 1:36:35 AM

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. Quotations should be shown as such. We are not fussy about referencing style, just that you reference when needed.

len2318488

6/8/2019 1:36:28 AM

MARKING CRITERIA - Accurate estimation of relevant base case cash flows and decision criteria (12 marks) All relevant base case cash flows have been accurately incorporated into the analysis and net cash flows and decision criteria are correct. Accurate and appropriate analysis of uncertainty (5 marks) 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. Appropriate interpretation and recommendations based on the project analysis (8 marks) 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.

Write a Review

Financial Management Questions & Answers

  Which bank faces less risk

Consider two local banks. Bank A has 75 loans outstanding, each for $ 1.0 million, that it expects will be repaid today. Which bank faces less risk?

  How many put option contracts are required

Suppose you hold LLL employee stock options representing options to buy 10,400 shares of LLL stock. How many put option contracts are required?

  What is maximum price per share that arthouse should offer

What is the maximum price per share that Arthouse should offer?

  What about an aggressive investor

Investors are concerned with holding an optimal portfolio. Consider the choices an investor can make. How will the portfolio choices differ for a conservative.

  Calculating return-calculate your total return for last year

Calculating returns: Last year you bought a share of 7.25 percent preferred stock for $63.75. Your stock's market price is now $66.92. Calculate your total return for last year.

  What will be the company earnings per share

What will be the company’s earnings per share, if it proceeds with the recapitalization?

  Estimate the likely standards of value creation

Looking out over the next decade, estimate the likely standards of value creation. How would you advise a company like IBM or Cisco to configure and coordinate its value chain to prosper in this environment? Would you give the same advice to a compan..

  What is investor expected rate of return upon conversion

What is the conversion price? what is the investor’s expected rate of return upon conversion?

  Considering new five-year expansion project

NFL, Inc., is considering a new five-year expansion project that requires an initial fixed asset investment of $2 million.

  What would her taxable gain be for income tax purposes

When Ronnie died seven months ago he left his prize art collection to his daughter Kate. what would her taxable gain be for income tax purposes.

  What is capital gain in stock price from year zero to one

Calculate the expected rate of return. What is the capital gain in stock price from year 0 to year 1?

  Income generated through the brokerage account

Murphy has a brokerage account and buys on margin-which resulted in interest expense of $20,000 during the year. Income generated through the brokerage account

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