90.2K

Verified Solution

Link Copied!

Please help show the excel work

$1)$ Using the data below, create a multi$-$step GAAP Income Statement in appropriate protessional Excel tormat $($i$.$e$.,$ use cell reterencing and tormulas, 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 $\backslash (\backslash \%\backslash )$ of the $51$ cells that are completed correctly.

Tips:

$1)$ The P$\backslash$&L header should start in cell F$24$ and the first line of data should be in row $28.$ The Earnings Per Share header should be in cell F$49$ with the first line of data in row $50.$

$2)$ All expenses should be reported as negative numbers

$3)$ If there is more than one line item in a category in the P$\backslash$&L where there is flexibility in the order, list the line items in alphabetical order

$4)$ All labels should be included in column F and all amounts should be included in column G

$)$ When formatting cells in a financial worksheet, it is customary that the first and last numbers have $\backslash (\backslash$$ $\backslash ),$ but all numbers are comma format.

$5)$ Earnings Per Share should be taken to two decimal places

Answer & Explanation Solved by verified expert

See Answer