BUSINESS COLLEGE

Case Study: Assume that are the financial manager of a company, which is considering apotential 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%

Answers

Answer 1

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

Related Questions

Suppose the most you would be willing to pay to have a freshly washed car before going out on a date is $8.00. The smallest amount for which you would be willing to wash someone else's car is $5.50. You are going out this evening and your car is dirty. How much economic surplus would you receive from washing it
On January 8, the end of the first weekly pay period of the year, Regis Company's payroll register showed that its employees earned $21,760 of office salaries and $60,840 of sales salaries. Withholdings from the employees' salaries include FICA Social Security taxes at the rate of 6.20%, FICA Medicare taxes at the rate of 1.45%, $13,560 of federal income taxes, $1,420 of medical insurance deductions, and $940 of union dues. No employee earned more than $7,000 in this first period.Calculate below the amounts for each of these four taxes of Regis Company. Regis’s merit rating reduces its state unemployment tax rate to 3% of the first $7,000 paid each employee. The federal unemployment tax rate is 0.8%. (Round your answers to 2 decimal places.) FICA - Social Security FICA -Medicare FUTA SUTA Prepare the journal entry to record Regis Company's January 8 (employee) payroll expenses and liabilities. (Round your answers to 2 decimal places.) Prepare the journal entry to record Regis’s (employer) payroll taxes resulting from the January 8 payroll. Regis’s merit rating reduces its state unemployment tax rate to 3% of the first $7,000 paid each employee. The federal unemployment tax rate is 0.8%.
The first step in the project control process for measuring and evaluating project performance is to ch13 Select one: a. Determine the project objectives. b. Determine the project deliverables. c. Analyze the project budget. d. Set a baseline plan e. Review the project priority matrix.
Julio Company purchased a $200,000 machine that has a four-year life and no salvage value. The company uses straight-line depreciation on all asset acquisitions and is subject to a 30% tax rate. The proper cash flow to show in a discounted-cash-flow analysis as occurring at time 0 would be:(A) $15,000.(B) $50,000.(C) $140,000.(D) $35,000.(E) $200,000.
Wentworth's Five and Dime Store has a cost of equity of 11.4 percent. The company has an aftertax cost of debt of 5 percent, and the tax rate is 35 percent. If the company's debt–equity ratio is .74, what is the weighted average cost of capital?

Fixed cost per unit is $7 when 25,000 units are produced and $5 when 35,000 units are produced. What is the total fixed cost when nothing is produced? a.$12 b.$130,000 c.$200,000 d.$175,000

Answers

Answer:

The correct answer is D.

Explanation:

Giving the following information:

The fixed cost per unit is $7 when 25,000 units are produced and $5 when 35,000 units are produced.

Total fixed costs= 7*25,000= 175,000

Total fixed costs= 5*35,000= 175,000

Fixed costs= $175,000

In January, Knox Company requisitions raw materials for production as follows: Job 1 $936, Job 2 $1,690, Job 3 $767, and general factory use $667.Prepare a summary journal entry to record raw materials used:

DEBIT CREDIT
Work in Process Inventory
Jan 31. Manufacturing Overhead
Raw Materials Inventory

Answers

Answer:

Materials used in production go to Work in Process so;

= 936 + 1,690 + 767

= $3,393

The materials used in the general factory will go to Manufacturing Overhead.

Date Debit Credit

Jan 31 Work in Process $3,393

Manufacturing Overhead $ 667

Raw Materials Inventory $4,060

The average lead time of a unit of product through a manufacturing station is 18 minutes. The average work in process inventory at this station has been 30 pieces. What is the production rate?a. 3.0 pieces/min
b. 0.33 pieces/min
c. 1.66 pieces/min
d. 0.83 pieces/min

Answers

Answer:

Production rate = 1.66 pieces/min (Approx)

Explanation:

Given:

Average lead time = 18 minutes

Average work in process inventory = 30 pieces

Find:

Production rate

Computation:

Production rate = Average work in process inventory/Average lead time

Production rate = 30/18

Production rate = 1.66 pieces/min (Approx)

