Purchase Solution

Balance sheet for Sample Company

Not what you're looking for?

Ask Custom Question

I have a presentation that requires excel file (3 pages)
The data figure has to be accurate
but it is sample company

1. Balance sheet for Jan 10
2. Current budget for 2010
3. Income statement for 3 years

Company made 9.7 mil in 07
Company made 15.5 mil in 08
Company made 47.2 mil in 09

ALL Expenses increased 22% from 2008 and 13% from 2007
Company pays out the following expense in 2009:

Accounts Receivable 47.2

Accounts Payable

Salaries & Commissions 680k year
Office Rent 26k/mo
Inventory 1.6 mil
Insurances & Licensees 8400/year
Travel 85k year
Conferences & Seminars 780k year
Legal 255k year
Goodwill 10% of revenues (same for all 3 years)
Advertising & Marketing 27% of revenues
Support Contracts 325k year
Investments 25.2 million (no investments for 07, 08
Research & Development 1.8mil
Taxes 30%

Attachments
Purchase this Solution
Solution Summary

The expert examines the balance sheets for sample companies.

Solution Preview

NOTE: I answered the requirements based on the information provided

Please double check. It's on the ...

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

View More Free Quizzes
Related BrainMass Solutions

  • The income statement

    each account, indicate whether a company would ordinarily disclose the account on balance sheet, or income statement. ** Please see the attached file for the complete solution response ** Listed below are accounts that may appear on the balance sheet

  • Company Financial Analysis

    Other than the 2007 income statement and balance sheet for the company, what other financial statements are required?

  • Uncollectible accounts: balance sheet approach vs. income statement approach

    Problem: In making the annual adjusting entry for uncollectible accounts, a company may utilize a balance sheet approach to make the estimate, or it may use an income statement approach.

  • Consolidated Balance sheets: issues of goodwill, differentia

    The links include sample journal entries for better understanding.

  • A sample ratio analysis in Excel

    The ratios are linked with the balance sheet, income statement and cash flow statement worksheets. From this handy calculations, students may learn how to calculate each ratio.

  • How are layaway cash amounts recorded?

    "I don't believe my company records unearned income in their balance sheet. We are a retail company, and, although we have layaway, most of our sales are immediate cash for product transactions.

  • Trial Balances and Petty Cash

    For the first question - I have attached a classified balance sheet and all you need to do is fill in the numbers from the data you were given.

  • Prepare fictitious personal budget, balance sheet, cash flow

    Prepare a personal budget, balance sheet, and cash flow statement. Summarize key items and findings from the personal budget, balance sheet, and cash flow statement. Recommend and support actions for improving the financial situation.

  • Primary Financial Statements

    See components of the Income Statement explained in the next question (#2), following the sample of a Balance Sheet and Income Statement.

View More Related Solutions