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

  Calculate the expected return and risk and sharpe ratio

You decide to invest 70% of your money in a portfolio P and 30% in T-bills. The portfolio P contains two risky securities A and B with a correlation of 0.2

  Does risk-free arbitrage opportunity exist-general strategy

Does a risk-free arbitrage opportunity exist? If so, describe the general strategy.

  What price would you expect tcks common stock to sell

If the risk-free rate is 9.2 percent and the market risk premium is 6 percent, at what price would you expect TCK’s common stock to sell?

  Describe the major points of the report

Executive Summary: State the purpose of the report and describe the major points of the report. Service and/or  Equipment Description: This section should be at least one page.

  What is the operating cash flow for project

What is the operating cash flow for this project?

  Compute the correct forward rate implied by interest rates

The current level of real estate prices in Moscow seem to be on a reasonable level now and you consider that this is just the right time to step into the market. You have noticed a nice apartment in the Leninsky Prospekt close to the city centre.  Co..

  What is the duration of a bond with four years to maturity

What is the duration of a bond with four years to maturity and a coupon of 9.6 percent paid annually if the bond sells at par?

  Calculate the present value of the compound interest loan

Calculate the present value of the compound interest loan.

  Calculate the cost of purchasing the equipment with debt

Calculate the cost of purchasing the equipment with debt. Calculate the cost of leasing the equipment.

  Made mortgage five years

What rate of return would Mr.Tramp receive by prepaying the loan?

  What would the company loan requirements

What would the company’s loan requirements be at the end of December in this case?

  How much will you pay for the policy

Assume the required return on this investment is 7.6 percent. How much will you pay for the policy?

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