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 why is the income approach to value often difficult to

1. Why is the income approach to value often difficult to use on a single-family residential appraisal? 2. What are the differences between the cost and sales comparison approaches to appraising property? 3. What are the ...

1 discuss uncertainty as it relates to the overall

1. Discuss uncertainty as it relates to the overall logistical performance cycle. Discuss and illustrate how performance cycle variance can be controlled. 2. What is the logic of designing echeloned logistical structures ...

Cost of common equity with flotationbanyan cos common stock

Cost of Common Equity with Flotation Banyan Co.'s common stock currently sells for $42.00 per share. The growth rate is a constant 11.2%, and the company has an expected dividend yield of 3%. The expected long-run divide ...

1 historically what types of risk were the focus of most

1. Historically, what types of risk were the focus of most firms' risk- management practices? 2. Distinguish between the motivations for purchasing insurance and the motivations for hedging marketwide sources of risk. 3. ...

The rex-lint inc is planning to put a manufacturing

The Rex-Lint Inc. is planning to put a manufacturing facility in place to build widgets. The systematic risk of this project alone is 25% greater than they currently manage. The company has a target debt to value ratio o ...

It is essential that you have a solid grounding in the

It is essential that you have a solid grounding in the academic theories of investing. In your final assignment, compare and contrast the academic theories of investing covered in your required readings with the philosop ...

If you receive 15000 today and can invest it at a 5 annual

If you receive $15,000 today and can invest it at a 5% annual rate compounded continuously, what will be your ending value after 20 years?

A firm is considering the purchase of a machine which would

A firm is considering the purchase of a machine which would represent an investment of $31 million, and would be depreciated in a straightline basis over 4 years. Sales are expected to be $11 million per year, and operat ...

Explain an mncs strategy of diversifying projects

Explain an MNC's strategy of diversifying projects internationally to maintain a low level of overall country risk? Do you think that a full country risk analysis can replace a capital budgeting analysis of a project in ...

Can someone help provide the steps and solution to this

Can someone help provide the steps and solution to this problem. X-treme Vitamin Company is considering two investments, both of which cost $10,000. The cash flows are as follows: Year Project A Project B 1.............. ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen