The Sumitomo Chemical Corporation is considering replacing a $5-$year$-$old machine that originally cost

$$50,000$ and can be sold for $$60,000.$ This machine is totally depreciated. The replacement machine

would cost $$125,000$ and have a $5-$year expected life over which it would be depreciated down using the

straight$-$line method and have no salvage value at the end of five years. The new machine would produce

savings before depreciation and taxes of $$45,000$ per year. Assuming a $34$ percent marginal tax rate and

a required return of $10\%,$ calculate The internal rate of return and the net present value.

please solve on an exel spreadsheet with the functions on all equations