Question

In: Finance

XYZ Company is a reputable manufacturer of various especially electronic items. Jay Carter, a recent MBA...

XYZ Company is a reputable manufacturer of various especially electronic items. Jay Carter, a recent MBA graduate, has been hired by the company in its finance department. On of the major revenue-producing items manufactured by the XYZ is smartphone. The company currently has one smartphone in the market and sells has 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. The company can manufacture the new smartphone for $300 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 unit 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 $31 million and will be depreciated on a seven-year MACRS schedule (Use Table A-1 below). It is believed the value of the equipment in five years will be $5.5 million. Net working capital for the smartphones will be one time at $5,000,000 at the beginning of the project (time zero). XYZ has a 35% corporate tax rate and required return of 12%. Jay was asked to prepare a report that answer the following questions: Part 1- (40 Points) 1. What is the project NPV? 2. What is the Project IRR? 3. What is the payback period of the project? 4. What is profitability index of the project? 5. How sensitive is the NPV to change in the price of the new smartphone (assume that the price goes done to $370)? 6. How sensitive is the NPV to change in the quantity sold (assume that quantity reduce by 10%)? Part 2- (25 Points) 1. What is a break-even (quantity)? 2. If the total interest payment be $150,000, what are the degrees of operating and financial leverage? Part 3- (25 Points) Assume that the company has the following capital structure: Debt $15,000,000 Preferred stock $7,5,000,000 Common stock $27,5,000,000 What will be the cost of capital if the company decide to raise the needed capital proportionally and with following costs? Please use the following information to calculate the weighted cost of capital: a. Bond: A 30-year bond with a face value of $1000 and coupon interest rate of 13% and floatation cost of $20 (Tax is 35%) b. Preferred stock: Face value of $35 that pays dividend $5 and floatation cost of $2 c. Common stock: Market value of $54 with floatation cost of $3.5. Last dividend was $6. The dividend will expect to grow at 7%. Part 4 (10 Points) Uses the new cost of capital, calculate the NPV and IRR?

Solutions

Expert Solution

Present Value of Cash Flow;
(Cash Flow)/((1+i)^N)
i=discount Rate=Required rate of return=12%=0.12
N=Year of cash Flow
7 year MACRS
Equipment Cost=$31,000,000
A B=A*$31,000,000 C
Depreciation Amount of Accumulated
Year Rate Depreciation Depreciation
1 14.29% $4,429,900 $4,429,900
2 24.49% $7,591,900 $12,021,800
3 17.49% $5,421,900 $17,443,700
4 12.49% $3,871,900 $21,315,600
5 8.93% $2,768,300 $24,083,900
Book value at end of 5 years $6,916,100 (31000000-24083900)
Salvage Value $5,500,000
Loss on Salvage $1,416,100
Tax Saving on loss on salvage=1416100*35% $495,635
TerminalCash Flow on Salvage $5,995,635 (5500000+495635)
N Year 0 1 2 3 4 5
Investments:
a Equipment Installed Cost ($31,000,000)
b Initial Working Capital: -$5,000,000
c=a+b Initial Outlay -$36,000,000
Operations:
.(1) Sales in units 64000 106000 87000 78000 54000
.(2) Price per unit $485 $485 $485 $485 $485
.(1)*(2) Sales Revenue $31,040,000 $51,410,000 $42,195,000 $37,830,000 $26,190,000
.(1)*$300 Variable Production Costs -$19,200,000 -$31,800,000 -$26,100,000 -$23,400,000 -$16,200,000
Total Fixed Costs (excluding depreciation) -$5,100,000 -$5,100,000 -$5,100,000 -$5,100,000 -$5,100,000
Depreciation -$4,429,900 -$7,591,900 -$5,421,900 -$3,871,900 -$2,768,300
EBIT $2,310,100 $6,918,100 $5,573,100 $5,458,100 $2,121,700

Related Solutions

