Ask Question, Ask an Expert


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


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

Financial management assignmentdirections be sure to save

Financial Management ASSIGNMENT Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to us ...

Cross-border mergers are a useful means of overseas

Cross-border mergers are a useful means of overseas expansion for multinational enterprises (MNEs). What are cross-border mergers? What are the circumstances under which MNEs internationalise using cross-border mergers? ...

Fe 570 course project- 1 select security stock index or a

FE 570 Course Project- 1. Select security (stock, index, or a mutual fund), time period (2 - 5 years) and download relevant daily closing prices from 2. Find technical strategy that yields positive ...

1 what are the transaction costs ie difference between bid

1. What are the transaction costs (i.e., difference between bid and asked prices) for 10,000,000 of 3-month, 6-months and 12-months T-Bills? Use exact days to maturity for each T-Bill. For each maturity, show all the det ...

Following table shows the price information for three

Following table shows the price information for three stocks:  Stock Price 0 Quantity 0 P 1 Q 1 A $70 50 $85 50 B 10 150 12 150 C 100 30 50 60 1. What happened for stock C during this period? 2. Calculate the price-weigh ...

What are the net proceeds from the sale of a bond what are

What are the net proceeds from the sale of a bond? What are flotation costs, and how do they affect a bond's net proceeds? Please answer in 100-150 words.

The mean sat score in mathematics is the standard

The mean SAT score in mathematics, , is . The standard deviation of these scores is. A special preparation course claims that its graduates will score higher, on average, than the mean score. A random sample of students ...

Impact of lehman brothers failure explain how the

Impact of Lehman Brothers Failure : Explain how the bankruptcy of Lehman Brothers (a large securities firm) reduced the liquidity of the commercial paper market.

For questions a and b express your answer in a number

For questions A and B, express your answer in a number between 0 and 1 with four digits of precision (i.e. 25.01% is 0.2501). For question C, express your answer in two decimal places (e.g. 1.31) A manufacturing firm has ...

1 suppose that the spot rate of eur is 11250 usd for 1euro

1. Suppose that the spot rate of EUR is 1.1250 USD for 1Euro. 1 year forward rate is 1.1440 USD for 1 Euro. Suppose that the 1 year USD interest rate is 1.50% annualized and Euro interest rate is 0.001% annualized (rates ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate