Based on the following data table, please provide the cash flow statement from Day 1 to...

 

Transcribed Image Text:

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 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