Cougar Mountain Sports has prepared an adjusted trial balance for the fiscal year ended June 30, 2018. Notes to the adjusted trial balance are located below the totals. Use the blue shaded areas on the income statement worksheet for inputs.

1. Use Excel to prepare a multi-step income statement based on the adjusted trial balance. a. Use formulas to link the balances on the adjusted trial balance to the amounts on the income statement. Note that some balances an different areas of the Income Statement. For example, the Rent Expense is divided into two categories-Selling and Administrative. b. Use a formula to add and subtract account amounts as indicated. c. Format the numbers in the dollar columns with a comma and no decimal places (e.g. 5,460). Use a dollar sign at the top of each column and at the total (e.g. $26,201). Make sure the decimal places align. d. Double-underline the total. 2. Compute the gross profit margin percentage. Format percentages to two decimal places (e.g. 22.74\%). 1. Use Excel to prepare a multi-step income statement based on the adjusted trial balance. a. Use formulas to link the balances on the adjusted trial balance to the amounts on the income statement. Note that some balances are split between two different areas of the Income Statement. For example, the Rent Expense is divided into two categories-Selling and Administrative. b. Use a formula to add and subtract account amounts as indicated. c. Format the numbers in the dollar columns with a comma and no decimal places (e.g. 5,460). Use a dollar sign at the top of each column and at the total (e.g. $26,201 ). Make sure the decimal places align. d. Double-underline the total. 2. Compute the gross profit margin percentage. Format percentages to two decimal places (e.g. 22.74\%). Notes \#1 - 30% of the salaries is for the Administrative Offices. \#2- 20% of the rent is for the Administrative Offices. \#3-40\% of the utilities is for the Administrative Offices. \#4 - The Building houses the Administrative Offices. \#5- The Equipment is categorized as selling. \#6-50\% of the supplies is for the Administrative Offices. COUGAR MOUNTAIN SPORTS Income Statement Year Ended June 30, 2018 Operating Expenses: Selling Expenses: Total Selling Expenses Administrative Expenses