Years Initial Invetsment Units Sold Selling Price Revenue (units sold * selling price) Variable % Variable cost (Revenue * variable 96) Fixed Cost MACRS Rate Depreciation (Initial investment * MACRS rate) Additional Investment Depreciation for additional Investment (3,500,000/4) Earnings Before Tax (EBT) (Revenue - Variable Cost - Fixed Cost - Depreciation) Salvage Value Tax Rate ° $ 41,000,000 25% Earnings After Tax(EAT) (EBT * (1-tax rate 25%) 3 4 5 6 7 70,000 $150 $ 100,000 250,000 250,000 250,000 325,000 325,000 150 S $10,500,000 $ 30% $3,150,000 $ 15,000,000 $ 30% 90 $ 22,500,000 $ 90 $ $1,100,000 14.29% 4,500,000 $ $1,100,000 24.49% 30% 6,750,000 $ $1,100,000 17.49% 22,500,000 $ 30% 6,750,000 $ $1,100,000 12.49% 90 $ 22,500,000 $ 30% 6,750,000 $ $1,100,000 8.93% 90 $ 29,250,000 $ 90 29,250,000 30% 8,775,000 $ 30% $1,100,000 8.92% 8,775,000 $1,100,000 8.93% $ 5,858,900 $ 10,040,900 $ -S 7,170,900 $ 3,500,000 5,120,900 $ 3,661,300 $ 3,657,200 $ 3,661,300 $ 875,000 $ 875,000 $ 875,000 $ 875,000 $391,100-$ 640,900 $ 3,979,100 $ 8,654,100 $ 10,113,700 $ 14,842,800 $ 14,838,700 $ 50,000 $ 293,325-$ 480,675 $ 2,984,325 $ 6,490,575 $ 7,585,275 $ 11,132,100 $ 11,166,525
Rare Agri-Products Ltd. is considering a new project with a projected
life of seven (7) years. The project falls under the government’s
subsidy program for encouraging local agricultural products and is
eligible for a one-time rebate of 25% on any initial equipment
installed for the project. The initial equipment (IE) will cost
$41,000,000.An additional equipment (AE) costing
$3,500,000 will be needed at the end of year 3. At the end of seven
(7) years, the original equipment, IE, will have no resale value but
the supplementary equipment, AE, can be sold for $50,000. A working
capital of $1,350,000 will be needed.
The project is forecast to generate sales of agri-products over the
seven years as follows:
Year 1 70,000 units
Year 2 100,000 units
Years 3-5 250,000 units
Years 6-7 325,000 units
A sale price of $150 per unit for the first two years is expected and
then decline to $90 per unit thereafter as the newness of the product
loses some sheen. The variable expenses will amount to 30% of sales
revenue. Fixed cash operating expenses will amount to $1,100,000 per
year.
The company falls in the 25% tax category for ordinary income and 40%
tax category for capital gain.
The initial equipment is
and the additional equipment is depreciated on a straight-line basis.
In the event of a negative taxable income, the tax is computed as
usual and is reported as a negative number, indicating a reduction in
loss after tax.
The initial financing of the project will be carried out as follows:-
55% equity and 45% debt. The company paid $1.50 per share in the form
of dividend this year, which is likely to increase at a rate of 3%
per year for the near future. The current price of the company’s stock
is $9.50 per share. The bank loan is likely to be arranged at an
interest rate of 13.5% p.a.
Compute the terminal cash flow. Compute the FCF for year 1 through 7. Compute the
Step by step
Solved in 2 steps