Franklin, Inc., has an inventory turnover of 18.9 times, a payables turnover of 11.2 times, and a receivables turnover of 9.7 times. What is the company's cash cycle

Answers

Answer: Cash cycle =24.35 days

Explanation:

Cash cycle=Days in inventory+Days in receivables-Days in payables

Days in inventory=365/inventory turnover

=365/18.9

= 19.3121693 days

Days in receivables=365/receivables turnover

=365/9.7

=37.628866days

Days in payables=365/payables turnover

=365/11.2

=32.5892857 days

Therefore, Cash cycle=Days in inventory+Days in receivables-Days in payables

= 19.3121693 days+ 37.628866 days - -32.5892857days

=24.3517496days

Rounded up to 24.35 days

Final answer:

The cash cycle of Franklin, Inc., considering its inventory turnover, receivables turnover, and payables turnover, is approximately 24.35 days.

Explanation:

In order to calculate the cash conversion cycle for Franklin, Inc., we need to consider three aspects: Inventory turnover, payables turnover, and receivables turnover.

Firstly, we need to convert these turnovers into days. That's achieved by dividing 365 by the turnover ratio for each component.

The converted days for each component will be:

Inventory Days = 365 / Inventory Turnover = 365/18.9 ≈ 19.31 days
Receivables Days = 365 / Receivables Turnover = 365/9.7 ≈ 37.63 days
Payables Days = 365 / Payables Turnover = 365/11.2 ≈ 32.59 days

The Cash Conversion Cycle is then computed as follows: Cash Conversion Cycle = Inventory Days + Receivables Days - Payables Days = 19.31 + 37.63 - 32.59 ≈ 24.35 days

So, the cash cycle of Franklin, Inc. is approximately 24.35 days.

Learn more about Cash Conversion Cycle here:

brainly.com/question/36571330

Gilligan Co.'s bonds currently sell for $1,150. They have a 6.75% annual coupon rate and a 15-year maturity, and are callable in 6 years at $1,067.50. Assume that no costs other than the call premium would be incurred to call and refund the bonds, and also assume that the yield curve is horizontal, with rates expected to remain at current levels on into the future. Under these conditions, what rate of return should an investor expect to earn if he or she purchases these bonds, the YTC or the YTM?(A) 3.92%
(B) 4.12%
(C) 4.34%
(D) 4.57%
(E) 4.81%

Answers

Answer:

(E) 4.81%

Explanation:

See the image below to get the explanation

An activity being analyzed under PERT was judged to most likely have a duration of 40 days. When considering the time it would take to complete the activity if every relevant factor went well, it was estimated to be able to be doable in 20 days and even under the worst case imaginable, the task would be take 50 days. The estimates PERT duration of that activity is:

Answers

Answer:

38.33 days

Explanation:

The PERT method is a common method used to determine the weighted mean or average of three different values of a parameter to calculate a final estimate. Therefore, in the question shown above, the PERT duration can be estimated as:

PERT duration = (20+4*40+50)/6 = (20+160+50)/6 = 38.33 days.

Thus, for the given activity, the PERT duration is approximately 38.33 days.

Other Questions

Select all that apply.Select the items that describe wants (not needs).latest laptopmost expensive shoesextra pair of jeanswater

Franklin Company deposits all cash receipts on the day they are received and makes all cash payments by check. At the close of business on August 31, its Cash account shows a debit balance of $22,662. Franklin's August bank statement shows $21,837 on deposit in the bank. Determine the adjusted cash balance using the following information: Deposit in transit $ 7,350 Outstanding checks $ 5,800 Bank service fees, not yet recorded by company $ 145 The bank collected on a note receivable, not yet recorded by the company $ 870

Ivanhoe Electronics reported the following information at its annual meetings: The company had cash and marketable securities worth $1,235,455, accounts payables worth $4,159,357, inventory of $7,145,200, accounts receivables of $3,489,700, short-term notes payable worth $1,138,700, and other current assets of $121,455. What is the company's net working capital

When a manager treats employees as lazy, unmotivated, and in need of tight supervision, the employees eventually meet the manager's expectations by acting that way. According to Douglas McGregor, this is known as a(n)___________.