Question

In: Accounting

"A firm is considering purchasing a new milling machine and has collected the following information for...

"A firm is considering purchasing a new milling machine and has collected the following information for its income statement and cash flow statement. However, this income statement was calculated as if there is no inflation! All dollars are expressed in constant (year-0) dollars. Recalculate the income and cash flow statement by assuming there is a general (average) inflation of 4.7% applied to revenue, O&M, and salvage value.
- The firm will pay back the loan in 2 years, and the annual loan payment is $15,796.
- The tax rate is 39%.
- The revenue for year 1 is $36,000 and $27,000 for year 2.
- O&M for year 1 is $12,000 and $13,500 for year 2.
- The interest paid on the debt is $2427 for year 1 and $1264 for year 2.
- The taxable income is $12,713 for year 1 and $4,644 for year 2.
- The income taxes are $4,958 for year 1 and $1,811 for year 2.
- The milling machine costs $62,000.
- The salvage value at the end of year 2 is $47,000.
Calculate the IRR of the cash flow based on actual dollars. Express your answer as a percentage between 0 and 100.
You should calculate the depreciation based on the information given in the problem, but do not refer to the MACRS table. You will also need to calculate the amount that is borrowed and that goes to the principal on the debt in years 1 and 2."

Solutions

Expert Solution

Cash Flow statement

Year 0

Year 1

Year 2

1

Sales revenue

-

$37,692

$28,269

2

O&M cost

-

-12,564

-14,135

3

Interest cost

-

-2,427

-1,264

4

Income before tax

-

22,701

12,871

[1-(2+3+4)]

5

Taxes at 39%

-

-4958

-4958

6

Net income

-

17,743

7,913

[4-5]

-

7

Cash flow from operation

-

17,743

7,912.5

[1-2-3-5]

-

8

Initial Investment

($62,000)

-

-

9

Salvage value

47000

10

Total cash flow

($62,000)

$17,743

$54,913

[7+8+9]

IRR Calculation

The calculation of IRR is based on Net Present Value (NPV) being zero, thus:

NPV = 0; or

PV of future cash flows − Initial Investment = 0; or

CF1

+

CF2

− Initial Investment = 0

( 1 + r )1

( 1 + r )2

Where,
   r is the internal rate of return;
   CF1 is the period one net cash inflow;
   CF2 is the period two net cash inflow,

Assuming IRR at 12%

PV(C0)

PV(C1)

PV(C2)

-62000

= 17743/(1.12)^1

= 54913/(1.12)^2

-62000

15842

43776

NPV {(PV(C0)+ PV(C0)+ PV(C0)}

-2382.1

Since negative NPV let’s assume lower IRR of 10%

PV(C0)

PV(C1)

PV(C2)

-62000

= 17743/(1.10)^1

= 54913/(1.10)^2

-62000

16130

45382

NPV

-487.77

Since negative NPV let’s assume lower IRR of 9.5%

PV(C0)

PV(C1)

PV(C2)

-62000

= 17743/(1.095)^1

= 54913/(1.095)^2

-62000

16204

45798

NPV

1.28

Since NPV is close to zero, IRR is 9.5%

Principle payment

Year 1

Year 2

Aggregate loan payment

15796

15796

Interest Payment

-2,427

-1,264

Principle payment

13369

14532


Related Solutions

"A firm is considering purchasing a computer system. The following data has been collected. - Cost...
"A firm is considering purchasing a computer system. The following data has been collected. - Cost of the system: $165,000 - Project life: 6 years - Salvage value at the end of year 6: $19,000 - Depreciation method: five-year MACRS - Tax rate: 32% - Annual revenue from project: $120,000 - Annual expenses (not including depreciation): $78,000 The firm will borrow the entire $165,000 at 5.5% interest to be repaid in 2 annual payments. The firm's MARR is 19%. Determine...
ABC Printing Corporation is considering purchasing a new printing machine. The following information relates to the...
ABC Printing Corporation is considering purchasing a new printing machine. The following information relates to the proposed machine: The proposed machine will be disposed at the end of its usable life of four years at an estimated sale price of K800 000. The machine has an original purchase price of K8 000 000, installation cost of K500 000, and will be depreciated under the five year WTA using the rates provided below. WTA Depreciation Schedule Year Depreciation Rate 1 25%...
Talia’s Tutus is considering purchasing a new sewing machine. The old machine it has right now...
Talia’s Tutus is considering purchasing a new sewing machine. The old machine it has right now was bought 2 years ago for $30,000, with an assume life of 5 years and an assume salvage value of $5,000. The firm uses straight-line depreciation. The old machine can be sold for $25,000. The new machine can be purchased today for $40,000. The new machine will have a 5-year life and will be depreciated to $5,000 using straight-line depreciation. With the new sewing...
123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will...
123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $800,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will be able to charge $22 per widget. The...
A certain firm is evaluating the proposed acquisition of a new milling machine. The cost of...
A certain firm is evaluating the proposed acquisition of a new milling machine. The cost of machine is Rs. 1,000,000 and it would cost another Rs. 200,000 to modify it for special use. The firm has been using the straight-line depreciation assuming 5 years life and Rs 100,000 of salvage value. The machine would require an increase in net working capital (inventory) of Rs.100,000. The milling machine would have no effect on revenues, but it is expected to save the...
A firm is considering the purchase of a new machine at a price of $108,000.  The machine...
A firm is considering the purchase of a new machine at a price of $108,000.  The machine falls into the three-year MACRS class. If the new machine is acquired, the firm's investment in net working capital will immediately increase by $15,000 and then remain at that level throughout the life of the project. At the end of 3 years, the new machine can be sold for $5,000. Earnings before depreciation, interest and taxes (EBDIT) are expected to be as follows with...
(IN EXCEL PLEASE/ With formulas shown) Engineering economics A firm is considering purchasing a machine that...
(IN EXCEL PLEASE/ With formulas shown) Engineering economics A firm is considering purchasing a machine that costs ​$65000. It will be used for six​ years, and the salvage value at that time is expected to be zero. The machine will save ​$35000 per year in​labor, but it will incur ​$12000 in operating and maintenance costs each year. The machine will be depreciated according to​ five-year MACRS. The​ firm's tax rate is 40%, and its​ after-tax MARR is 15%. Should the...
Subang Folding Box Berhad is considering purchasing a new gluing machine. The gluing machine costs RM50,000...
Subang Folding Box Berhad is considering purchasing a new gluing machine. The gluing machine costs RM50,000 and requires installation costs of RM2,500. This outlay would be partially offset by the sale of an existing gluer. The existing gluer originally cost RM30,000 and is four years old. It is being depreciated under straight line method and can currently be sold for RM15,000. The existing gluer has a remaining useful life of two years. If held until year six, the existing machine's...
A firm is considering an investment in a new machine with a price of $18.06 million...
A firm is considering an investment in a new machine with a price of $18.06 million to replace its existing machine. The current machine has a book value of $6.06 million and a market value of $4.56 million. The new machine is expected to have a four-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save $6.76 million in...
A firm is considering an investment in a new machine with a price of $18.06 million...
A firm is considering an investment in a new machine with a price of $18.06 million to replace its existing machine. The current machine has a book value of $6.06 million and a market value of $4.56 million. The new machine is expected to have a four-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save $6.76 million in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT