Question

In: Finance

You are considering an investment of $500,000 at time zero for machinery and equipment. Annual revenue...

You are considering an investment of $500,000 at time zero for machinery and equipment. Annual revenue produced by the machinery is estimated to be $400,000 with annual operating costs of $140,000. The investment requires an initial investment of $200,000 for working capital at time zero. The working capital return is equal to the initial working capital investment at the end of the project (8th year). Salvage value of the machinery and equipment is expected to be zero. The minimum After Tax Cash Flow ROR (annual discount rate) is 12% and the effective income tax rate is 38%. 1.Calculate the ROR (Internal Rate of Return) for this investment project, assuming straight line depreciation. 2.Calculate the ROR (Internal Rate of Return) for this investment project, assuming declining balance depreciation with a declining rate of 15% per year over 8 years. Note: You will note that at the end of Year 8 the investment cost is not fully depreciated. 3. Calculate the ROR (Internal Rate of Return) for this investment project, using the 5 year MACRS schedule for depreciation (see Example 7-7). Note: There will be zero depreciation in Years 7 and 8 in this problem.

Solutions

Expert Solution

St.line depn 0 1 2 3 4 5 6 7 8
1.Initial investment -500000
2.Working capital introd.& recd. -200000 200000
3.Annual revenue 400000 400000 400000 400000 400000 400000 400000 400000
4.Annual Operating costs -140000 -140000 -140000 -140000 -140000 -140000 -140000 -140000
5.Depn.(St.line) -62500 -62500 -62500 -62500 -62500 -62500 -62500 -62500
6. EBT(3+4+5) 197500 197500 197500 197500 197500 197500 197500 197500
7.Tax at 38%(Row 6*38%) -75050 -75050 -75050 -75050 -75050 -75050 -75050 -75050
8. EAT(6+7) 122450 122450 122450 122450 122450 122450 122450 122450
9.Add Back depn.(Row 5) 62500 62500 62500 62500 62500 62500 62500 62500
10.Annual Operating cash flow 184950 184950 184950 184950 184950 184950 184950 184950
11. Net annual cash flows(1+2+10) -700000 184950 184950 184950 184950 184950 184950 184950 384950
12. IRR(of row 11) 22%
NPV calculations:
13. PV F at 12%(1/1.12^no.of yr.) 1 0.89286 0.79719 0.71178 0.63552 0.56743 0.50663 0.45235 0.40388
14. PV at 8%(11*13) -700000 165134 147441 131644 117539 104946 93701 83662 155475
15. NPV(sum of row 14) 299542
Declining balance depn 0 1 2 3 4 5 6 7 8
1.Initial investment -500000
2.Working capital introd.& recd. -200000 200000
3.Annual revenue 400000 400000 400000 400000 400000 400000 400000 400000
4.Annual Operating costs -140000 -140000 -140000 -140000 -140000 -140000 -140000 -140000
5.Depn.(Decl.bal.) -75000 -63750 -54188 -46059 -39150 -33278 -28286 -24043
6. EBT(3+4+5) 185000 196250 205813 213941 220850 226722 231714 235957
7.Tax at 38%(Row 6*38%) -70300 -74575 -78209 -81297 -83923 -86154 -88051.2 -89664
8. EAT(6+7) 114700 121675 127604 132643 136927 140568 143663 146293
9.Add Back depn.(Row 5) 75000 63750 54188 46059 39150 33278 28286 24043
10.Annual Operating cash flow 189700 185425 181791 178703 176077 173846 171949 170336
11. Net annual cash flows(1+2+10) -700000 189700 185425 181791 178703 176077 173846 171949 370336
12. IRR(of row 11) 22%
NPV calculations:
13. PV F at 12%(1/1.12^no.of yr.) 1 0.89286 0.79719 0.71178 0.63552 0.56743 0.50663 0.45235 0.40388
14. PV at 8%(11*13) -700000 169375 147820 129395 113569 99910.9 88076 77781 149573
15. NPV(sum of row 14) 275499
Year Depn.(15%*prev. bal.) Balance
0 500000
1 75000 425000
2 63750 361250
3 54188 307063
4 46059 261003
5 39150 221853
6 33278 188575
7 28286 160289
8 24043 136245
MACRS 0 1 2 3 4 5 6 7 8
1.Initial investment -500000
2.Working capital introd.& recd. -200000 200000
3.Annual revenue 400000 400000 400000 400000 400000 400000 400000 400000
4.Annual Operating costs -140000 -140000 -140000 -140000 -140000 -140000 -140000 -140000
5.Depn.(MACRS) -100000 -160000 -96000 -57600 -57600 -28800 0 0
6. EBT(3+4+5) 160000 100000 164000 202400 202400 231200 260000 260000
7.Tax at 38%(Row 6*38%) -60800 -38000 -62320 -76912 -76912 -87856 -98800 -98800
8. EAT(6+7) 99200 62000 101680 125488 125488 143344 161200 161200
9.Add Back depn.(Row 5) 100000 160000 96000 57600 57600 28800 0 0
10.Annual Operating cash flow 199200 222000 197680 183088 183088 172144 161200 161200
11. Net annual cash flows(1+2+10) -700000 199200 222000 197680 183088 183088 172144 161200 361200
12. IRR(of row 11) 24%
NPV calculations:
13. PV F at 12%(1/1.12^no.of yr.) 1 0.89286 0.79719 0.71178 0.63552 0.56743 0.50663 0.45235 0.40388
14. PV at 8%(11*13) -700000 177857 176977 140705 116356 103889 87214 72919 145883
15. NPV(sum of row 14) 321799
Year MACRS rates % Depn. Amt.
0
1 20 100000
2 32 160000
3 19.2 96000
4 11.52 57600
5 11.52 57600
6 5.76 28800
100 500000

Related Solutions

You are considering an investment of $500,000 at time zero for machinery and equipment. Annual revenue...
You are considering an investment of $500,000 at time zero for machinery and equipment. Annual revenue produced by the machinery is estimated to be $400,000 with annual operating costs of $140,000. The investment requires an initial investment of $200,000 for working capital at time zero. The working capital return is equal to the initial working capital investment at the end of the project (8th year). Salvage value of the machinery and equipment is expected to be zero. The minimum After...
Consideration is being given to the investment of $420,000 at time zero for machinery and equipment...
Consideration is being given to the investment of $420,000 at time zero for machinery and equipment to be depreciated using 7 year straight line depreciation starting in year 1 with the half-year convention. Annual sales are projected to be $400,000 less annual operating costs of $200,000. Escalation of operating costs and sales revenue is expected to be a washout from year to year. $100,000 for working capital investment is also needed at time zero and working capital return is expected...
You own a building worth $1,000,000 which also has $500,000 of machinery and equipment, and $500,000...
You own a building worth $1,000,000 which also has $500,000 of machinery and equipment, and $500,000 of ingredients, finished goods and packaging materials in it on a regular basis. You are purchasing a Property Insurance policy that, for premium purposes, has an 80% Coinsurance Clause. Determine how much insurance you need to purchase to comply with the Coinsurance Clause. Provide your calculation for this portion of the answer. Describe the impact to an insurance claim if 1.) You purchased the...
Shown below are rental and leasing revenue figures for office machinery and equipment in the United...
Shown below are rental and leasing revenue figures for office machinery and equipment in the United States over a 7-year period according to the U.S. Census Bureau. Use this data and the regression tool in the data analysis tool pack to run a linear regression. Based on the formula you get from the regression output, answer the following questions: a) What is the forecast for the rental and leasing revenue for the year 2011? b) How confident are you in...
Product A Product B Initial Investment: Cost of Equipment (zero salvage value) $170,000 $380,000 Annual Revenues...
Product A Product B Initial Investment: Cost of Equipment (zero salvage value) $170,000 $380,000 Annual Revenues and costs: Sales Revenue: $250,000 $350,000 Variable Expenses: $120,000 $170,000 Depreciation Expense: $34,000 $76,000 Fixed out-of-pocket operating costs: $70,000 $50,000 Item Periods Amount of Cash Flows Product A: Purchase of equipment $170,000 Net annual cash inflows (above) $60,000 Net Present Value: Product B: Purchase of equipment $380,000 Net annual cash inflows (above) $130,000 Net Present Value: What would the amount of cash flows be?
Randi Corp. is considering the replacement of some machinery that has zero book value and a...
Randi Corp. is considering the replacement of some machinery that has zero book value and a current market value of $3,700. One possible alternative is to invest in new machinery that costs $30,900. The new equipment has a 5-year service life and an estimated salvage value of $4,400, will produce annual cash operating savings of $10,300, and will require a $3,100 overhaul in year 3. The company uses straight-line depreciation. Year FV of $1 at 10% FV of an ordinary...
The company is considering the purchase of machinery and equipment to set up a line to...
The company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value. Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month. Cost of capital is 8%,...
the company is considering the purchase of machinery and equipment to set up a line to...
the company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value. Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month. Cost of capital is 8%,...
the company is considering the purchase of machinery and equipment to set up a line to...
the company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline: Initial cash outlay is $150,000, no residual value. Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials. Direct fixed costs are estimated to run $20,750 per month. Cost of capital is 8%,...
A&Y Inc. considers a 7-year project that requires $500,000 of investment in new machinery and $40,000...
A&Y Inc. considers a 7-year project that requires $500,000 of investment in new machinery and $40,000 in NWC (that will stay constant for the entire life of the project). At the end of the project the equipment will be sold for a salvage value of $70,000. The cost of capital is 10%, the equipment belongs to a CCA class with d=40%, and the corporate tax rate is 30% Problem 20: Prof Reynolds was able to use his industry connections to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT