Please help with problems 3 and 4 in excel formatting.

The answer for problem 3:$7468.10

The answer for problem 4: $9694.16

Problem Three (10 marks): Tetley Company is considering acquiring a new machine. The machine would cost $120,000 and it would cost another $30,000 to modify the machine and get it installed and ready for operations. The machine falls into class 8 with a 20% CCA rate and it would be sold after 3 years for $50,000. The machine would require an immediate increase of $8,000 in operating net working capital. The balance of operating net working capital would remain unchanged during the project and be recovered after 3 years. The machine would have no effect on revenues, however the machine is expected to save the company $62,000 per year in before-tax operating costs. The company's tax rate is 30%. The project has a required rate of return of 12% per year compounded annually. What is the NPV of the project? (Note: To get full marks you must show your work. If you are using the table approach you must show the numbers for year 0 to year 3. In addition you must show the calculation or function you used to arrive at the final answer. If you are using the formula, recipe or list approach you must show each step in the approach.) (This page is left blank for you to use.) Problem Four (10 marks): Kaplan Incorporated currently uses an older model BAII plus milling machine that was purchased two years ago for $10,000. The machine would be sold today for $3,000. If the old machine is not replaced, it is expected to operate for another 4 years at which time its salvage value will be $1,200. The BAII plus currently generates revenues of $13,000 per year. The machine has annual operating costs of $8,000 per year. The company maintains an investment of $1,750 in operating net working capital with the old machine. Kaplan Incorporated is considering acquiring a new milling machine to replace its old milling machine. The new milling machine has a capital cost of $12,000 and an estimated useful life of 4 years and an expected salvage value of $2,000. The company expects the new machine to generate total revenues of $25,000 per year. The new machine would have operating costs of $11,000 per year. With the new machine, the investment in operating net working capital would be increased to $2,500 and remain at this level until the end of the project. Both machines have a CCA rate of 30%. The company's tax rate is 35%. The project has a required rate of return of 15% per year compounded annually. What is the NPV of the project, which replaces the old machine with the new machine? (Note: To get full marks you must show your work. If you are using the table approach you must show the numbers for year 0 to year 4. In addition you must show the calculation or function you used to arrive at the final answer. If you are using the formula, recipe or list approach you must show each step in the approach.)