Business Finance Homework Help

Requirements: 1) Complete adjusted trial balance of worksheet; 2) Use your completed worksheet to prepare (a) multi-step Income Statement, (b) Statement of Owner’s Equity and (c) balance sheet as of Dec-31-20; 3) HINT: (a) Sort the data by chart of account number, then (b) review totals for reasonableness. 4) You just received a promotion. However, before you can accept your new position, you must provide your successor (or replacement) with instructions on how to complete one of your tasks for which you will no longer complete. Your replacement is not familiar with excel so you want to provide clear instructions. Assignment: Prepare memos addressed to the management of Pat’s Retail Store which provide: a) A step-by-step guide documenting how to use excel to prepare an adjusted trial balance in excel for this company. Start with the first tab where you must insert your name. Next, go to the second tab which displays the unadjusted trial balance sorted alphabetically by account name. List steps and excel commands necessary to complete the adjusted trial balance for this company. (Do not explain how to prepare the financial statements.) b) An evaluation of the company’s financial performance assuming this is the first completed year of operations. Select, calculate and discuss 3 financial ratios (e.g. profit margin, quick ratio) for this company. (Font: Times Roman, single spaced, 12 pts). Please make any assumptions to support your claim.