Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

problem: Construct a worksheet with an information table (Suggestion: look in the book for the data table) for Sony Entertainment that analyzes the breakeven point for CD prices between $5 & $10 in .20 increases.

            Break Even point = Fixed Expenses [Price per unit - Expense per unit]

            Fixed Expenses = $10,000,000 [name this cell & 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 computations. Format money as currency.

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

Use Goal seek to find out Fixed Expenses if breakeven point is set to 3,000,000

Sony Entertainment

 

 

Fixed Expenses

 $10,000,000.00

Expenses per unit

 mce_markernbsp;              2.45

Price per Unit

 mce_markernbsp;              5.00

Breakeven point

 

 

 

Data Table for different Prices per Unit

 

Price per Unit

Breakeven Point

 

 

 mce_markernbsp;                  5.00

 

 mce_markernbsp;                  5.20

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M920512

Have any Question? 


Related Questions in Basic Finance

Examine the following case Examine the following case study:

Examine the following case study: http://www.finance.nsw.gov.au/ict/resources/nsw-government-digital-information-security-policy 1. Use a diagram (produced by the means of using Rationale, Visio or any other relevant sof ...

If the calculated value of f is found to be significant for

If the calculated value of F is found to be significant for the main effect of an independent variable with more than two levels, what tests does the researcher then conduct? Why are such tests not necessary if the indep ...

1 a researcher would like to compare two therapy techniques

1. A researcher would like to compare two therapy techniques for treating depression in both adolescents and adults. Identify which factor is experimental and which is quasi-experimental. 2. Suppose a researcher has demo ...

Determine whether information has to be documentedimagine

Determine whether information has to be documented. Imagine that you're writing a case study report about the bookseller Barnes and Noble. Which of the following information has to be documented in a report? • Barnes and ...

Budget analysis needed asapi need a budget analysis

Budget analysis needed ASAP I need a budget analysis completed. I will provide the template and previous assignments needed to complete this project. I am on a time crunch and need this done ASAP. Using the workbooks and ...

The scores on an aptitude test required for entry into a

The scores on an aptitude test required for entry into a certain job position have a mean at most 500. If a random sample of 36 applicants have a mean of 546 and a standard deviation of 120, is there evidence that their ...

A very thin polymeric coating of thickness 01 mm uniformly

A very thin polymeric coating of thickness 0.1 mm uniformly coats a rectangular surface. The rectangular surface has a length of 20 cm and a width of 10 cm. the coating contains a solvent that must be evaporated away fro ...

You must show workinputs in order to receive partial

YOU MUST SHOW WORK/INPUTS IN ORDER TO RECEIVE PARTIAL CREDIT.  Lincoln Restaurants is introducing a new product this year. If "glow in the dark hamburgers" are a hit, the firm expects to be able to sell 500 units a year ...

What is the objective of an industry self-regulatory

What is the objective of an industry self-regulatory organization? Compare and contrast three types of futures trading costs? Compare and contrast cash settlement with physical settlement ? Identify the typical character ...

What are examples of money market securities provide at

What are examples of money market securities? Provide at least four examples ? What is the difference between an exchange and an over-the-counter market? What are the three forms of market efficiency? What distinguishes ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro