Analyzing Glow Plc Issues Essay

Open, View, and/or
Download this Document

Total Length: 1693 words ( 6 double-spaced pages)

Total Sources: 6

Page 1 of 6

Glow PLC

Identify the relevant cash flows to evaluate production of the new security light

In order to assess capital expenditure alternatives, it is imperative for the firm to determine the relevant cash flows. These include the incremental cash outflow, also perceived as the investment, and ensuing accruals (Bierman Jr. and Smidt, 2012). It is imperative to note that the incremental cash flows signify the extra cash flows, which might be inflows or outflows, anticipated to come about from the projected capital expenditure. The cash flows of this particular projected have the normal pattern, which encompasses three elements, and these are the initial investment, the operating cash inflows and the terminal cash flow (Bierman Jr. and Smidt, 2012).

Initial Investment

The term 'initial investment' encompasses the relevant cash outflows, considered when assessing a prospective capital expenditure, which in this case is new machinery. In particular, the initial investment takes place at time zero or year zero, which is the time at which the prospective capital expenditure is made (Bierman Jr. and Smidt, 2012). The initial investment is calculated by deducting all cash inflows taking place at year zero from all the cash outflows taking place in the same year. The cash flows that ought to be taken into consideration when ascertaining the initial investment linked with the capital expenditure include the installed cost of the new asset, the proceeds from the sale of an old asset and the change in net working capital (Horngren, Datar, and Rajan, M, 2012). In this case, there are no costs of installation and the company at the end of the fourth year will not be replacing the existing asset. As a result, the initial investment is equal to the purchase price of the new machinery adjusted for any alterations in net working capital (Bierman Jr. and Smidt, 2012).

The purchase price of the new machinery = $1,500,000

+ Consultation Fees = $250,000

+ Net Working Capital = $150,000

Initial Investment = $1,900,000

2. Operating Cash Inflows

The benefits projected from the capital expenditure, that is the new machinery, are projected in its operating cash inflows, which are incremental after-tax cash inflows. Benefits projected to come about from recommended capital expenditures are measured on an after-tax basis (Holmen, 2009). This is because Glow Plc will not have the usage of any benefits up until the point it has paid the corporation tax. As pointed out, Glow plc pays corporation tax on profits in the year following in which liabilities arise, at an annual rate of 12.50%. The following table indicates the calculation of operating cash inflows for Glow Plc's proposed new machinery (Bierman Jr. and Smidt, 2012).

Operating Cash Inflows for Glow Plc's Proposed New Machinery

Year 1

Year 2

Year 3

Year 4

Sales Units

14,000

16,000

16,000

14,000

Selling Price

Revenue

1540000

1920000

1920000

1400000

Expenses excluding depreciation

Material Costs

420000

480000

512000

476000

Direct Labor

210000

240000

240000

238000

Variable Overheads

70000

80000

96000

98000

Interest Bank Loan

120,000

120,000

120,000

120,000

Administration

100,000

100,000

100,000

100,000

Fixed Costs

80,000

80,000

80,000

80,000

Total

1

1100000

1148000

1112000

Profits before depreciation and taxes

540000

820000

772000

288000

Depreciation

250,000

250,000

250,000

250,000

Net profits before taxes

290,000

570,000

522,000

38,000

Taxes (rate = 12.50%)

36250

71250

65250

Net profits after taxes

253,750

498,750

456,750

33,250

Depreciation

250,000

250,000

250,000

250,000

Operating Cash Inflows

503,750

748,750

706,750

283,250

3. Terminal Cash Flow

Terminal cash flow is defined as the cash flow that comes about from termination and liquidation of a project at the end of its economic life.

Stuck Writing Your "Analyzing Glow Plc Issues" Essay?

View All Our Example Analyzing Glow Plc Issues Essay

Have A Custom Example Essay Written

It signifies the after-tax cash flow, after deducting operating cash inflows that takes place in the final year of the project. In this case, the terminal cash flow is the salvage value of the machinery. This is the amount of proceeds from the sale of the asset after the four years and is given as $500,000 (Bierman Jr. and Smidt, 2012).

