2:57

2:57 < Comparative Income... The owners Of Cyclepath Bicycle Store have aski you to cornparative income statements for the fiscal years ended March 31. 2016 and 2017 _ To aid in their analysis, the (Mners would also like you to size lforrnatbn with the comparative statements (vertical analysis). They have provded an alphabetical list Of account names and balances for on the par. A' have mrrnal balances. Guide' ines: I. use Excel to prepare a professional the owners. Fit the fmancial hformation on one worksheet in print-ready fTn. 2. Refer to the format on the third page to "eWe Cycle-path's incorne statements. Notice that it uses the multi-step format ard includes columns for cornrnm size information. use the numbers provded as figures. 3. Refer to chapter 4 of the if you are not sure what classified as Nonoperating Items. 4. List expense accounts separately and stX'w as negative 5. provide cornmon size information for line nems, subtotals and 6. Format numbers as follows: use commas use ( ) for negative use Whole numbers (zero places decimal point) Right align: do not center use dollar signs (S) *Ere me financial statements use two decnal plas S046 8.42) for the common size inforrnatn Pay attention to the placement Of both sir* and double. and centering of column headings 7. Make use Of Excel formulas This assignment is worth 50 points. as foibws. Correct mners irrome Correct size perceNages use of formulas Professiorul appearame 22 8