home / study / business / accounting / accounting questions and answers / for this assignment, you will use your accounting knowledge and spreadsheet skills to prepare ... Question: For this assignment, you will use your accounting knowledge and spreadsheet skills to prepare com... For this assignment, you will use your accounting knowledge and spreadsheet skills to prepare comparative multi-step income statements, including common size information. Problem Information: The owners of Cyclepath Bicycle Store have asked you to prepare comparative income statements for the fiscal years ended March 31, 2016 and 2017. To aid in their analysis, the owners would also like you to provide common size information with the comparative statements (vertical analysis). They have provided an alphabetical list of account names and balances for the store on the second page. All accounts have normal balances. Guidelines: 1. Use Excel to prepare a professional work product for the owners. Fit the financial information on one worksheet in print-ready form. 2. Refer to the format on the third page to prepare Cyclepaths income statements. Notice that it uses the multi-step format and also includes columns for common size information. Use the numbers provided as check figures. 3. Refer to chapter 4 of the Edmonds textbook if you are not sure what should be classified as Nonoperating Items. 4. List expense accounts separately and show expenses as negative numbers. 5. Provide common size information for all statement line items, not just subtotals and totals. 6. Format numbers as follows: Use commas Use brackets ( ) for negative numbers Use whole numbers (zero places behind the decimal point) Right align; do not center Use dollar signs ($) where appropriate on the financial statements Use two decimal places (e.g., 50.46 and 8.42) for the common size information Pay attention to the placement of underlines, both single and double, and centering of column headings 7. Make use of Excel formulas wherever possible. This assignment is worth 50 points, allocated as follows: Correct numbers for income statements 22 Correct common size percentages 8 Use of formulas 8 Professional appearance 12 50 2 Cyclepath Bicycle Store Account Balances 3/31/16 3/31/17 Accounts Payable 30,600 22,700 Accounts Receivable 25,100 45,200 Building 162,000 166,800 Cash 7,500 12,600 Common Stock 48,000 48,000 Cost of Goods Sold 189,300 205,800 Dividends 3,000 4,000 Equipment 52,000 58,000 Gain on Sale of Land 0 4,000 Insurance Expense 9,000 10,500 Interest Expense 3,000 4,200 Interest Payable 1,000 1,600 Interest Receivable 2,000 0 Interest Revenue 2,000 400 Inventory 28,300 34,800 Land 89,000 62,000 Miscellaneous Expense 2,000 500 Notes Payable 60,000 75,000 Prepaid Insurance 8,000 9,500 Rent Expense 6,000 6,200 Retained Earnings 214,300 230,000 Salaries Expense 32,000 35,300 Salaries Payable 3,300 1,500 Sales 295,000 315,000 Sales Returns & Allowances 11,000 9,000 Shipping Expense 8,000 9,000 Supplies 4,000 6,000 Supplies Expense 9,000 11,500 Telephone Expense 4,000 4,800 Unearned Revenue 5,000 4,400 Utilities Expense 5,000 6,900 3 Use the following format to assist you in preparing the owners request Can you please use an excel spreadsheet with formulas