Complete a depreciation schedule for the new assembly machine using all $3$ depreciation methods. Link$/$reference all cells on your depreciation schedules back to the Master Fixed Asset record. Use the math functionality as needed. Referencing 'answer' cells $($schedules$)$ back to 'input' cells $($fixed asset record$)$ creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results.