help me explaining step by step of how to this assigment. $2.$ Navigate to the Bank Statement Transaction worksheet, convert the data range into an excel table, and insert the following:

$$ Change the Table Design to Red, Table Style Medium $19.$

$$ A Totals Row to the Excel Table

$$ Count in the Transaction Type Column $($Column C$)$

$$ Sum in the Amount Column $($Column G$)$

$3.$ Navigate to the BMW Financial Analysis worksheet.

Read Carefully: The car the client wants to purchase is a $2023$ BMW $750$i that has a sticker price of $$136,778$ and was approved at an interest rate of $7\mathrm{.}00\%$ for $6$ years or $72$ months.

$4.$ In cells C$5$ to C$10,$ enter the BMW Financial Loan Terms.

$5.$ In cell C$11,$ calculate the monthly payment of the loan.

$($Hint: If done correctly, the payment amount in will equal $$2,331\mathrm{.}93.)$

$6.$ In cell C$15,$ using a cell reference, enter the principal value of the loan.

$7.$ In cell D$15,$ calculate the Interest Payment.

$8.$ In cell E$15,$ calculate the Principal Payment.

$9.$ In cell F$15,$ sum cells D$15$ and E$15$ to calculate the Total Payment.

$10.$ In cell C$16,$ calculate the next starting principal balance.

$11.$ Complete the rest of the Amortization Schedule for the car.

$($Hint: In cell J$51,$ the balance should be zero if done correctly.$)$

$12.$ Read Carefully: BMW Financial also includes a Depreciation Factor for the car to assist the buyer in their decision. Most $7$ series BMW have a life of approx. $10$ years and tend to have a trade in value of about $$55,000$ based on mileage. Based on the information provided, enter the BMW Depreciation Terms in cells Q$8$ to Q$10$

$13.$ In cells P$16$ to P$25,$ calculate the Straight$-$Line Depreciation.

$14.$ In cells R$16$ to R$25,$ calculate the new Depreciated Value of the Asset.

$15.$ In cells P$29$ to P$38,$ calculate the Declining Balance Depreciation.

$16.$ In cells R$16$ to R$25,$ calculate the new Depreciated Value of the Asset.

$17.$ In cells P$46$ to U$46,$ calculate the cumulative interest payments. In cells P$47$ to U$47,$ calculate the cumulative principal payments.

$($Hint: Cell U$48$ should reflect $$0\mathrm{.}00)$

$18.$ Navigate to the Monthly Income Statement worksheet.

Read Carefully: Through conversation with the client, we learned their Annual Salary is $$140,000.$ Additional Income includes investment returns in the amount of $$28,000$ from a rental property that is owned by a trust and $$11,500$ from instructing at the local college. The client is subject to a $32\%$ tax rate.

$19.$ In cells C$7$ to C$10,$ insert the appropriate information from above.

$20.$ In cell C$11,$ calculate the client$$s Total Gross Income.

$21.$ In cell C$12,$ calculate the client$$s Income after Taxes.

$22.$ In cell C$13$:C$14,$ calculate the monthly Income before Taxes. In cell C$15$:C$16,$ calculate the monthly Income after Taxes.

$23.$ Using the excel table we created on the Bank Statements Transactions worksheet, create a PivotTable, and place it in cell B$26.$

$24.$ Name of the Pivot Table to Allocated Expenses and adjust the fields list to display the following:

$$ Expense Category as Rows

$$ Date as Columns $($Month Only$)$

$$ Expense Amounts as Totals

$25.$ Format the PivotTable to include the following:

$$ Select PivotTable Style $$ Red, Pivot Style Medium

$$ Add Banded Rows to the Pivot Table

$$ Only show Total Averages for Rows.

$$ All Dollar Amounts in Accounting Format

$26.$ Insert a slicer for Bank Accounts between cells D$7$:G$9.$ The slicer should display two columns and have a Slicer Style of Rose, Slicer Style Dark $4.$

$27.$ Insert another slicer for Expense Category between cells D$11$:G$18.$ The slicer should display three columns and have a Slicer Style of Rose, Slicer Style Dark $4.$

$28.$ Insert a timeline slicer for the months January to December in between cells C$20$:G$25.$ The timeline slicer should reflect the following:

$$ Remove the Scrollbar, Selection Label, and Time Level

$$ Rename the timeline slicer to Expense Periods.

$29.$ Insert a Pie Chart through PivotCharts in cells B$44$:G$60$ and complete the following:

$$ Place the Pie chart to the left and the legend to the right.

$$ Add Data Labels displayed as percentages. $($Formatted to be easily read.$)$

$$ Place a black boarder around the entire chart.

$($Hint: Make sure all expense categories are visible in your chart.$)$

$30.$ In cell N$9$:N$11,$ using a reference, insert the clients Average Monthly Salary After Taxes.

$31.$ In cells N$15$:N$29$ using a variation of the IF Function, calculate the average monthly expense for each category using the Excel Table on the Bank Statement Transaction worksheet.

$32.$ In cell N$30$ using a reference, insert the BMW Car Loan Payment Amount.

$($Hint: If done correctly, the TOTAL GENERAL EXPENSES should display negative $$11,548\mathrm{.}69.)$

$33.$ In cell J$37$:N$39,$ write a response to the client detailing whether they should purchase this car for their birthday. Minimum Two Sentences.

$34.$ Navigate to the Question Prompt Worksheet.