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

You were recently hired as management director of the new i

You were recently hired as management director of the new I Can Business Incorporated (ICBI). You have been asked to establish policies and systems for the business. The first one you choose to work on is a financial rep ...

Identify a sample of food companies for example you could

Identify a sample of food companies. For example, you could try Campbell Soup (CPB), General Mills (GIS), Kellogg (K), Kraft Foods (KFT), and Sara Lee (SLE). a. Estimate beta and R2 for each company, using five years of ...

For the year ended june 30 2014 northern clothing company

For the year ended June 30, 2014, Northern Clothing Company has total assets of $69,500,000, ROA of 12.07 percent, ROE of 19.31 percent, and a net profit margin of 11.58 percent. What are the company's net income and net ...

Discussion 1ratio analysisusing the ashford university

Discussion 1 Ratio Analysis Using the Ashford University Library as a resource, find two articles that discuss financial ratio analysis. Identify two advantages and two disadvantages to using ratios in financial analysis ...

Market view video presentationbackground informationthe

MARKET VIEW VIDEO PRESENTATION Background information The foreign exchange market is an ever-so-changing area of the financial markets. In the foreign exchange market we see extremely rapid movements in exchange rates wi ...

Q1 an on-line retailing firm conducts a study into the

Q1. An on-line retailing firm conducts a study into the number of on-line purchases of footwear made during all of last year. The study wants to determine the proportion of Australians over the age of 25 who purchase foo ...

What is the present value of 12500 to be received 8 years

What is the present value of $12500 to be received 8 years from today? Assume a discount rate of 4.5% compounded annually and round to the nearest $10.

Describe each of the three components in the aim planning

Describe each of the three components in the AIM planning process for business messages: audience analysis, idea development, and message structuring.

Define par face value coupon rate coupon payment and

Define par ( face) value, coupon rate, coupon payment, and current yield. What are call provisions and convertible provisions, and how do they affect the interest rates on newly issued securities?

Discuss the major function of market makers in securities

Discuss the major function of market makers in securities markets. What is the difference between a broker and a dealer?

  • 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