Question

In: Finance

Company Alex would like to buy a new technological equipment for CZK 16 000 000. Useful...

Company Alex would like to buy a new technological equipment for CZK 16 000 000. Useful life of this equipment is 5 years and expected salvage value is CZK 1 000 000. Company use straight-line method. On the end of 5t? h? year, company will sell this property for CZK 1 500 000. Tax rate is 26 %. Discount rate for evaluation of project effectiveness is 15 %. Expected change of revenues and expenditures during useful life of investment cab be seen in following table:

a) Is it profitable to buy this equipment under such conditions? b) What is the IRR (Internal rate of return) of this investment?

1.yea r

2.yea r

3.yea r

4.yea r

5.yea r

Revenues (in mil. CZK)

6.5

6.9

7.8

7.8

5.6

Expenditures (in mil. CZK)

1.1

1.2

1.5

1.5

1.7

Solutions

Expert Solution

Annual Deprecitation = (Cost - Salvage value) / Number of years

Annual Deprecitation = (16 000 000 - 1 000 000) / 5

Annual Deprecitation = 3,000,000

Operating cash flow = ( Revenue - Expenditure - depreciation) ( 1 - tax) + depreciation

Operating cash flow for year 1 = ( 6500000 - 1100000 - 3000000) ( 1 - .26) + 3000000

Operating cash flow for year 1 = 4776000

Operating cash flow for year 2 = ( 6900000 - 1200000 - 3000000) ( 1 - .26) + 3000000

Operating cash flow for year 2 = 5052000

Operating cash flow for year 3 = ( 7800000 - 1500000 - 3000000) ( 1 - .26) + 3000000

Operating cash flow for year 3 = 5508000

Operating cash flow for year 4 = ( 7800000 - 1500000 - 3000000) ( 1 - .26) + 3000000

Operating cash flow for year 4 = 5508000

Operating cash flow for year 5 = ( 5600000 - 1700000 - 3000000) ( 1 - .26) + 3000000

Operating cash flow for year 5 = 3666000

Non-operating cash flow at year 5 = 1500000 - 0.26( 1500000 - 0)

Non-operating cash flow at year 5 = 1,110,000.

Total cash flow at year 5 = 3666000 + 1110000

Total cash flow at year 5 = 4776000

To check profiltabilty we calculate NPV:

NPV = -16 000 000 + 4776000 / ( 1 + 0.15) + 5052000 / ( 1 + 0.15)2 + 5508000 / ( 1 + 0.15)3 + 5508000 / ( 1 + 0.15)4 + 4776000 / ( 1 + 0.15)5

NPV = 1,118,413.658

Since it has a positive NPV, it is profitable to buy the equipment.

To calculate IRR, please use a financial calculator:

Keys to use in the financial calculator: CF0 = -16000000, CF1 = 4776000, CF2 = 5052000, CF3 = 5508000, CF4 = 5508000, CF5 = 4776000 IRR CPT

When you click CPT, you get IRR as 17.88%

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Caroline's Candles would like to buy $134,000 of new candle-making equipment. However, the company has a...
Caroline's Candles would like to buy $134,000 of new candle-making equipment. However, the company has a major loan maturing in three years and needs this money at that time to avoid bankruptcy. The candle-making equipment is expected to increase the cash flows by $27,000 in the first year, $48,000 in the second year, and $69,000 a year for the following two years. Should Caroline's Candles buy the equipment at this time? Why or why not? I need someone to show...
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates....
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation currently is done largely by hand. The machine the company is considering costs $150,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $9,600, including installation. After five years, the machine could be sold for $7,000. The company...
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates....
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation currently is done largely by hand. The machine the company is considering costs $180,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $9,900, including installation. After five years, the machine could be sold for $5,000. The company...
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates....
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation currently is done largely by hand. The machine the company is considering costs $120,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $9,300, including installation. After five years, the machine could be sold for $4,000. The company...
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates....
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation is currently done largely by hand. The machine the company is considering costs $200,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $10,100, including installation. After five years, the machine could be sold for $9,000.       The company...
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates....
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation currently is done largely by hand. The machine the company is considering costs $150,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $9,600, including installation. After five years, the machine could be sold for $7,000. The company...
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates....
The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation currently is done largely by hand. The machine the company is considering costs $260,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $10,700, including installation. After five years, the machine could be sold for $10,000. The company...
You would like to buy a house that costs $ 350 comma 000$350,000. You have $...
You would like to buy a house that costs $ 350 comma 000$350,000. You have $ 50 comma 000$50,000 in cash that you can put down on the​ house, but you need to borrow the rest of the purchase price. The bank is offering you a​ 30-year mortgage that requires annual payments and has an interest rate of 9 %9% per year. You can afford to pay only $ 27 comma 740$27,740 per year. The bank agrees to allow you...
Alex would like to purchase a car if the car is 22000 +HST(13%) and Alex finance:...
Alex would like to purchase a car if the car is 22000 +HST(13%) and Alex finance: the car over 48 months with an APR of 6% what is the monthly payment?
A new equipment would provide annual cash savings of $84 000 before income taxes. The equipment...
A new equipment would provide annual cash savings of $84 000 before income taxes. The equipment would cost $216 000 and have an estimated useful life of five years. The equipment is expected to have no salvage value at the end of five years. Straight-line depreciation method is used for all equipment for both accounting and tax purposes. TAX RATE : 40% After-tax required rate of return: 12% 1. For investment in new equipment, calculate the after-tax: a) payback period...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT