Purchase Solution

Net Income

Not what you're looking for?

Ask Custom Question

PLEASE USE MS EXCEL.

The Walton Company produces a specific item with the following information:

Sales Price $400 per unit
Variable Costs $100 per unit
Fixed Costs $150,000
Units Produced and Sold 2,000

Please use MS EXCEL to:

1) Calculate Net Income
2) Calculate the Contribution Margin per unit
3) Calculate the Contribution Margin Ratio
4) If the Walton Company sells 500 more additional units, by what amount will net income increase?
5) If the Walton Company has an additional $20,000 in sales, by what amount will net income increase?

Purchase this Solution
Solution Summary

MS Excel is used for calculating net income, contribution margin, contribution margin ratio etc.

Solution Preview

Please see attached file:

PLEASE USE MS EXCEL.
The Walton Company produces a specific item with the following information:
Sales Price $400 per unit
Variable Costs $100 per unit
Fixed Costs $150,000
Units Produced and Sold 2,000
Please use MS EXCEL to:

1)      Calculate Net Income

Units Produced and Sold= 2,000
Selling Price= $400 per unit
Variable cost= $100 per unit

Revenue $800,000 =2,000. x $400.
Less Variable Cost $200,000 =2,000. x $100.
Contribution $600,000 =$800,000.-$200000.
Less Fixed Cost $150,000
Net Income $450,000 =$600,000.-$150000.

Answer: Net Income= $450,000

2)      Calculate the ...

Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Motivation

This tests some key elements of major motivation theories.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • Operating Activity for Cash Flows

    Net income as reported by income statement and net income as reconciled in cash flow statement by converting accrual basis income in to cash basis may be different.

  • Net income and Net cash flow

    Net income = (operating income - depreciation) * ( 1 - tax rate) Net income = (750,000 - 200,000) * (1 - .40) Net income = 330,000 Net cash flow = Net income + depreciation Net cash flow = 330,000 + 200,000 Net cash flow = 530,000 The expert

  • Parthenon Company net income and year ratio

    If Parthenon Company had net income of $672,300 in 2007 and it experienced a 20% increase in net income over 2006, what was its 2006 net income? Let X be the net income for 2006.

  • Income from operations and net income

    B) Calculate net income for the year ended December 31, 2010.

  • Winston Corp: Calculating Net Income

    Winston Corporation's share of Net Income from Fullbright Company $ 28,000 Net Income $128,000 20X3 Winston Corporation's Operating Income $60,000 Winston Corporation's share of Net Income from Fullbright Company $16,000 Net Income

  • Calculation of Net Income Per Books versus Tax Return

    This solution calculates the net income per tax return from the net income per books.

  • Compute net sales, cost of goods sold, operating expenses

    (a) Net Income as a percentage of sales = Net Income/Net Sales Net Sales = Net Income/Percetage 2007 - Net Sales = 160,000/.12 = 1,333,333 2006 - Net Sales = 153,000/.11 = 1,390,909 (b) Gross Profit = Net Sales - Cost of goods sold Cost of goods

  • Ratio Analysis

    / Current Liabilities] 3 Total Liabilities to Net Worth 4 Fixed Assets to Net Worth 5 Income to Net Worth 6 Net Income to Total Income % 7 Net Income to Net Worth % 8 Net Income to Total Assets % Calculate all key financial ratios (below) for

  • Calculation of interest expense & depreciation

    , net income and net cash flows are given

  • Calculate operating income after tax and net financial expense

    283841 Calculate operating income after tax and net financial expense A firm reported $818 million of net income in its income statement after $140 million of net interest expense and income tax expense of 4402 million.

View More Related Solutions