I also need help with the income statement, I cannot figure it out.

Please Include formulas used !

Case 5 - Baylee Byrd Playsets Inc 60 points Instructions: 1. This is an individual assignment. You must work on it on your own. Do not share your work with anybody else. 2. Read the Baylee Byrd Playsets case (pages 79 to 86 ) from the case book and complete the requirements below. 3. All required data are in the case. 4. Refer to the excel help videos provided on Canvas. 5. Format the worksheet with borders, highlight the column headings and include a title for the spreadsheet. 6. Indicate your name in the spreadsheet and in the file name as well. 7. Your submission must be professional and well presented with adequate formatting. 8. NO CREDIT GIVEN IF THE SPECIFIED FORMULAS AND FUNCTIONS ARE NOT USED. DO NOT MODIFY THE NUMBERS IN YOUR TABLES/CHARTS BY TYPING IN THE NUMBERS. 9. UPLOAD YOUR COMPLETED EXCEL SPREADSHEET ON CANVAS. 1. Develop an income statement based on the inputs provided in the case- Refer to Table 1 on Page 82 for the inputs. 2. Compute the ratios shown below. Refer to Figure 4 (Page 84) in the case for required formulas. Create this table in the same worksheet as the income statement. 3. Mr. Byrd wants to examine the impact of various target income levels on the breakeven point. What would be the impact of the following target incomes ($15,000,$20,000,$25,000,$30,000,$35,000 and $40,000) on the break-even point? Create a one-variable data table for this purpose. Create this table in the same worksheet as the income statement. 4. Mr. Byrd wants to see how the following scenarios impact the business's net income. Refer to the last paragraph on Page 84 for the two scenarios. Add these two scenarios to the scenario manager and solve. Display the summary in a separate worksheet. Use SCENARIO MANAGER. 5. Mr. Byrd wants a net margin ratio of 15%. Using Excel's Solver, adjust the values for the Revenue per unit and Number of units sold. Revenue per unit cannot exceed $1100; number of units sold cannot exceed 250 ; and total variable expenses cannot exceed $110,000. - In order to have a net margin of 15%, how many playsets will Mr. Byrd have to sell? - What price should he charge? Generate an answer report and display it on a separate worksheet. You have to use the input summary and income statement from question 1 for the solver function. Use Excel's Solver function