makabhai    this problem, given the same data has several different answers for the NPV. Please show in excel with formulas that correct answer.   TexMex Food Company is considering a new salsa whose data are shown below. The equipment to be used would be depreciated by the straight-line method over its 3-year life and would have a zero salvage value, and no new working capital would be required. Revenues and other operating costs are expected to be constant over the project's 3-year life. However, this project would compete with other TexMex products and would reduce their pre-tax annual cash flows. What is the project's NPV? WACC 10.0% Pre-tax cash flow reduction for other products (cannibalization) -$5,000 Investment cost (depreciable basis) $80,000 Straight-line deprec. rate 33.333% Sales revenues, each year for 3 years $67,500 Annual operating costs (excl. deprec.) -$25,000 Tax rate 35.0%

3. Schultz Company is considering purchasing a machine that would cost $478,800 and have a useful life of 5 years. The machine would reduce cash operating costs by $114,000 per year. The machine would have a salvage value of $6,200.  Schultz Company prefers a payback period of 3.5 years or less.Required: a.  Compute the payback period for the machine.  What does this mean? b.  Compute the return on average investment (ROI)

please asnwer correctly: Your company has been approached to bid on a contract to sell 5,000 voice recognition (VR) computer keyboards per year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $3.4 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $395,000 to be returned at the end of the project, and the equipment can be sold for $325,000 at the end of production. Fixed costs are $595,000 per year, and variable costs are $85 per unit. In addition to the contract, you feel your company can sell 12,300, 14,600, 19,200, and 11,600 additional units to companies in other countries over the next four years, respectively, at a price of $180. This price is fixed. The tax rate is 23 percent, and the required return is 10 percent. Additionally, the president of the company…

Make this Question