Build a spreadsheet model to calculate the profit

Assignment Help Financial Management

Reference no: EM13911299

Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and Web site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell access to the book for $46 each.

a. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3500 copies?

b. Use a data table to vary demand from 1000 to 6000 increments of 200 to assess the sensitivity of profit to demand.

c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3500 copies.

Reference no: EM13911299

Questions Cloud

Dividends continue to grow at rate for foreseeable future : ATP Industries paid a $0.50 dividend to its common shareholders 6 years ago. It just paid a dividend of $0.67 to its common shareholders. If dividends continue to grow at this rate for the foreseeable future, and the shares are worth $10.05, what is ..

Standard deviation of returns for this investors portfolio : An investor plans to invest 75 percent of her funds in the common stock of GAmma Industries and 25 percent in Epsilon Company. The expected return on GAmma is 12 percent and the expected return on Epsilonis 16 percent. Determine the standard deviatio..

How could you apply the concepts of predictive analytics : How could you apply the concepts of predictive analytics to a sport of your choice, other than baseball, to improve a team performance? What data would you use and what would you try to predict from that data?

Future value of five-year ordinary annuity-annual payments : What is the future value of a five-year ordinary annuity with annual payments of $200, evaluated at a 15 percent interest rate?

Build a spreadsheet model to calculate the profit : Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and Web site construction is estimated to be $160,000. Build a spreadshee..

Considered for installation at municipal sewage-treatment : Two 150-horsepower (HP) motors are being considered for installation at a municipal sewage-treatment plant. The first costs $4,500 and has an operating efficiency of 83%. The second costs $3,600 and has an efficiency of 80%. Both motors are projected..

Select one strength, one weakness : Select one strength, one weakness, one opportunity, and one threat from the Ben & Jerry's SWOT analysis shown in Figure.

How do you think miss and dss assist altitude online : How do you think MISs and DSS assist Altitude Online top executives in guiding the direction of the company?

Fund the seminar at the same level into infinity : A foundation supports an annual seminar on campus by using the earnings of a $50,000 gift. It is felt that 10% interest will be realized for 10 years, but that plans should be made to anticipate an interest rate of 6% after that time. What uniform an..

User Account

All Pages