Using Glow plc's cost of capital of 13%, calculate the Net Present Value of the new product

The net present value (NPV) is the present value of future after-tax cash flows after deducting the initial investment. It mirrors the variance between the market value of the project and the cost of the project (Atrill and McLaney, 2013).

Net Present Value =

The discount rate is 13%. The Present value factors are calculated as under:

PV Factors:

Year 1 = 1 + (1 + 13%)^1 ? 0.8850

Year 2 = 1 + (1 + 13%)^2 ? 0.7831

Year 3 = 1 + (1 + 13%)^3 ? 0.6931

Year 4 = 1 + (1 + 13%)^4 ? 0.6133

Operating Cash Inflows for Glow Plc's Proposed New Machinery

Year 1

Year 2

Year 3

Year 4

Sales Units

14,000

16,000

16,000

14,000

Selling Price

Revenue

1540000

1920000

1920000

1400000

Expenses excluding depreciation

Material Costs

420000

480000

512000

476000

Direct Labor

210000

240000

240000

238000

Variable Overheads

70000

80000

96000

98000

Interest Bank Loan

120,000

120,000

120,000

120,000

Administration

100,000

100,000

100,000

100,000

Fixed Costs

80,000

80,000

80,000

80,000

Total

1

1100000

1148000

1112000

Profits before depreciation and taxes

540000

820000

772000

288000

Depreciation

250,000

250,000

250,000

250,000

Net profits before taxes

290,000

570,000

522,000

38,000

Taxes (rate = 12.50%)

36250

71250

65250

Net profits after taxes

253,750

498,750

456,750

33,250

Depreciation

250,000

250,000

250,000

250,000

Operating Cash Inflows

503,750

748,750

706,750

283,250

Present Value of Cash Flows:

Year 1 = 503,750 x 0.8850 = 445,818.75

Year 2 = 748,750 x 0.7831 = 586,346.13

Year 3 = 706,750 x 0.6931 = 489,849.43

Year 4 = 283,250 x 0.6133 = 173,717.23

Total Present Value of Cash Inflows: 445,818.75 + 586,346.13 + 489,849.43 + 173,717.23 = 1,696,731.54

Net Present Value (NPV) = Total Present Value of Cash Inflows - Initial Investment

= 1,394,770.6-1,900,000

= -204,268.46

Calculate the Internal Rate of Return of the new product

Internal Rate of Return (IRR) is the rate of interest at which the net present value of the positive cash flows and the negative cash flows from a particular project or investment amount to zero. This interest rate is employed to assess the viability and desirability of an investment or a project (Atrill and McLaney, 2013). The IRR is calculated using the following formula:

IRR = Lower rate + NPV at lower rate / (NPV at lower rate -- NPV at higher rate) x (higher rate -- lower rate) (Horngren, Datar, and Rajan, M, 2012).

Assuming a discounting rate of 8%

PV Factors:

Year 1 = 1 + (1 + 8%) ^ 1 ? 0.925926

Year 2 = 1 + (1 + 8%) ^ 2 ? 0.857339

Year 3 = 1 + (1 + 8%) ^ 3 ? 0.793832

Year 4 = 1 + (1 + 8%) ^ 4 ? 0.73503

Present Value of Cash Flows:

Year 1 =.....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Analyzing Glow Plc Issues" (2016, March 11) Retrieved July 6, 2024, from
https://www.aceyourpaper.com/essays/analyzing-glow-plc-issues-2160010

Latest MLA Format (8th edition)

Copy Reference
"Analyzing Glow Plc Issues" 11 March 2016. Web.6 July. 2024. <
https://www.aceyourpaper.com/essays/analyzing-glow-plc-issues-2160010>

Latest Chicago Format (16th edition)

Copy Reference
"Analyzing Glow Plc Issues", 11 March 2016, Accessed.6 July. 2024,
https://www.aceyourpaper.com/essays/analyzing-glow-plc-issues-2160010
   

Open, View, and/or
Download this Document
order custom essay example