RedBear Landscaping Company List of Accounts December 31, 2020 1 2 3 4 5 Cash $ 14,700 6 Accounts Receivable 7 Supplies 8 Prepaid Expenses 9 Equipment 10 Vehicles 1,200 10,000 8,000 22,000 50,000 11 Office Furniture 5,000 12 Accumulated Depreciation 11,000 13 Accounts Payable 4,600 14 Accrued Expenses Payable 1,800 15 Note Payable (due in six months) 5,000 16 Loan Payable (due in five years) 44,500 17 Common Stock, $1 par 4,000 instructor notations 18 Additional Paid in Capital 28,000 19 Retained Earnings 20 Dividends Declared (contra RE) 1,900 21 Services Revenue 72,000 22 Wage Expense 28,800 23 Insurance Expense 7,200 24 Rent Expense 6,000 25 Advertising Expense 1,000 26 Depreciation Expense 11,000 27 Interest Expense 28 Income Tax Expense 3,100 1,000 29 30 31 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 32 Required: 33 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 34 (c) compare, analyzing your results in a narrative. This ratio analysis should be calculated/performed directly on the Income 35 The following industry data is available: 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 2 I 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 7 I 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 0'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 10 I 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