you can use excel sheet A new operation requires an initial investment of $48,000 in plant...

you can use excel sheet

A new operation requires an initial investment of $48,000 in plant and equipment. It also requires an initial $3,000 increase of inventory, a $1,000 increase of account payable, and a $2,000 increase of account receivable, and . During the 20-year life of operation (from year 1 to year 20), the annual revenues will be $10,000, cash expenses $2,700, depreciation $2,000. The firm is all-equity financed. The operation has the same risk as the average risk of the firm. A comparable firm with a debt-to-equity ratio 0.5 has an equity beta of 1.2. The tax rate is 21%, the risk-free rate is 3.84%, and the market risk premium is 6%.

a) What is the cash flow from the changes in working capital in the initial year? What is the annual operating cash flow from year 1 to year 20?

b) What is the beta of this firm? What is the appropriate discount rate for this project?

c) What is the NPV, IRR, and payback period of the project? Should we launch this operation?

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A new type of commuter airplane is being manufactured for private use requires an initial investment...

A new type of commuter airplane is being manufactured for private use requires an initial investment of $4,500,000 that will be depreciated straight-line to zero over 8 years. The price of the plane will be $25,000 and the variable costs are $17,500 per plane. The fixed costs are $850,000. Using the financial BE methodology which delivers NPV = $0, what is the BE operating cash flow needed if the required return = 10%?

You are considering an investment opportunity that requires an initial investment of $18,000 and is expected...

You are considering an investment opportunity that requires an initial investment of $18,000 and is expected to provide an annual cash flows of $1,450 for the first three years, then an annual cash flow of $1,620 for the next four years, then a final cash flow of $24,000 one year later. If your required rate of return is 9%, what is net present value of this opportunity? Enter your answer rounded to the nearest penny but do not include any...

A company is developing a new product. The development of the product requires an initial investment...

A company is developing a new product. The development of the product requires an initial investment of $160,000 with further investments of $90,000 in year 1, $60,000 in year 2 and $10,000 in year 3. The company will launch the product on the market in year 3 and the company expects annual profits of $60,000 from year 3 to year 7. At the end of year 7, the company expects to terminate the production line and sell it to a...

The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to...

The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to build a new plant and purchase equipment. The investment will be depreciated using the straight line method over 10 years. The new plant will be built on some of the company's land which has a current, after-tax market value of $5,000,000. The company will produce widgets at a cost of $130 each and will sell them for $420 each. Annual fixed costs are $500,000. Sales (in units)...

The Elkton Company is considering a new project that requires an initial investment of $24,000,000 to...

A firm is considering a project that requires an initial investment of $300,000 in new equipment,...

A firm is considering a project that requires an initial investment of $300,000 in new equipment, which has a five-year life and a CCA rate of 30 percent. An initial investment in raw materials inventory of $50,000 is also required to support the project, which will rise to 15 percent of sales. The project will generate sales revenue of $400,000 in the first year, which will grow at 4 percent per year. Variable costs will be $220,000 for the first...

A firm is evaluating the purchase of new machinery that requires an initial investment of $10,000....

A firm is evaluating the purchase of new machinery that requires an initial investment of $10,000. The cash flows that will result from this investment are presently valued at $11,500. The net present value of the investment is: A. $0 B. –$1,500 C. $1,500 D. $10,000 E. $11,500 Armstrong Bolts, Inc. is considering the purchase of a new machine that will cost $69.500 with installation. If Armstrong expects the cash inflows to zero in the first year and then $21,500...

Calculations must be done in Excel Polycorp is considering an investment in new plant of $3.2...

Calculations must be done in Excel Polycorp is considering an investment in new plant of $3.2 million. The project will be partially financed with a loan of $2,000,000 which will be repaid over the next five years in equal annual end of year instalments at a rate of 6.20 percent pa. The rest of the project will be financed by equity. Assume straight-line depreciation over a five-year life, and no taxes. The project’s cash flows before loan repayments and interest...

You are investing in a project that requires an initial investment of $500,000. The project will...

You are investing in a project that requires an initial investment of $500,000. The project will last for 10 years with the following additional cash flows (CF) at the end of each year: If the discount rate is 10%, calculate the payback periods in Excel for both the methods below; Years 1 2 3 4 5 6 7 8 9 10 CF -500,000 80,000 100,000 100,000 120,000 140,000 150,000 150,000 150,000 150,000 a) Payback Method [10] b) Discounted Payback Method...

Miller Tools is considering a new project that requires an initial investment of $81,300 for fixed...

Miller Tools is considering a new project that requires an initial investment of $81,300 for fixed assets, which will be depreciated straight line to zero over the projects 3 year life. The project is expected to have fixed costs of $37,600 a year, and a contribution margin of $18.40. The tax rate is 34 percent and the discount rate is 15 percent. What is the financial break even point. Need problem solved in excel. Answers 2,950, 4,217, 2,200, 2,483, 3,667...

Subjects