Question

In: Finance

A company is considering a project that requires an initial investment of $660,000 and has a...

A company is considering a project that requires an initial investment of $660,000 and has a useful life of 11 years. Expected cash receipts from the project will be $195,000 each year. The salvage value of the assets used in the project will be $70,000. The company’s tax rate is 25%. For tax purposes, the entire initial investment (without any reduction for salvage value) will be depreciated over 11 years. The company uses a discount rate of 20%.

Provide the variables you entered into Excel and your final calculation of net present value after-tax. (If a variable is not used in the calculation, input a zero (0). Omit the "$" and "%" signs in your response. Round answers to the nearest dollar and use a minus sign ( - ) for negative numbers.)

Excel input:


Rate
%
  Nper   
  PMT $   
  PV $   
  FV $   
  Net present value $   
Required:

Compute the internal rate of return after-tax. Provide the variables you entered into Excel for the calculation. (If a variable is not used in the calculation, input a zero (0). Omit the "$" and "%" signs in your response. Round answers to the nearest dollar / whole number and use a minus sign (-) for negative numbers.)


Excel / calculator input:

Rate
%
  Nper   
  PMT $   
  PV $   
  FV $   
  Internal Rate of Return (IRR) %

Solutions

Expert Solution

After tax cash flow (ATCF) each year = cash receipts - taxes

After tax salvage value = salvage value - tax

As the assets are fully depreciated, the book value of assets is zero, and the entire salvage value is taxed

NPV and IRR are calculated using the functions in Excel

NPV is $239,522

IRR is 29.58%

NPV is $239,522

IRR is 29.58%


Related Solutions

A company is considering a project that requires an initial investment of $660,000 and has a...
A company is considering a project that requires an initial investment of $660,000 and has a useful life of 11 years. Expected cash receipts from the project will be $175,000 each year. The salvage value of the assets used in the project will be $75,000. The company’s tax rate is 30%. For tax purposes, the entire initial investment (without any reduction for salvage value) will be depreciated over 11 years. The company uses a discount rate of 21%. Provide the...
A company is considering a project that requires an initial investment of $810,000 and has a...
A company is considering a project that requires an initial investment of $810,000 and has a useful life of 12 years. Expected cash receipts from the project will be $190,000 each year. The salvage value of the assets used in the project will be $75,000. The company’s tax rate is 35%. For tax purposes, the entire initial investment (without any reduction for salvage value) will be depreciated over 12 years. The company uses a discount rate of 17%. Provide the...
Company XYZ is considering project A. Project A requires an initial investment of $75,000.
Company XYZ is considering project A. Project A requires an initial investment of $75,000. It generates $35,000 each year for the coming 3 years. What is the discounted payback period for this project if the proper discount rate is 18%?
A company is considering a project that requires an initial investment of $56M to build a...
A company is considering a project that requires an initial investment of $56M to build a new plant and purchase equipment. The investment will be depreciated as a MACRS 10-year class (see p. 21 in the text) asset. The new plant will be built on some of the company’s land which has a current, after-tax market value of $5.5M. The company will produce units at a cost of $255 each and will sell them for $300 each. There are annual...
Kendall Corporation is considering a project that requires an initial investment of $900,000 and has a...
Kendall Corporation is considering a project that requires an initial investment of $900,000 and has a useful life of 12 years. The annual net cash receipts will be $175,000. The salvage value of the assets used in the project will be $50,000. The company’s tax rate is 35%. For tax purposes, the entire initial investment (without any reduction for salvage value) will be depreciated over 12 years. The company uses a discount rate of 20%. Provide the variables you entered...
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to...
The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to build a new plant and purchase equipment. The investment will be depreciated using the straight line method over 10 years.   The new plant will be built on some of the company's land which has a current, after-tax market value of $5,000,000.  The company will produce widgets at a cost of $130 each and will sell them for $420 each. Annual fixed costs are $500,000.  Sales (in units)...
The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to...
The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to build a new plant and purchase equipment. The investment will be depreciated using the straight line method over 10 years.   The new plant will be built on some of the company's land which has a current, after-tax market value of $5,000,000.  The company will produce widgets at a cost of $130 each and will sell them for $420 each. Annual fixed costs are $500,000.  Sales (in units)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT