What is the irr of the project

Assignment Help Finance Basics
Reference no: EM132384779

This question will require you to use Excel's IRR function. A firm invests $100,000 in a project today. It receives $15,000 a year from now, $20,000 two years from now, and $95,000 three years from now and nothing more. What is the IRR of the project?

The format of Excel's IRR function is =IRR(aX:aY,Z)

Where aX:aY are cells aX to aY which have cash flows entered into them. The initial investment is a negative cash flow so it should have a negative sign.

Z is a "guess" IRR, usually you can set to 0.1 (which is 10%).

Answer should be a number given as a %. That is, for example 3.18% should be answered as 3.18 rather than 3.18% or 0.0318

Reference no: EM132384779

Questions Cloud

How much do you have to save each month : How much do you have to save each month if you can earn an annual return of 11.1 percent?
What is the pretax cost of debt : The bond currently sells for 91 percent of its face value. The company's tax rate is 35 percent.
What is the npv of the project if the market demand is high : A firm is evaluating a product. The market demand for the product can be low or high.
What is the irr for the project : This is a Growing perpetuity formula. Remember the rate of discount and rate of return are one and the same thing.
What is the irr of the project : It receives $15,000 a year from now, $20,000 two years from now, and $95,000 three years from now and nothing more. What is the IRR of the project?
Project returns cash of amount : At the end of second year the project returns cash of amount $F. These are only cash flows from the project. If the IRR for the project is 10%
Difference between the type of risk bank faces : Explain the difference between the type of risk each bank faces. Which bank faces less risk? Why?
How much does the firm have in net fixed assets : How much does the firm have in net fixed assets (i.e., total assets - current assets)?
What is the amount of units that n corporation needs : What is the amount of units that N corporation needs in order to break-even with cash?

Reviews

Write a Review

Finance Basics Questions & Answers

  What will be price of stock on ex-dividend date

a. What will be the price of the stock on the ex-dividend date if the dividend is declared?

  Expected return to an investor

What is the expected return to an investor on this preferred stock?

  What is the firm market value weight of debt

What is the firm's market value weight of debt, market value weight of preferred stock and market value weight of equity?

  Should calandra buy a put on or call on canadian dollars

Contrarious Calandra. Calandra Panagakos works for CIBC Currency Funds in Toronto. Calandra is something of a contrarian-as opposed to most of the forecasts.

  Before you would reject the project

How high can the discount rate be before you would reject the project?

  What is the effective cost of borrowing in this case

Your firm has an average collection period of 23 days. Current practice is to factor all receivables immediately at a 1.30 percent discount. What is the effective cost of borrowing in this case?

  Bank to write off bad loans by liquidation

As a result of loan write-offs, Bank A has to be liquidated by the regulators. The book value of the assets and liabilities of the bank is presented below (in millions of dollars). The market value of the loans has been estimated at $240 million.

  Identify potential capital project for your company describe

Identify a potential capital project for your company describe such a project and write a short summary of the problems you see in getting the funding to see it through.

  How much equity financing is required for next year

The firm does not pay any dividends. Sales are expected to increase by 3.5 percent next year. If all assets, short-term liabilities, and costs vary directly with sales, how much additional equity financing is required for next year?

  Public utility companies usually have capital structures

Why do public utility companies usually have capital structures that are different from those of retail firms?

  How much additional money will be in the account if the

a self-employed person deposits 3000 annually in a retirement account that earns 8 percent.a. how much will be in the

  What is the firm weighted average cost of capital

The bond issue has a face value of $550,000 and a market quote of 101.2. The company's tax rate is 37 percent. What is the firm's weighted average cost of capital?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd