Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Based on the following data table, please provide the cash flow statement from Day 1 to Day 365 for the company. Please be sure

Based on the following data table, please provide the cash flow statement from Day 1 to Day 365 for the company. Please be su 

Based on the following data table, please provide the cash flow statement from Day 1 to Day 365 for the company. Please be sure to include the year ending cash position. Hint: You need to: 1. Create an income statement 2. Read the Notes carefully Day 1 ($000's) Day 365 ($000's) Account Notes Monthly Sales $0 $40,000 | Sales, expenses etc. in the Cash Flow Statement ($000's) Income Statement are the same Net Profit for all 12 months Accounts Payable COGS - % of sales 70% 70% Company pays all COGS in 60 Accrued Taxes Days or two months Depreciation Monthly Operating $0 $6,000 Company pays operating Accounts Receivable expenses during each month 25% Company pays taxes 3 months after they are due Expenses Inventory Income Tax Liability - % 25% of Income before taxes Capital Investment (PPE) $0 $20,000 Paid on day 90 of year one Cash from Operations during year Depreciation for total PPE $15,000 Included in COGS and Operating Expenses (above) utilized for the $0 year Income Statement Cash Used in Investing Cash $25,000 Calculate Bonds Owners Paid in Capital Accounts Receivable $0 Calculate Customers pay invoices in 45 days or one and one-half months Cash from Financing Activities $0 $0 $0 $0 Inventory $35,000 Accounts Payable Calculate Bonds Issued $30,000 10 year maturity Accrued Taxes Calculate Ending Cash Owners Paid-in Capital Calculate Calculate $0 Retained Earnings Owner's Equity Calculate Calculate Calculate

Step by Step Solution

3.48 Rating (151 Votes )

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_2

Step: 3

blur-text-image_3

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

College Accounting A Practical Approach

Authors: Jeffrey Slater

12th edition

978-0132772068, 133468100, 013277206X, 9780133468106, 978-0133133233

More Books

Students explore these related Accounting questions