$$

DR$.$E$.$Brown Enterprises offers $24$ hour scientific services and is in need of new equipment. Complete the following table using formulas to consider applicable limitations$.$ Also consider what the maximum Elected $$179$ could be without creating a carryforward.

$($HINT: Use the MIN Function for Maximum $179$ after T$.$I. IImit$)$

$($HINT: Only one cell's formula will be different between the two scenarios$)$

Taxable Income

Machinery Placed in Service

$179$ Threshold

Phase$-$out of max$179$

Maximum $179$ before phase$-$out

Maximum $$179$ after phase$-$out

Elected $179$

Basis after $$179$

MACRS Depreciation Rate Year $1$

MACRS Depreciation Year $1$

$5179$ Taxable Income Limit

Maximum $$179$ after T$.$I. limit

Excess $$179$ carried forward

Total Depreciation Year $1$

Remaining Basis

$\backslash$table$[[$Maximum $$179,$No $$179$ Carryforward$],[1,150,000,1,150,000$