Question
In: Finance
Frito Lay is determining whether to purchase a new piece of equipment, which has a base...
Frito Lay is determining whether to purchase a new piece of equipment, which has a base price of $450,000 and would cost another $34,000 to install. Using the equipment requires a $25,000 investment in additional assets, which will not be sold at the conclusion of this project. This represents the purchase of additional assets required to use the new equipment.
The equipment would be sold after three years for $100,000 and the depreciation allocated to each of those years is as listed below. Upon the sale, the before-tax gain will be $61,000.
Year 1 = $160,000 Year 2 = $210,000 Year 3 = $75,000
Although it would have no effect on revenues, the equipment should save the firm $180,000 per year in before-tax operating costs (excluding depreciation). Frito Lay’s marginal tax rate is 40%, and its required rate of return is 14%.
Calculate the total initial investment, the total supplemental cash flows for each year 1 - 3, the terminal cash flows, the NPV for the project, and state if the equipment should be purchased in a full sentence.
Below is a template for your work.
Step 1: Initial Investment =
Step 2: Supplemental Cash Flows =
Step 3: Terminal Cash Flows =
Step 4: Net Present Value Analysis =
Step 5: Decision =
Solutions
Expert Solution
Step 1 : Initial Investment = Cost for new equipment + investment in additional assets
= 450000+34000 + 25000 = 509000
Step 2 : Supplemental cash flows
| Particulars | Year 1 | Year 2 | Year 3 |
| Savings per year (A) | $180,000 | $180,000 | $180,000 |
| Depreciation (B) | $160,000 | $210,000 | $75,000 |
| Operating Savings (C=A-B) | $20,000 | -$30,000 | $105,000 |
| Tax (D = C*0.40) | $8,000 | -$12,000 | $42,000 |
| Depreciation (E) | $160,000 | $210,000 | $75,000 |
| Cash flows ( F = C - D + E) | $172,000 | $192,000 | $138,000 |
Step 3 :
Terminal cash flow = Sale value of equipment - tax on gain on sale of equipment
= 100000 - 0.4*61000
= 100000 - 24400 = $75,600
Step 4 :
Net presenty value analysis
= sum of present value of supplemnetal cash inflows + present value of terminal cash flows - initial investment
| Particulars | Year 1 | Year 2 | Year 3 | Total |
| Savings per year (A) | $180,000 | $180,000 | $180,000 | $540,000 |
| Depreciation (B) | $160,000 | $210,000 | $75,000 | $445,000 |
| Operating Savings (C=A-B) | $20,000 | -$30,000 | $105,000 | $95,000 |
| Tax (D = C*0.40) | $8,000 | -$12,000 | $42,000 | $38,000 |
| Depreciation (E) | $160,000 | $210,000 | $75,000 | $445,000 |
| Cash flows ( F = C - D + E) | $172,000 | $192,000 | $138,000 | $502,000 |
| Discounting Factor | 0.877192982 | 0.769467528 | 0.674971516 | $2 |
| Present value | $150,877.19 | $147,737.77 | $93,146.07 | $391,761.03 |
= 391761.03 + 75600 / 1.14^3 - 509000
= -$66,211.13
Step 5 : Decision : We should nt buy the equipment as it has a negative NPV.
jeff jeffy answered 1 year agoRelated Solutions
The ICan’tBelieveWhat’sHappening Company needs to decide whether or not to purchase a new piece of equipment....
The ICan’tBelieveWhat’sHappening Company needs to decide whether
or not to purchase a new piece of equipment. The equipment costs
$5.2 million (payable now). The equipment will provide before-tax
cash inflows of $2.0 million a year at the end of each of the next
four years. The equipment would be categorized as a 3-year tax
class asset according to the MACRS system. Therefore use the
following depreciation rates: 33%, 45%, 15%, and 7%, for each year
respectively from year 1 through...
The ICan’tBelieveWhat’sHappening Company needs to decide whether or not to purchase a new piece of equipment....
The ICan’tBelieveWhat’sHappening Company needs to decide whether
or not to purchase a new piece of equipment. The equipment costs
$5.2 million (payable now). The equipment will provide before-tax
cash inflows of $2.0 million a year at the end of each of the next
four years. The equipment would be categorized as a 3-year tax
class asset according to the MACRS system. Therefore use the
following depreciation rates: 33%, 45%, 15%, and 7%, for each year
respectively from year 1 through...
DataPoint Engineering is considering the purchase of a new piece of equipment for $310,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $310,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $130,000 in nondepreciable working capital.
$52,000 of this investment will be recovered after the sixth year
and will provide additional cash flow for that year. Income before
depreciation and taxes for the next six are shown in the following
table. Use Table 12–11, Table 12–12. Use Appendix...
DataPoint Engineering is considering the purchase of a new piece of equipment for $310,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $310,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $130,000 in nondepreciable working capital.
$52,000 of this investment will be recovered after the sixth year
and will provide additional cash flow for that year. Income before
depreciation and taxes for the next six are shown in the following
table. Use Table 12–11, Table 12–12. Use Appendix...
DataPoint Engineering is considering the purchase of a new piece of equipment for $290,000. It has...
DataPoint Engineering
is considering the purchase of a new piece of equipment for
$290,000. It has an eight-year midpoint of its asset depreciation
range (ADR). It will require an additional initial investment of
$190,000 in nondepreciable working capital. $47,000 of this
investment will be recovered after the sixth year and will provide
additional cash flow for that year. Income before depreciation and
taxes for the next six are shown in the following table. Use Table
12–11, Table 12–12. Use Appendix...
DataPoint Engineering is considering the purchase of a new piece of equipment for $310,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $310,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $130,000 in nondepreciable working capital.
$52,000 of this investment will be recovered after the sixth year
and will provide additional cash flow for that year. Income before
depreciation and taxes for the next six are shown in the following
table. Use Table 12–11, Table 12–12. Use Appendix...
DataPoint Engineering is considering the purchase of a new piece of equipment for $330,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $330,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $150,000 in nondepreciable working capital.
Fifty-seven thousand dollars of this investment will be recovered
after the sixth year and will provide additional cash flow for that
year. Income before depreciation and taxes for the next six are
shown in the following table. Use Table 12–11, Table 12–12....
DataPoint Engineering is considering the purchase of a new piece of equipment for $260,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $260,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $160,000 in nondepreciable working capital.
$40,000 of this investment will be recovered after the sixth year
and will provide additional cash flow for that year. Income before
depreciation and taxes for the next six are shown in the following
table. Use Table 12–11, Table 12–12. Use Appendix...
DataPoint Engineering is considering the purchase of a new piece of equipment for $310,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $310,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $130,000 in nondepreciable working capital.
$52,000 of this investment will be recovered after the sixth year
and will provide additional cash flow for that year. Income before
depreciation and taxes for the next six are shown in the following
table. Use Table 12–11, Table 12–12. Use Appendix...
DataPoint Engineering is considering the purchase of a new piece of equipment for $255,000. It has...
DataPoint Engineering is considering the purchase of a new piece
of equipment for $255,000. It has an eight-year midpoint of its
asset depreciation range (ADR). It will require an additional
initial investment of $250,000 in nondepreciable working capital.
$82,000 of this investment will be recovered after the sixth year
and will provide additional cash flow for that year. Income before
depreciation and taxes for the next six are shown in the following
table. Use Table 12–11, Table 12–12. Use Appendix...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- discuss crowdfunding on platforms: What features of the services incorporate virality? What are some of the...
- A textbook of mass 2.08 kg rests on a frictionless, horizontal surface. A cord attached to...
- Describe a time when someone did not really listen to or understand a point you were...
- Enumerations Create an advanced enumeration to represent months (JANUARY – DECEMBER) called enuMonths Add internal properties...
- What is the minimum size of the automorphism group of a simple directed graph having more...
- The birthday paradox says that the probability (chance) that two people in a room will have...
- #include <iostream> #include "lib.hpp" using namespace std; int main() { // declare the bool bool...
ADVERTISEMENT