Ramirez Company installs a computerized manufacturing machine in its factory at the beginning of

the year at a cost of $$49,000.$ The machine's useful life is estimated at $10$ years, or $400,000$ units of

product, with a $$9,000$ salvage value. During its second year, the machine produces $34,000$ units of

product.

Required: Formulas for each excel square

Determine the machine's second$-$year depreciation and year end book value under the straight$-$line method.