Perform sensitivity analysis on project

Assignment Help Financial Management
Reference no: EM13922055

Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other household appliances. Over the years, it has expended into manufacturing and is now a reputable manufacturer of various electronic items. You have been hired by the company’s finance department.

One of the major revenue-producing items manufactured by Conch is a cell phone. Conch currently has one phone model on the market and sales have been excellent. The phone is a unique item in that it comes in a variety of tropical colors and is pre programmed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly and the current phone has limited features in comparison with newer models. Conch has spent $750,000 to develop a prototype for a new phone that has all the features of the existing phone but adds new features. The company has spent a further $200,000 for a marketing study to determine expected sales figures for the new phone.

Conch can manufacture the new phone for $155 each in variable costs. Fixed costs for the operation are estimated to run $4.7 million per year. The estimated sales volume is 74,000, 95,000, 125,000, 105,000, and 80,000 per each year for the next five years, respectively. The unit price of the new phone will be $360. The necessary equipment can be purchased for $21.5 million and will be depreciated on a seven-year MACRS schedule. It is believed that the value of the equipment in five years will be $4.1 million.

As previously stated, Conch currently manufactures a phone. Production of the existing model is expected to be terminated in two years. If Conch does not introduce the new phone, sales of the existing model will be 80,000 units and 60,000 units for the next two years, respectively. The price of the existing phone is $290 per unit, with variable costs of $120 each and fixed costs of $1,800,000 per year. If Conch does introduce the new phone, sales of the existing phone will fall by 15,000 units per year and the price of the existing units will be lowered to $255 each.

Net working capital requirements for the new phone production and sales will be 20% of sales and will occur with the timing of the cash flows; for example, there is no initial outlay for NWC, but changes in NWC will occur in year 1 with the first year’s sales. In the final year, the NWC balance (if any) will be fully recouped by the company. Conch has a 35% corporate tax rate and a 12% required return.

MUST SHOW ALL WORK

A) Find payback period, profitability index, NPV, and IRR for the project.

B) Perform sensitivity analysis on this project.

C) Give an estimated best-case and worst-case NPV.

D) What is the break-even price for the new phone?

 

E) Should Conch Republic Electronics pursue the new phone?

Reference no: EM13922055

Questions Cloud

What should market price be if the coupon were paid annually : Dewey Cheetham & Howe accounting firm is considering the purchase of a $1000 New Haven Municipal Bond. The stated coupon rate is 5% paid quarterly. The bond will mature in 22 years. The YTM for similar bonds is 4%. What should the market price of the..
Prepare the entries for both the purchase and subsequent : During 2013, TNL Systems reacquired shares of its common stock and later sold shares in two separate transactions. Prepare the entries for both the purchase and subsequent resale of the shares assuming the shares are (a) retired and (b) viewed as tre..
How much would a risk-neutral person be willing to pay : What is the expected value and standard deviation of the investment? How much would a risk-neutral person be willing to pay for the investment? How much would a risk-averse person be willing to pay for the investment?
Graphical representation showing trend and fitted model : Use the Decomposition facility under stat menu to obtain seasonal variations, trend and deseasonalised using an additive model - Produce and comment the graphical representation showing trend and fitted model.
Perform sensitivity analysis on project : Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other..
Unix operating system : The UNIX operating system (and its variants, of which Linux is one) includes quite a few useful utility programs. One of those is wc, which is short for Word Count. The purpose of wc is to give users an easy way to determine the size of a text fil..
Attractive to marketers around the world : because it represents a collective approach to marketing in contrast to the traditional individualist approach used in the United States and other western cultures
Plot a budget line for a representative consumer : Plot a budget line for a representative consumer both before and after the voucher program. Do you expect that current consumption of a typical consumer will increase by the full 100,000 yen of the voucher? Explain.
What is the market value per share of common stock : Analysts forecast that Dixie Chicks, Inc. (DCI) will pay a dividend of $2.50 a share now, continuing a long-term growth trend of 10% per year. If this trend is expected to continue indefinitely, and investors' required rate of return for DCI is 12%: ..

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd