Purchase Solution

Create all four financial statements

Not what you're looking for?

Ask Custom Question

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.

Solution provided by:
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.