Compute the cash flows, wacc, npv and IRR. Should this project be accepted? Why? Draw NPV profile graph.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question

Rainbow is manufacturing plush toys. The firm thinks that manufacturing of plastic toys would be profitable. Marketing department made a marketing research that costs $30.000. After that research Rainbow is determined for the production. New toy requires a new machine. New toys will be produced in the facility of the firm which was bought 5 years ago. This facility can be sold for $150.000 (after taxes) now. New machine costs $200.000 to buy. It has 5 years of useful life and can be sold for $30.000 at the end of usedful life (straight line depreciation). The manufacturing units will be 5000 in the first year, 8000 in the second year, 12000 in the third year, 10000 in the fourth and 6000 in the fifth year. These toys will be sold for $30 per unit. Prices will increase by %2 in each year. The cost of manufacturing is $10 in the first year and will increase by % 10 in each of the following years. Tax rate: %20 Net working capital is the difference between current assets and current liabilities. Rainbow knows that it will need raw materials before manufacturing and it will also have some cash as a caution. Credit sales will also increase. In the year of investment the net working capital requirement is $10.000 net working capital amount will be 1. Year: $10.000, 2nd year $16320, 3. year $24970, 4. year $21.200, last year it will be 0. Target capital structure is %40 debt, % 60 equity. The firms should issue bonds with a coupon rate of % 20 and a nominal value of $1000, the price of bonds are $950, the flotation cost is $50 per bond. Company paid $2 of dividend per share recently and the expected growth rate is %8, the price of share is $12 per share and the flotation cost is $2 for the new issues. For equity financing this firms should issue shares. Compute the cash flows, wacc, npv and IRR. Should this project be accepted? Why? Draw NPV profile graph. Tip: Take the difference between the specific year and the previous year to calculate the change in net working capital each year. I WANT
YOU TO SOLVE THIS QUESTION IN EXCEL MORE ORIGINAL WAY.

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education