Solution-Create a scenario analysis of project

Create a scenario analysis of project

Assignment Help Finance Basics

Reference no: EM133121009

Lancers Retail Stores is considering the opening of a new store in Des Moines. An analyst for the company has created the following simple model:

Initial Investment at t=0, $1.2M
Life of store, 10 years
Revenues, $1.3M
Variable cost rate, 60%
Fixed costs, (inc., $50K of depreciation) of $300K per year
Expected tax rate 18.0%
There are no net working capital implications
The appropriate risk adjusted discount rate is 10.0%

The above values are base case values. The analyst has also said the three assumptions above that are the most uncertain are Revenues, Variable Cost Rate, and the Tax Rate - the rest of the assumptions are easy to estimate in comparison and the analyst has greater certainty as to those values.

For these three assumptions the analysts has created the following additional analysis:

Assumption	Worse Case	Best Case
Revenues	5% less than Base	5% more than Base
Variable cost rate	65% of revenues	58% of revenues
Tax Rate	20.0%	16.0%

Create a scenario analysis of this project showing worst/base/best cases using the NPV, IRR and PI methods.

Reference no: EM133121009

Questions Cloud

Average beta of the new stocks : What must the average beta of the new stocks be to achieve the target required rate of return?

What is the amount of outstanding checks : You earned interest of $21 and had a service charge of $7. There are no outstanding deposits. What is the amount of outstanding checks?

Assumed risks of changing the capital structure : What are the assumed risks of changing the capital structure to lower the WACC?

Calculate the dividend paid to preferred stockholders : Sold at par, convertible into 114,000 shares of common (already adjusted for stock dividend). Calculate the dividend paid to preferred stockholders

Create a scenario analysis of project : Lancers Retail Stores is considering the opening of a new store in Des Moines. An analyst for the company has created the following simple model:

Determine expected settlement dates in trading contexts : How exactly do you determine expected settlement dates in trading contexts?

What is the expected rate of return of menger corporation : 1. The rate of return on the U.S. government treasury bill is 0.05 and the expected rate of return on the Wilshire 5000 is 0.07 . What is the required rate of r

What is the effect of the errors to the working capital : The company reported net income amounting to P568,200, P814,900 and P625,300. What is the effect of the errors to the working capital

Lower return on a project relative : Given all of the additional risks involved in doing a project overseas, why would a firm accept a lower return on a project relative to the return on a much saf

User Account

All Pages

Create a scenario analysis of project

Reference no: EM133121009

Reference no: EM133121009

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT