XYZ Company is a reputable manufacturer of various especially electronic items.
ID: 2658019 • Letter: X
Question
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. XYZ 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. The company 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 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 $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% of sales and will occur with the timing of the cash flows for the year (i.e. there is no initial outlay for the first year’s sales. XYZ has a 35% corporate tax rate and required return of 12%. Jay was asked to prepare a report that answer the following questions:
How sensitive is the NPV to change in the price of the new smartphone (assume that the price goes done to $370)?
5. How sensitive is the NPV to change in the quantity sold (assume that quantity reduce by 10%)?
Part 2- 1. What is a break-even?
2. What are the degrees of operating and financial leverage?
Part 3- The company has the following capital structure: Debt $36,000,000 Preferred stock $18,000,000 Common stock $66,000,000 To support the new investment, the company needs to raise $40,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 If the company uses the new cost of capital, what will be the NPV and total leverage? Please use excel with formulas.
Explanation / Answer
Initial Outlay: Equipment $34,500,000 Sunk Costs already spent before analysis are not considered Calculation of Annual cash Flow: N Year 1 2 3 4 5 A Unit sales 64000 106000 87000 78000 54000 B=A*$485 Sales Revenue $ 31,040,000 $ 51,410,000 $ 42,195,000 $ 37,830,000 $ 26,190,000 C=A*$205 Variable Costs $ 13,120,000 $ 21,730,000 $ 17,835,000 $ 15,990,000 $ 11,070,000 D=B-C Contribution Margin $ 17,920,000 $ 29,680,000 $ 24,360,000 $ 21,840,000 $ 15,120,000 E Fixed costs $5,100,000 $5,100,000 $5,100,000 $5,100,000 $5,100,000 F MACRS 7 year depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% G=F*34.5million AnnualDepreciation $ 4,930,050 $ 8,449,050 $ 6,034,050 $ 4,309,050 $ 3,080,850 H Cumulative Depreciation $ 4,930,050 $ 13,379,100 $ 19,413,150 $ 23,722,200 $ 26,803,050 I=34500000-H Book value at end of year $ 29,569,950 $ 21,120,900 $ 15,086,850 $ 10,777,800 $ 7,696,950 J=D-E-G Earning before taxes $ 7,889,950 $ 16,130,950 $ 13,225,950 $ 12,430,950 $ 6,939,150 K=J*(1-0.35) Earning after tax $ 5,128,468 $ 10,485,118 $ 8,596,868 $ 8,080,118 $ 4,510,448 L=B*0.2 Net working capital required $ 6,208,000 $ 10,282,000 $ 8,439,000 $ 7,566,000 $ 5,238,000 M Cash Flow due toworking capital change $ (6,208,000) $ (4,074,000) $ 1,843,000 $ 873,000 $ 2,328,000 P=K+G+M TotalAnnual Cash Flow $ 3,850,518 $ 14,860,168 $ 16,473,918 $ 13,262,168 $ 9,919,298 Terminal Cash Flows: Q Salvage of equipment $5,500,000 R=I-Q Loss On Salvage in year 5 $ 2,196,950 S=R*0.35 Tax Saving due to loss on salvage $ 768,933 T Working Capital release $ 5,238,000 U=Q+S+T TotalTerminalCash Flow $11,506,933 V=P+U Net Cash in Flow $ 3,850,518 $ 14,860,168 $ 16,473,918 $ 13,262,168 $ 21,426,230 Present Value (PV) of Cash Flow: (Cash Flow)/((1+i)^N) i=Discount Rate=Required Return=12% 0.12 N=Year of Cash Flow SUM PV=V/(1.12^N) Present Value (PV)of Cash inflow $ 3,437,962 $ 11,846,435 $ 11,725,809 $ 8,428,347 $ 12,157,818 $ 47,596,371 X SUM OF PV OF CASH INFLOW $ 47,596,371 Y INITIAL CASH FLOW ($34,500,000) Z=X+Y Net Present value(NPV) $ 13,096,371 CALCULATION OF NPV IF QUANTITY IS REDCED BY 10% Unit Sales =Earlier sales*(1-0.1) N Year 1 2 3 4 5 A Unit sales 57600 95400 78300 70200 48600 B=A*$485 Sales Revenue $ 27,936,000 $ 46,269,000 $ 37,975,500 $ 34,047,000 $ 23,571,000 C=A*$205 Variable Costs $ 11,808,000 $ 19,557,000 $ 16,051,500 $ 14,391,000 $ 9,963,000 D=B-C Contribution Margin $ 16,128,000 $ 26,712,000 $ 21,924,000 $ 19,656,000 $ 13,608,000 E Fixed costs $5,100,000 $5,100,000 $5,100,000 $5,100,000 $5,100,000 F MACRS 7 year depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% G=F*34.5million AnnualDepreciation $ 4,930,050 $ 8,449,050 $ 6,034,050 $ 4,309,050 $ 3,080,850 H Cumulative Depreciation $ 4,930,050 $ 13,379,100 $ 19,413,150 $ 23,722,200 $ 26,803,050 I=34500000-H Book value at end of year $ 29,569,950 $ 21,120,900 $ 15,086,850 $ 10,777,800 $ 7,696,950 J=D-E-G Earning before taxes $ 6,097,950 $ 13,162,950 $ 10,789,950 $ 10,246,950 $ 5,427,150 K=J*(1-0.35) Earning after tax $ 3,963,668 $ 8,555,918 $ 7,013,468 $ 6,660,518 $ 3,527,648 L=B*0.2 Net working capital required $ 5,587,200 $ 9,253,800 $ 7,595,100 $ 6,809,400 $ 4,714,200 M Cash Flow due toworking capital change $ (5,587,200) $ (3,666,600) $ 1,658,700 $ 785,700 $ 2,095,200 P=K+G+M TotalAnnual Cash Flow $ 3,306,518 $ 13,338,368 $ 14,706,218 $ 11,755,268 $ 8,703,698 Terminal Cash Flows: Q Salvage of equipment $5,500,000 R=I-Q Loss On Salvage in year 5 $ 2,196,950 S=R*0.35 Tax Saving due to loss on salvage $ 768,933 T Working Capital release $ 4,714,200 U=Q+S+T TotalTerminalCash Flow $10,983,133 V=P+U Net Cash in Flow $ 3,306,518 $ 13,338,368 $ 14,706,218 $ 11,755,268 $ 19,686,830 SUM PV=V/(1.12^N) Present Value (PV)of Cash inflow $ 2,952,248 $ 10,633,265 $ 10,467,595 $ 7,470,685 $ 11,170,836 $ 42,694,629 X SUM OF PV OF CASH INFLOW $ 42,694,629 Y INITIAL CASH FLOW ($34,500,000) Z=X+Y Net Present value(NPV) $ 8,194,629 NPV is REDUCED BY(1-(8194629/13096371)) 0.374282483 NPV IS REDUCED BY 37.43% BreakEven % Reduction where NPV=NIL CALCULATION OF NPV IF QUANTITY IS REDCED BY 18.575% Unit Sales =Earlier sales*(1-0.18575)= 0.81425 0.18575 N Year 1 2 3 4 5 A Unit sales 46900.8 77679.45 63755.775 57160.35 39572.55 B=A*$485 Sales Revenue $ 22,746,888 $ 37,674,533 $ 30,921,551 $ 27,722,770 $ 19,192,687 C=A*$205 Variable Costs $ 9,614,664 $ 15,924,287 $ 13,069,934 $ 11,717,872 $ 8,112,373 D=B-C Contribution Margin $ 13,132,224 $ 21,750,246 $ 17,851,617 $ 16,004,898 $ 11,080,314 E Fixed costs $5,100,000 $5,100,000 $5,100,000 $5,100,000 $5,100,000 F MACRS 7 year depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% G=F*34.5million AnnualDepreciation $ 4,930,050 $ 8,449,050 $ 6,034,050 $ 4,309,050 $ 3,080,850 H Cumulative Depreciation $ 4,930,050 $ 13,379,100 $ 19,413,150 $ 23,722,200 $ 26,803,050 I=34500000-H Book value at end of year $ 29,569,950 $ 21,120,900 $ 15,086,850 $ 10,777,800 $ 7,696,950 J=D-E-G Earning before taxes $ 3,102,174 $ 8,201,196 $ 6,717,567 $ 6,595,848 $ 2,899,464 K=J*(1-0.35) Earning after tax $ 2,016,413 $ 5,330,777 $ 4,366,419 $ 4,287,301 $ 1,884,652 L=B*0.2 Net working capital required $ 4,549,378 $ 7,534,907 $ 6,184,310 $ 5,544,554 $ 3,838,537 M Cash Flow due toworking capital change $ (4,549,378) $ (2,985,529) $ 1,350,596 $ 639,756 $ 1,706,017 P=K+G+M TotalAnnual Cash Flow $ 2,397,086 $ 10,794,298 $ 11,751,065 $ 9,236,107 $ 6,671,518 Terminal Cash Flows: Q Salvage of equipment $5,500,000 R=I-Q Loss On Salvage in year 5 $ 2,196,950 S=R*0.35 Tax Saving due to loss on salvage $ 768,933 T Working Capital release $ 3,838,537 U=Q+S+T TotalTerminalCash Flow $10,107,470 V=P+U Net Cash in Flow $ 2,397,086 $ 10,794,298 $ 11,751,065 $ 9,236,107 $ 16,778,988 SUM PV=V/(1.12^N) Present Value (PV)of Cash inflow $ 2,140,255 $ 8,605,149 $ 8,364,176 $ 5,869,713 $ 9,520,848 $ 34,500,141 X SUM OF PV OF CASH INFLOW $ 34,500,141 Y INITIAL CASH FLOW ($34,500,000) Z=X+Y Net Present value(NPV) $ 141
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.