Prepare a sensitivity risk analysis with three variables

Assignment Help Financial Accounting
Reference no: EM131394499

Include a capital budget analysis, an interpretation of the analysis and your recommended strategy for the Deluxe Corporation.

Deluxe Corporation is a large chain of retail stores operating in the USA. It sells top-of the- range, expensive clothes to a wealthy clientele throughout the country. Currently, Deluxe only operates in the USA. Its current market capitalization is $760 million and the current market value of debt is $350 million.

At last month's management meeting the marketing director explained that sales volume had increased slightly in the previous year, largely due to heavy discounting in most of its stores. The finance director expressed concern that such a strategy might damage the image of the company and reduce profits over the longer term.

An alternative strategy to increase sales volume has recently been proposed by the marketing department. This would involve introducing a new range of clothing specifically aimed at the middle-income market. The new range of clothing would be expected to be attractive to consumers in Canada and Europe.

Assume your represent the financial management of Deluxe and have been asked to evaluate the marketing department's proposal to introduce a new range of clothing.

An initial investigation into the potential markets has been undertaken by a firm of consultants at a cost of $100,000 but this amount has not yet been paid. It is intended to settle the amount due in three months' time. With the help of a small multi-department team of staff you have estimated the following cash flows for the proposed project:

- The initial investment required would be $46 million: This comprises $30 million for fixed assets and $16 million for net current assets (working capital).

- For accounting purposes, fixed assets are depreciated on a straight line basis over three (3)years after allowing for a residual value of 10%.

- The value of net current assets at the end of the evaluation period can be assumed to be the same as at the start of the period.

- Earnings before taxes are forecast to be $14 million in 2016, $17million in 2017 and $22 million in 2018.

The following information is also relevant:

- The proposed project is to be evaluated over a three-year time horizon. The firm uses Net Present Value and Internal Rate of Return methods to evaluate projects.

- Deluxe usually evaluates its investments using an after-tax discount rate of 8%. The proposed project is considered to be riskier than average and so a risk-adjusted rate of 9% will be used for this project. ?

- The following return analysis should be used: Net Present Value and Internal Rate of Return.
- Prepare a Sensitivity risk analysis with three variables of your (Group) choosing. Your margins of variance are plus/minus 10%, 20%, 30%. Your Sensitivity work should include a graph analysis. ?
- Corporate tax is 25%. ?
- Ignore inflation.

Verified Expert

The solution presented above is an objective financial analysis of various aspects of the book accounts to act as a guide for Deluxe’s Management to enable them makes a well informed decision in the uptake of the proposed project. The workings have tried to give a clear picture of the forecasted outcomes and have also tried to capture the project's outcome in case of either positive or negative deviations. Please note that when performing the sensitivity analysis in the tables above you need to manually changed the inputs, then put the NPV as calculated with the modified variables here. In nutshell, the whole excel work was inclined in ensuring that the management is well advised on whether to accept or reject the Marketing Department proposal.

Reference no: EM131394499

Questions Cloud

What should the policies or laws regulate or encourage : What should these policies or laws regulate or encourage? Use specific facts to defend your position. Has the law improved the environment or situation?
Identify the ws of given data : Identify the W's of these data.- Identify the variables, classify each as categorical or quantitative, and specify units if relevant.
What percent of oldest children are humanities students : What percent of these students are oldest or only children?- What percent of Humanities majors are oldest children?- What percent of oldest children are Humanities students?
What types of information are used for hazard identification : What types of information are used for hazard identification? Summarize the most important points about the Toxic Substances Control Act (TSCA).
Prepare a sensitivity risk analysis with three variables : Prepare a Sensitivity risk analysis with three variables of your (Group) choosing - Deluxe usually evaluates its investments using an after-tax discount rate of 8%. The proposed project is considered to be riskier than average and so a risk-adjuste..
Explain green seattle partnership organization-tree planting : Explain green seattle partnerships organization-tree planting. Write 2 & half pages about: What you did and Why the org needed this work. How this work contributes to our environment.
What is the probability of selecting the sample : What is the probability of selecting the sample {2, 5, 7} under this sampling scheme? Hint: There are 3 possibilities, depending on which unit is drawn first. For subsequent draws, you can use the facts that the first and second order inclusion pr..
Identify the ways to eliminate or reduce hazards : Identifying ways to eliminate or reduce hazards. Compare and contrast the four levels of protection used during spill response and cleanup activities. In your discussion, provide an example of a spill or cleanup scenario for each level.
What types of management system issues are targeted : What types of management system issues are targeted in the planning process of Z10 section 4.0? Provide an example of each issue.

Reviews

inf1394499

3/1/2017 4:32:50 AM

I want to thank you and the expert for all the assistance and backing me up. My session will over after one week from now and the expert has sent me all the work now only, now i have ample of time to go through all the questions. It has been an extremely positive and wonderful experience. On the off chance that I require any further help, I will definately all you once more. Much appreciated once more.

len1394499

2/15/2017 3:46:44 AM

Assess the riskiness of the project - 10% Excellent Good Satisfactory Unsatisfactory Correctly assess and argue in support of the level of the overall riskiness of the project Assess the riskiness without providing supporting arguments Not used Not assess the riskiness of the project Make accept/reject decision - 10% Excellent Good Satisfactory Unsatisfactory Utilize the weighted average NPV analysis to correctly express an opinion on the acceptability of the project Not used Not used Not utilizing NPV

len1394499

2/15/2017 3:46:31 AM

Perform sensitivity analysis - 25% Excellent Good Satisfactory Unsatisfactory Correctly 1. Calculate the changes in the NPV& IRR for the average scenario for changes of +/- 10%, +/- 20%, +/- 30% with respect to the required variable. 2. Analyze the sensitivity of the NPV and IRR with respect to the required variables. Allow miscalculating one or two of the requirements Missing one of the requirements Missing more than one of the requirements

len1394499

2/15/2017 3:46:21 AM

Needing for all the correct calculations to be completed so I can analyze the data accurately. Correctly Excellent Good Satisfactory Unsatisfactory Correctly 1. Initial Investment calculation 2. Calculate the annual depreciation based on the depreciable part of the investment 3. Forecast the net annual cash flows under the given scenarios 4. Allow miscalculating one or two of the requirements Missing one of the requirements Missing more than one of the requirements Calculate NPV and IRR to determine capital return analysis - 20% Excellent Good Satisfactory Unsatisfactory Correctly calculate the weighted average NPV and IRR based on the given scenarios. One or two arithmetic errors More than two arithmetic errors Not using the probabilities to calculate the weighted average NPV

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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