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
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:
8. Suppose Conch Republic loses sales on other models because of the introduction of the new model. How would this affect your analysis?
Case summary:
Company CR is an electronics manufacturing company that is located in 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.
Given statement: The Company CR loses its sales on other models because of the introduction of the new model.
To determine: How the analysis of Person X is affected by the given statement.
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 dollars. 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 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 and its effect on the analysis of Person X:
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 sales that is lost can be included as a reduction in the sale of the new project. It is also essential to reduce the variable cost for the losses in sales of the existing model.
The financial reports are helpful for taking financial actions with regards to the company. The financial analysis helps Person X in the above situation to take necessary action against the existing model and the new model.
Want to see more full solutions like this?
Chapter 9 Solutions
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The companypresident is Shelly Couts, who inherited the company. The company originally repaired radios and other householdappliances when it was founded over 70 years ago. Over the years, the company has expanded, and it is now a reputablemanufacturer of various specialty electronic items. Jay McCanless, a recent MBA graduate, has been hired by thecompany in its finance department.One of the major revenue-producing items manufactured by Conch Republic is a smart phone. Conch Republiccurrently has one smart phone model on the market and sales have been excellent. The smart phone is a unique itemin that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as withany electronic item, technology changes rapidly, and the current smart phone has limited features in comparison withnewer models. Conch Republic spent $300,000 to develop a prototype for…arrow_forwardEco Plastics Company has been revolutionizing plastic and trying to do its part to save the environment. Eco’s founder, Marion Cosby, developed a biodegradable plastic that her company is marketing to manufacturing companies throughout the southeastern United States. After operating as a private company for six years, Eco went public in 2009 and is listed on the Nasdaq stock exchange. As the chief financial officer of a young company with lots of investment opportunities, Eco’s CFO closely monitors the firm’s cost of capital. The CFO keeps tabs on each of the individual costs of Eco’s three main financing sources: long-term debt, preferred stock, and common stock. The target capital structure for ECO is given by the weights in the following table: Source of capital weight Long term debt 30 % Preferred stock 20 % Common stock equity 50 % Total 100 % At the present time, Eco can raise debt by selling 20-year bonds with a $1,000 par value and a 10.5%…arrow_forwardEco Plastics Company has been revolutionizing plastic and trying to do its part to save the environment. Eco’s founder, Marion Cosby, developed a biodegradable plastic that her company is marketing to manufacturing companies throughout the southeastern United States. After operating as a private company for six years, Eco went public in 2009 and is listed on the Nasdaq stock exchange. As the chief financial officer of a young company with lots of investment opportunities, Eco’s CFO closely monitors the firm’s cost of capital. The CFO keeps tabs on each of the individual costs of Eco’s three main financing sources: long-term debt, preferred stock, and common stock. The target capital structure for ECO is given by the weights in the following table: Source of capital weight Long term debt 30 % Preferred stock 20 % Common stock equity 50 % Total 100 % At the present time, Eco can raise debt by selling 20-year bonds with a $1,000 par value and a 10.5%…arrow_forward
- The Toledo Shirt Company manufactures men’s shirts sold to department stores and other outlets throughout Ohio, Illinois, and Indiana. For the past 14 years, one of Toledo’s major customers has been Abraham and Sons, a chain of nine stores selling men’s clothing. Mr. Abraham retired 18 months ago and his two sons took complete control of the organization. Since that time, they have invested significant sums of money in an attempt to expand each store by also selling women’s clothing. Success in this new market has proven to be difficult. Abraham and Sons is not known for selling women’s clothing, and no one in the company has much expertise in the area.Approximately seven months ago, James Thurber, Toledo’s chief financial officer, began to notice that Abraham and Sons was taking longer than usual to make payments. Instead of the normal 30 days, the retailer was taking 45 days—and frequently longer—to pay each invoice. Because of the amount of money involved, Thurber began to monitor…arrow_forwardFamily Resorts, Inc., is a holding company for several vacation hotels in the northeastern and mid-Atlantic states. The firm originally purchased several old inns, restored the buildings, and upgraded the recreational facilities. Vacationing families have been well pleased with the inns because many services are provided that accommodate children and afford parents time for themselves. Since the completion of the restoration 10 years ago, the company has been profitable.Family Resorts has just concluded its annual meeting of regional and district managers. This meeting is held each November to review the results of the previous season and to help the managers prepare for the upcoming year. Before the meeting, the managers submitted proposed budgets for their districts or regions as appropriate. These budgets are reviewed and consolidated into an annual operating budget for the entire company. The 2008 budget has been presented at the meeting, and the managers accepted it. To evaluate…arrow_forwardFamily Resorts, Inc., is a holding company for several vacation hotels in the northeastern and Mid-Atlantic states. The firm originally purchased several old Inns, restored the buildings, and upgraded the recreational facilities. Vacationing families have been well pleased with the Inns because many services are provided that accommodate children and afford parents time for themselves. Since the completion of the restoration 10 years ago, the company has been profitable. Family Resorts has just concluded its annual meeting of regional and district managers. This meeting is held each November to review the results of the previous season and to help the managers prepare for the upcoming year. Before the meeting, the managers submitted proposed budgets for their districts or regions as appropriate. These budgets are reviewed and consolidated into an annual operating budget for the entire company. The 2008 budget has been presented at the meeting and the managers accepted it. To…arrow_forward
- Davidson Yachts is a small company founded by two businesspeople who are friends and avid sailors. At present, they are interested in expanding the business and have asked you to review its financial statements. Davidson Yachts sells approximately 130 to 180 sailboats each year, ranging from 15-foot dinghies to 21-foot sailboats. Their sales prices range from $2,300 to more than $10,300. The company has a limited inventory of boats consisting primarily of one or two boats from each of the four manufacturers that supply Davidson. The company also sells a variety of supplies and parts and performs different types of service. Most sales are on credit. The company operates from a large building that has offices, storage, and sales space for some of the smaller sailboats. The larger sailboats are kept in a fenced area adjacent to the main building, and an ample parking area is nearby. This year, Davidson purchased a boat lift to haul boats. The lift has brought in revenues for boat…arrow_forwardNextG Limited is a leading manufacturer of automotive components. It supplies to the original equipment manufacturers as well as the replacement market. Its projects typically have a short life as it introduces new models periodically. You have recently joined NextG Limited as a financial analyst reporting to Mr. Atiamoh, the CFO of the company. He has provided you the following information about two mutually exclusive projects. A and B, that are being considered by the Executive Committee of NextG Limited:Project A is an extension of an existing line. Its cash flow will decrease over time. Project B involves a new product. Building its market will take some time and hence its cash flow will increase over time.The expected net cash flows of the two mutually exclusive projects are as follows. Mr. Atiamoh believes that all the two projects have risk characteristics similar to the average risk of the firm and hence NextG’s cost of capital of 10 percent will apply to them and both…arrow_forwardNextGen Wealth Ltd is a large manufacturing firm Ghana, that was created 20 years ago by Opanin Nsiah’s family. It was initially financed with an equity investment by the Opanin Nsiah family and ten other individuals. Over time, NextGen Wealth Ltd has obtained substantial loans from finance companies and commercial banks. The loans that NextGen Wealth Ltd has obtained from commercial banks stipulate that NextGen Wealth Ltd must receive the banks’ approval before pursuing any large projects. The interest rate on the loans is tied to market interest rates, and is adjusted every six months. Thus, NextGen Wealth Ltd.’s cost of obtaining funds is sensitive to interest rate movements. It has a credit line with a bank in case it suddenly needs to obtain funds for a temporary period. It has purchased Treasury securities that it could sell if it experiences any liquidity problems. NextGen Wealth Ltd has assets valued at about Gh₵50 million and generates sales of about Gh₵100 million per year.…arrow_forward
- John Snow has recently retired, and he received a large lump sum settlement from his employer. He would like to invest this money to achieve a stable long term income. He is considering investing in the following two companies: Allied Grocers (AG) are a 3-year-old online grocery retailer that specializes in delivering a wide selection of quality food products through an online platform. Beta Solutions (BS) is an established 10-year-old electronics company that is known for selling the most innovative electronic products and software solutions. Selected financial data for 2019 AG BS Average total assets 1,500,000 4,000,000 Average # of common shares outstanding (no preferred shares) 10,000 10,000 Dividends paid 10,000 50,000 Current Market price per share $95 $165 Net sales 1,300,000 6,300,000 Cost of goods sold 900,000 4,200,000 Gross profit 400,000 2,100,000 Operating Expenses: Administrative…arrow_forwardHappyville, Inc., operates a chain of department stores located in the northwest. The first store began operations in 1965, and the company has steadily grown to its present size of 44 stores. Two years ago, the board of directors of Happyville approved a large-scale remodeling of its stores to attract a more upscale clientele.arrow_forwardRundle Delivery is a small company that transports business packages between New York and Chicago. It operates a fleet of small vans that moves packages to and from a central depot within each city and uses a common carrier to deliver the packages between the depots in the two cities. Rundle Delivery recently acquired approximately $5.5 million of cash capital from its owners, and its president, George Hay, is trying to identify the most profitable way to invest these funds. Todd Payne, the company's operations manager, believes that the money should be used to expand the fleet of city vans at a cost of $720,000. He argues that more vans would enable the company to expand its services into new markets, thereby increasing the revenue base. More specifically, he expects cash inflows to increase by $320,000 per year. The additional vans are expected to have an average useful life of four years and a combined salvage value of $106,000. Operating the vans will require additional working…arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education