Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help! thanks Using the financial data at the top of the Exhibit spreadsheet labeled Exhibit I for the Cigarette and Liquor Warehouse Stores, Inc.,
please help! thanks
Using the financial data at the top of the Exhibit spreadsheet labeled Exhibit I for the Cigarette and Liquor Warehouse Stores, Inc., calculate fiscal 2022 EBITDA. You estimate the firm holds $28 million of excess cash on September 30, 2022. Answer in millions and round to one decimal. EBITDA: Using the financial data in Exhibit I for the Cigarette and Liquor Warehouse Stores, Inc., calculate fiscal 2022 Free Cash Flow of the Firm. You estimate the firm holds $28 million of excess cash on September 30,2022. Answer in millions and round to one decimal. Free Cash Flow to the Firm: Using the financial data in Exhibit I for the Cigarette and Liquor Warehouse Stores, Inc., calculate fiscal 2022 Free Cash Flow of the Common Equity. You estimate the firm holds $28 million of excess cash on September 30 , 2022. Answer in millions and round to one decimal. Free Cash Flow to Common Equity: Cigarette and Liquor Warehouse Stores, Inc. Balance Sheet [\$ in millions] \begin{tabular}{|c|r|r|} \hline Years Ended September 30 & 2021 & 2022 \\ \hline Assets & & \\ \hline Cash + Equivalents & $210 & $248 \\ \hline Accounts Receivable & $474 & $513 \\ \hline Inventory & $520 & $564 \\ \hline Current Assets & $1,204 & $1,325 \\ \hline Fixed Assets, cost & $2,501 & $2,850 \\ \hline Accumulated Depreciation & ($604) & ($784) \\ \hline Fixed Assets, net & $1,897 & $2,066 \\ \hline Total Assets & $3,101 & $3,391 \\ \hline \end{tabular} Liabilities + Equities \begin{tabular}{|l|r|r|} \hline Accounts Payable & $295 & $317 \\ \hline Notes Payable & $300 & $310 \\ \hline Accrued Expenses & $76 & $99 \\ \hline Current Liabilities & $671 & $726 \\ \hline Long Term Debt & $1,010 & $1,050 \\ \hline Common Stock & $50 & $50 \\ \hline Additional Paid in Capital & $300 & $300 \\ \hline Retained Earnings & $1,070 & $1,265 \\ \hline [Treasury Stock] & $0 & $0 \\ \hline Shareholders' Equity & $1,420 & $1,615 \\ \hline Total Liabilities + Equity & $3,101 & $3,391 \\ \hline \end{tabular} Income Statement [\$ in millions] \begin{tabular}{l|c} Year Ending & 30 Sep-22 \\ \hline Total Revenues & $2,215 \\ \hline Cash Operating Costs + Expenses & ($1,430) \\ \hline Depreciation & ($180) \end{tabular} Operating Income Interest Expense Pretax Income Tax at 40\% (\$190) Net Income Dividends \$285 Statement of Cash Flows [\$ in millions] Operating Activities \begin{tabular}{|l|c|} \hline Net Income & $285 \\ \hline Adjustments & \\ \hline Depreciation & $180 \\ \hline Changes in Working Capital & \\ \hline Accounts Receivable & $39) \\ \hline Inventories & $44) \\ \hline Accounts Payable & $22 \\ \hline Accrued Expenses & 23 \\ \hline Cash Provided by Operations & $227 \\ \hline \end{tabular} Investment Activities Capital Expenditures Cash Used for Investing Activities $349$349 Financing Activities \begin{tabular}{l|r|} \hline Notes Payable & ($10) \\ \hline Long Term Debt & $40) \\ \hline Common Dividends & $90 \\ \hline Cash Used for Financing Activities & $40 \\ \hline Change in Cash + Equivalents & $38 \\ \hline Beginning Cash + Equivalents & $10 \end{tabular} Ending Cash + Equivalents $248 Supplemental Information Interest Paid Income Taxes Paid $130 $190Step 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