Background Information:
Been Carded, Ltd.'s 2015 Balance Sheet and 2016 Pre-Closing Trial Balance are presented here. Based on these data, complete the Module 3 Assignment 2 on the following Excel worksheets. You must properly link all data included in your solution to receive full credit for your work.
A. Complete a Multiple-Step Income Statement for 2016 based on the Background Information provided. You should have a separate line item for each Account item included. (12 points- graded for accuracy and format, including Excel spreadsheet links)
B. Calculate ending Retained Earnings based on the background information and your Net Income calculated in part B. Show your calculations using a Statement of Retained Earnings (5 points- graded for accuracy and format, including Excel spreadsheet links).
C. Complete a comparative classified Balance Sheet for December 31, 2016 and 2015 based on the background information provided. (18 points-graded for accuracy and format, including Excel spreadsheet links).
D. Calculate Basic Earnings per Share for Been Carded, Ltd. Show the formula using words and also show the numbers used in your calculations (3 points-graded for accuracy and format, including Excel spreadsheet links).
E. Based on your Been Carded, Ltd. Income Statement, calculate the Gross Margin Percentage and Profit Margin Percentage. Show your formulas using words and also show all numbers used in your calculations. All amounts used in the ratios must be properly linked to the Income Statement.
Attachment:- Assignment Excel Workbook.xlsx