Question

In: Economics

An electronics company estimated the investment cost for equipment for producing  replacement CCTV will be $800,000.  The operating...

An electronics company estimated the investment cost for equipment for producing  replacement CCTV will be $800,000.  The operating and maintenance cost is expected to be $500,000 per year with an annual revenues estimated at $650,000.  Considering MARR of 15% per year, find:

The simple payback period=.......years  

The discounted payback period=......years

Solutions

Expert Solution

The formula to be used = year where cash flow is last negative + (absolute value of last negative value/cash flow of positive cum cash flow)

Simple payback period

Year

Expenditure

Income

Net Cashflow

Cumulative cashflow

0

-800000

-800000

-800000

1

-500000

650000

150000

-650000

2

-500000

650000

150000

-500000

3

-500000

650000

150000

-350000

4

-500000

650000

150000

-200000

5

-500000

650000

150000

-50000

6

-500000

650000

150000

100000

simple payback period = 5+(50000/150000) = 5.33 years

Discounted pay back period:

Year

Expenditure

Income

Net Cashflow

Discounted Cashflow

Cumulative cashflow

0

-800000

-800000

-800000

-800000.00

1

-500000

650000

150000

130434.78

-669565.22

2

-500000

650000

150000

113421.55

-556143.67

3

-500000

650000

150000

98627.43

-457516.23

4

-500000

650000

150000

85762.99

-371753.25

5

-500000

650000

150000

74576.51

-297176.74

6

-500000

650000

150000

64849.14

-232327.60

7

-500000

650000

150000

56390.56

-175937.04

8

-500000

650000

150000

49035.27

-126901.77

9

-500000

650000

150000

42639.36

-84262.41

10

-500000

650000

150000

37077.71

-47184.71

11

-500000

650000

150000

32241.48

-14943.22

12

-500000

650000

150000

28036.07

13092.85

Discounted payback period = 11+(14943.22/28036.07) = 11.53 years


Related Solutions

A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of...
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of $500,000, replacing equipment with a scrap value of $50,000. This will reduce defect costs by $150,000 a year. At the end of 7 years, the equipment will be replaced and will have a scrap value of $100,000. The interest charges for financing the purchase will be $25,000 a year. The new system will be housed in a building that is currently unused, with an...
On January 1, 2018, Sport Company purchased for $800,000 equipment having an estimated useful life of...
On January 1, 2018, Sport Company purchased for $800,000 equipment having an estimated useful life of 4 years with an estimated salvage value of $20,000. Determine the depreciation expense and year-end book values for 2018 and 2019 using the (1). Sum-of-the-Years'-Digits Method (2). Straight-Line Method (3). Double-declining method
An investment in an item of equipment would cost GH¢150,000. It is estimated that sales in...
An investment in an item of equipment would cost GH¢150,000. It is estimated that sales in the first year would be GH¢120,000 rising by 10% a year for the next four years. Variable costs would be 50% of sales. Annual fixed costs would be GH¢40,000 in the first three years, rising to GH¢60,000 in years 4 and 5. Fixed costs of 60% would be avoidable if the project did not go ahead. The scrap value of the equipment at the...
We have a project for the investment of 3D printing equipment in $ 800,000. It is...
We have a project for the investment of 3D printing equipment in $ 800,000. It is estimated that operating costs such as maintenance, supplies, etc. will be $ 60,000 per year. It is also expected that the income will be $ 180,000 in year 1 and that it will increase $ 6,000 each year through the tenth year. The equipment can be sold at the end of these 10 years at $ 350,000. With a TREMA of 14% per year,...
Your company just purchased a piece of equipment. The maintenance cost of the equipment is estimated...
Your company just purchased a piece of equipment. The maintenance cost of the equipment is estimated at $1,200 for the first year and it is to rise by $200 each year. How much should be set aside now to have enough to cover for the maintenance cost for the next 7 years? Assume payments are made at the end of each year and an interest rate of 4%.
Suppose that a company has estimated the average variable cost of producing its product to be...
Suppose that a company has estimated the average variable cost of producing its product to be $10. The firm’s total fixed cost is $100,000. If the company produces 1,000 units and its pricing strategy is to add a 35 percent markup, what price would the company charge?
Basic Concepts Roberts Company is considering an investment in equipment that is capable of producing more...
Basic Concepts Roberts Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is $2,266,667. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Year Cash Revenues Cash Expenses 1 $2,970,000 $2,290,000 2 2,970,000 2,290,000 3 2,970,000 2,290,000 4 2,970,000 2,290,000 5 2,970,000 2,290,000 The present value tables provided in Exhibit 19B.1 and...
Roberts Company is considering an investment in equipment that is capable of producing more efficiently than...
Roberts Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is $2,066,667. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Year Cash Revenues Cash Expenses 1 $2,930,000 $2,310,000 2 2,930,000 2,310,000 3 2,930,000 2,310,000 4 2,930,000 2,310,000 5 2,930,000 2,310,000 1. Compute the project’s payback period. If required, round your answer...
Basic Concepts Roberts Company is considering an investment in equipment that is capable of producing more...
Basic Concepts Roberts Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is $2,200,000. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Year Cash Revenues Cash Expenses 1 $2,960,000 $2,300,000 2 2,960,000 2,300,000 3 2,960,000 2,300,000 4 2,960,000 2,300,000 5 2,960,000 2,300,000 The present value tables provided in Exhibit 19B.1 and...
Basic Concepts Roberts Company is considering an investment in equipment that is capable of producing more...
Basic Concepts Roberts Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is $2,293,200. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Year Cash Revenues Cash Expenses 1 $2,981,160 $2,293,200 2 2,981,160 2,293,200 3 2,981,160 2,293,200 4 2,981,160 2,293,200 5 2,981,160 2,293,200 The present value tables provided in Exhibit 19B.1 and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT