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

hucinace

Required: $2$ worksheets per instructions below, plus ratio comparison $($no narrative$)$

From the List of Accounts, prepare a well$-$formatted, multi$-$step income statement for the year ended as noted.

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 Income Margin $($NIM$)$ for the company; $($b$)$ average NIM for the Industry; and $($c$)$

compare and state which one is better. This ratio analysis should be calculated$/$performed directly on the Income

Statement and MUST be two decimal places xx$.$xx$\%$

The following industry data is available:

Prepare a well$-$formatted Statement of Stockholders' Equity for the year ended as noted on a Separate Worksheet

$-->$ you may copy appropriate SSE template $($in Bb$)$ into your Excel file. Must remove template info, add$/$link data.

Reminder: use a separate worksheet for the IS and for the SSE, labeling both worksheets appropriately.

Common Errors, fix before submit: IS does not contain $3$ subtotals & $1$ total; NIM not calculated for both

company & industry; didn't identify which ratio better; SSE does not contain formatted beginning balances

$($even if zero, should be shown $$0$ or $ $-$ depending on format. Net Income in the SSE not linked to your IS$.$