Case study starting a business project schedules and curves edgenuity

Asked by maham237 @ in Business viewed by 1060 People

Case Study: Assume that are the financial manager of a company, which is considering a
potential project with a new product that is expected to sell for an average price of $22 per
unit and the company expects it can sell 350 000 unit per year at this price for a period of 4
years. Launching this project will require purchase of a $2 000 000 equipment that has
residual value in four years of $200 000 and adding $ 600 000 in working capital which is
expected to be fully retrieved at the end of the project. Other information is available below:
Depreciation method: straight line
Variable cost per unit: $11
Cash fixed costs per year $350 000
Discount rate: 10%
Tax Rate: 30%
Do an analysis with cash flows of the project to determine the sensitivity of the project NPV
with the following changes in the value drivers and provide your results in (a) relevant
tables:
Unit sales decrease by 10%
Price per unit decreases by 10%
Variable cost per unit increases 10%
Cash fixed cost per year increases by 10%

Answered by maham237 @


Answer:

Explanation:

The calculation can be done using sensitivity analysis

The sensitivity analysis is done as follows:

Scenario NPV Deviation in NPV from orignial scenario % depletion

Original 6140513

Unit sale decreases by 10% 5286234 -854279 13.91%

Price per unit decreases by 10% 2894254 -3246259 52.87%

Variable cost per unit increases 10% 5286234 -854279 13.91%

Cash fixed cost per year increases by 10% 6062851 -77662 1.26%

Calculation of original NPV

Sales (350000 * 22) 7700000

Less: Variable cost (350000 * 11) -3850000

Less: Fixed cost -350000

Less: Depreciation [(2000000 - 200000) / 4] -450000

Profit before tax 3050000

Less: Tax at 30% -915000

Profit after tax 2135000

Add: Depreciation 450000

Cash flow after tax 2585000

0 1 2 3 4

Initial investment -2000000

Working capital -600000

Cash flow after tax 2585000 2585000 2585000 2585000

Working capital released 600000

Residual value 200000

Net cash flows -2600000 2585000 2585000 2585000 3385000

PVF at 10% 1 0.9091 0.8264 0.7513 0.6830

Present value -2600000 2350000 2136364 1942149 2312001

NPV 6140513

Calculation of NPV when unit sales decrease by 10%

Sales (315000 * 22) 6930000

Less: Variable cost (315000 * 11) -3465000

Less: Fixed cost -350000

Less: Depreciation [(2000000 - 200000) / 4] -450000

Profit before tax 2665000

Less: Tax at 30% -799500

Profit after tax 1865500

Add: Depreciation 450000

Cash flow after tax 2315500

0 1 2 3 4

Initial investment -2000000

Working capital -600000

Cash flow after tax 2315500 2315500 2315500 2315500

Working capital released 600000

Residual value 200000

Net cash flows -2600000 2315500 2315500 2315500 3115500

PVF at 10% 1 0.9091 0.8264 0.7513 0.6830

Present value -2600000 2105000 1913636 1739669 2127928

NPV 5286234

Calculation of NPV when price per unit decrease by 10%

Sales (350000 * 19.8) 6237000

Less: Variable cost (350000 * 11) -3850000

Less: Fixed cost -350000

Less: Depreciation [(2000000 - 200000) / 4] -450000

Profit before tax 1587000

Less: Tax at 30% -476100

Profit after tax 1110900

Add: Depreciation 450000

Cash flow after tax 1560900

0 1 2 3 4

Initial investment -2000000

Working capital -600000

Cash flow after tax 1560900 1560900 1560900 1560900

Working capital released 600000

Residual value 200000

Net cash flows -2600000 1560900 1560900 1560900 2360900

PVF at 10% 1 0.9091 0.8264 0.7513 0.6830

Present value -2600000 1419000 1290000 1172727 1612526

NPV 2894254

Calculation of NPV when variable cost per unit increases 10%

Sales (350000 * 22) 7700000

Less: Variable cost (350000 * 12.1) -4235000

Less: Fixed cost -350000

Less: Depreciation [(2000000 - 200000) / 4] -450000

Profit before tax 2665000

Less: Tax at 30% -799500

Profit after tax 1865500

Add: Depreciation 450000

Cash flow after tax 2315500

0 1 2 3 4

Initial investment -2000000

Working capital -600000

Cash flow after tax 2315500 2315500 2315500 2315500

Working capital released 600000

Residual value 200000

Net cash flows -2600000 2315500 2315500 2315500 3115500

PVF at 10% 1 0.9091 0.8264 0.7513 0.6830

Present value -2600000 2105000 1913636 1739669 2127928

NPV 5286234

Calculation of NPV when cash fixed cost per year increases by 10%

Sales (350000 * 22) 7700000

Less: Variable cost (350000 * 11) -3850000

Less: Fixed cost -385000

Less: Depreciation [(2000000 - 200000) / 4] -450000

Profit before tax 3015000

Less: Tax 30% -904500

Profit after tax 2110500

Add: Depreciation 450000

Cash flow after tax 2560500

0 1 2 3 4

Initial investment -2000000

Working capital -600000

