Create all four financial statements
Not what you're looking for?
Creating financial statements
Accounts Payable 20,000
Account Receivable 60,000
Capital Stock 252,000
Cash ?
Cash Payments for operating activities 657,000
Cash Receipts from operating activities 690,000
Cost of Sales 435,000
Dividends 30,000
Income Tax expense 53,000
Income Tax payable 8,000
Interest expense 2,000
Inventories 115,000
Notes Payable (due in 2017) 50,000
Property, plant, and equipment 265,000
Retained earnings ?
Sales 750,000
Selling and administrative expense 80,000
Create an income statement, retained earnings statement, balance sheet, and statement of cash flows.
Purchase this Solution
Solution Summary
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.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Motivation
This tests some key elements of major motivation theories.