Reference no: EM131229677
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
|
Compute more than a lower-level programming language
: Can a higher-level programming language instruct a computer to compute more than a lower-level programming language?
|
|
What is involved in performing the eight key managerial task
: Explain what role a company's culture plays in executing these managerial tasks. Discuss what is involved in performing the eight key managerial tasks that shape the process of implementing and executing strategy.
|
|
What are the two scores that applicants must score
: Therefore, they administer a screening test to all job applicants and decide to eliminate from consideration anyone scoring in the bottom or top 15%. If scores are normally distributed with a mean of 40 and a standard deviation of 8, what are the ..
|
|
What property does this sentence demonstrate
: John said, "I saw the man in the park with a telescope." What did he mean? How many reasonable interpretations can you provide for this statement? List them. What property does this sentence demonstrate that makes it unacceptable as a statement in..
|
|
Calculate ending retained earnings
: Module 3 Assignment 2 Excel Workbook Assignment - MFE 6100 - 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
|
|
Finding the critical path for a project
: When creating activities on node, and after finding the critical path for a project, if you need to crash a project, can you only choose time reductions from the critical path/paths?
|
|
Describe the ethical model being used by the company
: Describe ethical model being used by company. Present your overall opinion of organization's corporate strategy approach. Is strategy execution effort delivering the expected results? Explain and illustrate your conclusions.
|
|
Are natural languages capable of expressing algorithms
: For each characteristic of an algorithm, give an example of a procedure that does not have the characteristic, and is therefore not an algorithm.
|
|
Hospital needs to consider in layout design
: Identify the many variables that a hospital needs to consider in layout design.
|