Question
Given the following information, calculate the cash flow statement for the current and prior year using the indirect method. Exhibit 1: Income Statement (US$ Thousands)
Given the following information, calculate the cash flow statement for the current and prior year using the indirect method.
Exhibit 1: Income Statement (US$ Thousands) | |||
Current year | Prior year | Two years prior | |
Total revenue | $ 441,588 | $ 589,379 | $ 650,261 |
Store operating expenses | |||
Food & beverage | 125,190 | 168,222 | 189,363 |
Labour & benefits | 149,140 | 191,034 | 207,091 |
Occupancy & other | 118,281 | 156,517 | 162,433 |
Total | 392,611 | 515,773 | 558,887 |
Other operating expenses | |||
Depreciation and amortization | 14,861 | 19,639 | 23,140 |
General & administrative | 26,580 | 31,011 | 36,976 |
Asset impairment | 45,994 | 49,110 | 58,485 |
Operating income (loss) | (38,458) | (26,154) | (27,227) |
Interest expense | 31,050 | 35,305 | 38,262 |
Other losses and charges | 26,458 | 22,651 | 23,773 |
Gain on debt extinguishment | (32,912) | - | - |
Loss before income taxes | (63,054) | (84,110) | (89,262) |
Income tax expense (benefit) | 375 | 11,150 | (23,528) |
Net loss | $ (63,429) | $ (95,260) | $ (65,734) |
Exhibit 2: Balance Sheet (US$ Thousands) | ||||
Current year | Prior year | Two years prior | Three years prior | |
Assets | ||||
Cash and cash equivalents | $ 636 | $ 10,537 | $ 402 | |
Accounts receivable | 5,087 | 10,723 | 7,621 | |
Inventories | 5,283 | 5,870 | 9,418 | 9,097 |
Prepaid expenses and other | 2,129 | 2,928 | 3,535 | |
Total current assets | 13,135 | 30,058 | 20,976 | |
Premises and equipment, net | 252,870 | 292,765 | 315,793 | |
Goodwill, net | - | 34,920 | 72,012 | |
Deferred income tax benefit | 11,620 | 11,620 | 18,900 | |
Other assets | 28,670 | 29,193 | 44,000 | |
Total assets | $ 306,295 | $ 398,556 | $ 471,681 | $ 656,596 |
Liabilities and shareholders' equity | ||||
Current liabilities: | ||||
Accounts payable | $ 11,509 | $ 15,766 | $ 16,568 | |
Accrued liabilities | 54,292 | 64,265 | 64,567 | |
Income taxes payable | 35,038 | 33,773 | 30,164 | |
Total current liabilities | 100,839 | 113,804 | 111,299 | |
Long-term debt | 199,869 | 215,828 | 194,541 | |
Other long-term liabilities | 2,143 | 3,111 | 5,024 | |
Total liabilities | 302,851 | 332,743 | 310,864 | |
Shareholders' equity (deficit): | ||||
Common stock | 405 | 405 | 405 | |
Additional paid-in capital | 154,637 | 146,139 | 147,809 | |
Retained earnings (accumulated deficit) | (58,118) | 5,311 | 100,571 | |
Treasury stock at cost | (93,480) | (86,042) | (87,968) | |
Total shareholders' equity (deficit) | 3,444 | 65,813 | 160,817 | |
Total liabilities & shareholders' equity (deficit) | $ 306,295 | $ 398,556 | $ 471,681 |
Complete the cash flow statemnt under the following assumptions.
a. All depreciation and amortization are related to net property and equipment.
b. Other assets are associated with cash from investing activities.
c. Other long-term liabilities pertain to cash from financing activities.
d. The capital expenditure amounts for the current and prior years are ($5,426) and ($8,629) respectively.
e.The company sale of equipment amounts to $19,386 for the current year and $0 for the prior year.
Additional info;
1. Gain on early retirement of debt is a positive number (because it is a gain) of $32,912 in the current year. This figure includes US$8,500 in credit for facility amendment and waiver fee.
2. Asset Impairment charges need to be treated in a similar fashion as depreciation in the cash flow statements.
3. Any changes in other assets need to be reflected in the investing activities section of the cash flow statement.
4. Any changes in long-term liabilities need to be reflected in the financing activities section of the cash flow statement. 5. Treasury stock reflects the amount at which shares were repurchased. For example, in the current year, treasury stock stands at ($93,480) which means that the company spent $93,480 to repurchase shares. You need to account for this in the financing activities section of the cash flow statement.
6. Additional Paid in capital increases the equity and needs to be accounted for in the financing activities section of the cash flow statement
Step by Step Solution
3.48 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
To calculate the cash flow statement using the indirect method we need to analyze the changes in various balance sheet accounts and incorporate the gi...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