Mountain State Sporting Goods (Fraud Investigation Phases 4-6.)

profilehuang.lis
MountainStateCashFlows.xlsx

Sheet1

Mountain State Sporting Goods, Inc
Cash Flow Statement Worksheet
Year Ending 2008
Beginning End
Assets of Year Increase Decrease of Year
Current Assets:
Cash $ 82,803 $ 63,904
Inventory $ 281,147 $ 296,776
Total CA $ 363,950 $ 360,680
Equipment $ 83,498 $ 123,498
Accum Dep $ (66,824) $ (73,358)
Net FA $ 16,674 $ 50,140
Other Assets $ 1,253 $ 1,253
Total Assets $ 381,877 $ 412,073
Liabilities and Equity
Current Liabilities
Payroll taxes payable $ 49,169 $ 51,789
Sales tax payable $ 16,593 $ 18,410
Total CL $ 65,762 $ 70,199
LT debt $ 44,441 $ 42,579
Total Liabilities $ 110,203 $ 112,778
Equity
Common Stock $ 1,000 $ 1,000
Retained earnings $ 270,674 $ 298,295
Total Equity $ 271,674 $ 299,295
Total Liab and Equity $ 381,877 $ 412,073
Statement of Cash Flows
Year ended 2008
Cash Flows from Operations:
Net income
Non cash expense- dep
Change in working capital accounts:
Inventory
Payroll taxes payable
Sales tax payable
Cash Flows from operations
Cash Flows from Investing Activities
PPE additions
Cash Flows from Investing Activities
Cash Flows from Financing Activities:
Long term debt
Dividends
Cash Flows from Financing Activities
Change in cash
Cash at beginning of year
Cash at end of year