XYZ Company is a reputable manufacturer of various especially electronic items. Jay Carter, a recent MBA...
XYZ Company is a reputable manufacturer of various especially electronic items. Jay Carter, a recent MBA graduate, has been hired by the company in its finance department. On of the major revenue-producing items manufactured by the XYZ is smartphone. The company currently has one smartphone in the market and sells has 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...
XYZ company has been in the toys business for more than 10 years. XYZ is a reputable company and has a very strong brand name. However, the
XYZ company has been in the toys business for more than 10 years. XYZ is a reputable company and has a very strong brand name. However, the competition increased in the last 5 years forcing XYZ to invest on creating unique and novel toys in order to retain its current customers and attract new ones. In the above case XYZ used its capital for :*a. Business Start-upb. Paying short-term expensesc. Purchasing of fixed assetsd. Business-expansion
1. Carter Company purchases and resells various electronics to consumers. Listed below are the transactions for...
1. Carter Company purchases and resells various electronics to consumers. Listed below are the transactions for the month of September. Carter has a beginning inventory balance of $5,900 at September 1. Sep 1 Purchased $11,000 of merchandise inventory; terms 1/15, n/30. 7 Purchased for cash $9,900 of merchandise inventory. 9 Contacted a major supplier to place an order for $55,000 to be shipped on October 31. 10 Purchased $16,500 of merchandise inventory; terms 2/15, n/45. 11 Purchased $2,700 of office...
1. Carter Company purchases and resells various electronics to consumers. Listed below are the transactions for...
1. Carter Company purchases and resells various electronics to consumers. Listed below are the transactions for the month of September. Carter has a beginning inventory balance of $5,900 at September 1. Sep 1 Purchased $11,000 of merchandise inventory; terms 1/15, n/30. 7 Purchased for cash $9,900 of merchandise inventory. 9 Contacted a major supplier to place an order for $55,000 to be shipped on October 31. 10 Purchased $16,500 of merchandise inventory; terms 2/15, n/45. 11 Purchased $2,700 of office...
3. Suppose you are the manager of an airline company. As a recent MBA graduate, you...
3. Suppose you are the manager of an airline company. As a recent MBA graduate, you decided to use all the knowledge you have acquired to improve the firm’s pricing decisions. To begin with, you search for a market survey company to find out the demand curve for flights. The market survey company sent you back a report stating that there are two distinct segments of consumers - tourists and business travelers – and that their demand curves are given...
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,000 items in its inventory...
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,000 items in its inventory and has hired Joan Blasco Paul to manage its inventory. Joan has determined that 11% of the items in inventory are A items, 37% are B items, and 52% are C items. She would like to set up a system in which all A items are counted monthly (every 19 working days), all B items are counted quarterly (every 61 working days), and all...
XYZ Company is located in California and manufacturer of telecommunications equipment. The company has no sales...
XYZ Company is located in California and manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 15% for all items sold. Lisa, XYZ’s controller, has just prepared the company’s budgeted income statement for next year as follows: XYZ Company Budgeted Income Statement For the Year Ended December 31 Sales $ 16,000,000 Manufacturing expenses: Variable $ 7,200,000...
Howard Electronics, a small manufacturer of electronic research equipment, has approximately 7000 items in inventory and has hired Eng.
Howard Electronics, a small manufacturer of electronic research equipment, has approximately 7000 items in inventory and has hired Eng. Mostafa to manage its inventory. Mostafa has determined that 10% of the items in inventory are A items, 35% are B items, and 55% are C items. He would like to set up a system in which all A items are counted monthly (every 20 working days), and all B items are counted quarterly (every 60 working days), and all C...
XYZ Company began operations on January 1, 2020. The company has the following items included in...
XYZ Company began operations on January 1, 2020. The company has the following items included in the owners' equity section of its balance sheet. 8% Preferred Stock, $100 par, 100,000 shares authorized, 25,000 shares issued and outstanding $2,500,000 Common Stock, $3 par, 500,000 shares authorized; 150,000 shares issued and outstanding 450,000 Additional paid-in capital 2,250,000 Total dividends declared and paid were: 2020 $170,000 2021 210,000 2022 240,000 A. Referring to the information above, if XYZ Company's preferred stock were CUMULATIVE,...
The Protek Company is a large manufacturer and distributor of electronic components. Because of some successful...
The Protek Company is a large manufacturer and distributor of electronic components. Because of some successful new products marketed to manufacturers of personal computers, the firm has recently undergone a period of explosive growth, more than doubling its revenues during the last two years. However, the growth has been accompanied by a marked decline in profitability and a precipitous drop in the company’s stock price. You are a financial consultant who has been retained to analyze the company’s performance and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT