please show formulas used in excel . chegg does not take pdf files must upload by image.

complete (a) on first worksheet (b-k) on second worksheet (L) on third worksheet (m-n) on forth worksheet. (o) on fifth worksheet

COMPUTER EXERCISES 5-1. We Love Plants, Inc. is a small company in the houseplant care business. People can arrange for the company to come into their apartment or house to care for their plants when they are away on business or on vacation or all-year around. The company has begun offering the same service to businesses and offices. The most recent Income Statement for the company is as follows. WE LOVE PLANTS, INC. Income Statement For the Year Ended December 31 Revenues: Home plant care revenue Office plant care revenue Total Revenues $197,329 65,545 $262,874 Expenses: Salaries expense Payroll tax expense Rent expense for office Utilities expense Advertising expense Automobile expense Supplies expense Misc. expense 72,488 9,803 7,800 1,377 23,103 35,292 24,550 8,500 OPERATIONS ON CELLS | 101 Total Expenses $182,913 Pretax Income Income tax expense $79.961 15.992 Net income $63.969 Earnings per share $1.60 The company pays 20% in income taxes. There are 40,000 shares of stock. (a) Create a "template" worksheet for the Income Statement where each of the numbers in the middle column is 0. All of the numbers in the right column should be the results of formulas and should appear as 0 also. The numbers should be formatted as they appear above. Save the worksheet on the disk. (b) Now fill in the numbers in the middle column. The numbers in the right column should match. Save the worksheet. (c) Select a rectangular range of cells that includes all of the non-blank cells by dragging across the cells. Move this entire range of cells two columns to the right and one row down. (d) Erase the first four of the expenses categories and values by selecting the range containing the cells and dragging the Fill Handle back over the range. (e) Undo the erase. (1) Delete columns A and B. (They should be empty as the result of the move in part (c).) (g) Insert a new row in the middle of the expenses. Enter in Insurance Expense 7,300. (h) Attach the comment "We need to get better control of these." to the cell for Misc. Expense. 0 Select the information in the two columns of numbers by dragging across it. Then click on the Copy button in the Clipboard group of the Home tab. Click on the cell two columns to the right of the top right cell of the copied range. Now click on the Paste button in the Clipboard group of the Home tab to paste a new copy of the information two columns over. This could be used as the basis for entering in next year's income statement to compare it with this year's (0) Erase what was just pasted either by selecting Undo or by erasing the range of cells. (k) Save the worksheet () Format the worksheet as a table with striped rows. Save the worksheet under a different name 102 | CHAPTER 5 as (m) Retrieve the worksheet from (k). Format the worksheet so that it looks as attractive possible. Save the worksheet. (n) Add a link to an appropriate site about home plants. (0) Assume that the Expenses remain the same. Use Goal Seek to determine the Total Revenues required for the company to earn $2.00 per share. Save the worksheet under a different name. COMPUTER EXERCISES 5-1. We Love Plants, Inc. is a small company in the houseplant care business. People can arrange for the company to come into their apartment or house to care for their plants when they are away on business or on vacation or all-year around. The company has begun offering the same service to businesses and offices. The most recent Income Statement for the company is as follows. WE LOVE PLANTS, INC. Income Statement For the Year Ended December 31 Revenues: Home plant care revenue Office plant care revenue Total Revenues $197,329 65,545 $262,874 Expenses: Salaries expense Payroll tax expense Rent expense for office Utilities expense Advertising expense Automobile expense Supplies expense Misc. expense 72,488 9,803 7,800 1,377 23,103 35,292 24,550 8,500 OPERATIONS ON CELLS | 101 Total Expenses $182,913 Pretax Income Income tax expense $79.961 15.992 Net income $63.969 Earnings per share $1.60 The company pays 20% in income taxes. There are 40,000 shares of stock. (a) Create a "template" worksheet for the Income Statement where each of the numbers in the middle column is 0. All of the numbers in the right column should be the results of formulas and should appear as 0 also. The numbers should be formatted as they appear above. Save the worksheet on the disk. (b) Now fill in the numbers in the middle column. The numbers in the right column should match. Save the worksheet. (c) Select a rectangular range of cells that includes all of the non-blank cells by dragging across the cells. Move this entire range of cells two columns to the right and one row down. (d) Erase the first four of the expenses categories and values by selecting the range containing the cells and dragging the Fill Handle back over the range. (e) Undo the erase. (1) Delete columns A and B. (They should be empty as the result of the move in part (c).) (g) Insert a new row in the middle of the expenses. Enter in Insurance Expense 7,300. (h) Attach the comment "We need to get better control of these." to the cell for Misc. Expense. 0 Select the information in the two columns of numbers by dragging across it. Then click on the Copy button in the Clipboard group of the Home tab. Click on the cell two columns to the right of the top right cell of the copied range. Now click on the Paste button in the Clipboard group of the Home tab to paste a new copy of the information two columns over. This could be used as the basis for entering in next year's income statement to compare it with this year's (0) Erase what was just pasted either by selecting Undo or by erasing the range of cells. (k) Save the worksheet () Format the worksheet as a table with striped rows. Save the worksheet under a different name 102 | CHAPTER 5 as (m) Retrieve the worksheet from (k). Format the worksheet so that it looks as attractive possible. Save the worksheet. (n) Add a link to an appropriate site about home plants. (0) Assume that the Expenses remain the same. Use Goal Seek to determine the Total Revenues required for the company to earn $2.00 per share. Save the worksheet under a different name