Question

In: Finance

The machine is estimated to cost $100,000 which can last for 7 years before it becomes...

The machine is estimated to cost $100,000 which can last for 7 years before it becomes too costly to maintain and can be sold for scrap at $15,000. The project is estimated to bring in additional $30,000 cash inflow and incur $10,000 in additional expenses related to the running the machine in the first year. The company expects there will be an annual sales growth of 5% from year 2 onward. Expenses are also expected to grow by 2% annually from the second year of the operation.  

The company plans to fund the purchase of the new machine using a bank loan with an interest rate of 10%.

  1. How long is the payback period for this project?  years. Case sensitive. Type in 7.00 (two decimal places) for 7 years.
  2. What is the NPV for this project? $.  Case sensitive. Type in 120,000.00 (two decimal places) for $120,000.00, or -120,000.00 for negative $120,000.00.
  3. What is the IRR for this project?  %.  Case sensitive. Type in 20.00 (two decimal places) for 20%.
  4. p.s no other information given

Solutions

Expert Solution

The given is the below information:

Outlfow: 100,000

Cost of capital: 10%

Revenue : 30,000. Increase of 5% year on year

Cost: 10,000. Increase of 2% year on year

Scrap value end of 7 year is 15,000.

The cash flow is projected as given below

Particulars Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Outflow        (100,000)
Sales- 5 % increase from year 2          30,000          31,500          33,075          34,729          36,465          38,288          40,203
Expenses- 2 % increase from year 2        (10,000)        (10,200)        (10,404)        (10,612)        (10,824)        (11,041)        (11,262)
Scrap Value          15,000
Cash flow       (100,000)         20,000         21,300         22,671         24,117         25,641         27,248         43,941

Payback period

Payback period is calculated as given below

Capital Investment          100,000
Cumulative Cash flow till year 4            88,088
Remaining Cost to be recovered (a)            11,912
Net Cash flow year 2 (b)]            25,641
Payback Period, year 4 (a) / (b)                0.46
Total Cash Payback period in years                4.46

NPV of the project

The cash flows are discounted using the cost of capital. Discounting factor is caculated basis the below formula

Particulars Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Discounting Factor 1 =1/(1.1)^1 =1/(1.1)^2 =1/(1.1)^3 =1/(1.1)^4 =1/(1.1)^5 =1/(1.1)^6 =1/(1.1)^7
Discounting Factor           1.00           0.91           0.83          0.75          0.68          0.62          0.56          0.51

The NPV is calculated as given below

Particulars Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Outflow (100,000.00)
Sales- 5 % increase from year 2    30,000.00    31,500.00    33,075.00    34,728.75    36,465.19    38,288.45    40,202.87
Expenses- 2 % increase from year 2 (10,000.00) (10,200.00) (10,404.00) (10,612.08) (10,824.32) (11,040.81) (11,261.62)
Scrap Value    15,000.00
Cash flow (100,000.00)    20,000.00    21,300.00    22,671.00    24,116.67    25,640.87    27,247.64    43,941.25
Discounting Factor                 1.00              0.91              0.83              0.75              0.68              0.62              0.56              0.51

Discounted Cash flow

= cash flow x disc factor

(100,000.00)    18,181.82    17,603.31    17,033.06    16,472.01    15,920.96    15,380.58    22,548.81
Total Discounted Cash flow       23,140.54

The NPV is 23,140.54

IRR of the proejct

IRR is when NPV is 0. This is calculated using trial and error method. Basis that, the IRR shall be as given below

Particulars Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Outflow (100,000.00)
Sales- 5 % increase from year 2    30,000.00    31,500.00    33,075.00    34,728.75    36,465.19    38,288.45    40,202.87
Expenses- 2 % increase from year 2 (10,000.00) (10,200.00) (10,404.00) (10,612.08) (10,824.32) (11,040.81) (11,261.62)
Scrap Value    15,000.00
Cash flow (100,000.00)    20,000.00    21,300.00    22,671.00    24,116.67    25,640.87    27,247.64    43,941.25
Discounting Factor                 1.00              0.86              0.74              0.64              0.55              0.48              0.41              0.35
Discounted Cash flow (100,000.00)    17,247.96    15,841.46    14,540.99    13,339.78    12,231.27    11,209.23    15,589.31
Total Discounted Cash flow                 0.00

