URGENT!!

Please complete all questions (1 - 4) in Excel, please show equations used.

Using the Assumptions provided below for the UWP Corporation, complete their Balance sheet for the period ending December 31,2020 Note: For this Financial Statement, you will need to (1). DETERMINE which Bolance Sheet items, from the list below, corresponds to which headings / sub-headings in column B. Multigles moy apply (2). Then, place the corresponding 55 amount/S) in the tally field (column D). HINT! Amounts are already correct for each item (3). Create the Excel formula that calculates and tallies the totals in column D [4]. All assumptions should be used Statement of Financial Position as at 31st December 2020 UWP Corporation (The balance sheet) Assets Non-current assets Current assets $ Total assets 5 Equity and liabilities Equity Total equity $ Non-current liabilities Current liabilities \begin{tabular}{ll} \hline$ & \\ \hline$ & \\ \hline$ & \\ \hline$ & \\ \hline \hline \end{tabular} Using the Assumptions provided below for the UWP Corporation, complete their Balance sheet for the period ending December 31,2020 Note: For this Financial Statement, you will need to (1). DETERMINE which Bolance Sheet items, from the list below, corresponds to which headings / sub-headings in column B. Multigles moy apply (2). Then, place the corresponding 55 amount/S) in the tally field (column D). HINT! Amounts are already correct for each item (3). Create the Excel formula that calculates and tallies the totals in column D [4]. All assumptions should be used Statement of Financial Position as at 31st December 2020 UWP Corporation (The balance sheet) Assets Non-current assets Current assets $ Total assets 5 Equity and liabilities Equity Total equity $ Non-current liabilities Current liabilities \begin{tabular}{ll} \hline$ & \\ \hline$ & \\ \hline$ & \\ \hline$ & \\ \hline \hline \end{tabular}