1. Ms Victoria is the Investment Manager and has requested some analysis concerning a proposed 5-years...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Ms Victoria is the Investment Manager and has requested some analysis concerning a proposed 5-years investment. The company plans to open a showroom in York and have narrowed their selection down to two locations: (1) City Centre and (2) Clifton Moor. You have to evaluate these options based on the following information. Daffodil will lease the showroom initially for 5 years, and the total initial cost of investment is estimated to be f10 million each. Option one: City Centre It is expected that the City Centre showroom will increase the overall sales revenue of the company by 10% per annum from 2020, and the variable cost will be forty-two percent of sales revenue. The fixed overhead cost will be £3,500,000, £2,000,000 and £1,500,000 in the first, second, and third years. The promotion cost will be £500,000 in the first two years and £200,000 for the next three years. All other expenses will be 10% of the total contribution margin. In the second year, the company will need a working capital investment of £2 million, and 60% of which will recover at the end of project life. The company follows a straight-line depreciation method and expects to sell the assets at 20 % of historical cost in year 5. Option two: Clifton Moor On the other hand, if the shoWroom is opened at Clifton Moor, then it will require fixed overhead cost for four years L2,500,000 in year one, £1,800,000 in year three, £2,100,000 in year four and f1,100,000 in year five. All other costs will increase and be at 10% per year of the contribution margin. The working capital investment will be f1,500,000 in year three, and 55% of it will recover in the last year. The sales revenue will increase at 12% per annum, and variable cost will be 45% of sales. The company will follow a similar strategy for depreciation and promotional cost, just like the city centre. 2 19 3 will follow a similar strategy for depreciation and promotional cost, just like the city centre. Financing the investment The company has several choices for financing this expansion issuing new equity or bond or using existing retained earnings. The shares of Daffodil are traded in the Alternative Investment Markets (AIM) for £30, however, the face value is £20 and last year's dividend was f0.35. HSBC will charge a flotation cost of 10% to issue the new common stock in the market. There is a projection that the dividend will grow at 6% a year in the coming years. The firm can issue an additional long-term bond at an interest rate (before tax) of 10 % (i.e. Coupon rate). Currently, similar bonds are selling at f110, slightly over the face value (which is £100), with five years of maturity. The market risk premium is 5%, the 3-month UK gilt rate is 3.5% (risk-free rate), and the average Beta of the Electronic goods industry is 1.73. The company is also planning to issue preferred stocks. The industry average preferred dividend and current market price are f10 and £96, respectively. The company wants to maintain a capital structure of approximately 45% debt, 5% prefered equity and 50% of ordinary equity. The current corporate tax rate is 35%. Required a) Determine the Weighted Average Cost of Capital (WACC) for target capital structure. b) Evaluate which showroom should be selected (Hints: use NPV and IRR). Ms Victoria prefers to use CAPM (i.e., Capital Asset Pricing Model) over DDM (i.e., Dividend Discount Model). Advise, accordingly with appropriate assumptions and rationales for the future. (5+10+5 = 20 Marks) Victoria] PROFIT STATEMENTS (C million) Years 2016 2017 2018 2019 2020 Sales revenue 176.200 190.000 199.110 201.240 201.545 Cost of Sales 28.629 31.294 32.111 32.919 32.382 Gross profit 147.571 158.706 166.999 168.321 169.163 Fixed and semi-variable costs Fixed overhead 34.283 40.872 42.478 44.014 45.523 Promotion 5.000 6.000 7.000 8.000 9.000 Research and Development 6.000 6.500 7.000 7.500 8.000 Depreciation 31.500 49.400 51.350 53.300 55.250 New model launch 20.000 0.000 0.000 0.000 Professional charges 8.000 8.000 8.000 8.000 8.000 Stock upkeep 0.000 0.362 0.376 0.472 0.504 Total fixed and semi variable 104.783 111.134 116.203 121.286 126.277 Operating profit 42.788 47.572 50.795 47.036 42.887 Interest on loans 15.000 25.000 30.000 30.000 15.000 Profit before tax 27.788 22.572 20.795 17.036 27.887 Tax 9.726 7.900 7.278 5.962 9.760 Profit after tax 18.062 14.672 13.517 11.073 18.126 Dividends 10.000 10.000 10.000 10.000 10.000 Retained earnings 8.062 4.672 3.517 1.073 8.126 單昆 三 70% 1. Ms Victoria is the Investment Manager and has requested some analysis concerning a proposed 5-years investment. The company plans to open a showroom in York and have narrowed their selection down to two locations: (1) City Centre and (2) Clifton Moor. You have to evaluate these options based on the following information. Daffodil will lease the showroom initially for 5 years, and the total initial cost of investment is estimated to be f10 million each. Option one: City Centre It is expected that the City Centre showroom will increase the overall sales revenue of the company by 10% per annum from 2020, and the variable cost will be forty-two percent of sales revenue. The fixed overhead cost will be £3,500,000, £2,000,000 and £1,500,000 in the first, second, and third years. The promotion cost will be £500,000 in the first two years and £200,000 for the next three years. All other expenses will be 10% of the total contribution margin. In the second year, the company will need a working capital investment of £2 million, and 60% of which will recover at the end of project life. The company follows a straight-line depreciation method and expects to sell the assets at 20 % of historical cost in year 5. Option two: Clifton Moor On the other hand, if the shoWroom is opened at Clifton Moor, then it will require fixed overhead cost for four years L2,500,000 in year one, £1,800,000 in year three, £2,100,000 in year four and f1,100,000 in year five. All other costs will increase and be at 10% per year of the contribution margin. The working capital investment will be f1,500,000 in year three, and 55% of it will recover in the last year. The sales revenue will increase at 12% per annum, and variable cost will be 45% of sales. The company will follow a similar strategy for depreciation and promotional cost, just like the city centre. 2 19 3 will follow a similar strategy for depreciation and promotional cost, just like the city centre. Financing the investment The company has several choices for financing this expansion issuing new equity or bond or using existing retained earnings. The shares of Daffodil are traded in the Alternative Investment Markets (AIM) for £30, however, the face value is £20 and last year's dividend was f0.35. HSBC will charge a flotation cost of 10% to issue the new common stock in the market. There is a projection that the dividend will grow at 6% a year in the coming years. The firm can issue an additional long-term bond at an interest rate (before tax) of 10 % (i.e. Coupon rate). Currently, similar bonds are selling at f110, slightly over the face value (which is £100), with five years of maturity. The market risk premium is 5%, the 3-month UK gilt rate is 3.5% (risk-free rate), and the average Beta of the Electronic goods industry is 1.73. The company is also planning to issue preferred stocks. The industry average preferred dividend and current market price are f10 and £96, respectively. The company wants to maintain a capital structure of approximately 45% debt, 5% prefered equity and 50% of ordinary equity. The current corporate tax rate is 35%. Required a) Determine the Weighted Average Cost of Capital (WACC) for target capital structure. b) Evaluate which showroom should be selected (Hints: use NPV and IRR). Ms Victoria prefers to use CAPM (i.e., Capital Asset Pricing Model) over DDM (i.e., Dividend Discount Model). Advise, accordingly with appropriate assumptions and rationales for the future. (5+10+5 = 20 Marks) Victoria] PROFIT STATEMENTS (C million) Years 2016 2017 2018 2019 2020 Sales revenue 176.200 190.000 199.110 201.240 201.545 Cost of Sales 28.629 31.294 32.111 32.919 32.382 Gross profit 147.571 158.706 166.999 168.321 169.163 Fixed and semi-variable costs Fixed overhead 34.283 40.872 42.478 44.014 45.523 Promotion 5.000 6.000 7.000 8.000 9.000 Research and Development 6.000 6.500 7.000 7.500 8.000 Depreciation 31.500 49.400 51.350 53.300 55.250 New model launch 20.000 0.000 0.000 0.000 Professional charges 8.000 8.000 8.000 8.000 8.000 Stock upkeep 0.000 0.362 0.376 0.472 0.504 Total fixed and semi variable 104.783 111.134 116.203 121.286 126.277 Operating profit 42.788 47.572 50.795 47.036 42.887 Interest on loans 15.000 25.000 30.000 30.000 15.000 Profit before tax 27.788 22.572 20.795 17.036 27.887 Tax 9.726 7.900 7.278 5.962 9.760 Profit after tax 18.062 14.672 13.517 11.073 18.126 Dividends 10.000 10.000 10.000 10.000 10.000 Retained earnings 8.062 4.672 3.517 1.073 8.126 單昆 三 70%
Expert Answer:
Answer rating: 100% (QA)
a WACC 623 b The showroom at Clifton Moor should be selected NPV of City Centre 14180238 NPV of Clifton Moor 19737238 IRR at City Centre 38 IRR at Clifton Moor 55 c Based on NPV and IRR Ms Victoria sh... View the full answer
Related Book For
Introduction to Governmental and Not for Profit Accounting
ISBN: 978-0132776011
7th edition
Authors: Martin Ives, Terry K. Patton, Suesan R. Patton
Posted Date:
Students also viewed these organizational behavior questions
-
At $1,000 par value, a 10-percent coupon bond matures in 20 years. If the price of the bond is $1,196.80, what is the yield to maturity on the bond? Assume interest is paid annually.
-
a Retired bonds payable at maturity date by issuing common shares 143000 b Sold the longterm investments for cash c Sold plant assets for cash cost 554400 twothirds depreciated d Purchased plant...
-
Which bond is premium? Bond Type Maturity Face Bond Symbol Coupon Bond Quote, closing Rate Feb 1, 2021 Credit Rating Value APL June 30, 2025 6% 95.3 2. What is the current yield of bond APL based on...
-
1) A survey of 200 public universities indicated that the 25th percentile of the yearly tuition cost of the universities was $4600 and the 75th percentile was $7100. The minimum value was $2000, the...
-
Suppose income taxes and unemployment compensation were cut by an equal amount. How would aggregate demand be affected?
-
Angela runs a donut shop in a residential neighborhood in Houston. Currently, Angela sells 300 glazed donuts at $0.80 each, 250 jelly donuts at $1.20 each, and 200 chocolate donuts at $1.00 each. On...
-
In a loudspeaker, an electromagnetic coil rapidly drives a paper cone back and forth, sending out sound waves. If the cone of a loudspeaker moves sinusoidally at 1.2 kHz with an amplitude of 3.5 m,...
-
McCawl Company produces two products and uses a predetermined overhead rate to apply overhead. McCawl currently applies overhead using a plantwide rate based on direct labor hours. Consideration is...
-
How can a company determine the correct value of its fixed assets? According to you, how does the depreciation of fixed assets affect the accounting and finances of a company? In your opinion, what...
-
Sofia Lofts case, but under a new set of assumptions on page 11 of the case. First re-read the Sofia Lofts case, then click here to download the new page 11. Specifically, you are to write up a brief...
-
Which FROM clause should be used to list the dates of orders by employees with the first name 'John'?Select one: a. FROM orders o JOIN employees e ON o.employee_id = e.id b. FROM orders o JOIN...
-
2. A stationary 250 g apple is held by a string as illustrated in the figure. The apple is shot by an 18 g arrow at an initial velocity of 10 m/s and penetrates the apple reaching a height H. Assume...
-
Write a MASM (6.11) program to display on the screen the Ace of Hearts playing card with the characters and background colours, red and white correspondingly, as shown in the image below. Use Dos...
-
Complete a written analysis of leadership within the film (use the topics you have covered in your readings, assignments. (100 POINTS) This assignment provides the opportunity to synthesize your...
-
A Corporation has provided its contribution format income statement for August Sales $863,300 Variable expenses 424,200 Contribution margin 436,100 Fixed expenses 352,400 net operating income $83,700...
-
show an algorithm to find the closest pair among points on a graph and return the Euclidian distance. IL F 10 5 E -5 0 5 C B A 10 15 D Write pseudocode for an algorithm to find the most distant...
-
the equation in general form of the line that passesthrough the point (-2,-2) and is perpendicular to the line7?+8y+2=0 isax=By+C=0 whereA=B=C= oint) Fine the equation for the line passing through...
-
If the amplifier indicated by the box input impedance of oo, which of the following statements are true ? has an open loop gain as well as Feedback factor (\beta = 1/ R_1\) The feedback is voltage...
-
What are earmarked funds ? Which funds are characterized as earmarked?
-
Using your answers from the preceding problem and the following information, prepare a budget summary for the General Fund of Jeter Village for fiscal year 2013. Assume that the fund balance at the...
-
How do the calculations of ratios and per capita amounts assist in assessing an entitys financial position and financial condition?
-
Rank in order, from least stable to most stable, the three objects shown in the figure. The positions of their centers of gravity are marked. (For the centers of gravity to be positioned like thi s,...
-
The end of a spring is pulled to the right by 4 cm; the restoring force is 8 N to the left. Given the relationships shown in Figure 8.14c, if the spring is returned to equilibrium and then pushed to...
-
A 1.0 kg weight is suspended from a spring, stretching it by 5.0 cm. How much does the spring stretch if the 1.0 kg weight is replaced by a 3.0 kg weight? A. 5.0cm B. 10.0cm C. 15.0cm D. 20.0cm
Study smarter with the SolutionInn App