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

On November 1, 2021, Ziegler Products issued a $200,000, 9-month, noninterest-bearing note to the bank. Interest was discounted

IceJOKER [234]

Answer:

Jshshdhdjdjfjfnfjfjnrntnrnrnrnt is a great place to be a

7 0

3 years ago

Your task is to take this and construct a graphical representation of the data. in doing so, you determine that as the price of

fenix001 [56]

<span>Your task is to take this and construct a graphical representation of the data. in doing so, you determine that as the price of soup rises, the quantity of soup demanded decreases. This confirms the Law of Supply and Demand which states that the supply is inversely proportional to the demand. Simply speaking, whenever there is an increase in the price, the supplier tends to produce an excess supply even though the demand is low to generate a greater profit.</span>

3 0

3 years ago

On December 31, 2020, Berclair Inc. had 600 million shares of common stock and 7 million shares of 9%, $100 par value cumulative

Debora [2.8K]

Answer:

The diluted EPS is $1.65

Explanation:

Solution

The Numerator (Basic EPS):

The Net income = $1,050 million

The Preferred dividends= 3mn * 9% * $ 100 = $ 27 million

because the preferred stock is cumulative, the dividend is deducted whether or not paid)

The Denominator (Basic EPS): Weighted average Number of shares

Now,

common stock outstanding (1/1 – 12/31) 600 million x (12/12) *1.05 = 630 million

The Treasury shares purchased (3/1 – 12/31) (24) million x (10/12) *1.05 =(21) million

The shares treasury sold (10/1 – 12/31) (4) million x (3/12) =1

The average weighted number of shares =610 million

so,

Basic EPS = ($1,050-27) ÷ 610 = $1.68

Stock Options

The stock choice are dilutive because exercise price is lesser than market price of $ 70 per share.

By applying the treasury stock method.

Exercise is supposed to take place at the later of the date of issue (9/13/21) or the beginning of the year (1/1/21). Assume exercise 1/1/21

The Treasury Stock Method suggests that the proceeds received upon exercise of $1,680 (30 million x $56) are used to purchase back stock at the market price average, for example $1,680 ÷ $70 = 24 million

The net goes higher in the number of shares = 6 million (30 million issued upon exercise – 24 million repurchased)

Convertible Bonds

By applying method if bonds are transformed into common stock. however,a step by step approach to calculate nature of dilution. is determined

Now,

The shares issued on conversion = 6 million

The Interest paid, net of tax = $3 [(8% x $50) x 75%]

The Interest per shares issued = 3/6 = $ 0.5 per share

The EPS without assumed conversion = ($1,050 - $27+3) ÷ (610 + 6+6) = $1.65

The convertible bonds are dilutive because $1.65 is less than $1.68

Therefore, diluted EPS = ($1,050 - $27+3) ÷ (610 + 6+6) = $1.65

4 0

3 years ago

A company uses the percent of sales method to determine its bad debts expense. At the end of the current year, the company's una

kompoz [17]

Answer:

Accounts receivable $361,000 debit

Allowance for uncollectible accounts $560 debit

Net Sales $806,000 credit

0.4% of credit sales are uncollectible = 0.4% x $806,000 = $3,224

adjusting entry:

December 31, 202x

Dr Bad debt expense 3,224

Cr Allowance for doubtful accounts 3,224

Allowance for doubtful accounts is a contra asset account that reduces accounts receivable.

8 0

3 years ago

Whiplash Ltd. makes a single product and only one type of direct material is used to make this product. Whiplash uses a standard

RSB [31]

Answer:

$2 per gram.

Explanation:

We are given the following parameters in the question above; the production of output in July: Actual number of units of output produced = 7,800 units, the Materials quantity variance = $2,609, the favorable (F) Materials spending variance = $3,744, the Favorable (F) Standard amount of materials used per unit of output = 5.0 grams per unit , the Actual total materials purchased/used = 37,830 grams and the Actual price per gram purchased/used = $2.20 per gram.

(37,830 × standard price) - (37,830 × 2.2 ) =$3,744.

Thus, (37,830 × standard price) = 79482.

Approximately, standard price = $2 per gram

4 0

3 years ago

Read 2 more answers