write my assignment 27180

I do not know how to do some of these formulas. How can I find the formulas in this assignment?

Independent Challenge !You are thinking of starting a small coffee shop where locals can gather . Before you begin , you need to evaluate what Youthink your monthly expenses will be . You’ve started a workbook , but need to complete the entries and add formulas .. Open EX 2 – 3. XIs x from the location where you store your Data Files , then save it as EX 2 – CoffeeShop Expenses .6 . Make up your own expense data , and enter it in cells $ 4 : B10. ( Monthly sales are already included in theworksheet . )C. Create a formula in cell C 4 that calculates the annual rent .d. Copy the formula in cell C 4 to the range C 5 : C10 .C . Move the label in cell A 15 to cell A14 .{. Create formulas in cells $ 1 1 and C1 1 that total the monthly and annual expenses .8. Create a formula in cell C13 that calculates annual sales .M . Create a formula in cell $ 1 4 that determines whether you will make a profit or loss , then copy the formula intocell C1 4 .1 . Copy the labels in cells B 3 : C3 to cells E3 : F3 .1. Type Projected Increase in cell GI , then type . 2 in cell H 2 .K. Create a formula in cell EA that calculates an increase in the monthly rent by the amount in cell H2 . You will becopying this formula to other cells , so you’ll need to use an absolute reference .1 . Create a formula in cell $ 4 that calculates the increased annual rent expense based on the calculation in cell $4 .m . Copy the formulas in cells $4 : $4 into cells ES : F10 to calculate the remaining monthly and annual expenses .M . Create a formula in cell Ell that calculates the total monthly expenses , then copy that formula to cell F ]] .0 . Copy the contents of cells B 13 : C13 into cells E13 : F13 .`p. Create formulas in cells $1 4 and FI4 that calculate profit / loss based on the projected increase in monthly andannual expenses .9. Change the projected increase to . 17 , then compare your work to the sample in FIGURE 2 – 24 .r . Enter your name in a cell in the worksheet .S. Save your work , preview the worksheet in Backstage view , submit your work to your instructor as directed , closethe workbook , and exit Excel .FIGURE 2 – 24Your formulas go here cDEFGHEstim ( your formula results ._insesProjected Increase2will differ )0. 17Monthly AnnuallyMonthly Annually4| Rent$509|3.00002925351005 Supplies1500 W|192001872224646 MilkBEOO4.3200421250544|7 Sugar134 0156001521182528 Pastries85%10200994.5119349 Coffee84241213 Sales10 Utilities1 1 Total14 Profit / Loss1120013:300124500720015960013:44002940003:000Working with Formulas and Functions$50702230009896877.513104276000105.30118752157248