Creating financial statements
Accounts Payable 20,000
Account Receivable 60,000
Capital Stock 252,000
Cash Payments for operating activities 657,000
Cash Receipts from operating activities 690,000
Cost of Sales 435,000
Income Tax expense 53,000
Income Tax payable 8,000
Interest expense 2,000
Notes Payable (due in 2017) 50,000
Property, plant, and equipment 265,000
Retained earnings ?
Selling and administrative expense 80,000
Your tutorial shows the four financial statements in Excel. Click on cells to see calculations. I assumed no beginning retained earnings (no mention was made) and plugged backwards for beginning cash.