All categories

3 years ago

Case Study: Assume that are the financial manager of a company, which is considering a

Business

1 answer:

krok68 [10]3 years ago

3 0

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

You might be interested in

Loretta went to a store to buy thermal underwear. The underwear had been featured in an advertisement for $24.99 a pair. She was

sweet [91]

Answer:

are there no answer choses maybe stress problem solving

Explanation:

3 0

3 years ago

What restriction did the US government place on advertising in 1997?

12345 [234]

Answer:

The answer should be D, a ban of deceptive advertisements.

Explanation:

In the 90s the government cracked down on deceptive advertising more than ever and more laws on the matter were added. The only other option that was actually ever banned was A, none of the other choices were ever banned. The ban on tobacco happened in the 70s under Nixon, that makes D the only possible answer. Hope this helps! :)

3 0

2 years ago

If the market interest rate drops to 5% on December 31, 2022, it will cost $458,290 to retire the bonds. Record the retirement o

dlinn [17]

To record the retirement of bonds we have to debit the bond payable account with $435,376, debit the interest account with $22,914, and credit the cash account with $458,290.

The retirement of the bond takes place when they are required to be redeemed before they mature. In other words, if the company wants to buy back its bonds before the period of the bond is over. Sometimes the company will also have to pay the interest amount that is due on the bond to the bond-holder.

The bondholders are creditors of the company. These are the people to have loaned money to the company and who the company has to pay back either at maturity or when the company wants. This should be specified to the bondholder before issuing him the bond. The transaction that will be written to record the transaction will be:

Bonds Payable a/c Dr. 435,376

Interest a/c Dr. 22,914

To cash a/c 458,290.

(Being the bonds retired and interest amount paid)

Learn more about the retirement of bonds here:

brainly.com/question/13960495

#SPJ4

3 0

1 year ago

Part-time workers likely result in A. inaccurately high estimates of the labor force. B. inaccurately low estimates of the labor

avanturin [10]

Answer:

Correct answer:

A. inaccurately high estimates of the labor force.

Explanation:

Part-time work is the type of work where an individual has a flexible work plan is a given company unlike the traditional full-time work. Doing such work create the impression that, there is high labour force among the various industries and sectors.<em> For example, someone might be working in two different firms under part-time basis same day which create an impression of two different individuals.</em>

5 0

3 years ago

You are considering a stock that is expected to pay dividends during the next five years of $0.50, $0,52, $0,54, $0,56 and $0.58

nikklg [1K]

Answer:

9.7%

Explanation:

The rate of return can be determined using a financial calculator

Cash flow in year 0 = -65

Cash flow in year 1 = $0.50

Cash flow in year 2 = $0.52

Cash flow in year 3 = $0.54

Cash flow in year 4 = $0.56

Cash flow in year 5 = $0.58 + $100

Rate of return = 9.7%

To find the rate of return using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.

4 0

2 years ago