Apps Microsoft Word - Week8 Capstone_Scenario.docx 1 13 Step 1: Complete Income Statement It is time to build the formulas nceded to complete the income statement. Begin working on the Income Statement worksheet and complete formulas for all of the cells marked in gray A. Enter the formula to calculate the Condo Rentals Revenue in C13 Multiple the Quantity of Condo Rental Days the Price for Condo Rental B. Enter the formula to calculate the Ski Lift Revenue in C14 Multiple the Quantity of Ski Lift Tickets the Price for Ski Lift Tickets C. Enter the formula to calculate the Winter X Games Revenue in C17 Multiple the Quantity of X Games Ticketsthe Price for X Games Tickets D. Enter the formula to calculate the Total Revenues in C20 and Total Expenses in C34 E. Make sure the cell references for Total Revenues and Total Expenses are placed in cells C37 and C38 respectively. F. Enter the formula to calculate the Net Income in cell C39 G. Apply professional formatting to all of this data using the image below as a guide. Step 2: Build the One-Variable Data Tables thumbnail (1).jpg Show all | Apps Microsoft Word - Week8 Capstone_Scenario.docx 1 13 Step 1: Complete Income Statement It is time to build the formulas nceded to complete the income statement. Begin working on the Income Statement worksheet and complete formulas for all of the cells marked in gray A. Enter the formula to calculate the Condo Rentals Revenue in C13 Multiple the Quantity of Condo Rental Days the Price for Condo Rental B. Enter the formula to calculate the Ski Lift Revenue in C14 Multiple the Quantity of Ski Lift Tickets the Price for Ski Lift Tickets C. Enter the formula to calculate the Winter X Games Revenue in C17 Multiple the Quantity of X Games Ticketsthe Price for X Games Tickets D. Enter the formula to calculate the Total Revenues in C20 and Total Expenses in C34 E. Make sure the cell references for Total Revenues and Total Expenses are placed in cells C37 and C38 respectively. F. Enter the formula to calculate the Net Income in cell C39 G. Apply professional formatting to all of this data using the image below as a guide. Step 2: Build the One-Variable Data Tables thumbnail (1).jpg Show all |