Question: please include all the possible ditails if posible formulas too 1) Using the data below, create a multi-step GAAP Income Statement in appropriate professlonal Excel
1) Using the data below, create a multi-step GAAP Income Statement in appropriate professlonal Excel format (i.e., use cell referencing and formulas, no hard coding numbers). 2) All account titles and subtotals should be added using cell referencing. Grading: 10 possible points This spreadsheet contains macros which will provide real time feedback on EACH cell that you enter in the Solution. There are 51 cells which get graded, and your score on this assignment will be calculated based upon the % of the 51 cells that are completed correctly. Tips: 1) The P\&L header should start in cell F23 and the first line of data should be in row 27 . The Earnings Per Share header should be in cell F48 with the first line of data in row 49 2) All expenses should be included as negative numbers 3) If there is more than one line item in a category in the P\&L where there is flexibility in the order, list the line items in alphabetical order 4) All amounts should be included in column G 5) Earnings Per Share should be taken to two decimal places
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
