Cashflow inclass exercise Jan 31

xlsx

School

Willamette University *

*We aren’t endorsed by this school

Course

GSM5112

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

14

Uploaded by DrCranePerson1079

Report
Fiscal Year End (YYYY-MM-DD) 2019/01/31 Income Statement (in 000s at most recent fiscal year end) Sales (Net) 25,625,043 Cost of Goods Sold 17,821,173 Gross Profit 7,803,870 R&D Expense 0 SG&A Expense 5,687,564 EBITDA 2,116,306 Depreciation 0 EBIT 2,116,306 Net Interest Expense 99,871 Non-Operating Income (Loss) 0 Taxable Income 2,016,435 Taxes 426,963 Net Income 1,589,472 Common Dividends 306,523 Balance Sheet (in 000s at most recent fiscal year end) Operating Cash and Market. Sec. 235,487 Receivables 0 Inventories 4,097,004 Other Current Assets 330,529 Total Current Assets 4,663,020 PP&E (Net) 2,970,806 Investments 0 Intangibles 5,538,806 Other Fixed Assets 31,406 Total Fixed assets 93,437 Total Assets 4,756,457 Current Debt 1,950 Accounts Payable 2,385,469 Income Taxes Payable 10,033 Other Current Liabilities 618,405 Total Current Liabilities 3,015,857 Total Long-Term Debt 3,161,101 Other liability 0 Total Liabilities 6,786,645 Preferred Stock 0 Common stock and capital surplus (Excluding treasury stock) 3,476,286 (5,506,474) Accumulated Retained earnings and gains and losses not affecting retained earnings
Total Liabilities and Equity 4,756,457 Q 1 what is this company's CF(A) in the last 4 years? Operating cash flow 2019 Earnings before interest and taxes Depreciation - taxes Operating cash flow (OCF) Net capital spending (not available for the first year) Ending fixed assets -Beginning fixed assets Depreciation Net capital spending (NCS) Net working capital cash flow (not available for the first year) Ending NWC (Current assets - Current liability) Beginning NWC (Current assets - Current liability) NWC cash flow ( NWC) Cash flow from assets OCF -Net capital spending -Change in NWC Cash flow from assets (CF(A)) Q 2 Should the shareholders be concerned? Or should they be pleased with the firm’s st This had a negative amount of free cash flow in recent years primarily due to its and net working capital. A negative cash flow from assets means that the amou equity would have increased
Q 3 what is this company's CF(B) and CF(S) in the last 5 years? Cash flow to creditors (not available for the first year) Beginning long-term debt -Ending long-term debt Interest Cash flow to creditors (CF(B)) Cash flow to stockholders Begining. common stock, Capital Surplus & (-)Treasury stock -Ending. common stock, Capital Surplus & (-) Treasury stock Dividends Cash flow to stockholders (CF(S)) CF(B)+CF(S)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2020/01/30 2021/01/31 2022/01/31 2023/01/31 27,753,973 33,746,839 34,220,449 37,844,863 19,264,912 23,027,977 23,407,443 26,024,765 8,489,061 10,718,862 10,813,006 11,820,098 0 0 0 0 6,186,757 7,164,097 7,592,331 8,491,796 2,302,304 3,554,765 3,220,675 3,328,302 0 0 0 0 2,302,304 3,554,765 3,220,675 3,328,302 100,574 150,385 157,526 211,273 0 0 0 (415) 2,201,730 3,404,380 3,063,149 3,116,614 489,175 749,330 663,917 700,625 1,712,555 2,655,050 2,399,232 2,415,989 327,568 355,926 392,188 493,726 240,320 1,376,577 344,829 381,576 0 0 0 0 4,676,848 5,247,477 5,614,325 6,760,733 260,700 290,165 344,689 438,700 5,177,868 6,914,219 6,303,843 7,581,009 3,278,359 3,899,997 4,346,127 5,236,309 0 0 0 0 5,538,595 5,538,459 5,538,339 5,538,289 8,830,262 9,509,949 10,139,062 10,727,760 10,297,529 14,019,078 17,518,643 21,502,358 15,475,397 20,933,297 23,822,486 29,083,367 0 0 0 0 2,860,682 3,614,089 3,738,604 3,552,991 8,362 16,063 8,055 8,919 1,673,961 2,080,631 2,232,698 2,325,858 4,543,005 5,710,783 5,979,357 5,887,768 10,904,352 12,780,054 13,260,774 16,592,921 0 0 0 0 16,122,584 19,201,386 20,065,385 23,541,595 0 0 0 0 3,539,840 3,655,136 3,787,987 3,885,632 3,162,660 3,006,102 2,473,999 1,656,140
15,475,397 20,933,297 23,822,486 29,083,367 2020 2021 2022 2023 $ 2,302,304 $ 3,554,765 $ 3,220,675 $ 3,328,302 $ - $ - $ - $ - $ 489,175 $ 749,330 $ 663,917 $ 700,625 $ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 $ 10,297,529 $ 14,019,078 $ 17,518,643 $ 21,502,358 $ 93,437 $ 10,297,529 $ 14,019,078 $ 17,518,643 $ - $ - $ - $ - $ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 $ 634,863 $ 1,203,436 $ 324,486 $ 1,693,241 $ 1,647,163 $ 634,863 $ 1,203,436 $ 324,486 $ (1,012,300) $ 568,573 $ (878,950) $ 1,368,755 $ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 $ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 $ (1,012,300) $ 568,573 $ (878,950) $ 1,368,755 $ (7,378,663) $ (1,484,687) $ (63,857) $ (2,724,793) table earnings (NI)? Please explain your answer. s increase in net capital spending unt of net new borrowing and
$ 3,161,101 $ 10,904,352 $ 12,780,054 $ 13,260,774 $ 10,904,352 $ 12,780,054 $ 13,260,774 $ 16,592,921 $ 100,574 $ 150,385 $ 157,526 $ 211,273 $ (7,642,677) $ (1,725,317) $ (323,194) $ (3,120,874) $ 3,476,286 $ 3,539,840 $ 3,655,136 $ 3,787,987 $ 3,539,840 $ 3,655,136 $ 3,787,987 $ 3,885,632 $ 327,568 $ 355,926 $ 392,188 $ 493,726 $ 264,014 $ 240,630 $ 259,337 $ 396,081
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Fiscal Year End (YYYY-MM-DD) 2019/01/31 Income Statement (in 000s at most recent fiscal year end) Sales (Net) 25,625,043 Cost of Goods Sold 17,821,173 Gross Profit 7,803,870 R&D Expense 0 SG&A Expense 5,687,564 EBITDA 2,116,306 Depreciation 0 EBIT 2,116,306 Net Interest Expense 99,871 Non-Operating Income (Loss) 0 Taxable Income 2,016,435 Taxes 426,963 Net Income 1,589,472 Common Dividends 306,523 Balance Sheet (in 000s at most recent fiscal year end) Operating Cash and Market. Sec. 235,487 Receivables 0 Inventories 4,097,004 Other Current Assets 330,529 Total Current Assets 4,663,020 PP&E (Net) 2,970,806 Investments 0 Intangibles 5,538,806 Other Fixed Assets 31,406 Total Fixed assets 93,437 Total Assets 4,756,457 Current Debt 1,950 Accounts Payable 2,385,469 Income Taxes Payable 10,033 Other Current Liabilities 618,405 Total Current Liabilities 3,015,857 Long-Term Debt 3,161,101 Other Liabilities 0 Total Liabilities 6,786,645 Preferred Stock 0 Common stock and capital surplus (Excluding treasury stock) 3,476,286 (5,506,474) Accumulated Retained earnings and gains and losses not affecting retained earnings
Total Liabilities and Equity 4,756,457 Q 1 what is this company's CF(A) in the last 4 years? Operating cash flow Earnings before interest and taxes $ 2,116,306 Depreciation $ - - taxes $ 426,963 Operating cash flow (OCF) $ 1,689,343 Net capital spending (not available for the first year) Ending fixed assets -Beginning fixed assets Depreciation Net capital spending (NCS) Net working capital cash flow (not available for the first year) Ending NWC (Current assets - Current liability) Beginning NWC (Current assets - Current liability) NWC cash flow ( NWC) Cash flow from assets OCF -Net capital spending -Change in NWC Cash flow from assets (CF(A)) Q 2 Should the shareholders be concerned? Or should they be pleased with the firm’s st This had a negative amount of free cash flow in recent years primarily due to its and net working capital. A negative cash flow from assets means that the amou would have increased. (See the calculations below) The shareholders probably should be concerned about the significant drop in th cash flow is usually an early warning signal. The company’s managers should ta alleviate the resulting deterioration of the firm’s cash flows.
Q 3 what is this company's CF(B) and CF(S) in the last 5 years? Cash flow to creditors (not available for the first year) Beginning long-term debt -Ending long-term debt Interest Cash flow to creditors (CF(B)) Cash flow to stockholders Begining. common stock, Capital Surplus & (-)Treasury stock -Ending. common stock, Capital Surplus & (-) Treasury stock Dividends Cash flow to stockholders (CF(S)) CF(B)+CF(S)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2020/01/30 2021/01/31 2022/01/31 2023/01/31 27,753,973 33,746,839 34,220,449 37,844,863 19,264,912 23,027,977 23,407,443 26,024,765 8,489,061 10,718,862 10,813,006 11,820,098 0 0 0 0 6,186,757 7,164,097 7,592,331 8,491,796 2,302,304 3,554,765 3,220,675 3,328,302 0 0 0 0 2,302,304 3,554,765 3,220,675 3,328,302 100,574 150,385 157,526 211,273 0 0 0 (415) 2,201,730 3,404,380 3,063,149 3,116,614 489,175 749,330 663,917 700,625 1,712,555 2,655,050 2,399,232 2,415,989 327,568 355,926 392,188 493,726 240,320 1,376,577 344,829 381,576 0 0 0 0 4,676,848 5,247,477 5,614,325 6,760,733 260,700 290,165 344,689 438,700 5,177,868 6,914,219 6,303,843 7,581,009 3,278,359 3,899,997 4,346,127 5,236,309 0 0 0 0 5,538,595 5,538,459 5,538,339 5,538,289 8,830,262 9,509,949 10,139,062 10,727,760 10,297,529 14,019,078 17,518,643 21,502,358 15,475,397 20,933,297 23,822,486 29,083,367 0 0 0 0 2,860,682 3,614,089 3,738,604 3,552,991 8,362 16,063 8,055 8,919 1,673,961 2,080,631 2,232,698 2,325,858 4,543,005 5,710,783 5,979,357 5,887,768 10,904,352 12,780,054 13,260,774 16,592,921 0 0 0 0 16,122,584 19,201,386 20,065,385 23,541,595 0 0 0 0 3,539,840 3,655,136 3,787,987 3,885,632 3,162,660 3,006,102 2,473,999 1,656,140
15,475,397 20,933,297 23,822,486 29,083,367 $ 2,302,304 $ 3,554,765 $ 3,220,675 $ 3,328,302 =G12 $ - $ - $ - $ - =G11 $ 489,175 $ 749,330 $ 663,917 $ 700,625 =G16 $ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 =G50+G51-G $ 10,297,529 $ 14,019,078 $ 17,518,643 $ 21,502,358 =G31 $ 93,437 $ 10,297,529 $ 14,019,078 $ 17,518,643 =F31 $ - $ - $ - $ - =G11 $ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 =G56-G57+G $ 634,863 $ 1,203,436 $ 324,486 $ 1,693,241 =G26-G38 $ 1,647,163 $ 634,863 $ 1,203,436 $ 324,486 =F26-F38 $ (1,012,300) $ 568,573 $ (878,950) $ 1,368,755 =G63-G64 $ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 =G53 $ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 =G59 $ (1,012,300) $ 568,573 $ (878,950) $ 1,368,755 =G65 $ (7,378,663) $ (1,484,687) $ (63,857) $ (2,724,793) =G68-G69-G table earnings (NI)? Please explain your answer. s increase in net capital spending unt of net new borrowing and equity he firm’s cash flows. The decline in ake the necessary steps to
$ 3,161,101 $ 10,904,352 $ 12,780,054 $ 13,260,774 =F39 $ 10,904,352 $ 12,780,054 $ 13,260,774 $ 16,592,921 =G39 $ 100,574 $ 150,385 $ 157,526 $ 211,273 =G13 $ (7,642,677) $ (1,725,317) $ (323,194) $ (3,120,874) =G93-G94+G $ 3,476,286 $ 3,539,840 $ 3,655,136 $ 3,787,987 =F43 $ 3,539,840 $ 3,655,136 $ 3,787,987 $ 3,885,632 =G43 $ 327,568 $ 355,926 $ 392,188 $ 493,726 =G18 $ 264,014 $ 240,630 $ 259,337 $ 396,081 =G99-G100+ $ (7,378,663) $ (1,484,687) $ (63,857) $ (2,724,793)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
G52 G58 G70
G95 +G101