Question

1 Approved Answer

Posted on Aug 01, 2024

I need the following ratios for the balance sheet and income statement provided. Can anyone help me? Required Ratios Liquidity Current Ratio Acid-Test (quick) Ratio

I need the following ratios for the balance sheet and income statement provided. Can anyone help me?
1. Required Ratios
  1. Liquidity
    1. Current Ratio
    2. Acid-Test (quick) Ratio
    3. Receivables Turnover Ratio
    4. Inventory Turnover Ratio
  2. Solvency
    1. Debt to Equity (Net Worth) Ratio
    2. Times Interest Earned (Earnings Before Interest & Taxes/Interest) Ratio
  3. Profitability
    1. *Gross Profit Ratio
    2. Return on Assets (Sales/Total Assets) Ratio
    3. *Profit Margin Ratio
    4. Asset Turnover (Profit Before Taxes) Ratio
    5. Return on Equity (Profit Before Taxes / Net Worth)
    6. *Earnings Per Share
    7. *Price-Earnings Ratio

-14,307.00 YETI HOLDINGS INC. Balance Sheet HOFIZONTAL ANALYSIS For Year Ended December 2017-2019 Inc. (Dec. 2018 Inc. (Dec.) 2019 Cash & Short Term Investments 26,401 49.21% 18,865.00 Assets 2019 2018 2017 Liabilties 2019 2018 2017 Cash Only 26,401 49.21% 18,865.00 Cash & Short Term Investments 72,515.00 30.051.00 53,650,00 ST Debt & Curent Parion LT Debt 22.953.00 43.833,00 47,050.00 Total Accounts Receivable -7,824 -11.65% 15,536.00 Cash Only 72,515.00 30.051.00 53,650.00 Short Term Deb! 7,788.00 0 Accounts Receivables, Net -7,824 -11.65% 15,536.00 Total Accounts Receivable 82,688.00 59,328.00 67,152.00 Cument Portion of Long Tern Dett 15,185.00 43.839.00 47,050.00 Accounts Receivables, Gross -7,824 -11.63% 15436.00 Accounts Receivables, Net a2.699.00 59,329.00 67,152.00 Accounts Payable 83.823.00 68,737.00 40,342.00 Inventories -29,675 -16.95% 10,602.00 Accounts Receivables, Grass 82,680.00 59.428,00 67 252.00 Other Cumuntabilities 63,538.00 74.983.00 64.508.0 Finished Goods -29,675 -16.95% 10,602.00 Bad Debu Doubtful Accounts -100 -100 Accrued Payroll 18,119,00 15,551.00 6,384.0 Other Cumunt Assets 5,077 71.17% 12,510.00 2 Inventarios 185,700.00 ---- 145,423.00 175,098.00 Miscellaneous Curent Liabilities 45.417.00 59,412.00 58,142.00 Miscellaneous Cumunt Assets 5,077 71.17% -3,916.00 3 Finished Goods 185,700.00 145.423.00 24 175,098.00 Total Cumont Liabilities 170,312.00 187,338.00 151.898.00 Total Cumont Assets -6,021 -1.99% 57,513.00 4 Other Cumont Assets 19,644,00 12 211.00 7.134.00 Long Tam Debi 323.915.00 284 378,00 428,63200 Net Property, Plant & Equipment 314 0.43% 46,595.00 5 Prepaid Expenses 18.425.00 16,426.00 - Long-Term Debt excl. Capitalized Leases 280,765.00 284 376.00 428,632.00 Property. Plant & Equipment - Grass 19,948 19.61% 89,715.00 6 Miscellaneous Curent Assets 12211.00 3.218.00 7,134.00 . Non-Convertible De . 280,785.00 284,378.00 428,632.00 Machinery & Equipment 4426 10.75% 15,187.00 7 Total Curent Assets 380,547.00 297 013.00 42 303,034.00 Capitalized Lease Obligations 950 0 Leases -26,154 -100.00% -24,946.00 8 Net Property. Plant & Equipment 120,378.00 74,097.00 73,783.00 Computer Software and Equipment 12,435 43.22% 24,156.00 9 Property. Plant & Equipment - Gross 191,421.00 121654.00 101,708.00 Defamed Taxes -1,082.00 -7,777.00 -10,004.00 Other Property. Plant & Equipment 29,241 523.09% 37,550.00 0 Machinery & Equipment 58,375.00 45,614.00 41,188.00 Defamed Taxes - Credit 0 21,782.00 14,307.00 Accumulated Depreciation 19,634 70.31% 43,120.00 1 Leases 1.208.00 - 0 26,154.00 Defamed Taxes-Debit 1,082.00 29,559.00 24,311.00 Intangible Assets 5,717 4.45% 16,548.00 2 Computer Software and Equipment 52,930.00 41.209.00 28,774.00 Other abilities 13,307.00 13,528.00 12,128.00 Ne! Goodwill 0.00% 0.00 3 Other Property. Plant & Equipment 43,140.00 34 83100 5.590.00 Other Liabilities (excl. Derfomed Income) 13,307.00 13,529.00 12,128.00 Net Oher Intangibles 5,717 7.69% 16,548.00 4 Accumulated Depreciation 71,043.00 47,557,00 27,923.00 Total Liabilities 507,534,00 507 024.00 608,985.00 Other Assets 3 0.30% 1,378.00 5 Intangible Assets - 145,143.00 134 312.00 128,595.00 Equity Tangible Other Assets 3 0.30% 1,378.00 6 Net Goodwill 54.293.00 54293.00 54.293.00 Total Assets 5,261 0.99% 98,805.00 7 Net Other Intangibles 90,850.00 80,019.00 74 302.00 Common Equity (Total) 122,005.00 28,971.00 -78.231.00 ST Debt & Cument Parion LT Debt -3,412.00 -7.25% -24,097.00 8 Oher Assets 2,389.00 1,014.00 . 1,011.00 Common Stock Parcary Value 888 842 2,054.00 Curent Portion of Long Term Dets! -3.412.00 -7.25% -31,865.00 9 Tangible Other Assets 2,389.00 1,014.00 1,011.00 Additional Paid in Capital Capital Surplus 310,678.00 268,327.00 217,858.00 Accounts Payable 28,395.00 70.39% 43,481.00 0 Total Assets 629,539.00 535,995.00 530,734,00 Other Cument Liabilities 10,457.00 16.21% -970.00 1 Retained Earnings -189,545.00 240,104.00 298,184.00 Accrued Padil 9,187.00 144.36% 11,755.00 Miscellaneous Cument Liabilities 1,270.00 2.18% - 12,725.00 3 Cumulative Translation Adjustmenedized For Exch. Gain 94 43 Total Curent Liabilities 35,440.00 23.33% 18,414.00 .. 4 Long-Term Dei - 144,256.00 -33.65% -104,717.00 5 Total Shareholders' Equity 122.005.00 28.971.00 . -78.231.00 Long-Term Debt excl. Capitalized Lease -144,256.00 -33.65% - 147,867.00 6 ... Non-Convertible Debt -144,256.00 -33.65% -147,867.00 Tatal EV 122,005.00 28,971.00 -76.231.00 Capitalized Lease Obligations 0.00 0.00% 950.00 8 Liabilities & Shareholders' Equity 629,539.00 535,995.00 . 530,734,00 Defemed Taxes-Credi! 7,475.00 52.25% Defamed Taxes-Debi 5,248.00 21.59% -23,229.00 0 Other Liabilises 1,400.00 11.54% 1,179.00 1 *** Omer Liabilities (excl. Defered Incarne) 1,400.00 11.54% 1,179.00 2 Total Liabilities -99,941.00 -16.47% -99,431.00 AVY 35.16% 35.16% 23.14% 23.14% 22.95% 6.05% - 6.05% 175.36% -54.89% 18.98% 63.15% 88.21% 36.87% -95.38% 83.95% 671.74% 154.42% 12.87% 0.00% 22.27% 136.30% 136.30% 18.62% -51.22% -67.73% 107.78% -1.50% 2 184.71% -21.89% 12.12% -24.43% -34.50% -34.50% 0.00% OW -100.00% -95.55% 9.72% 9.72% -16.38% 7 3 un Common Equity (Total) Common Stock Parcary Value Additional Paid-in Capital Capital Suplus 105,202.00 0.00 -1.212.00 - 138.00% -1.38% 6 -59.01% 198,236.00 0.00 -1,186.00 92.822.00 106,639.00 -260.05% -2.60% -57.74% 42.61% -36.00% 23.17% 50,471.00 56,080.00 Retained Earings -18.93% Cumulative Translation Adjustment Unrealized For. Exch. Gain - 137.00 -318.60% -39.00 -90.70% 7 8 9 0 1 2 3 4 5 Total Shareholders' Equity 105,202.00 -138.00% 198,236.00 -260.05% - 138.00% Total Equity Listilities & Shareholder av 105,202.00 5.26100 198,236.00 98.805.00 -260.05% 18.60% YETI Holdinngs Inc. Income Statement For Year Ended Dec. 31, 2017-2020 Revenue 0% Year 2019 Percentage 913,734.00 100% 444,220.00 49% 415, 261.00 45% 28,959.00 3% 23, 159.00 3% 5,800.00 1% 469,514.00 51% 379,743.00 42% Sales Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles Gross Income SG&A Expense Research & Development Year 2018 Percent 778,833.00 100% 420,482.00 54% 395,705.00 51% 24,777.00 3% 19,477.00 3% 5,300.00 1% 358,351.00 46% 256, 195.00 33% 10,800.00 1% Year 2017 Percent 639,239.00 365, 407.00 344,638.00 20,769.00 15,469.00 5,300.00 273,832.00 209,865.00 -3% -3% 0% 100% 57% 54% 3% 2% 0.00% -5.50% -5.40% 0.10% 0.00% 0.00% 5.38% 8.67% 0% 1% 0% 43% 3% 33% 0% 20,500.00 2% 0% 1% 0.90% Other SG&A 359,243.00 39% 245, 395.00 32% 209,865.00 33% -1% 7.80% 0% 0.00% Expenses Interest Expense 21,779.00 2% 31,280.00 4% 5% -1% -1.62% 32,607.00 32,607.00 Gross Interest Expense 21,779.00 2% 31,280.00 4% 5% -1% -2.00% Pretax Income 67,258.00 7% 9% 5% 4% -1.54% 69,615.00 11,852.00 32,059.00 16,658.00 Income Tax 16,824.00 2% 2% 3% -1% 0.30% Shares issued for Each Year 10% 11% 83,647.00 13% -2% 86,774 86,000,000 84,1961 84,000,000 -1.30% #VALUE! Share outstanding for Each Year 83,000,000 #VALUE! Treasury Stock for Each Year 0% 0% 0% 0% 0.00% Net Income Net Income 50,434.00 6% 57,763.00 7% 15.401.00 2% 5% -1.90% Discussion of Largest Change This increase was attributable to costs incurred in Yeti Holding's transition to a public company. The change is primarily due to higher selling expenses, increased personnel and infrascture to support long-term growth in the business and increased depreciation and amortization expense and other expenses. Thi information was found on Yeti's investors page on their official website. -14,307.00 YETI HOLDINGS INC. Balance Sheet HOFIZONTAL ANALYSIS For Year Ended December 2017-2019 Inc. (Dec. 2018 Inc. (Dec.) 2019 Cash & Short Term Investments 26,401 49.21% 18,865.00 Assets 2019 2018 2017 Liabilties 2019 2018 2017 Cash Only 26,401 49.21% 18,865.00 Cash & Short Term Investments 72,515.00 30.051.00 53,650,00 ST Debt & Curent Parion LT Debt 22.953.00 43.833,00 47,050.00 Total Accounts Receivable -7,824 -11.65% 15,536.00 Cash Only 72,515.00 30.051.00 53,650.00 Short Term Deb! 7,788.00 0 Accounts Receivables, Net -7,824 -11.65% 15,536.00 Total Accounts Receivable 82,688.00 59,328.00 67,152.00 Cument Portion of Long Tern Dett 15,185.00 43.839.00 47,050.00 Accounts Receivables, Gross -7,824 -11.63% 15436.00 Accounts Receivables, Net a2.699.00 59,329.00 67,152.00 Accounts Payable 83.823.00 68,737.00 40,342.00 Inventories -29,675 -16.95% 10,602.00 Accounts Receivables, Grass 82,680.00 59.428,00 67 252.00 Other Cumuntabilities 63,538.00 74.983.00 64.508.0 Finished Goods -29,675 -16.95% 10,602.00 Bad Debu Doubtful Accounts -100 -100 Accrued Payroll 18,119,00 15,551.00 6,384.0 Other Cumunt Assets 5,077 71.17% 12,510.00 2 Inventarios 185,700.00 ---- 145,423.00 175,098.00 Miscellaneous Curent Liabilities 45.417.00 59,412.00 58,142.00 Miscellaneous Cumunt Assets 5,077 71.17% -3,916.00 3 Finished Goods 185,700.00 145.423.00 24 175,098.00 Total Cumont Liabilities 170,312.00 187,338.00 151.898.00 Total Cumont Assets -6,021 -1.99% 57,513.00 4 Other Cumont Assets 19,644,00 12 211.00 7.134.00 Long Tam Debi 323.915.00 284 378,00 428,63200 Net Property, Plant & Equipment 314 0.43% 46,595.00 5 Prepaid Expenses 18.425.00 16,426.00 - Long-Term Debt excl. Capitalized Leases 280,765.00 284 376.00 428,632.00 Property. Plant & Equipment - Grass 19,948 19.61% 89,715.00 6 Miscellaneous Curent Assets 12211.00 3.218.00 7,134.00 . Non-Convertible De . 280,785.00 284,378.00 428,632.00 Machinery & Equipment 4426 10.75% 15,187.00 7 Total Curent Assets 380,547.00 297 013.00 42 303,034.00 Capitalized Lease Obligations 950 0 Leases -26,154 -100.00% -24,946.00 8 Net Property. Plant & Equipment 120,378.00 74,097.00 73,783.00 Computer Software and Equipment 12,435 43.22% 24,156.00 9 Property. Plant & Equipment - Gross 191,421.00 121654.00 101,708.00 Defamed Taxes -1,082.00 -7,777.00 -10,004.00 Other Property. Plant & Equipment 29,241 523.09% 37,550.00 0 Machinery & Equipment 58,375.00 45,614.00 41,188.00 Defamed Taxes - Credit 0 21,782.00 14,307.00 Accumulated Depreciation 19,634 70.31% 43,120.00 1 Leases 1.208.00 - 0 26,154.00 Defamed Taxes-Debit 1,082.00 29,559.00 24,311.00 Intangible Assets 5,717 4.45% 16,548.00 2 Computer Software and Equipment 52,930.00 41.209.00 28,774.00 Other abilities 13,307.00 13,528.00 12,128.00 Ne! Goodwill 0.00% 0.00 3 Other Property. Plant & Equipment 43,140.00 34 83100 5.590.00 Other Liabilities (excl. Derfomed Income) 13,307.00 13,529.00 12,128.00 Net Oher Intangibles 5,717 7.69% 16,548.00 4 Accumulated Depreciation 71,043.00 47,557,00 27,923.00 Total Liabilities 507,534,00 507 024.00 608,985.00 Other Assets 3 0.30% 1,378.00 5 Intangible Assets - 145,143.00 134 312.00 128,595.00 Equity Tangible Other Assets 3 0.30% 1,378.00 6 Net Goodwill 54.293.00 54293.00 54.293.00 Total Assets 5,261 0.99% 98,805.00 7 Net Other Intangibles 90,850.00 80,019.00 74 302.00 Common Equity (Total) 122,005.00 28,971.00 -78.231.00 ST Debt & Cument Parion LT Debt -3,412.00 -7.25% -24,097.00 8 Oher Assets 2,389.00 1,014.00 . 1,011.00 Common Stock Parcary Value 888 842 2,054.00 Curent Portion of Long Term Dets! -3.412.00 -7.25% -31,865.00 9 Tangible Other Assets 2,389.00 1,014.00 1,011.00 Additional Paid in Capital Capital Surplus 310,678.00 268,327.00 217,858.00 Accounts Payable 28,395.00 70.39% 43,481.00 0 Total Assets 629,539.00 535,995.00 530,734,00 Other Cument Liabilities 10,457.00 16.21% -970.00 1 Retained Earnings -189,545.00 240,104.00 298,184.00 Accrued Padil 9,187.00 144.36% 11,755.00 Miscellaneous Cument Liabilities 1,270.00 2.18% - 12,725.00 3 Cumulative Translation Adjustmenedized For Exch. Gain 94 43 Total Curent Liabilities 35,440.00 23.33% 18,414.00 .. 4 Long-Term Dei - 144,256.00 -33.65% -104,717.00 5 Total Shareholders' Equity 122.005.00 28.971.00 . -78.231.00 Long-Term Debt excl. Capitalized Lease -144,256.00 -33.65% - 147,867.00 6 ... Non-Convertible Debt -144,256.00 -33.65% -147,867.00 Tatal EV 122,005.00 28,971.00 -76.231.00 Capitalized Lease Obligations 0.00 0.00% 950.00 8 Liabilities & Shareholders' Equity 629,539.00 535,995.00 . 530,734,00 Defemed Taxes-Credi! 7,475.00 52.25% Defamed Taxes-Debi 5,248.00 21.59% -23,229.00 0 Other Liabilises 1,400.00 11.54% 1,179.00 1 *** Omer Liabilities (excl. Defered Incarne) 1,400.00 11.54% 1,179.00 2 Total Liabilities -99,941.00 -16.47% -99,431.00 AVY 35.16% 35.16% 23.14% 23.14% 22.95% 6.05% - 6.05% 175.36% -54.89% 18.98% 63.15% 88.21% 36.87% -95.38% 83.95% 671.74% 154.42% 12.87% 0.00% 22.27% 136.30% 136.30% 18.62% -51.22% -67.73% 107.78% -1.50% 2 184.71% -21.89% 12.12% -24.43% -34.50% -34.50% 0.00% OW -100.00% -95.55% 9.72% 9.72% -16.38% 7 3 un Common Equity (Total) Common Stock Parcary Value Additional Paid-in Capital Capital Suplus 105,202.00 0.00 -1.212.00 - 138.00% -1.38% 6 -59.01% 198,236.00 0.00 -1,186.00 92.822.00 106,639.00 -260.05% -2.60% -57.74% 42.61% -36.00% 23.17% 50,471.00 56,080.00 Retained Earings -18.93% Cumulative Translation Adjustment Unrealized For. Exch. Gain - 137.00 -318.60% -39.00 -90.70% 7 8 9 0 1 2 3 4 5 Total Shareholders' Equity 105,202.00 -138.00% 198,236.00 -260.05% - 138.00% Total Equity Listilities & Shareholder av 105,202.00 5.26100 198,236.00 98.805.00 -260.05% 18.60% YETI Holdinngs Inc. Income Statement For Year Ended Dec. 31, 2017-2020 Revenue 0% Year 2019 Percentage 913,734.00 100% 444,220.00 49% 415, 261.00 45% 28,959.00 3% 23, 159.00 3% 5,800.00 1% 469,514.00 51% 379,743.00 42% Sales Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles Gross Income SG&A Expense Research & Development Year 2018 Percent 778,833.00 100% 420,482.00 54% 395,705.00 51% 24,777.00 3% 19,477.00 3% 5,300.00 1% 358,351.00 46% 256, 195.00 33% 10,800.00 1% Year 2017 Percent 639,239.00 365, 407.00 344,638.00 20,769.00 15,469.00 5,300.00 273,832.00 209,865.00 -3% -3% 0% 100% 57% 54% 3% 2% 0.00% -5.50% -5.40% 0.10% 0.00% 0.00% 5.38% 8.67% 0% 1% 0% 43% 3% 33% 0% 20,500.00 2% 0% 1% 0.90% Other SG&A 359,243.00 39% 245, 395.00 32% 209,865.00 33% -1% 7.80% 0% 0.00% Expenses Interest Expense 21,779.00 2% 31,280.00 4% 5% -1% -1.62% 32,607.00 32,607.00 Gross Interest Expense 21,779.00 2% 31,280.00 4% 5% -1% -2.00% Pretax Income 67,258.00 7% 9% 5% 4% -1.54% 69,615.00 11,852.00 32,059.00 16,658.00 Income Tax 16,824.00 2% 2% 3% -1% 0.30% Shares issued for Each Year 10% 11% 83,647.00 13% -2% 86,774 86,000,000 84,1961 84,000,000 -1.30% #VALUE! Share outstanding for Each Year 83,000,000 #VALUE! Treasury Stock for Each Year 0% 0% 0% 0% 0.00% Net Income Net Income 50,434.00 6% 57,763.00 7% 15.401.00 2% 5% -1.90% Discussion of Largest Change This increase was attributable to costs incurred in Yeti Holding's transition to a public company. The change is primarily due to higher selling expenses, increased personnel and infrascture to support long-term growth in the business and increased depreciation and amortization expense and other expenses. Thi information was found on Yeti's investors page on their official website