Question: Using the attached Excel spreadsheet for Wicked Good Cupcakes (WGC) calculate the listed ratios. 1. Copy and paste your ratio calculation as a Table 1,
Using the attached Excel spreadsheet for Wicked Good Cupcakes (WGC) calculate the listed ratios. 1. Copy and paste your ratio calculation as a Table 1, inserted into the Word document. 2. What do these ratios suggest about the companys performance during the period presented? 3. In Table 2 list the 5 ratios from Walmart and corresponding ratios for WGC. 4. Which ratios would a senior operational manager for WGC be most interested in following?

1-Dec-15 31-Dec 16 Cach &Short-Trm Ivpstments Prepaid Fpenses otheroavent Asset $1.38 2.93 ToRal Coent Assets 618449 Gruss Plant, Pruperty&Equipment $3616$3261 Cukitinpaid (ds) Payables peiod Leverage andiRatins Net Plant, Pruperty &Equipmnt Sa10 Long Term Deht De In One Year Tarpc Payable $1.8815 $154 $2.67 $19.79 $1.16$2.32 Retained Earnines tock San Thousands, pHorpt por share) 3 S7$91.99 $$2.79 SellinGeneral, & Administrative E $27.17 $21.64 Og erst irIncom.e Before Dere $7133 Operating Profrt Special ItmE $1415 $L.26$0.19 ps Diluted firom Operations SLOG $112 1-Dec-15 31-Dec 16 Cach &Short-Trm Ivpstments Prepaid Fpenses otheroavent Asset $1.38 2.93 ToRal Coent Assets 618449 Gruss Plant, Pruperty&Equipment $3616$3261 Cukitinpaid (ds) Payables peiod Leverage andiRatins Net Plant, Pruperty &Equipmnt Sa10 Long Term Deht De In One Year Tarpc Payable $1.8815 $154 $2.67 $19.79 $1.16$2.32 Retained Earnines tock San Thousands, pHorpt por share) 3 S7$91.99 $$2.79 SellinGeneral, & Administrative E $27.17 $21.64 Og erst irIncom.e Before Dere $7133 Operating Profrt Special ItmE $1415 $L.26$0.19 ps Diluted firom Operations SLOG $112
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
