Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

you can search at Chegg Study, someone already answers this question, but I feel something is wrong, you can use the word below to search

image text in transcribed

you can search at Chegg Study, someone already answers this question, but I feel something is wrong, you can use the word below to search

The Edmonton Fabricating Company (EFC) manufactures snow blowers. EFC is investigating the feasibility of a new line of cordless snow blower.

The new manufacturing equipment to produce the new line of snow blower will cost $700,000. The installation costs are expected to be $50,000, the setup costs are expected to be $30,000 and the training costs are expected to be $20,000. The company has just finished a marketing feasibility and this study strongly endorses going ahead with a further financial study to evaluate the overall feasibility of the project. The cost of the marketing study was $50,000.

Below I found an answer from Cheggbut I feel this did not calculate the present value of salvage value and working capital, even though he did NPV at 8 years, could you help me get the correct answer.

image text in transcribed

image text in transcribed

The Edmonton Fabricating Company (EFC) manufactures snow blowers. EFC is investigating the feasibility of a new line of cordless snow blower. The new manufacturing equipment to produce the new line of snow blower will cost $700,000. The installation costs are expected to be $50,000, the setup costs are expected to be $30,000 and the training costs are expected to be $20,000. The company has just finished a marketing feasibility and this study strongly endorses going ahead with a further financial study to evaluate the overall feasibility of the project. The cost of the marketing study was $50,000. The projected useful life of the new equipment is 8 years and the project unit sales are expected to be: YEAR UNIT SALES 1 3,000 N 3,300 3 3,500 4 3,700 5 4,000 6 4,250 7 4,300 8 4,300 The new cordless snow blower would be priced to sell at $300 per unit and the variable operating costs are expected to be 55% of sales. After the first year, the sales price is estimated to increase by 2% every year. The total fixed operating costs are expected to be $150,000 per year and would remain constant over the life of the project The project would require $40,000 in working capital at the start time period zero). The entire amount of working capital will be recovered at the end of the project. The estimated salvage value of the equipment after 8 years is $150,000. The marginal tax rate is 40%. The CCA rate of the equipment is 20%. The company uses the DCF model to determine the cost of retained earnings and new common stock. You have been provided with the following data: DO = $0.80; PO = $22.50; g = 8.00% (constant) and F=9.00% The company's 9.25% coupon rate, semi-annual payment, $1,000 par value bond that matures in 20 years sells at a price of $1,075. The new bonds would be privately placed with no flotation costs. The target capital structure is 40% debt, 40% common equity (retained earnings) and 20% common equity (new common stock). REQUIRED: What is the net present value of this project? Should the project be undertaken by Edmonton Fabricating Company (EFC)? wm 1 Years 2 Initial Investment 3 Salvage Value 4 Tax on salvage Value 5 Working Capital 6 Sales 7 Selling Price 8 Total Sales 9 Variable Operating cost 10 Fixed Operating costs 11 CCA @ 20% 12 Net Income 13 tax @ 40% 14 Add CCA 15 Net Cash Flow 16 NPV @ 9.21% B C D D F G H 1 J 0 1 2 4 5 6 7 8 $ (800,000.00) $ 150,000.00 $ (6,312.91) $ (40,000.00) $ 40,000.00 3,000.00 3,300.00 3,500.00 3,700.00 4,000.00 4,250.00 4,300.00 4,300.00 $ 300.00 $ 306.00 $ 312.12 $ 318.36 $ 324.73 $ 331.22 $ 337.85$ 344.61 $ 900,000.00 $ 1,009,800.00 $ 1,092,420.00 $ 1,177,940.88 $ 1,298,918.59 $ 1,407,703.02 $ 1,452,749.52 $ 1,481,804.51 $ (495,000.00) $ (555,390.00) $ (600,831.00) $ (647,867.48) $ (714,405.23) $ (774,236.66) $ (799,012.24) $ (814,992.48) $(150,000.00) $ (150,000.00) $ (150,000.00) $ (150,000.00) $ (150,000.00) $ (150,000.00) $ (150,000.00) $ (150,000.00) $(160,000.00) $ (128,000.00) $ (102,400.00) $ (81,920.00) $ (65,536.00) $ (52,428.80) $ (41,943.04) $ (33,554.43) $ 95,000.00 $ 176,410.00 $ 239,189.00 $ 298,153.40 $ 368,977.37 $ 431,037.56 $ 461,794.24 $ 483,257.60 $ (38,000.00) $ (70,564.00) $ (95,675.60) $ (119,261.36) $ (147,590.95) $ (172,415.02) $ (184,717.70) $ (193,303.04) $ 160,000.00 $ 128,000.00 $ 102,400.00 $ 81,920.00 $ 65,536.00 $ 52,428.80$ 41,943.04 $ 33,554.43 $(840,000.00) $ 217,000.00 $ 233,846.00 $ 245,913.40 $ 260,812.04 $ 286,922.42 $ 311,051.34 $ 319,019.59 $ 507,196.08 $ 717,781.06 17 Years B D E F G H 1 1 lo =C1+1 =D1+1 =E1+1 =F1+1 =G1+1 =H1+1 1 =11+1 2 Initial Investment -800000 3 Salvage Value 150000 4. Tax on salvage Value --(3-(800000+SUM(C11:J11))*0.4 5 Working Capital -40000 40000 6 Sales 3000 3300 3500 3700 4000 4250 4300 4300 7 Selling Price 300 =C71.02 =D71.02 =E71.02 =F7*1.02 =G71.02 =H71.02 =171.02 8 Total Sales =C6 C7 =D6*D7 -E6 E7 =F6F7 -G6 G7 =H6 H7 =16*17 =J6J7 9 Variable Operating Cost --C8*0.55 |--D8*0.55 --E8 0.55 =-F8*0.55 --G8*0.55 |--H8*0.55 =-18*0.55 --J8 0.55 10 Fixed Operating Costs - 150000 -150000 -150000 -150000 - 150000 - 150000 -150000 -150000 11 CCA 2096 --800000*20% =($B$ 2-C11)*0.2 =($B$2-SUM(C11:011))*0.2 =($B$2-SUM(C11:E11))*0.2 =($B$ 2-SUM(C11:F11))*0.2 =($B$2-SUM(C11:G11))*0.2 =($B$2-SUM(C11:H11))*0.2 =($B$2-SUM(C11:111))*0.2 12 Net Income |-SUM(C8:C11) ESUMD8:D11) =SUMES:E11) -SUM(F8:F11) -SUM(G8:G11) I: =SUM(H8:H11) =SUM(18:111) -SUM(J8:J11) 13 tax @ 40% --C12*0.4 --D12*0,4 =-E12*0.4 =-F12*0.4 --G12*0.4 |--H12*0.4 --112*0.4 =-J12*0.4 14 Add CCA --C11 =-D11 =-E11 --F11 --G11 =-H11 =-111 --J11 15 Net Cash Flow -SUM(B2:35) -SUM(C12:C14) -SUM/D12:014) SUM(E12:E14) =SUM(F12:F14) -SUM(G12:G14) =SUM(H12:H14) -SUM(112:114) -SUM(J12:J14)+SUM(J3:35) 16 NPV @ 9.21% % =+NPV(9.21%,C15:15+015

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Personal Finance An Active Approach To Help You Develop Successful Financial Skills

Authors: Jack Kapoor, Les Dlabay, Robert Hughes

4th Edition

0078034787, 978-0078034787

More Books

Students also viewed these Finance questions

Question

What is Larmors formula? Explain with a suitable example.

Answered: 1 week ago

Question

OUTCOME 3 Describe pay equity and strategies for implementing it.

Answered: 1 week ago