also need amortization schedule for 6 years

also need depreciation schedule for 6 years.

PLEASE have all work done in excel and show work

\begin{tabular}{|c|c|c|c|c|} \hline 3 & Property details & & & \\ \hline 4 & Office Building & & & \\ \hline 5 & Rentable Area: & & 80,000 & sqft \\ \hline 6 & Rental Rate Year 1: & $ & 24.00 & per sq ft \\ \hline 7 & Yearly Increase: & & 2.00% & \\ \hline 8 & Lease term: & & 10 & yrs \\ \hline 9 & \# of tenants: & & 5 & \\ \hline 10 & Occupancy: & & 95% & \\ \hline 11 & Vacancy: & & 5% & \\ \hline 12 & Cost: & $ & 22,700,000 & \\ \hline 13 & Equity: & $ & 7,945,000 & 35% \\ \hline 14 & Debt: & $ & 14,755,000 & 65% \\ \hline 15 & Loan Rate: & & 5.40% & \\ \hline 16 & Loan Term: & & 20 & yrs \\ \hline 17 & Land Value: & $ & 4,086,000 & 18% \\ \hline 18 & Depreciable Amount: & $ & 18,614,000 & 82% \\ \hline 19 & Depreciable Term: & & 39.0 & yrs \\ \hline 20 & Cap Rate for Sale: & & 7.20% & \\ \hline 21 & Income Tax Rate: & & 20% & \\ \hline 22 & Capital Gain Tax Rate: & & 15% & \\ \hline 23 & Management Fee: & & 3.00% & \\ \hline \end{tabular}