The IRR is 0 when cost of capital is 15.96% and discounting is done at the same rate.


Related Solutions

The Darlington Equipment Company purchased a machine 5 years ago at a cost of $100,000. The...
The Darlington Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $10,000 per year. If the machine is not replaced, it can be sold for $10,000 at the end of its useful life. A new machine can be purchased for $160,000, including installation costs. During its 5-year life, it will reduce cash...
The Darlington Equipment Company purchased a machine 5 years ago at a cost of $100,000. The...
The Darlington Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $10,000 per year. If the machine is not replaced, it can be sold for $10,000 at the end of its useful life. A new machine can be purchased for $170,000, including installation costs. During its 5-year life, it will reduce cash...
On January 1, 2018, a machine was purchased for $100,000. The machine has an estimated salvage...
On January 1, 2018, a machine was purchased for $100,000. The machine has an estimated salvage value of $6,400 and an estimated useful life of 5 years. The machine can operate for 104,000 hours before it needs to be replaced. The company closed its books on December 31 and operates the machine as follows: 2018, 20,800 hrs; 2019, 26,000 hrs; 2020, 15,600 hrs; 2021, 31,200 hrs; and 2022, 10,400 hrs. Compute the annual depreciation charges over the machine’s life assuming...
A machine was purchased on January 1 for $100,000. The machine has an estimated useful life...
A machine was purchased on January 1 for $100,000. The machine has an estimated useful life of 4 years with a salvage value of $10,000. Under the straight-line method, accumulated depreciation at the end of year 2 is:
management is considering the purchase of a machine that would cost $360,000, would last for 7...
management is considering the purchase of a machine that would cost $360,000, would last for 7 years, and would have no salvage value. The machine would reduce labor and other costs by $78,000 per year. The company requires a minimum pretax return of 11% on all investment projects. The net present value of the proposed project is what?
The cost base of a machine is 100,000 dollars and the machine is expected to be...
The cost base of a machine is 100,000 dollars and the machine is expected to be fully functional for 5 years. The machine will provide a net income of 35,000 dollars in each of the 5 years. The machine will have no value by the end of the 5 year period. For the deprecation calculations, 150% declining balance method will be used. By using the fact that the income tax is 40% and minimum acceptable rate of return after 10%...
Adelphi Company purchased a machine on January 1, 2017, for $100,000.  The machine was estimated to have...
Adelphi Company purchased a machine on January 1, 2017, for $100,000.  The machine was estimated to have a service life of ten years with an estimated residual value of $5,000.  Adelphi sold the machine on January 1, 2021 for $23,000. Adelphi uses the double declining method for depreciation. Using this information, how much is the gain or (loss) for the equipment sale entry made on January 1, 2021. Enter a loss as a negative number.
Assume a machine costs $548,000 and lasts eight years before it is replaced. The operating cost...
Assume a machine costs $548,000 and lasts eight years before it is replaced. The operating cost is $109,600 a year. Ignore taxes. What is the equivalent annual cost if the required rate of return is 14 percent? (Hint: the EAC should account for both initial investment and annual operating costs) $227,732.37 $235,885.17 $244,608.94 $251,835.43 $266,744.08
Assume a machine costs $404,000 and lasts four years before it is replaced. The operating cost...
Assume a machine costs $404,000 and lasts four years before it is replaced. The operating cost is $47,000 a year. Ignore taxes. What is the equivalent annual cost if the required rate of return is 12.5 percent? (Hint: the EAC should account for both initial investment and annual operating costs) $163,297 $174,825 $181,414 $195,637 $202,118
A machine that cost $400,000 has an estimated residual value of $40,000 and an estimated useful...
A machine that cost $400,000 has an estimated residual value of $40,000 and an estimated useful life of four years. The company uses double-declining-balance depreciation. Required: 1. Calculate the machine's depreciable cost. 2. Calculate the machine's depreciation expense for each year. 3. Calculate the machine's accumulated depreciation and book value at the end of each year.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT