Instructions 1. Review all the materials associated with completing this assignment (Before you complete this assignment, you will need to review all of the Financial Statement Review materials)....

Please complete the enclosed assignment. Can you please help with this? Thank you!!


Instructions 1. Review all the materials associated with completing this assignment (Before you complete this assignment, you will need to review all of the Financial Statement Review materials). HINT: net margin is the same as the net profit ratio. - SINCE MOM'S BURGERS RATIOS ARE FROM 2017, COMPARE ONLY TO THE FAST FOOD COMPANIES THAT HAVE PROVIDED 2017 DATA WITHIN THE PROVIDED EXCEL SPREADSHEET WITHIN THIS ASSIGNMENT AND THAT IS THE DATA YOU WILL USE FOR YOUR RATIO COMPARISON. 2. Make sure you have read the Mom’s Burgers case. 3. Review the case and the question posed (Amy knows her numbers but needs your help to understand how Mom’s Burgers is doing against the competition). 4. Conduct a case analysis (comparing her ratios to the industry, draw conclusions, and present your findings). MAKE SURE I CAN SEE/ACCESS ALL OF THE FORMULAS YOU HAVE USED WITHIN YOUR SPREADSHEET SUBMISSION. - Pull the public financial information for the fast food industry from the Fast Food-Student Excel spreadsheet within this assignment folder to complete ratios for comparisons. 5. Create a mini presentation (can be a Power Point) that provides insight to Amy how she is doing against the competition. - This is your creation and can be presented in any format as long as you have shown your analysis with findings (ratios from the fast food industry that were used to compare to Mom’s Burgers). You can compare the ratios within an Excel spreadsheet by creating your own table (using shades of color to differentiate data), use simple line or column graphs for each company comparison or create a custom combo chart to compare two series of data. - Use the Excel skills you have learned thus far to ensure a quality mini presentation. - The response for this assignment can vary and will depend on your evaluation of the case and data; it is your own data exploration, analysis, and conclusion findings to respond to Amy's inquiry. - Make sure your case is backed up with your data findings within your mini presentation. 6. Upload your completed presentation file with all resources cited in APA format. “Mom’s Burgers” Amy likes to tell stories about her summers when she was a kid at the lake. Her stories would be about playing all day with friends and the dog, diving into the water, going fishing or swimming… but her stories always came back to those late afternoon burgers! Big fat burgers, made on the grill… with all the fixings! Amy’s mom knew how to cook…. And those summer days were her inspiration for “Mom’s Burgers”. It seemed that Amy started “Mom’s Burgers” at the right time, just as the gourmet Burger craze was getting started. Amy now has 10 stores and is considering really pushing rapid growth. Amy knows her numbers but needs your help to understand how Mom’s Burgers is doing against the competition. She has asked you to pull all public financial information for the fast food industry and tell her how Mom’s Burgers compares. She has given you the following ratios for “Mom’s Burgers” for 2017 Liquidity Current Ratio: 1.08x Cash Ratio: 10.3% Activity Asset Turn: 1.0x Inventory Turn: 43.4x Profitability Gross Margin 29.4% Operating Margin 11.5% Net Margin 3.0% Fast Food NAICSICTicker CoYRCash & ST InvCurrent Assets Total AssetsInventoriesCurrent LiabEquityTotal RevenueCOGSGross ProfitOperating Inc after DepNet Income 7225135812MCDMCDONALD'S CORP201023874368.531975.2109.92924.714634.224074.613236.910837.773044946.3 7225135812MCDMCDONALD'S CORP20112335.7440332989.9116.83509.214390.22700614989.812016.28292.95503.1 7225135812MCDMCDONALD'S CORP20122336.14922.135386.5121.73403.115293.62756715348.512218.58361.15464.8 7225135812MCDMCDONALD'S CORP20132798.75050.136626.3123.7317016009.728105.715704.212401.58517.15585.9 7225135812MCDMCDONALD'S CORP20142077.94185.534281.41102747.912853.427441.315446.3119957967.84757.8 7225135812MCDMCDONALD'S CORP20157685.5964337938.7100.12950.47087.92541314185.811227.27354.94529.3 7225135812MCDMCDONALD'S CORP20161223.44848.631023.958.93468.3-2204.324621.913026.511595.47820.24686.5 7225135812MCDMCDONALD'S CORP20172463.85327.233803.758.82890.6-326822820.410972.111848.38389.55192.3 7225135812MCDMCDONALD'S CORP20188664053.232811.251.12973.5-6258.421025.28936.312088.98585.85924.3 72251358120738BNPC RESTAURANT HOLDINGS LLC201044.15965.886825.2287.163106.074182.332978.284834.647143.63758.07721.464 72251358120738BNPC RESTAURANT HOLDINGS LLC201178.394113.499848.7287.296116.392201.46980.973833.305147.66862.0194.706 72251358120738BNPC RESTAURANT HOLDINGS LLC201225.49368.7861169.7827.32189.743235.4711048.923872.605176.31878.37715.02 72251358120738BNPC RESTAURANT HOLDINGS LLC201320.03557.1041205.1128.255105.068265.2131094.032912.632181.481.07629.742 72251358120738BNPC RESTAURANT HOLDINGS LLC201412.06361.911236.35510.591107.141267.0251179.8971033.483146.41435.1011.672 72251358120738BNPC RESTAURANT HOLDINGS LLC201532.71763.1151220.7910.067108.196273.6891223.2991055.197168.10242.7046.712 72251358120738BNPC RESTAURANT HOLDINGS LLC201613.60444.3681217.13510.061113.047284.7971236.5681052.014184.55450.4978.729 7225135812JACKJACK IN THE BOX INC201010.607274.9221407.09237.391283.183520.4632297.5311836.855460.67666.92270.21 7225135812JACKJACK IN THE BOX INC201111.424254.4111432.32238.931282.983405.9562193.2981778.516414.78281.08280.6 7225135812JACKJACK IN THE BOX INC20128.469231.1811463.7257.752275.302411.9451545.0261104.347440.67998.80557.651 7225135812JACKJACK IN THE BOX INC20139.644117.2121319.2097.181211.674472.0181489.8671029.322460.545138.01651.152 7225135812JACKJACK IN THE BOX INC201410.578146.561270.6657.481206.307257.9111484.1311005.195478.936174.47788.95 7225135812JACKJACK IN THE BOX INC201517.743147.9891303.9797.376229.38915.9531540.3171017.635522.682199.441108.812 7225135812JACKJACK IN THE BOX INC201617.03155.4051348.7918.229279.56-217.2061599.3311054.929544.402241.295124.073 7225135812JACKJACK IN THE BOX INC20177.642139.2771228.4216.647261.99-388.0321553.9141045.975507.939236.944135.332 7225135812JACKJACK IN THE BOX INC20182.70594.973823.3971.858183.72-591.699869.69499.751369.939196.097121.371 7225135812MHGUMERITAGE HOSPITALITY GROUP20101.833.50432.9690.5287.571.35978.55768.44110.1162.7342.31 7225135812MHGUMERITAGE HOSPITALITY GROUP20111.7634.1543.8340.669.763.42491.94278.53813.4043.1792.316 7225135812MHGUMERITAGE HOSPITALITY GROUP20122.0134.13963.3480.93515.4048.33698.95385.48313.472.4762.905 7225135812MHGUMERITAGE HOSPITALITY GROUP20133.4796.42471.6171.07815.0310.708137.784117.75820.0264.6363.054 7225135812MHGUMERITAGE HOSPITALITY GROUP20145.28.06485.531.26824.57613.024160.213137.65622.5574.4052.758 7225135812MHGUMERITAGE HOSPITALITY GROUP20156.58810.933109.5231.40232.91920.524209.996172.55437.44210.8347.026 7225135812MHGUMERITAGE HOSPITALITY GROUP20169.83613.494137.0231.54739.526.117235.771191.82143.9511.3716.45 7225135812MHGUMERITAGE HOSPITALITY GROUP201712.91719.036235.2922.63976.95238.236312.58255.69556.88514.4478.961 7225135812NDLSNOODLES & CO20110.52312.879126.3254.59520.5574.951256.066201.75154.31512.0163.829 7225135812NDLSNOODLES & CO20120.58116.154156.9956.04223.7610.407300.41236.99663.41416.0525.163 7225135812NDLSNOODLES & CO20130.96818.333187.8027.22324.165124.473350.924275.18375.74119.9196.665 7225135812NDLSNOODLES & CO20141.90622.776238.9039.41525.831140.115403.741322.82980.91218.91511.428 7225135812NDLSNOODLES & CO20151.91225.401239.96110.49432.91493.772455.451377.44978.002-20.867-13.765 7225135812NDLSNOODLES & CO20161.83725.788209.46111.28549.03325.818487.474420.77266.702-51.639-71.677 7225135812NDLSNOODLES & CO20173.36122.058185.2339.92943.86935.861456.492387.60268.89-32.991-37.482 7225135812NDLSNOODLES & CO20184.65523.351172.0329.64633.14752.681457.841385.44372.398-0.054-8.441 7225135812PBPBPOTBELLY CORP201124.14633.94699.112.6217.456-185.302237.966159.62278.3448.5637.165 7225135812PBPBPOTBELLY CORP201222.59532.464126.6991.9117.294-168.924274.914185.44589.46910.14124.046 7225135812PBPBPOTBELLY CORP201369.57981.798186.082.26318.705153.045299.712201.7497.97213.1991.258 7225135812PBPBPOTBELLY CORP201463.00580.218191.9472.76820.884156.059326.979221.522105.4577.4714.358 7225135812PBPBPOTBELLY CORP201532.00649.781174.5073.15925.182129.424372.849252.111120.7389.6295.628 7225135812PBPBPOTBELLY CORP201623.37938.551175.4453.36527.815123.485407.131272.602134.52913.0138.212 7225135812PBPBPOTBELLY CORP201725.5345.203170.733.52527.352116.723428.111288.972139.1390.772-6.956 7225135812PBPBPOTBELLY CORP201819.77539.42153.2153.48229.02695.171422.638289.408133.23-6.308-8.878 7225135812TACODEL TACO RESTAURANTS INC201510.19419.765703.5722.80651.453368.377424.002328.32995.67341.0434.757 7225135812TACODEL TACO RESTAURANTS INC20168.79519.858727.1572.71854.668377.333452.083346.956105.12743.61220.913 7225135812TACODEL TACO RESTAURANTS INC20176.55919.883742.3242.71255.431416.249471.456365.836105.6242.32249.871 7225135812TACODEL TACO RESTAURANTS INC20187.15332.981758.9562.93255.695422.274505.49381.739123.75135.04518.959 7225135812RSTRFRESTAURANT BRANDS INTL LP2013786.91074.45828.51.23461516.21146.3273.1873.2582.4233.7 7225135812RSTRFRESTAURANT BRANDS INTL LP20141887.7266021164100.11924.84322.31197.3250.8946.5650.9-277.2 7225135812RSTRFRESTAURANT BRANDS INTL LP2015753.71365.118408.581.311182912.44052.220961956.21419508.3 7225135812RSTRFRESTAURANT BRANDS INTL LP20161420.4205719125.371.81210.73484.94145.81987.12158.71662.2952.4 7225135812RSTRFRESTAURANT BRANDS INTL LP20171073.41749.621223.97816554559.64576.12128.72447.41896.31233.9 7225135812RSTRFRESTAURANT BRANDS INTL LP2018913150020141751408361653572042331519581143 7225135812GTIMGOOD TIMES RESTAURANTS INC20100.4290.8348.3180.2012.7031.4220.86318.9951.868-1.628-2.932 7225135812GTIMGOOD TIMES RESTAURANTS INC20110.8471.1966.9990.1911.6842.30520.60318.5262.077-0.849-1.013 7225135812GTIMGOOD TIMES RESTAURANTS INC20120.6163.8587.0610.1593.013.05619.70617.2822.424-0.525-0.777 7225135812GTIMGOOD TIMES RESTAURANTS INC20136.1436.6419.8750.1841.8077.07522.89219.8763.016-0.41-0.687 7225135812GTIMGOOD TIMES RESTAURANTS INC20149.89410.39116.8810.2822.5513.04228.03723.574.467-0.235-0.69 7225135812GTIMGOOD TIMES RESTAURANTS INC201513.80914.72848.2280.517.25836.64244.05736.2447.8130.418-0.791 7225135812GTIMGOOD TIMES RESTAURANTS INC20166.337.79346.8770.6315.12236.07864.43953.01911.42-0.325-1.321 7225135812GTIMGOOD TIMES RESTAURANTS INC20174.3376.06655.1530.8476.91634.57179.0866.12512.955-1.445-2.255 7225135812GTIMGOOD TIMES RESTAURANTS INC20183.4776.38160.951.0048.33533.98399.2482.49416.7460.337-1.034 7225135812SHAKSHAKE SHACK INC201216.03317.98444.0680.2435.56731.87157.03841.34415.6944.6864.133 7225135812SHAKSHAKE SHACK INC201313.07615.20755.2190.3317.20537.38782.45658.16824.2885.965.423 7225135812SHAKSHAKE SHACK INC20142.6777.94582.9620.52948.17712.6118.5385.18133.3495.9232.118 7225135812SHAKSHAKE SHACK INC201571.12478.934379.5470.54324.005100.599190.592130.34560.24720.993-8.776 7225135812SHAKSHAKE SHACK INC201673.64783.944538.1940.80631.716152.177268.475186.05882.41727.83912.446 7225135812SHAKSHAKE SHACK INC201784.54393.199470.6061.25834.024169.482358.81254.079104.73135.085-0.32 7225135812SHAKSHAKE SHACK INC201886.863101.119610.5321.74959.948226.067459.31332.683126.62735.18715.179 7225135812SBUXSTARBUCKS CORP20101449.72756.46385.9543.31779.13674.710707.48301.62405.81325.9945.6 7225135812SBUXSTARBUCKS CORP20112050.73794.97360.4965.82075.84384.911700.49016.426841524.61245.7 7225135812SBUXSTARBUCKS CORP201220374199.68219.21241.52209.8510913299.510161.33138.21786.71383.8 7225135812SBUXSTARBUCKS CORP20133233.85471.411516.71111.25377.34480.214892.211125.63766.62207.38.3 7225135812SBUXSTARBUCKS CORP20141843.84168.710752.91090.93038.7527216447.811954.34493.52797.62068.1 7225135812SBUXSTARBUCKS CORP20151611.44352.712446.11306.43653.5581819162.7137215441.733632757.4 7225135812SBUXSTARBUCKS CORP20162263.24760.514329.51378.54546.9588421315.915120.86195.13853.72817.7 7225135812SBUXSTARBUCKS CORP20172690.95283.414365.613644220.75450.122386.8160746312.83908.12884.7 7225135812SBUXSTARBUCKS CORP20188937.812494.224156.41400.55684.21169.524719.517843.66875.93873.54518.3 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201046.225112.372415.94117.40290.687198.6941126.397889.269237.12886.74451.94 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201118.94294.824390.38220.09181.133205.6471217.882977.59240.29287.01754.735 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201216.396118.626438.40822.178103.581181.5141342.6531070.842271.81199.80761.66 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201313.67125.04464.29123.03597.861137.6741439.0221157.118281.904106.50369.537 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201420.122156.008512.80327.394106.76286.2331598.1491292.63305.519117.6373.315 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201521.006152.59494.91221.564132.93729.1811637.3751297.742339.633136.30775.682 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201615.563145.575512.56525.132128.03-3.9111713.621354.607359.013155.101102.82 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201722.345169.994555.55330.62132.86-121.7111783.3591429.285354.074152.691102.292 7225135812PZZAPAPA JOHNS INTERNATIONAL INC201819.468171.708570.94727.203164.636-317.3591573.3161304