Use the data given to develop a Statement of Cash flows for 2007and calculate...

Free

60.1K

Verified Solution

Question

Accounting

Use the data given to develop a Statement of Cash flows for 2007and calculate change in cash from 2006 in operating, investing andfinancing activities and reconcile to beginning and endingcash.

Income Statements
(Thousands of Dollars)
Katie's ConstructionPeer
20062007Proj. 2008Com. Size
Net Sales81,95083,875101,488.75100.00
Cost of goods sold66,00070,95085,849.581.00
Gross Profit15,95012,92515,639.2519.00
000
S & A Expenses8,3609,997.911,163.76210.00
Depreciation1,1009021,0451.00
Operating Profit6,4902,025.13,430.4888.00
000
Interest Expense775.51,322.21,125.31.00
Pre-Tax Profit5,714.5702.92,305.1887.00
000
Tax (34%)1,942.93238.986783.7642.38
After Tax profit3,771.57463.9141,521.4244.62
000
Dividends1,377.2165660
Retained Earnings2,394.37298.914861.424
No. of Shares1,4501,4501,450
Stock Price/Share139
Balance Sheets
(Thousands of Dollars)
Katie's ConstructionPeer
20062007Proj. 2008Com. Size
Cash1,7601,427.81,7603.5
Accounts Receivable8,14013,20011,55028
Inventory14,609.120,90015,381.347
Total Current Assets24,509.135,527.828,691.378.5
000
Net Fixed Assets6,832.17,156.68,760.421.5
Total Assets31,341.242,684.437,451.7100
000
Accounts Payable4,6208,8006,60015
Notes Payable2,256.18,2504,2909
Accruals2,2553,242.83,567.087.5
Total Current Liabilities9,131.120,292.814,457.0831.5
000
Long Term Debt5,380.15,262.45,148.70419
Total Liabilities14,511.225,555.219,605.78450.5
000
Common Equity16,83017,129.217,845.91649.5
Total Liabilities & Equity31,341.242,684.437,451.7100

Answer & Explanation Solved by verified expert
4.1 Ratings (492 Votes)

cash flow statement

Indirect Method

net income

463.91

add depreciation

902.00

changes in working capital

increase in accounts receivables

-5060.00

increase in inventory

-6290.90

increase in accounts payable

4180.00

increase in accruals

987.80

increase in notes payable

5993.90

cash flow from operating activities

1176.714

cash flow from investing activities

purchase of fixed assets

6832.1-(7156.6+902)

-1226.5

cash flow from investing activities

-1226.5

cash flow from financing activities

payment of long term debt

-117.7

dividend paid

-165

cash flow from financing activities

-282.7

net cash flow during the year

-332.486

beginning cash balance

1760

year end cash balance

1427.514

0.286

Difference in closing balance of cash due to the figure of retained earnings

retained earning given in balance sheet

17129.2

retained earning should be

16830+298.914

17128.914

difference in cash balance due to changed amount of retained earning

0.286


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingUse the data given to develop a Statement of Cash flows for 2007and calculate change...Use the data given to develop a Statement of Cash flows for 2007and calculate change in cash from 2006 in operating, investing andfinancing activities and reconcile to beginning and endingcash.Income Statements(Thousands of Dollars)Katie's ConstructionPeer20062007Proj. 2008Com. SizeNet Sales81,95083,875101,488.75100.00Cost of goods sold66,00070,95085,849.581.00Gross Profit15,95012,92515,639.2519.00000S & A Expenses8,3609,997.911,163.76210.00Depreciation1,1009021,0451.00Operating Profit6,4902,025.13,430.4888.00000Interest Expense775.51,322.21,125.31.00Pre-Tax Profit5,714.5702.92,305.1887.00000Tax (34%)1,942.93238.986783.7642.38After Tax profit3,771.57463.9141,521.4244.62000Dividends1,377.2165660Retained Earnings2,394.37298.914861.424No. of Shares1,4501,4501,450Stock Price/Share139Balance Sheets(Thousands of Dollars)Katie's ConstructionPeer20062007Proj. 2008Com. SizeCash1,7601,427.81,7603.5Accounts Receivable8,14013,20011,55028Inventory14,609.120,90015,381.347Total Current Assets24,509.135,527.828,691.378.5000Net Fixed Assets6,832.17,156.68,760.421.5Total Assets31,341.242,684.437,451.7100000Accounts Payable4,6208,8006,60015Notes Payable2,256.18,2504,2909Accruals2,2553,242.83,567.087.5Total Current Liabilities9,131.120,292.814,457.0831.5000Long Term Debt5,380.15,262.45,148.70419Total Liabilities14,511.225,555.219,605.78450.5000Common Equity16,83017,129.217,845.91649.5Total Liabilities & Equity31,341.242,684.437,451.7100

Other questions asked by students