Set up the cash flow totals by year

Assignment Help Financial Management

Reference no: EM131961236

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

Reference no: EM131961236

Questions Cloud

How much money will you have on the date of your retirement : Your salary will increase at 3 percent per year throughout your career. How much money will you have on the date of your retirement 40 years from today?

Why does the student adequately identify the thesis thereof : Has the student selected scholarly article or book chapter within scope of feminist philosophy? Does the student adequately identify the thesis/theses thereof?

Was there consideration for the second contract : John contacts the President of the Lohassel Magnet Company to purchase the magnets needed for the headphones.

How much will you be able to withdraw : If you contribution the maximum currently allowable in a 401(k) plan per year at the end of each year (only your contribution, ignoring employer contributions).

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

What is the optimal sharpe ratio in a portfolio : What is the optimal Sharpe ratio in a portfolio of the two assets? What is the smallest expected loss for this portfolio over the coming year with a probability

How does this affect your taxes and what are recommendation : Since the property is used for commercial rental purposes, Joe can depreciate the building on a straight-line basis over a 39 year period.

Explore security goals that bitmessage attempting to achieve : Choose one of the following cryptographic protocols and explore the security goals that it is attempting to achieve.

Construct a price-weighted index of stock : You construct a price-weighted index of 45 stocks. At the beginning of the day the index is 8,649.21. During the day, 44 stock prices remain the same.

User Account

All Pages