Requirements:

Using the data below and T$-$accounts, convert the cash basis income statement to accrual basis in appropriate professional Excel format $($i$.$e$.,$ use cell referencing and formulas, no hard coding numbers$).$

In the T$-$accounts and Income Statement, all account titles should be added using cell referencing. See the first T account for an example.

T$-$accounts should have a beginning and ending balance, as well as a description of what transaction increases and decreases the account. See the first T$-$account for an example.

Grading: This assignment is grading on the following:

Solution $-$ Income statement in good single$-$step format $(4$ points$).$ Note the expenses may be in any order.

Appropriate use of Excel $-$ Use of cell references for labels, account names and amounts if given in problem data and use of formulas for all calculations $(3$ points$).$

Hint: For T$-$accounts, you can solve for any one unknown

For normal debit balance account:

Beginning Balance

Debits

Credits

$=$ Ending Bolance

For normal cradit balance account:

Beginning Balance

Credits

Debits

$=$ Ending Balance

I need help from someone to show me how to calculate everything for this assignment, I CANNOT just type it in$,$ it HAS to be calculated through Excel, so please do not just write the numbers down, please show ALL calculations.