Prepare a worksheet with a data table

Assignment Help Corporate Finance
Reference no: EM1315880

Computation of Break-even-point in units.

Create a worksheet with a data table (Hint: look in the book for the data table)

 for Sony Entertainment that analyzes the breakeven point for CD prices between $5.00 and $10.00 in .20 increments.

            Break Even point = Fixed Expenses / (Price per unit - Expense per unit)

            Fixed Expenses = $10,000,000 (name this cell and use in formula)

            Price per unit = $5.00

            Expenses per unit = $2.45

Name the cells for fixed expenses, Price per Unit, Expenses per unit, Breakeven point and use the names in the calculations.

Format money as currency.

Use conditional formatting to highlight when the breakeven point is less than 2,000,000 in the data table.

*** Use Goal seek to calculate Fixed Expenses if breakeven point is set to 3,000,000

Sony Entertainment

 

 

Fixed Expenses

 $10,000,000.00

Expenses per unit

 $               2.45

Price per Unit

 $               5.00

Breakeven point

 

 

 

Data Table for different Prices per Unit


Price per Unit

Breakeven Point

 

 

 $                   5.00

 

 $                   5.20

 

 

Reference no: EM1315880

Questions Cloud

Use the binomial theorem : Use the binomial theorem
Finding the expansion path : Suppose a production function is given by f(K;L) = KL 2 What combination of labour and capital minimizes the cost of producing any given output?
Margin of error for the population proportion : Find the margin of error for the 95% confidence interval used to estimate the population proportion.
Sample size when margin of error ids given : Find the sample size for the 95% confidence interval used to estimate the population proportion.
Prepare a worksheet with a data table : Computation of Break-even-point in units and prepare a worksheet with a  data table  (Hint: look in the book for the data table)
Elasticity of demand over time : From each pair of goods, pick the good for which demand will most likely be more elastic:
Finding coefficient : Finding coefficient
Cross price elasticity for substitute goods : Calculate the cross-price elasticity for the following goods.  Are they complements or substitutes?
Evaluation of break even number of students : Evaluation of break even number of students of a college - How many students does the college need to enroll to break even?

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd