Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Thanks for helping out in advance What is the trend in the EBITDA-to-total-debt-service and Funded debt-to-EBITDA ratios for the years 20Y2 and 20Y3? The EBITDA-to-Total-debt-service
Thanks for helping out in advance
What is the trend in the EBITDA-to-total-debt-service and Funded debt-to-EBITDA ratios for the years 20Y2 and 20Y3? The EBITDA-to-Total-debt-service improved from 2.1 to 3.0 and Funded-debt-to-EBITDA improved from 2.9 to 2.1. The EBITDA-to-Total-debt-service improved from 1.4 to 1.9 despite the decrease of Funded-debt-to-EBITDA from 6.4 to 6.3. The EBITDA-to-Total-debt-service increased slightly from 0.3 to 0.5 and the Funded-debt-to-EBITDA decreased from 6.4 to 6.3. The EBITDA-to-Total-debt-service increased from 2.1 to 2.9 in spite of the modest decline of Funded-debt-to-EBITDA from 6.4 to 6.3. Brook Plumbing Supply Company, Inc. Balance Sheets (in $000s) As At December 31: 2093 20Y2 20Y1 $ $ $ ASSETS Current assets Cash and equivalents Accounts receivable Inventory Other current assets Total current assets 110 785 1,075 40 2,010 154 770 902 97 885 1,020 23 2,025 44 1,870 Fixed assets Gross fixed assets Less: Accumulated depreciation Net fixed assets 335 117 218 331 100 327 89 231 238 Other noncurrent assets 97 99 TOTAL ASSETS $ 2,325 $ 2,200 $ 2,358 $ 551 155 LIABILITIES AND EQUITY Current liabilities Accounts payable Accrued expenses Other current liabilities Notes payable Current portion-LTD Total current liabilities 117 473 136 91 592 62 1,354 528 143 99 486 66 1,322 490 68 1,381 Long-term debt 143 277 209 33 277 Other noncurrent liabilities Owners' equity 793 636 663 TOTAL LIABILITIES AND EQUITY $ 2,325 $ 2,200 $ 2,358 Brook Plumbing Supply Company, Inc. Income Statements (in $000s) Years Ended December 31: $ $ $ Sales Cost of goods sold Gross profit 20Y3 6,504 4,814 1,690 20Y2 5,801 4,258 1,543 20Y1 5,120 3,661 1,459 901 915 905 417 General and administrative expense Selling expense Interest expense Profit before taxes 303 Provision for income taxes 146 Net income $ 157 $ 102 $ 56 Depreciation in general and administrative expenses 20 12 Brook Plumbing Supply Company, Inc. Monthly Sales (in $000s) 20Y2 $ 20Y3 405 455 480 496 January February March April May June July August September October November December 610 615 640 398 405 450 455 520 545 570 590 505 459 439 465 oo 556 Quick Cash Flow (in $000s) Company Name: Brook Plumbing Supply Company, Inc. WI (U) GFA (U) s S 2042 2043 157 20 Net profit Plus: Depreciation, amortization expense Plus (or less): A Working investment Equals: Cash after operating cycle 102 12 198 312 Plus (or less): A Gross fixed assets Equals: Cash after capital investment cycle 304 o 0 Less: Dividends declared Equals: Cash available for all debt repayment 304 (66) Less: Current portion long-term debt (prior year) Equals: Cash available for other debt repayment (68) 236 ENDING 770 902 Change in working investment Accounts receivable (net) Plus: Inventory Less: Accounts payable Less: Accrued expenses Equals: Working investment BEGINNING 885 1,020 551 155 1,199 143 1,001 Beginning working investment Less: Ending working investment Equals: A Working investment 1,199 1,001 198 20Y2 BEGINNING ENDING Change in working investment Accounts receivable (net) Plus: Inventory Less: Accounts payable Less: Accrued expenses Equals: Working investment Beginning working investment Less: Ending working investment Equals: A Working investment 2013 BEGINNING ENDING Change in working investment Accounts receivable (net) Plus: Inventory Less: Accounts payable Less: Accrued expenses Equals: Working investment Beginning working investment Less: Ending working investment Equals: A Working investment Are any changes in income taxes payable, interest payable, prepaid expenses, investments, or miscellaneous other accounts large enough to distort quick cash flowStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started