$1.$ Complete the blank cells in the first table in the Excel document on D$2$L to determine what the company's accounting records look like after you made the journal entries as part of the CFO's special project. Note that when you made the journal entry, the Property and Equipment, Net account accumulated the $$magic$$numbers each quarter. For example, in Q$1$ Year $1$ the entry to Property and Equipment, Net account results in a balance of $$48,000$ plus $$850$ or $$48,850.$ In Q$2$ Year $1$ the amount would be $$46,000$ plus $$850$ from the prior quarter plus

another $$660$ for the current quarter or $$47,510$ and so on$.$ Included in your workbook spreadsheet $($row $3)$ are the adjustment amounts for each of the $5$ quarters so you can refer to those cells when doing your calculations. Also note the operating expenses will be reduced each period by the amount capitalized in that period. For example, in Q$1$ Year $1$ operating expenses would be reduced by $$850$ and in Q$2$ Year $1$ operating expenses would be reduced by $$660.$ Sales revenue should not be altered by the journal entry.

$2.$ Complete the second table in the Excel document on D$2$L using both before and after the magic entry numbers. You will need to compute the fixed asset turnover ratio $($rounded to three decimal places$)$ for the periods ended Q$2$Q$4$ of year $1$ and

Q$1$ of year $2.$ Note you cannot answer this for Q$1$ of Year $1$ because you don$$t have beginning Property and Equipment, Net. For these same $4$ quarters also calculate the net profit margin before and after the magic entry. Discuss in $2-4$ sentences in a text box what you notice about the two ratios. You must use the power of Excel in computing your ratios to get a $10$ on this assignment.