Calculate the common size for the balance sheet and the Ratios (Cogs, Current Ra

Question

Calculate the common size for the balance sheet and the Ratios (Cogs, Current Ratio, Quick Ratio etc.) of the balance sheet as well

% chg common size sales 150000 195500 grss prof 108434 132357 marketing exp 34678 42096 overhd 26789 30856 dep 15000 22000 op prf 31967 37405 int 15000 20000 taxes 8450 9500 net inc 8517 7905 cash 8004 15086 liq inv 10543 13468 ar 15086 16754 inv 22134 25432 lt pe 50875 95000 accum dep -22000 -29000 other assets 60000 60000 tot assets 144642 196740 c cd 2560 2432 trade payable 8953 9579 cp ltd 4576 4877 ltd 30000 55000 sub debt 0 20000 paid in cap 6000 6000 tot eq 98553 72754 tot liab n eq 144642 144642 imp/decl cogs cr qr td/w prof /ratio ff/int ebitda/int roe roa

Explanation / Answer

Year 1 Year 2 % chg over Yr 1 sales                      150,000 100.00%       195,500 100.00% 30.3% grss prof                      108,434 72.29%       132,357 67.70% 22.1% marketing exp                        34,678 23.12%         42,096 21.53% 21.4% overhd                        26,789 17.86%         30,856 15.78% 15.2% dep                        15,000 10.00%         22,000 11.25% 46.7% op prf                        31,967 21.31%         37,405 19.13% 17.0% int                        15,000 10.00%         20,000 10.23% 33.3% taxes                          8,450 5.63%           9,500 4.86% 12.4% net inc                          8,517 5.68%           7,905 4.04% -7.2% cash                          8,004 5.53%         15,086 7.67% 88.5% liq inv                        10,543 7.29%         13,468 6.85% 27.7% ar                        15,086 10.43%         16,754 8.52% 11.1% inv                        22,134 15.30%         25,432 12.93% 14.9% Current Assets                        55,767         70,740 lt pe                        50,875 35.17%         95,000 48.29% 86.7% accum dep                       (22,000) -15.21%        (29,000) -14.74% 31.8% other assets                        60,000 41.48%         60,000 30.50% 0.0% tot assets                      144,642 100.00%       196,740 100.00% 36.0% c cd                          2,560 1.77%           2,432 1.24% -5.0% trade payable                          8,953 6.19%           9,579 4.87% 7.0% cp ltd                          4,576 3.16%           4,877 2.48% 6.6% Current Laib                        16,089         16,888 ltd                        30,000 20.74%         55,000 27.96% 83.3% sub debt                               -           20,000 paid in cap                          6,000 4.15%           6,000 3.05% 0.0% tot eq                        98,553 68.14%         72,754 36.98% -26.2% tot liab n eq                      144,642 100.00%       144,642 73.52% 0.0% There is data mistake in ssecond yr liability part imp/decl cogs                             41,566.0         63,143.0 cr                                       3.5                   4.2 qr                                       2.1                   2.7 td/w ratio not understood prof /ratio ratio not understood ff/int ratio not understood ebitda/int                                       2.1                   1.9 roe 8.6% 10.9% roa 5.9% 4.0%

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.