John, the hapless manager of John's Barbecue is considering replacing his old barbecue with a newer and more efficient model. The old barbecue was...

John, the hapless manager of John's Barbecue is considering replacing his old barbecue with a newer and more efficient model. The old barbecue was purchased for $100,000 two years ago. It is now fully depreciated but it is still functional and has an estimated salvage value of $40,000 now and $10,000 after the five remaining years that John plans to run the business.

            John is considering buying a new barbecue at a cost of $200,000. The cost would be buffered by sale of the old barbecue. The new barbecue has an estimated salvage value of $60,000 after 5 years of use.  It requires an increase in the average inventory of charcoal of $10,000, but it is projected to cause cost savings of $30,000 per year.

            If John buys the new barbecue (which is very big) it will need to be housed in a currently unused portion of the business’s building. John has had offers from other businesses to rent that space for $10,000 a year but he has been (and continues to be) unwilling to allow “outsiders” access to his property.

            The marginal tax rate is 30%.  The new machine will be depreciated on a “3-year” IRS schedule.  The IRS schedule is 30.00%, 40.00%, 20.00%, and 10.00% in years 1-4, respectively.

            Because John realizes that he is financially incompetent, he asks that you analyze this decision.  Please set up the cash flow totals by year.

  0                      1                      2                      3                      4                      5