$Z$ Inc is committed to becoming carbon neutral by $2026.$ They are investing in a new packaging machine which will use recycled paper packaging instead of plastic. The packaging machine will cost $$12,000,000$ and is expected to have a salvage value of $500,000$ in $15$ years.

a$)$ Develop the depreciation schedule $($aka a table in Excel$)$ to show the depreciation amounts $Z$ Inc can claim each year for Straight Line, Double Declining Balance and MACRS $(15$year class$)$ methods.

b$)$ Z Inc. is located in the US and will pay taxes based on MACRS depreciation. However, for internal accounting they would like to determine with method from part a provides them the most depreciation over the first $3$ years of owning the packaging equipment. This will help them budget for other initiatives to reach their goal of carbon neutral by $2026.$ Each year they will use the depreciation amount and invest it into a savings account which eams $5\mathrm{.}5\%$ on annual basis. Then in $2026$ they will use this money to finish out any projects to Achieve their goal and which method they should use for internal deperciation of the equipment

INCLUDE THE EXCEL INFO