Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART 1: Please answer and upload Section a) and b) question as Excel document and answer Section c), d) and e) on your Answer Sheet.

image text in transcribed

PART 1: Please answer and upload Section a) and b) question as Excel document and answer Section c), d) and e) on your Answer Sheet. 1-You are Manager of the Kumar Campany and working on the campany's Capital Structure. The Kumar Corpotation, a firm in the 34% marginal taxbracket with a 15% required rate of return or cost of capital, is considering a new project. This project involves the introduction of a new product. The project is expected to last five years and then, because this is somewhat of a fad project, to be terminated. Year Cost of new plant and equipment: Shipping and installation cost: Unit Sales: 1 2 3 4 5 $ 9,900,000 $ 100,000 Unit sold 8,000 10,000 15,500 9,500 9,500 $350 / unit in years 1 and 2, $300 / unit in year 3,4 and 5 Sales price per unit: Variable cost per unit: $50 / unit . Annual fixed costs: $ 200,000 Working Capital Requirement: There will be an initial working capital requirement of $ 100,000 just to get production started. Then, for each year, the total investment in NWC will be equal to 10% of the dollar value of sales for that year. Finally, 90 percent of the working capital is liquidated at the termination of the project at the end of year 5. The Depretiation Method: We used the simplified straight-line method over 5 years. It is assumed that the plant and equipment will have no salvage value after 5 years. Interest Expenses: There will be an interest payment of $100,000 every year for five years. . a) Given the following information, Use Excel Programa and determine the free cash flows associated with the project. b) Use Excel Program and calculate NPV (Net Present Value) and the IRR (Internal Rate of Return) c) According to your NPV and IRR result in section b), as a Financial Manager, do you accept or reject the preoject? Why? d) Use calculator to find the NPV ? Do you accept the project? Explain your result. e) Use Payback Period ? Do you accept the project? Explain your result. PART 1: Please answer and upload Section a) and b) question as Excel document and answer Section c), d) and e) on your Answer Sheet. 1-You are Manager of the Kumar Campany and working on the campany's Capital Structure. The Kumar Corpotation, a firm in the 34% marginal taxbracket with a 15% required rate of return or cost of capital, is considering a new project. This project involves the introduction of a new product. The project is expected to last five years and then, because this is somewhat of a fad project, to be terminated. Year Cost of new plant and equipment: Shipping and installation cost: Unit Sales: 1 2 3 4 5 $ 9,900,000 $ 100,000 Unit sold 8,000 10,000 15,500 9,500 9,500 $350 / unit in years 1 and 2, $300 / unit in year 3,4 and 5 Sales price per unit: Variable cost per unit: $50 / unit . Annual fixed costs: $ 200,000 Working Capital Requirement: There will be an initial working capital requirement of $ 100,000 just to get production started. Then, for each year, the total investment in NWC will be equal to 10% of the dollar value of sales for that year. Finally, 90 percent of the working capital is liquidated at the termination of the project at the end of year 5. The Depretiation Method: We used the simplified straight-line method over 5 years. It is assumed that the plant and equipment will have no salvage value after 5 years. Interest Expenses: There will be an interest payment of $100,000 every year for five years. . a) Given the following information, Use Excel Programa and determine the free cash flows associated with the project. b) Use Excel Program and calculate NPV (Net Present Value) and the IRR (Internal Rate of Return) c) According to your NPV and IRR result in section b), as a Financial Manager, do you accept or reject the preoject? Why? d) Use calculator to find the NPV ? Do you accept the project? Explain your result. e) Use Payback Period ? Do you accept the project? Explain your result

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

Finance Applications And Theory

Authors: Marcia Cornett, Troy Adair, John Nofsinger

5th Edition

1260013987, 9781260013986

More Books

Students also viewed these Finance questions