I want answers in excel with formula

Assume that a machine costing $300,000 and having a useful life of five years (with no salvage PROBLEM 4-7 value) generates a yearly income before depreciation and taxes of $100,000. Analyzing Depreciation Required: for Rates of Return Compute the annual rate of return on this machine (using the beginning-of-year book value as the base) for each of the following depreciation methods assume a 25% tax rate): CHECK a. Straight-line Year 2 return, SL: 12.5% b. Sum-of-the-years' digits SYD: 7.5%