Cash flow after tax 2560500 2560500 2560500 2560500

Working capital released 600000

Residual value 200000

Net cash flows -2600000 2560500 2560500 2560500 3360500

PVF at 10% 1 0.9091 0.8264 0.7513 0.6830

Present value -2600000 2327727 2116116 1923742 2295267

NPV 6062851


Similar Questions

Business studies class 12 project on principles of management questionnaire

Asked by admin @ in Business Studies viewed by 454 persons

I want a questionaire for my bst project.......PRINCIPLE OF MANAGEMENT (FAYOL)(MCD) class 12​

Which business case is better solved by ai

Asked by admin @ in English viewed by 542 persons

Which business case is better solved by Artificial Intelligence (AI) than conventional programming?1. sending email notifications for overdue invoices2. calculating interest rates for variable-interest rate loans3. predicting …

Which business case is better solved by artificial intelligence

Asked by admin @ in English viewed by 316 persons

Which business case is better solved by Artificial Intelligence (AI) than conventional programming?1. sending email notifications for overdue invoices2. calculating interest rates for variable-interest rate loans3. predicting …

Project on comparative study between harappan and mesopotamian civilization

Asked by admin @ in History viewed by 401 persons

Project on the comparative study of Harappan and mesopotamian civilization

What is the first process involved in project schedule management

Asked by maham237 @ in Social Studies viewed by 313 persons

. a. defining activities b. estimating activity durations c. planning schedule management d. sequencing activities

In project scheduling terminology are activities that must be completed

Asked by maham237 @ in Business viewed by 318 persons

before other activities can begin.

Why does consumption curve not start from the origin

Asked by admin @ in Economy viewed by 358 persons

Why does consumption Curve not start from the origin

Amazon wants to help you start your own delivery business

Asked by admin @ in Business viewed by 294 persons

If selected to own and operate a Delivery Service Partner, what personal and business goals would you hope to achieve by starting your company?

Ikea india case study

Asked by maham237 @ in Business viewed by 316 persons

Read the case study, Business Model and Competitive Strategy of IKEA in India, from the Deresky textbook Part 3 Comprehensive Cases. Analyze the content and prepare a paper addressing the …

What risks do entrepreneurs take when starting a business

Asked by maham237 @ in Social Studies viewed by 386 persons

How much is it to start a lawn mowing business

Asked by admin @ in Mathematics viewed by 283 persons

Terry and Ed start a lawn mowing business and purchase the mowers and equipment for $1,300. They charge $15 for each lawn and use $2 worth of gas for each …

How much does it cost to start a kombucha business

Asked by admin @ in Business viewed by 320 persons

You are in the business of making kombucha tea. Your variable costs to produce each bottle is $1. Your fixed costs are $100,000/year and you expect to sell 300,000 bottles …

Joint hindu family an affectionate business project for 12th

Asked by admin @ in Business Studies viewed by 295 persons

Importance of joint hindu family- an affectionate business in 200-300 words

A research which follows case study method is called

Asked by admin @ in Business Studies viewed by 462 persons

4. A research which follows case study method is called (A) Clinical or Diagnostic (B) Quantitative (C) Causal (D) Analytical

An entrepreneur primary motivation for starting a business is

Asked by admin @ in Business Studies viewed by 400 persons

N entrepreneur's primary motivation for starting a business is

Most viewed questions in Business

Foolproof module 9 test answers

Asked by maham237 @ in Business viewed by 3315 persons

Able, baker, and charles are engaged in the marketing to and enrollment of beneficiaries into medicare health plans. mr. able is an independent agent paid directly by a health plan. ms. baker is an independent agent paid through a field marketing organization (fmo). mr. charles is an independent agent paid for his work by a third-party marketing organization (tmo). how do the cms compensation rules apply to these three agents?

Asked by maham237 @ in Business viewed by 2735 persons

Interest rates are expressed as a percentage of

Asked by maham237 @ in Business viewed by 2104 persons

How to enhance knowledge regarding environmental factors through capsim?

Asked by wiki @ in Business viewed by 1641 persons

Match the job titles with the career clusters.

Asked by maham237 @ in Business viewed by 1477 persons

A company that allows you to license software

Asked by maham237 @ in Business viewed by 1285 persons

Lupe is ready to open a checking account

Asked by maham237 @ in Business viewed by 1281 persons

Mays and mccovey are beer brewing companies

Asked by maham237 @ in Business viewed by 1212 persons

What must be marked on ready to eat bags phfs

Asked by maham237 @ in Business viewed by 1169 persons

Coq six sigma

Asked by maham237 @ in Business viewed by 1136 persons

Henry ford was the first entrepreneur to implement which strategy

Asked by maham237 @ in Business viewed by 1083 persons

Your company was recently served with a lawsuit

Asked by maham237 @ in Business viewed by 1070 persons

Case study starting a business project schedules and curves edgenuity

Asked by maham237 @ in Business viewed by 1060 persons

Which two of the four cs of credit have to do with earning potential and available cash?

Asked by wiki @ in Business viewed by 980 persons

The total annual expenditures on advertising in the united states

Asked by maham237 @ in Business viewed by 966 persons