Conch Republic Electronics
Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded more than 70 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company in its finance department.
One of the major revenue-producing items manufactured by Conch Republic is a smartphone. Conch Republic currently has one smartphone model on the market and sales have been excellent. The smartphone is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current smartphone has limited features in comparison with newer models. Conch Republic spent $750,000 to develop a prototype for a new smartphone that has all the features of the existing one but adds new features such as wifi tethering. The company has spent a further $200,000 for a marketing study to determine the expected sales figures for the new smartphone.
Conch Republic can manufacture the new smartphone for $205 each in variable costs. Fixed costs for the operation are estimated to run $5.1 million per year. The estimated sales volume is 64,000, 106,000, 87,000, 78,000, and 54,000 per year for the next five years, respectively. The unit price of the new smartphone will be $485. The necessary equipment can be purchased for $34.5 million and will be depreciated on a seven-year MACRS schedule. It is believed the value of the equipment in five years will be $5.5 million.
Net working capital for the smartphones will be 20 percent of sales and will occur with the timing of the cash flows for the year (i.e., there is no initial outlay for NWC). Changes in NWC will thus first occur in Year 1 with the first year’s sales. Conch Republic has a 35 percent corporate tax rate and a required return of 12 percent.
Shelly has asked Jay to prepare a report that answers the following questions:
7. Should Conch Republic produce the new smartphone?
Case summary:
Company CR is an electronics manufacturing company that is located in the Key West of State F. The president of the company is Person SC, who started the company. The company initially repaired radios and home appliances. Over the years, the company has expanded its operations and is now a reputed manufacturer of many electronic items. The company has hired Person JMC for their finance department, as he has completed his MBA recently.
The smart phone is the major revenue-producing item that is manufactured by the company. The current smart phone model of the company has very good sales on the market.
Characters in the case:
- Company CR
- State F
- Person JMC
- Person SC
Adequate information:
- The company currently manufactures smart phones.
- The net working capital is 20% of the sales and will take place with the timing of cash flow in the year.
- The corporate tax is 35% and the required return is 12%.
- Person JMC prepares an essential report for further calculation.
To determine: Whether, the Company CR must produce the new smart phones.
Explanation of Solution
Given information:
The spending made by the company to develop a prototype for smart phone is $750,000. The money spent by the company to study the market is $200,000. The company can manufacture the new smart phones at available cost of $205 each in a variable cost, the estimated fixed cost to run the operation is $5.1 million for a year.
The estimated sales volume (sales unit) is 64,000, 106,000, 87,000, 78,000, and 54,000 for a year and for the next 5 years. The price of a unit for a smart phone is $520. The essential equipment can be bought for $34.5 million and will be depreciated on 7-year MACRS depreciation. It is believed that the equipment in the next 5 years will be around 5.5 million dollar. The unit price of the new smart phone is $485.
Explanation:
The initial cash outlay at the time 0 is the new equipment’s cost $34,500,000. The sale for every year is calculated by multiplying the sales unit with the unit price of the new smart phone.
Formula to calculate the sales:
Compute the sales:
MACRS depreciation table for 7-Year:
MACRS Depreciation table for seven year | |
Year | Seven year |
1 | 14.29% |
2 | 24.49% |
3 | 17.49% |
4 | 12.49% |
5 | 8.93% |
6 | 8.92% |
7 | 8.93% |
8 | 4.46% |
Computations of the operating cash flow and net cash flow:
Particulars | Year | ||||
Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Sales | $31,040,000 | $51,410,000 | $42,195,000 | $37,830,000 | $26,190,000 |
Variable cost | 13,120,000 | 21,730,000 | 17,835,000 | 15,990,000 | 11,070,000 |
Fixed costs | 5,100,000 | 5,100,000 | 5,100,000 | 5,100,000 | 5,100,000 |
Depreciation | 4,930,050 | 8,449,050 | 6,034,050 | 4,309,050 | 3,080,850 |
Earnings before tax | $7,889,950 | $16,130,950 | $13,225,950 | $12,430,950 | $6,939,150 |
Tax | 2,761,483 | 5,645,833 | 4,629,083 | 4,350,833 | 2,428,703 |
Net income | $5,128,468 | $10,485,118 | $8,596,868 | $8,080,118 | $4,510,448 |
+ Depreciation | 4,930,050 | 8,449,050 | 6,034,050 | 4,309,050 | 3,080,850 |
Operating cash flow | $10,058,518 | $18,934,168 | $14,630,918 | $12,389,168 | $7,591,298 |
Net working capital | |||||
Beginning | $0 | $6,208,000 | $10,282,000 | $8,439,000 | $7,566,000 |
End | 6,208,000 | 10,282,000 | 8,439,000 | 7,566,000 | 0 |
Net working capital Cash flow |
$6,208,000 | $10,282,000 | $1,843,000 | $873,000 | $7,566,000 |
Net Cash flow | $3,850,518 | $14,860,168 | $16,473,918 | $13,262,168 | $15,157,298 |
Note:
- The variable cost is calculated by multiplying the sales unit with the given variable cost.
- The depreciation is calculated by multiplying the purchase price of the equipment with the MACRS depreciation table of 7-Year based on the years.
- The beginning price in the net working capital is the end price of the next year.
- The end price is calculated by multiplying the sales with the net working capital percentage.
Formula to compute the book value of the equipment:
Computation of the book value of the equipment:
Hence, the book value of the equipment is $7,696,950.
Formula to compute the taxes on sale of the equipment:
Computation of the taxes on sale of the equipment:
Hence, the taxes on the sale of the equipment are $768,933.
Formula to calculate the cash flow on the equipment sales:
Computation of the cash flow on the equipment sales:
Hence, the cash flow on the equipment sales is $6,268,933.
Cash flow of the project:
Time | Cash Flow |
0 | -$34,500,000 |
1 | $3,850,518 |
2 | $14,860,168 |
3 | $16,473,918 |
4 | $13,262,168 |
5 | $21,426,230 |
Note: In the above table, the cash flow for 5th year is calculated by adding the net cash flow at Year 5 and the cash flow on the equipment sales.
Formula to calculate the net present value:
Note: The net present value is calculated using the above formula.
Computation of the net present value:
Hence, the net present value of the project is $13,096,371.21.
Computation of the sensitivity of the net present value when there is a change in the price:
The pro forma statement for the cash flow and the net working capital:
Particulars | Year | ||||
Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Sales | $31,680,000 | $52,470,000 | $43,065,000 | $38,610,000 | $26,730,000 |
Variable cost | 13,120,000 | 21,730,000 | 17,835,000 | 15,990,000 | 11,070,000 |
Fixed costs | 5,100,000 | 5,100,000 | 5,100,000 | 5,100,000 | 5,100,000 |
Depreciation | 4,930,050 | 8,449,050 | 6,034,050 | 4,309,050 | 3,080,850 |
Earnings before tax | $8,529,950 | $17,190,950 | $14,095,950 | $13,210,950 | $7,479,150 |
Tax | 2,985,483 | 6,016,833 | 4,933,583 | 4,623,833 | 2,617,703 |
Net income | $5,544,468 | $11,174,118 | $9,162,368 | $8,587,118 | $4,861,448 |
+ Depreciation | 4,930,050 | 8,449,050 | 6,034,050 | 4,309,050 | 3,080,850 |
Operating cash flow | $10,474,518 | $19,623,168 | $15,196,418 | $12,896,168 | $7,942,298 |
Net working capital | |||||
Beginning | $0 | $6,336,000 | $10,494,000 | $8,613,000 | $7,722,000 |
End | 6,336,000 | 10,494,000 | 8,613,000 | 7,722,000 | 0 |
Net working capital Cash flow |
$6,336,000 | $4,158,000 | $1,881,000 | $891,000 | $7,722,000 |
Net Cash flow | $4,138,518 | $15,465,168 | $17,077,418 | $13,787,168 | $15,664,298 |
- The sale amount is calculated by multiplying the assumed price ($495) with the various estimated sales volume as per the year.
- The variable cost is calculated by multiplying the sales unit with the given variable cost.
- The depreciation is calculated by multiplying the purchase price of the equipment with the MACRS depreciation table of 7 Year based on the years.
- The beginning price in the net working capital is the end price of the next year.
- The end price is calculated by multiplying the sales with the net working capital percentage.
Cash flow of the project:
Time | Cash flow |
0 | -$34,500,000 |
1 | $4,138,518 |
2 | $15,465,168 |
3 | $17,077,418 |
4 | $13,787,168 |
5 | $21,933,230 |
Note: The cash flows are from the above pro forma statement of the cash flow.
Formula to calculate the net present value:
Note: The net present value is calculated using the above formula.
Computation of the net present value:
Hence, the net present value of the project is $14,886,708.15.
The sensitivity of changes in the net present value to the changes in the price is as follows:
Hence, for each dollar, the change in the new smartphone’s price will lead to changes in the net present value of the project in the same direction of $179,033.69.
Computation of the sensitivity of the net present value when there is a change in the quantity:
Formula to calculate the sales:
Computation of sales:
Projection of the new quantity:
Particulars | Year | ||||
Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Sales | $31,088,500 | $51,458,500 | $42,243,500 | $37,878,500 | $26,238,500 |
Variable cost | 13,140,500 | 21,750,500 | 17,855,500 | 16,010,500 | 11,090,500 |
Fixed costs | 5,100,000 | 5,100,000 | 5,100,000 | 5,100,000 | 5,100,000 |
Depreciation | 4,930,050 | 8,449,050 | 6,034,050 | 4,309,050 | 3,080,850 |
Earnings before tax | $7,917,950 | $16,158,950 | $13,253,950 | $12,458,950 | $6,967,150 |
Tax | 2,771,283 | 5,655,633 | 4,638,883 | 4,360,633 | 2,438,503 |
Net income | $5,146,668 | $10,503,318 | $8,615,068 | $8,098,318 | $4,528,648 |
+ Depreciation | 4,930,050 | 8,449,050 | 6,034,050 | 4,309,050 | 3,080,850 |
Operating cash flow | $10,076,718 | $18,952,368 | $14,649,118 | $12,407,368 | $7,609,498 |
Net working capital | |||||
Beginning | $0 | $6,217,700 | $10,291,700 | $8,448,700 | $7,575,700 |
End | 6,217,700 | 10,291,700 | 8,448,700 | 7,575,700 | 0 |
Net working capital Cash flow |
$6,217,700 | $4,074,000 | $1,843,000 | $873,000 | $7,575,700 |
Net Cash flow | $3,859,018 | $14,878,368 | $16,492,118 | $13,280,368 | $15,185,198 |
- The variable cost is calculated by adding the sales unit with the quantity change of 100 and then multiplying it with the given variable cost.
- The depreciation is calculated by multiplying the purchase price of the equipment with the MACRS depreciation table of 7-Year based on the years.
- The beginning price in the net working capital is the end price of the next year.
- The end price is calculated by multiplying the sales with the net working capital percentage.
Cash flow of the project:
Time | Cash flow |
0 | -$34,500,000 |
1 | $3,859,018 |
2 | $14,878,368 |
3 | $16,492,118 |
4 | $13,280,368 |
5 | $21,454,130 |
Note: In the above table, the cash flow for the 5th year is calculated by adding the net cash flow at Year 5 and the cash flow on the equipment sales.
Formula to calculate the net present value:
Note: The net present value under this assumption are calculated as follows.
Computation of the net present value:
Hence, the net present value of the project is $13,158,821.46.
The sensitivity of changes in the net present value to the changes in the quantity is as follows:
Hence, a unit change in the quantity for a year of the sales in the new smart phone, changes the net present value to $624.50 in the same direction.
Explanation:
The production of the new smart phones:
The net present value of the project in various situation is positive and so the project can be accepted. Thus, with a positive net present value the company can produce the new smart phones.
The financial reports are helpful for taking financial actions with regards to the company. The financial analysis helps to find the long-run and the short-run of the company. Thus, by the financial reports an individual can decide whether the production of the new smart phone can continued or stopped.
Want to see more full solutions like this?
Chapter 9 Solutions
F371 Essn. of Corporate Finance >C< By Ross MCG Custom ISBN 9781259320576
- AutoShine, Inc. who currently supplies Car Wash Products has decided to expand its operations to owning and operating car washes. The following is an excerpt from the conversation between the chief executive officer of AutoShine , Larry VanWinkle, and the vice president of finance of AutoShine, John Clancy: Larry to John: John, have you given any thought to how we're going to manage the acquisition of Wash and Shine Car Wash? John: Well, the two basic options, as I see it, are to issue either preferred stock or bonds. The equity market is a little depressed right now and I have heard through the rummer mill, that the Federal Reserve Bank's going to increase the interest rates either this month or next. Larry: Yes. I've heard that rumor. The problem is that we can't wait around to see what's going to happen. We'll have to move on this quickly if we want any chance to complete the acquisition of Wash and Shine Car Wash. John: Well, the bond market is really strong right now. Maybe we…arrow_forwardSuppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Costs Product Cost/Period Cost 1. Depreciated on salesperson's cars 2. Rent on equipment used in the factory 3. Lubricants used for machine maintenance 4. Salaries of personnel who work in the finished goods warehouse 5. Soap and paper towels used by factory workers at the end of a shiftarrow_forwardThe Volvo Company is an established American multinational automaker that has its main headquarters in Detroit, USA. It was founded by Henry Michigan and incorporated on June 16, 1919 and had ever since been selling automobiles and commercial vehicles under the Volvo brand to the world. The UAE has been one of Volvo’s most loyal customers since the 1980’s. You work as a financial analyst and have recently been placed onto an assignment with the Volvo Company. According to the most recent financial statements, the Volvo Company has reported a net loss of $1,800. The firm’s earnings before interest, tax, depreciation & amortization are positive and amount to $9,000. The amount of debt outstanding that the company has borrowed from the HSBC bank at the 8% interest rate is $2,700. The applicable corporate tax rate used by the Volvo Company is 25%. In answering the questions below, show all the formulas used and calculations, along with the final answer. Calculate the amount of taxes…arrow_forward
- MAG Petroleum is an SME specialising in the sale of lubricants for industrial use. The company, which is owned and operated by Angelina, has just completed its third year operation. During this time, Angelina has sought to establish a reputation for the company as a supplier of high quality lubricants. The efforts made by Angelina and her staff have proved successful, and her company has become one of the best and fastest growing privately owned company in Zambia.Angelina has concluded that in order to plan better for the growth of the company in the future, it is necessary to develop assistance that will enable her to forecast lubricant sales by month for up to one year in advance. Angelina has available data on the total lubricant sales that were realized during the previous three years of operation. These data are provided in Table Q2.(a) What forecasting method would you recommend to Angelina? Justify your choicearrow_forwardCaribbean Hotel Services (CHS) is a small company specialising in services to the hotel industry. The company was just purchased, and the new owner was amazed to learn that there was no retirement plan for CHS workers. The new owner would like to provide adequate retirement benefits for workers and reward long-time service. The workforce consists of fourteen (14) skilled hotel housekeepers, each of whom is over age 50 and has been with the company for over twenty-five years; two (2) customer service representatives ages 40 and 55; three bellhops ages 35, 27, and 38; and a night auditor aged 54. Based on this situation, should this company adopt a Defined Contribution plan? Distinguish between defined benefits and defined contribution pension schemes Definitive position as to which plan should be adopted and why Disclosure requirements in the financial statements Analysis with reference to scenarioarrow_forwardSuppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Cost Product Cost/Period Cost1. Depreciation on chairs and tables in the factory lunchroom 2. The wages of the receptionist in the administrative offices 3. Cost of leasing the corporate jet used by the company's executives 4. The cost of renting rooms at a Florida resort for the annual sales conference 5. The cost of packaging the company's productarrow_forward
- Suppose that you have been given a summer job as an intern at Issac Aircams, a company that man- ufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. You have been asked to help prepare the financial statements and were given the following list of costs: Depreciation on salespersons’ cars. Rent on equipment used in the factory. Lubricants used for machine maintenance. Salaries of personnel who work in the finished goods warehouse. Soap and paper towels used by factory workers at the end of a shift. Factory supervisors’ salaries. Heat, water, and power consumed in the factory. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) Advertising costs. Workers’ compensation insurance for factory employees. Depreciation on…arrow_forwardIn 2002, Mr. Rollerball started Mighty Mouse, Inc., a small, 75-employee firm that produces and sells wireless keyboards and other devices to vendors through its manufacturing plant in Little Rock, Arkansas. In its first 2 years of business, MM saw a substantial growth in sales and at current capacity was unable to keep up with demand. To compete, MM enlarged its manufacturing facilities. The new facility increased to 250 employees. During this period of expansion, MM has paid little attention to internal control procedures.Security Recently, systems problems and hardware failures have caused the operating system to crash. Mr. Rollerball was extremely concerned to discover that confidential company information had been printed out on the printers as a result of these crashes. Also, important digital documents were erased from storage media. Malicious programs such as viruses, worms, and Trojan horses have plagued the company and caused significant data corruption. MM has devoted…arrow_forwardExtreme Inc. is a newly established enterprise. It was set up by an entrepreneur who is generally interested in the business of providing engineering and operational support services to aircraft manufacturers. Extreme Inc., through the contacts of its owner, received a confirmed order from a wellknown aircraft manufacturer to develop new designs for ducting the air conditioning of their aircraft. For this project, Extreme Inc. needed funds aggregating to $1 million. It was able to convince venture capitalists and was able to obtain funding of $1 million from two Silicon Valley venture capitalists. The expenditures Extreme Inc. incurred in pursuance of its research and development project follow, in chronological order: January 15, 2015: Paid $175,000 toward salaries of the technicians (engineers and consultants) March 31, 2015: Incurred $250,000 toward cost of developing the duct and producing the test model June 15, 2015: Paid an additional $300,000 for revising the ducting process to…arrow_forward
- CBA Company is engaged in producing quality cars. Its mission is to be a dominant player in car manufacturing industry in Southern Tagalog Region. You were hired as a management accountant of the company. It has come to your attention that ABC Aluminum Inc, an aluminum manufacturer is up for sale for P 500 million. The value of net underlying assets is P 450 million, with the remaining amount was attributable to its Research and Development (R & D) department. You also learned that aluminum is one of the materials used in car manufacturing. The reason why ABC Aluminum came to your attention is the fact that it also throws off P 40 million in tax benefits through rapid tax depreciation of equipment. The purchase of ABC Aluminum would be financed thru a bank with 10% annual interest. Note: Corporate tax rate is 30%. 1. Is the acquisition of ABC Aluminum aligned with CBA's strategic plan? Explain your answer. 2. Will there be an increase in value-added? By how much? Please show…arrow_forwardSuppose that you have been given a summer job as an intern at Issac Aircams, a company that manufacturessophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which isprivately owned, has approached a bank for a loan to help it finance its growth. The bank requires financialstatements before approving such a loan. You have been asked to help prepare the financial statements andwere given the following list of costs:1. Depreciation on salespersons’ cars.2. Rent on equipment used in the factory.3. Lubricants used for machine maintenance.4. Salaries of personnel who work in the finished goods warehouse.5. Soap and paper towels used by factory workers at the end of a shift.6. Factory supervisors’ salaries.7. Heat, water, and power consumed in the factory.8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.)9. Advertising costs.10. Workers’ compensation insurance for factory employees.11. Depreciation on chairs…arrow_forwardMark Benny started MM LTD, a niche furniture brand, 10 years ago. he ran the business as a sole proprietorship. While he has 50 skilled carpenters and 5 sales people on his payroll, he has been taking care of the accounting by himself. Now, he intends to offer 40% of the ownership to public in next couple years and is willing to make changes and has hired George as a management accountant to organize and improve the accounting systems. MM LTD's total budgeted manufacturing overheads cost for the current year is Ugx 111,240,000 and budgeted total labor hours are 20,000. Jemba Fred the financial accountant has been applying traditional costing method during the whole 10 years period. MM LTD's sofas includes the 2-set, 3-set and 6-set options. State House recently placed an order for 150 units of the 6-set type. The order is expected to be delivered in one-month time. Since it is a customized order, State House will be billed at cost plus 25%. George is not a fan of traditional costing…arrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:CengageCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub