$1.$ Save As$$PA$2\_$Lawn Care.

$2.$ Switch to the Annual Plan worksheet.

$3.$ Enter the following data into cells B$14,$ B$15,$ and B$16$:

Gasoline cost $($per cut$)=$ $$10$

Number of customers $=30$

Annual lawn cuts per customer $=20$

$4.$ In cell B$3,$ enter the average price per lawn cut of $$50.$

$5.$ In cell B$4,$ write a formula that calculates the total number of lawns cut in the year.$$This is the number of customers multiplied by the annual lawn cuts per customer.

$6.$ In cell B$5,$ write a formula that calculates the total annual sales.$$This is found by multiplying the average price per lawn by the total number of lawn cuts.

$7.$ In cell B$8,$ write a formula to calculate the total cost of gasoline for the year.$$This is found by multiplying the gasoline cost per cut by the total number of lawns cut.$$

$8.$ You will finish the rest of this worksheet after completing the Equipment Loans worksheet.

$9.$ Switch to the Equipment Loans worksheet.

$10.$ In cell E$3,$ write a PMT function to calculate the monthly payment for the Commercial Lawn Mower.$$Don$$t forget the negative sign in between the equal sign and the PMT$!$ Remember to convert the interest rate and years to monthly terms and to use cell references.$$The arguments of the PMT function should be as follows:

RATE: B$3/12$

NPER: C$3*12$

PV: D$3$

$11.$ Copy the PMT function from cell E$3$ to the other equipment items.

$12.$ In cell E$10,$ use the SUM function to calculate the total for the monthly loan payments. Make sure that the blank rows $(7$ through $9)$ were included in the range for the SUM function so that you can add more equipment items later if needed.

$13.$ In cell E$11,$ write a formula that calculates the total$$annual$$loan payments.$$This will be the monthly total multiplied by $12($the number of months in a year$).$

$14.$ If needed, apply Accounting format to all of the monetary values so that the placement of the dollar sign is consistent throughout the worksheet.

$15.$ Sort the data in the range A$3$:E$6$ first by$$Interest Rate$$and then by$$Loan Amount$$using the following steps:

Select the range A$3$:E$6.$

Click the Sort button in the Data tab of the Ribbon.

In the Sort dialog box, select the Interest Rate option in the $$Sort by$$ drop$-$down box. Select Largest to Smallest for the sort order.

Click the Add Level button in the Sort dialog box.

Select the Loan Amount option in the $$Then by$$ drop$-$down box. Select Largest to Smallest for the sort order.

Click the OK button in the Sort dialog box.

$16.$ Add a header with the date on the left and the worksheet name on the right.$$ Be sure to insert the date and worksheet name so that they will automatically update.

$17.$ Check Print Preview and make any other changes necessary for professional printing.

$18.$ Switch back to the Annual Plan worksheet.

$19.$ In cell B$9,$ write a formula that displays the annual monthly payments total from cell E$11$ in the Equipment Loans worksheet using the following steps:

$$Type an equal sign$=$

Click the$$Equipment Loans$$worksheet

Click cell E$11$

Press the ENTER key

$20.$ In cell B$10,$ calculate the Total Expenses by adding the Gasoline Cost and the Annual Equipment Payments.

$21.$ In cell B$12,$ calculate the Annual Profit by finding the difference between the Total Annual Sales and the Total Expenses.$$Hint: This will hopefully be a positive number which shows that your business is making money instead of losing money.

$22.$ Format all cells that contain monetary amounts in the Annual Plan worksheet for Accounting Number Format $($$$)$ with no decimal places. Format all other numerical values as Comma format with no decimal places.

$23.$ Add a header with the date on the left and the worksheet name on the right.$$ Be sure to insert the date and worksheet name so that they will automatically update.

$24.$ Check Print Preview and make any changes necessary for professional printing.

$25.$ Check the spelling on all of the worksheets and make any necessary changes. Do not delete the instructions sheet. Submit to the D$2$L Brightspace assignment area "Microsoft Excel: Practice Activity Two"