Question: Hi teachers! Please help me with this based on the second pic (model)! Thanks! You will need Green file to finish this assignment, this file
Hi teachers! Please help me with this based on the second pic (model)! Thanks!
You will need Green file to finish this assignment, this file is attached and also in module files. Your job is to finish the following tasks: 1. Open the Green workbook, and then save the workbook as Green Clean in the location specified by your instructor. 2. In the Documentation sheet, enter your name in cell B3 and the date in cell B4. 3. Display the date in cell B4 in the Long Date format and left-aligned. 4. Change the theme of the workbook to Facet. 5. Make the following formatting changes to the Documentation sheet: a. Merge and center cells A1 and B1. b. Apply the Accent2 cell style to the merged cell A1 and to the range A3:A5. c. In cell A1, set the font size to 22 points and bold the text. Italicize the word Clean in the company name. d. Add borders around each cell in the range A3:35. Top-align the text in the range A3:B5. e. Change the font color of the text in the range B3:B5 to Dark Green, Accent 2. Green Clean Homes Author Date Purpose To develop a projected income statement for Green Clean Homes Green Clean Homes Financial Assumptions Gross Sales Projected Income Income Gross Sales Cost of Sales Gross Profit 305718 61143.6 12 4 29 251 20% 4 16 Cost of Sales Payroll Operating Expenses Salaries Taxes and Benefits Employee Insurance Overhead Advertising Supplies Lease interest Total Operating Expenses Projects per Day Hours per Project Hourly Charte Annual Working Days Percent of Gross Sales Hired Cleaners Hourly Rate Hours per week WeeksperYear FICA Tax Rate Owners Liability Workman's Como Telephone 112000 7280 4440 5280 2700 9600 50 E.SK 210 Monthly Employee Insurance Monthly Overhead 2640 Monthly Advertising Monthly Supplies Total Operating Profit/Loss income Taxes Net Profit/Loss Internet Commercials and Notices Cleaning Solutions Raps and Brushes Miscellenous Monthly Lease Loan Interest Corporate Tax Rate 225 350 250 200 270 Lease interest Taxes 31.0%

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
