Question

Hi-Value Widgets can sell 50,000 units per year of a new widget at the price of...

Hi-Value Widgets can sell 50,000 units per year of a new widget at the price of $4 per unit. Variable cost is $2.5/unit. Fixed costs (including rent, administrative costs etc.) are $12,000 per year. The firm will need to invest $90,000 in equipment which is fully depreciated over the three-year life of the project. In addition, the project requires an initial $20,000 investment in net working capital. The tax rate is 34% p.a. and required return on equity is 20% p.a. should this project be accepted?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

File Home InsertPage LayoutFormulas DataReview View DeveloperNitro Pro8 5 EX Times New Roman, 12,A·A· в 1 u .田,上,스· -=9- wrap Text General Copy ! 掴Merge & Center, 雫, % 渦鼎Conditional-Format- Cell-Insert Delete Format , Sort & Find & Format Painter 2 Clear Filter Select Editing Formatting as Table, Styles Clipboard Font Alignment Number Cells D. Net Present Value A. INITIAL INVESTMENT (Year 0) Particulars Investment in Equipment Investment in Working Capital 20000 Amou P10647.69 ecision: Since NPV is positive, hence we should accept the project Total Outflow B. ANNUAL CASH FLow Sales 200000 200000200000 125000 125000 125000 12000 12000 12000 30000 30000 30000 3300033000 33000 11220 11220 11220 21780 217S021780 3000030000 30000 51780 51780 51780 0.83333 0.69444 0.5787 12 13 ss: Vaiable Cost Less: Fixed Cost 15 16 Profit Before Taxes Less: Tax a 96 Profit After Taxes dd:Depreciation Cash Flow After Taxes PVF @ 20% 19 43150359582 C. TERMINAL CASH FLOW (Year 3) Re-Capture of working Capital PVF 20%, 3rd year 20000 0.5787 1157 26 , , H Sheet1 Sheet2 i Sheet3,ウ Ready !File Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX Define Name ▼ Use in Formula- Create from Selection calculate Now | 떫 Trace Dependents ◆ Error Checking 水Remove Arrows, Q Evaluate Formula Insert Autosum Recently Financial Logical Text Date & Lookup & Math More Calculation Calculate Sheet Used Time Reference-aTrig, Functions-Manager window Function Library Defined Names Formula Auditing Calculation D. Net Present Value NPY A. INITIAL INVESTMENT (Year 0) Particulars Investment in Equipment Investment in Working Capital -SUM(C22:E22)+C28-C6 90000 20000 Decision: Since NPV is positive, hence we should accept the project Total Outflow B. ANNUAL CASH FLOW Selling Pice Sales Less: Variable Cost -C10 C11 -2.3*C10 D10D11 E10 E11 23 E10 12 13 -25 D10 12000 -90000 3 ess: Fined Cost Less: Depreciation Profit Before Taxes Less: Tax346 Profit After Taxes dd: Depreciation 15 -90000/3 -C12-c13.C14-C15-D12 D13-D14 D11-E12E13 E14 E15 -C16*0.34 -C16-C17 C15 -SUN IS:C19)|-SUN 18-D19)|-SU SEI -D16 0.34 -D16-D17 E16 034 E16-E17 18 19 D1 ash Flow After Taxes PVF 20% 21 -C21*C20 -D21 D20 -E21*E20 C. TERMINAL CASH FLOW Tear3 Re-Capture of W PVF 20%, 3rd vear 26 orking Cspital -E21 Sheetl Sheet2 sheet3 Ready ! | 80%

"If you have any Query, then please put it in the comment box."

Add a comment
Know the answer?
Add Answer to:
Hi-Value Widgets can sell 50,000 units per year of a new widget at the price of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Hi-Value Widgets can sell 50,000 units per year of a new widget at the price of...

    Hi-Value Widgets can sell 50,000 units per year of a new widget at the price of $4 per unit. Variable cost is $2.5/unit. Fixed costs (including rent, administrative costs etc.) are $12,000 per year. The firm will need to invest $90,000 in equipment which is fully depreciated over the three-year life of the project. In addition, the project requires an initial $20,000 investment in net working capital. The tax rate is 34% p.a. and required return on equity is 20%...

  • Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year. The following information relates to current production: $42 Sales price per unit Variable costs per unit: $24 Manufacturing Marketing and administrative $10 Total fixed costs: $78,000 $23,000 Manufacturing Marketing and administrative If a special sales order is accepted for 5,500 widgets at a price of $40 per unit, fixed costs remain unchanged, and no variable...

  • Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year. The following information relates to current production Sale price per unit $40 Variable costs per unit: Manufacturing Marketing and administrative $23 $5 Total fixed costs: Manufacturing Marketing and administrative $75,000 $22.000 If a special sales order is accepted for 2.900 widgets at a price of $33 per unit, foxed costs increase by $7.000, and variable...

  • Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year. The following information relates to current production: Sales price per unit $42 Variable costs per unit: Manufacturing $22 O A. Increase by $89,600 O B. Increase by $212,800 O c. Decrease by $89,600 OD. Increase by $50,400 Click to select your answer. Marketing and administrative Total fixed costs Manufacturing Marketing and administrative $76,000 $24,000 If...

  • Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year. The following information relates to current production: EB (Click the icon to view the data) If a special sales order is accepted for 2,800 widgets at a price of $36 per unit, fixed costs increase by $9,000, and variable marketing and administrative costs for that order are $3 per unit, how would operating income be...

  • Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year. The following information relates to current production: Sales price per unit $42 Variable costs per unit: Manufacturing Marketing and administrative $24 S6 Total fixed costs Manufacturing Marketing and administrative $77,000 $23,000 lf a spec a sales or er is accepted or 6.5 wo gets a a pn e o 7 per unit, an xed costs...

  • Widget Inc manfactures widgets The company has the capacity to produce 100,000 widgets per year, but it currently p...

    Widget Inc manfactures widgets The company has the capacity to produce 100,000 widgets per year, but it currently produces and ses 75 000 per year The following information relates to cum Sales price per unit Variable costs per un Marketing and administrative Maracturing S77000 Marketing and administrative $24000 a special sales order accepted for 5.300 widgets at a price of regular sales are not rected by the special order) p unit. Bred costs remain unchanged and no variable marketing and...

  • Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year. The following information relates to current production: Sales price per unit S41 Variable costs per unit Manufacturing Marketing and administrative $23 $6 Total fred costs: Manufacturing $75,000 Marketing and administrative $24,000 Ha enorial sales are arranter for 5 winnettarin 37 narunt fiv e remain unchanged and a variable marketing and aiministrativash will O A. Increase...

  • Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but...

    Widget Inc. manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and sells 75,000 widgets per year The following information relates to current production: Sales price per unit $40 Variable costs per unit Manufacturing Marketing and administrative $22 $5 Total fixed costs: $78,000 $25,000 Manufacturing Marketing and administrative If a snecial eales order is accented for 6.900 widoets at a.price.of $42.ner.unit and fixed.costs.remain unchanned how would oneratinn income.he affected2.(NOTE Decrease by $103,500...

  • how do i solve Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, b...

    how do i solve Widget Inc, manufactures widgets. The company has the capacity to produce 100,000 widgets per year, but it currently produces and solls 75,000 widgets per year. The following information relates to current production Sales price per unit $41 Variable costs per unit: Manufacturing Marketing and administrative $26 $10 Total foxed costs Manufacturing $80,000 Marketing and administrative $24,000 If a special sales order is accepted for 6.500 widgets at a price of $38 per unit, and food costs...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT