Question

In: Accounting

1. A new hog investment requires an initial outlay of $130,000 and is expected to increase...

1. A new hog investment requires an initial outlay of $130,000 and is expected to increase operating receipts by 87,000 but will also increase operating expenses by 23,000. The investment will be depreciated over 15 years and will have a $0 salvage value. The marginal tax rate is 30%. The investment will be analyzed over 7 years and the terminal value of the hog investment after 7 years will be $45,000. The pre-tax discount rate is 13.5%. What is the NPV?

Based on the previous question, what is the IRR?

Based on your previous answers, would you invest in this project? Why or why not?

Solutions

Expert Solution

New hog investment
NPV Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Total Calculation of straight line depreciation
Investment (130,000.00)                  -                    -                    -                    -                    -                    -                    -   (130,000.00)
Operating Expenses (23,000.00) (23,000.00) (23,000.00) (23,000.00) (23,000.00) (23,000.00) (23,000.00) (161,000.00) Purchase cost 130,000.00
Depreciation (18,571.43) (18,571.43) (18,571.43) (18,571.43) (18,571.43) (18,571.43) (18,571.43) (130,000.00) Life (Years)               7.00
Savings in costs    87,000.00    87,000.00    87,000.00    87,000.00    87,000.00    87,000.00    87,000.00     609,000.00 Annual Depreciation     18,571.43
Net Savings    45,428.57    45,428.57    45,428.57    45,428.57    45,428.57    45,428.57    45,428.57     318,000.00
Tax @ 30%    13,628.57    13,628.57    13,628.57    13,628.57    13,628.57    13,628.57    13,628.57       95,400.00
Savings after tax    31,800.00    31,800.00    31,800.00    31,800.00    31,800.00    31,800.00    31,800.00     222,600.00
Add: Depreciation    18,571.43    18,571.43    18,571.43    18,571.43    18,571.43    18,571.43    18,571.43     130,000.00
Add: Salvage Value                  -                    -                    -                    -                    -                    -      45,000.00       45,000.00
Net Cash flows (130,000.00)    50,371.43    50,371.43    50,371.43    50,371.43    50,371.43    50,371.43    95,371.43     267,600.00
PV factor @ 13.5%                1.00            0.881            0.776            0.684            0.603            0.531            0.468            0.412
PV of cash flows (130,000.00)    44,380.11    39,101.42    34,450.59    30,352.94    26,742.68    23,561.83    39,304.95     107,894.54
Net present value (NPV) is $ 107,894.54
IRR Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Total
Investment (130,000.00)                  -                    -                    -                    -                    -                    -                    -   (130,000.00)
Operating Expenses (23,000.00) (23,000.00) (23,000.00) (23,000.00) (23,000.00) (23,000.00) (23,000.00) (161,000.00)
Depreciation (18,571.43) (18,571.43) (18,571.43) (18,571.43) (18,571.43) (18,571.43) (18,571.43) (130,000.00)
Savings in costs    87,000.00    87,000.00    87,000.00    87,000.00    87,000.00    87,000.00    87,000.00     609,000.00
Net Savings    45,428.57    45,428.57    45,428.57    45,428.57    45,428.57    45,428.57    45,428.57     318,000.00
Tax @ 30%    13,628.57    13,628.57    13,628.57    13,628.57    13,628.57    13,628.57    13,628.57       95,400.00
Savings after tax    31,800.00    31,800.00    31,800.00    31,800.00    31,800.00    31,800.00    31,800.00     222,600.00
Add: Depreciation    18,571.43    18,571.43    18,571.43    18,571.43    18,571.43    18,571.43    18,571.43     130,000.00
Add: Salvage Value                  -                    -                    -                    -                    -                    -      45,000.00       45,000.00
Net Cash flows (130,000.00)    50,371.43    50,371.43    50,371.43    50,371.43    50,371.43    50,371.43    95,371.43     267,600.00
PV factor @ 35%                1.00            0.741            0.549            0.406            0.301            0.223            0.165            0.122
PV of cash flows (130,000.00)    37,312.17    27,638.64    20,473.07    15,165.24    11,233.51      8,321.12    11,670.30         1,814.04
IRR is 35%
As NPV is positive so you should invest in this project.

Related Solutions

An investment project requires an initial outlay of $100,000, and is expected to generate annual cash...
An investment project requires an initial outlay of $100,000, and is expected to generate annual cash inflows of $28,000 for the next 5 years. The cost of capital is 12 percent. Determine the internal rate of return for the project (to the nearest tenth of one percent). a. 12.0% b. 12.6% c. 3.6% d. 12.4%
Caribbean, Inc. is considering a new investment opportunity. The project requires an initial outlay of $525,000...
Caribbean, Inc. is considering a new investment opportunity. The project requires an initial outlay of $525,000 and is expected to bring in a $75,000 cash inflow at the end of the first year. After the first year, annual cash flows from the project are forecasted to grow at a constant rate of 5% until the end of the fifth year and to remain constant forever thereafter. The company currently has a target debt-to-equity ratio of .40, but the industry that...
1) A company invests in a new project that requires an initial capital outlay of $852790....
1) A company invests in a new project that requires an initial capital outlay of $852790. The project will generate annual net cash flows of $145612 over a period of 8 years. The after-tax cost of capital is 9%. In addition, a working capital outlay of $94620 will be required. This working capital outlay will be recovered at the end of the project’s life. What is the net present value of the project? Select one: a. $-141474 b. $-93987 c....
A new computer system will require an initial outlay of $20,000, but it will increase the...
A new computer system will require an initial outlay of $20,000, but it will increase the firm’s cash flows by $4,300 a year for each of the next 8 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $24,500, but it will increase the...
A new computer system will require an initial outlay of $24,500, but it will increase the firm's cash flows by $4,900 a year for each of the next 8 years. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. Calculate the NPV and decide if the system is worth installing if the required rate of return is 14%. How high can the discount rate be before you would reject the...
A new computer system will require an initial outlay of $17,500, but it will increase the...
A new computer system will require an initial outlay of $17,500, but it will increase the firm’s cash flows by $3,500 a year for each of the next 8 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $24,000, but it will increase the...
A new computer system will require an initial outlay of $24,000, but it will increase the firm’s cash flows by $4,800 a year for each of the next 6 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%. What if it is 13%? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Rate of Return NPV...
A new computer system will require an initial outlay of $21,500, but it will increase the...
A new computer system will require an initial outlay of $21,500, but it will increase the firm’s cash flows by $4,600 a year for each of the next 8 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $20,250, but it will increase the...
A new computer system will require an initial outlay of $20,250, but it will increase the firm’s cash flows by $4,500 a year for each of the next 6 years. A) Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) B) Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $18,750, but it will increase the...
A new computer system will require an initial outlay of $18,750, but it will increase the firm’s cash flows by $4,200 a year for each of the next 6 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT