PLEASE READ CAREFULLY. I NEED HELP WITH THIS PROBLEM CREATING INCOME STATEMENT OF STOCKHOLDERS EQUTITY NOT A BALANCE SHEE. PLEASE PROVIDE STEP BY STEP. THANK YOU

Use the following checklist to help ensure adequate completion of each SLA. After you are "done" with your SLA, you should run through this list. If you need to go back and make changes, you should run through this list again after you make changes. Repeat this process until your SLA is truly complete & accurate. 1 The Excel file is properly named with the SLA #, your first initial, your last name. For example, my SLA 1 would be named "SLA 1 DAbelli". note: do not use the symbol # in your file name, it creates problems opening from Blackboard. Do rename as noted; otherwise file name too long & can't open when I download from Blkbd 21 have created new worksheets (tabs) next to the assignment tab to create my solution. note: do NOT use the original SLA worksheet. If you do, your assignment will be returned to you with a zero and only one chance to correct & resubmit for scoring asap 3 For every figure that comes from doing a calculation, I have used a formula in the cell to produce this figure. (not manually entered or copy/paste) 4 For every calculation that uses figures from other cells in the worksheet or another worksheet, I have used a cell reference in my calculation. (not manually entered or copy/paste) 5 For every figure or wording that comes directly from the assignment, I have used a cell reference to bring this information to my solution tab. (not manually entered or copy/paste) 6 For every narrative response, I have used proper cell formatting to ensure that my response can be read without any modification by the instructor. example: narrative should not run across a page in one line. If instructor cannot reasonably review, it will not be read 71 have formatted all cells that contain figures properly and appropriately. All dollar amounts have proper comma placement, and dollar sign placement if applicable xx,xxx or $xx,xxx All figures presented without O's after decimal (no pennies if dollars; no rounding; at least two decimals for all ratios and multiples xx.xx All percentages have proper percent sign placement xx.xx% The cell is the proper size to allow the entire number to show without modification by the professor (fix any column widths before submission) 8 I have re-read all questions and instructions on the SLA to be sure I have fulfilled all requirements. 9 All questions that call for "discussion" or "analysis" are fully answered. I did not simply restate the numbers the question refers to, but also provided a narrative explanation for my observations based on reference or facts. do not explain how the ratio was calculated; explain what the results mean, demonstrating your understanding 10I ran a spellcheck. spelling errors and typos distract from good work 11 My worksheets are visually appealing, easy to read/understand, and in good form as required RedBear Landscaping Company List of Accounts December 31, 2020 Cash 14,700 1,200 Accounts Receivable Supplies 10,000 Prepaid Expenses 8,000 Equipment 22,000 Vehicles 50,000 Office Furniture 5,000 Accumulated Depreciation 11,000 Accounts Payable 4,600 Accrued Expenses Payable 1,800 Note Payable (due in six months) 5,000 Loan Payable (due in five years) 44,500 Common Stock, $1 par 4,000 instructor notations Additional Paid in Capital 28,000 Retained Earnings 1,900 Dividends Declared (contra RE) Services Revenue 72,000 Wage Expense 28,800 Insurance Expense 7,200 Rent Expense 6,000 Advertising Expense 1,000 Depreciation Expense 11,000 Interest Expense 3,100 1,000 Income Tax Expense A group of four students started at the beginning of the year a new residential landscaping and snowplowing business, RedBear Landscaping Company (RBLC). The List of Accounts (before closing) is as of the end of their first year of business. Required: 1. From the List of Accounts, prepare a well-formatted, classified income statement for the year ended as noted. 2. After a year in business, the company asks you to measure how effectively sales and expenses of the business are being managed. Compute the (a) Net Profit Margin (NPM) for the company; (b) average NPM for the Industry; and (c) compare, $ A group of four students started at the beginning of the year a new residential landscaping and snowplowing business, Red Bear Landscaping Company (RBLC). The List of Accounts (before closing) is as of the end of their first year of business. Required: 1. From the List of Accounts, prepare a well-formatted, classified income statement for the year ended as noted. 2. After a year in business, the company asks you to measure how effectively sales and expenses of the business are being managed. Compute the (a) Net Profit Margin (NPM) for the company; (b) average NPM for the Industry; and (c) compare, analyzing your results in a narrative. This ratio analysis should be calculated/performed directly on the Income Statement. The following industry data is available: 125,700 Total assets $ Total liabilities Total equity 43,300 82,400 Sales revenue 92,500 Net income 22,750 3. Prepare a well-formatted Statement of Stockholders' Equity for the year ended as noted. Separate Worksheet Reminder: use a separate worksheet for the IS and for the SSE, labeling both worksheets appropriately