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

1 where is lead most likely to be found in a household2

1. Where is lead most likely to be found in a household? 2. Identify the criteria for determining existence of wetlands. 3. What happens to land containing an endangered species habitat? 4. Discuss a landowner's rights i ...

A poll conducted by the new york times shows candidate a

A poll conducted by the New York Times shows candidate A leading candidate B by 33 to 31 percent. A poll conducted by the Washington Post shows candidate B leading candidate A by 34 to 32 percent. If the margin of error ...

A bond with a par value of 100000 and a semiannual coupon

A bond with a par value of $1,000.00 and a semiannual coupon has a nominal yield to maturity of 5.30% and a current price of $920.00. If the bond has 6 years to maturity, what is its current yield? 4.23% 4.34% 0.00% 4.18 ...

Ford is about to issue a new corporate bond face value 1000

Ford is about to issue a new corporate bond, face value= $1,000, coupon rate 8% (Annual), term to maturity= 4 years. You know that a very similar bond issued by GM is already being traded in a bond market with its market ...

As in ada suppose that each expression must have a unique

As in Ada, suppose that each expression must have a unique type, but that from a subexpression, by itself, all we can deduce is a set of possible types. That is, the application of function E1 to argument E2, represented ...

1 what is exchange-rate risk how can exchangerate risk be

1. What is exchange-rate risk? How can exchangerate risk be hedged using forward, futures, and options contracts? 2. How might an investor use forward, futures, and options contracts to speculate on the future value of a ...

Locate a newspaper or magazine article that reports a

Locate a newspaper or magazine article that reports a behavioral science research project. a. Determine whether the project is a descriptive, a correlational, or an experimental research design. b. What variables are mea ...

Assignmentcareers in finance finance is an exciting field

Assignment Careers in Finance Finance is an exciting field in need of intelligent, skilled people. The job opportunities range from corporate finance; financial planning; investment banking; insurance; and real estate fr ...

1 what advantage does drp have over a fair share method of

1. What advantage does DRP have over a fair share method of inventory deployment? 2. Discuss the importance of collaboration in the developing of supply chain inventory strategies. Provide an example. 3. Customer-based i ...

1 when the federal reserve raises the real interest rate

1. When the Federal Reserve raises the real interest rate, does the economy move up or down the IS curve, and does the value of the output gap increase or decrease? 2. What is the Phillips curve? Why is there an inverse ...

  • 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