Provide a sensitivity analysis and scenario analysis

Assignment Help Finance Basics
Reference no: EM132269456

Task 1 Ethics in Finance

Discuss the effects on National Australia Bank the report from the Royal Commission into Misconduct in the Banking, Superannuation and Financial Services Industry

Ethical perspectives should be the focus for this essay.

Task 2 (a) Application in Capital Budgeting

Michael, the product development manager for Apex Pharmaceuticals (AP) joined the firm about 7 years ago. With a bachelor's degree in chemistry and an MBA from Peter Faber Business School, Michael has been fairly successful in his professional career. Prior to working at AP, Michael was responsible for the launching of three highly successful drugs at another mid-sized pharmaceutical company. It did not take long for the head-hunters to find him and shortly thereafter AP made him an offer that was too good to refuse. AP is a fairly large pharmaceutical company that has a number of patented drugs under its belt. With a number of the firm's patents expiring in the next three years, there has been some pressure to expand its production lines.

Michael has been asked to make recommendations for new investment to the Board, specifically regarding a new drug recently developed by AP's Research Department.

The Vision Research division recently invented a new drug, nicknamed ClearView, for the cure of myopia, which has shown tremendous promise in the preliminary test. The project leader, Catherine, is very confident that this new drug could revolutionise the world of ophthalmology. Upon Michael's request, she also provides some standard cost estimates if the product is approved and launched early this year.

Development costs: 20 million
Testing costs: 10 million
Initial Marketing costs: 12 million
Initial outlay: 42 million

The new drug is expected to be a block-buster, which will help to increase the company's market share and the sales are expected to be $18 million in the first year. The sales revenue generated from this product alone is expected to grow at a rate of 9% pa in second, third, and fourth years and stay in line with inflation thereafter until its patent expires in 10 years.

Required equipment costing $8 million is expected to have a salvage value of $200,000 after 10 years. Fixed costs are estimated to be $3.50 million per year while variable production costs are expected to be equal to 20% of sales revenue in each case. To get the project underway, additional inventory of $450,000 would be required. The company would also need to increase its accounts payable by $100,000 and its accounts receivable by $150,000.

The weighted average cost of capital is calculated to be 11.5%. The current inflation of 1.5% pa is expected to remain stable over the next 15 years, and so is the company's tax rate of 30%.

Task 2 (a):
You have been asked to advise the manager whether the proposal should be adopted using NPV and IRR analyses. In doing so, you need to present the following in Excel:
i. Relevant assumptions
ii. Treatment of depreciation
iii. Treatment of working capital
iv. Calculation of initial cash outlay, operating cashflows per year and terminal cashflows
v. Calculation of NPV and IRR
vi. Valid conclusion based on NPV and IRR analyses

Task 2 (b) Project Risk Analysis

You need to provide a sensitivity analysis and scenario analysis in Excel using the results in Task 1(a), an analysis which could be scrutinised and questioned by the relevant company committee.

Scenarios

Sales

Fixed Cost (FC)

Pessimistic estimate

20% decrease in sales

20% Increase in FC

Base case

$18 million

$3.50 million

Optimistic estimate

20% Increase in sales

20% Decrease in FC

Attachment:- Principles of Finance.rar

Verified Expert

This assignment contains solution in regard to the effect on National Australian bank by the implementation of royal commission.This assignment also contains solution in regard to the calculation of nov and Irr using different aspects which covers the depreciation tax benefits and terminal cash flows.The sensitivity analysis is also done using different rates of discount and also by using different approaches.

Reference no: EM132269456

Questions Cloud

Project cost and timing concepts on firm business operations : Evaluate application of project cost and timing concepts on a firm's business operations.
Has western influence been good for a country like iran : Has Western influence been good for a country like Iran? Should the West try to have more influence, such as on Iran's nuclear power program and their politics?
How were saddam hussein and the men around him able : Explain how this feature has constituted an obstacle to the country's political and economic development?
Identify key security and ethical issues : The paper is designed to explore the current state and direction of an emerging technology, to identify key security, legal and ethical issues.
Provide a sensitivity analysis and scenario analysis : BAFN200 - Principles of Finance - Australian Catholic University - Discuss the effects on National Australia Bank the report from the Royal Commission
Alternative dispute resolution such as mediation : Companies will engage in other forms of Alternative Dispute Resolution (ADR) such as mediation and arbitration.
Customer relationship management refers : Customer relationship management refers to. A customer value proposition is. The societal marketing concept. Generational marketing refers to.
What are the common causes of death : In 1850 through the early 1900's the most common causes of death included infectious diseases (i.e., epidemics, pneumonia, influenza, TB, dysentery and cholera)
What are the characteristics and indicators : Is the increased attentiveness to the public and constituencies good for American democracy? Why or Why not?

Reviews

inf2269456

8/29/2019 2:03:50 AM

Assignment completed by the writer very well. Assignment is correctly structured and writer has used accurate and updated references in the assignment document. Appreciated writes efforts.

len2269456

3/29/2019 2:35:49 AM

LO1 Financial management and sustainability and social responsibility of organisations Level 5 (HD) Displays an excellent grasp of sustainability and social responsibility of organisations, and the interplay among them. Demonstrates exceptionally insightful and interesting arguments. A highly- structured and comprehensive response to the task. Extensive and relevant research. LO4 Capital budgeting techniques Outstanding performance in describing the relevant assumptions, treatment of depreciation and working capital and in calculating the initial cash outlay, operating and terminal cash flows, NPV and IRR and deriving a valid conclusion.

len2269456

3/29/2019 2:34:35 AM

hi can you please sent the paying details and i want excel file for this assignment as said in the pdf file. thanks Submission instructions: 1. Maximum word length: 500 words for Task 1 & the word limit is not applicable for Task 2. Assessment tasks submitted after the due or extended date will incur, for each whole or part of a calendar day that the work is overdue, a 5% penalty of the maximum marks available for that assessment task up to a maximum of 15%. Assessment tasks received more than three calendar days after the due or extended date will not be allocated a mark.

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