Chapter 2.7, Problem 2CC

The Pan American Bottling Co. is considering the purchase of a new machine that would increase the speed of bottling and save money. The net cost of this machine is $60,000. The annual cash flows have the following projections:  Year 1 ........... 2 ........... 3 ........... 4 ........... 5 ........... Cash Flow $23,000 26,000 29,000 15,000 8,000  a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine?  I need to see the work. I can't use Excel to solve the problem. Excel doesn't help me solve Part a.

Pat and Chris have identical interest-bearing bank accounts that pay them $15 interest per year. Pat leaves the $15 in the account each year, while Chris takes the $15 home to a jar and never spends any of it. After five years, who has more money? Pat. Chris. They both have the same amount. Don’t know

Assume a firm has earnings before depreciation and taxes of $200,000 and no depreciation. It is in a 25 percent tax bracket. a. Compute its cash flow using the following format: Earnings before depreciation and taxes _____Depreciation _____Earnings before taxes _____Taxes @ 25% _____Earnings after taxes _____Depreciation _____Cash Flow _____ b. Compute the cash flow for the company if depreciation is $200,000. Earnings before depreciation and taxes _____Depreciation _____Earnings before taxes _____Taxes @ 25% _____Earnings after taxes _____Depreciation _____Cash Flow _____ c. How large a cash flow benefit did the depreciation provide?