Excel Depreciation Formulas

[sunshine54915]

Please help me with this question for Excel 2007
I am doing my business federal income taxes myself and I need help please
on Federal Depreciation and AMT Depreciation. My past accountant
set up a worksheet to automatically compute the depreciation on the
assets.
He used 150DBHY 5 or 7 years cost basis with AMT REGULAR Adjust
columns
Federal Depreciation Schedule he used 200DBHY 7 years cost
Prior and current
I need to know how I can use Excel depreciation template or worsheet
to compute last year's depreciation for the income tax return.

Thank you
Sunshine