Question

Create a PowerPoint Presentation that includes a capital budget analysis, an interpretation of the analysis, and your recommended strategy for the Deluxe Corporation.

Deluxe Corporation is a large chain of retail stores operating in the USA. It sells top-of the- range, expensive clothes to a wealthy clientele throughout the country. Currently, Deluxe only operates in the USA. Its current market capitalization is $760 million and the current market value of debt is $350 million.

At last month’s management meeting the marketing director explained that sales volume had increased slightly in the previous year, largely due to heavy discounting in most of its stores. The finance director expressed concern that such a strategy might damage the image of the company and reduce profits over the longer term.

An alternative strategy to increase sales volume has recently been proposed by the marketing department. This would involve introducing a new range of clothing specifically aimed at the middle-income market. The new range of clothing would be expected to be attractive to consumers in Canada and Europe.

Assume your represent the financial management of Deluxe and have been asked to evaluate the marketing department’s proposal to introduce a new range of clothing. An initial investigation into the potential markets has been undertaken by a firm of consultants at a cost of $100,000 but this amount has not yet been paid. It is intended to settle the amount due in three months’ time. With the help of a small multi-department team of staff you have estimated the following cash flows for the proposed project:

• The initial investment required would be $46 million: This comprises $30 million for fixed assets and $16 million for net current assets (working capital).

• For accounting purposes, fixed assets are depreciated on a straight line basis over three (3) years after allowing for a residual value of 10%.

• The value of net current assets at the end of the evaluation period can be assumed to be the same as at the start of the period.

• Earnings before taxes are forecast to be $14 million in 2018, $17million in 2019 and $22 million in 2020.

The following information is also relevant:

The proposed project is to be evaluated over a three-year time horizon. The firm uses Net Present Value and Internal Rate of Return methods to evaluate projects.

Deluxe usually evaluates its investments using an after-tax discount rate of 8%. The proposed project is considered to be riskier than average and so a risk-adjusted rate of 9% will be used for this project.

Corporate tax is 25%.

Ignore inflation.

Prepare a Sensitivity Risk Analysis with the following variables: Earnings Before Taxes, Project Discount Rate, and Tax Rate. Your margins of variance are plus/ minus 10%, 20%, 30%.

Your Sensitivity work should include a graph analysis.

***What would you recommend provide capital budget analysis, risk analysis, SWOT analysis, as part of your evaluation.***

Answer 1

Solution :-

		Current Situation	2016	2017	2018	2018
Initial Fixed Capital		-30000000.00
Initial NWC		-16000000
EBIT			14000000.00	17000000.00	22000000.00
Less :- Interest			0.00	0.00	0.00
EBT			14000000.00	17000000.00	22000000.00
Less :- Tax@25%			3500000.00	4250000.00	5500000.00
EAT			10500000.00	12750000.00	16500000.00
ADD :- Dep			9000000.00	9000000.00	9000000.00
CFAT			19500000.00	21750000.00	25500000.00
Salvage Value						3000000
Less:- Tax@25%						750000
Salvage Value After Tax						2250000
NOWC Taken Back						16000000.00
Total CFAT		-46000000	19500000	21750000	25500000	18250000
PVF@9%		1	0.917431193	0.84167999	0.77218348	0.772183
PV		-46000000	17889908.26	18306539.9	19690678.74	14092339.8
Therefore NPV		23979466.6
IRR		32.62%
Year	Cash Flows	PVF@30%	PV	PVF@40%	PV
0	-4,60,00,000.00	1.00	-4,60,00,000.00	1.00	-4,60,00,000.00
1	1,95,00,000.00	0.77	1,50,00,000.00	0.71	1,39,28,571.43
2	2,17,50,000.00	0.59	1,28,69,822.49	0.51	1,10,96,938.78
3	2,55,00,000.00	0.46	1,16,06,736.46	0.36	92,93,002.92
4	1,82,50,000.00	0.46	83,06,779.50	0.36	66,50,865.75
	NPV		17,83,338.44		-50,30,621.13
IRR	30+ 1783338.44/6813960 *10				32.61718361
Sensitivity Analysis
NPV value with 10%, 20%, 30% plus/minus change in EBT, Discount rate and tax rate
	10%	-10%	20%	-20%	30%	-30%
EBT	11,92,90,022.85	11,26,68,927.88	12,26,00,570.33	10,93,58,380.39	125,911,117,82	10,60,47,832.91
Discount rate	11,47,11,167.81	11,72,85,354.71	11,34,79,016.71	11,86,30,289.98	11,22,81,671.72	12,00,15,838.08
Tax rate	11,87,90,133.12	12,12,41,543.04	11,75,64,428.16	12,24,67,248.00	11,63,38,723.20	12,36,92,952.96
IRR value with 10%, 20%, 30% plus/minus change in EBT and tax rate
	10%	-10%	20%	-20%	30%	-30%
EBT	35%	29%	38%	26%	41%	23%
Tax rate	31%	33%	30%	35%	29%	36%
	There is not a sufficient time brother It is not possible to make a power point presentation in this time