s File Edit Insert Table Organize Format Arrange View Share Window Help 05 Problem 3 125% Table Chart Adjusted Trial Balance ncome Statement 22pts This spreadsheet has missing fonts. Show Chapter 5 Prepare a multi-step income statement Winterpark Sports has prepared an adjusted trial balance for the fiseal year ended June 30, 2018. Notes to the ad justed trial balance are located the blue shaded areas on the income statement worksheet for inputs ALL BLUE SHADED AREAS SHOULD BE USED. 1. Use Excel to prepare a multi-step income statement based on the adjusted trial balance Use formulas to link the balances on the adjusted trial balance to the amounts on the income statement. Note that some balances are of the Income Statement. For examplie, the Rent Expense is divided into two categories-Selling and Administrative b Use a formula to fod and subtract account amounts as indicated 2.Compute the gross profit margin percentage. BONUS If you do not whh to use formulas you may simply type your answers in to the income statement. it may be helpful to print the adjunsted trial balance for easy 80 Do s File Edit Insert Table Organize Format Arrange View Share Window Help 05 Problem 3 125% Table Chart Adjusted Trial Balance ncome Statement 22pts This spreadsheet has missing fonts. Show Chapter 5 Prepare a multi-step income statement Winterpark Sports has prepared an adjusted trial balance for the fiseal year ended June 30, 2018. Notes to the ad justed trial balance are located the blue shaded areas on the income statement worksheet for inputs ALL BLUE SHADED AREAS SHOULD BE USED. 1. Use Excel to prepare a multi-step income statement based on the adjusted trial balance Use formulas to link the balances on the adjusted trial balance to the amounts on the income statement. Note that some balances are of the Income Statement. For examplie, the Rent Expense is divided into two categories-Selling and Administrative b Use a formula to fod and subtract account amounts as indicated 2.Compute the gross profit margin percentage. BONUS If you do not whh to use formulas you may simply type your answers in to the income statement. it may be helpful to print the adjunsted trial balance for easy 80 Do