Please answer the following questions in an excel spreadsheet. The is in regards to NPV, IRR, and cashflows.

#7:

A company is considering buying a new machine for one of its factories. The cost of the machine is $60,000 and its expected life span is 5 years. The machine will save the cost of a worker estimated at $22,500 annually. The book value of the machine at year 5 is $10,000 but the company estimates that the market value will only be $5,000. Calculate the companys cash flows and the NPV of the machine if the discount rate is 12% and the tax rate is 30%. Assume straight line depreciation over the 5 year life of the machine (that would depreciation of $10,000/yr).

#13:

A company is considering whether to buy a regular or color photocopier for the office. The cost of the regular machine is $10,000, its life span is 5 years, and the company has to pay another $1,500 annually in maintenance costs. The color photocopiers price is $30,000, its life span is also 5 years and the annual maintenance costs are $4,500. The color photocopier is expected to increase the revenue of the office by $8,500 annually. Assume that the company is profitable and pays 40% corporate tax; the relevant interest rate is 11%. Which photocopier should the firm buy? (Hint, calculate the differential cash flows to find the answer...)