Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 $190

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alex Kane, Alan Marcus, Lorne Switzer, Maureen Stapleton, Dana Boyko, Christine Panasian

9th Canadian Edition

1259271935, 9781259271939

More Books

Students also viewed these Finance questions

Question

Discuss the importance of asset management.

Answered: 1 week ago

Question

Draw a picture consisting parts of monocot leaf

Answered: 1 week ago

Question

What are possible safety concerns? Explain.

Answered: 1 week ago

Question

What would you do if you were in Margarets shoes?

Answered: 1 week ago