What is this project internal rate of return

Assignment Help Finance Basics

Reference no: EM13650346

You may use Excel spreadsheet in order to perform the necessary computations for this questions. The computation of the IRR is performed using the function: =IRR(range, guess) where range refers to the range where you have inserted the data on the spreadsheet and guess refers to an initial guess as to what might the IRR be [you may guess any number].
1. Consider a project with the following expected cash flows:
Year Cash flow
0 - $549,000
1 $91,000
2 $182,000
3 $374,000
a. If the discount rate is 0%, what is the project's net present value?
b. If the discount rate is 5%, what is the project's net present value?
c. What is this project's internal rate of return?
2. Consider a project with the expected cash flows:
Year Cash flow
0 - $51,000
1 $51,000
2 $87,000
3 - $87,000
a. What is this project's internal rate of return (IRR)?
b. If the discount rate is 4%, what is this project's net present value?

3. A project requiring a $1.26 million investment has a profitability index of 0.96. What is its net present value?
4. Suppose that I am trying to borrow money from you to finance my business. And suppose that I promise to repay you in two installments, one payment in two years of $15,000 and one payment in four years for $10,000. If your opportunity cost of funds is 10%, how much are you willing to lend me?
5. What is the effective annual rate of interest for a loan that has an 15% annual percentage rate, compounded monthly?

Reference no: EM13650346

Questions Cloud

Explain an electron moves with a velocity : An electron moves with a velocity of 2.5 x10 8 cm/s what is its wavelengh? the 8 next to the cm is suppose to be in script

Find the final speed of the blue ball : each croquet ball in a set has a mass of 0.51 kg. the greenball, traveling at 12.3 m/s strikes the blue ball, which is atrest. find the final speed of the blue ball in the following situation

Define what is the longest wavelengh of radiation : What is the longest wavelengh of radiation that possesses the necessary enery to break the bond. What type of electromagnetic radiation is this

Research paper on william shakespeares hamlet : Research paper Assignment on "william shakespeare's Hamlet". Theme of Revenge in Hamlet) reasearch paper words should be 1550 word.

What is this project internal rate of return : What is this project's internal rate of return?

Explain what concentration of the barium ion ba^2+ : What concentration of the barium ion, Ba^2+, must be exceeded to precipitate BaF2 from a solution that is 1.00*10^-2 M in the fluoride ion, F^- ? Ksp for barium fluoride is 2.45×10^-5.

Explain what is the total pressure of a mixture of the gas : What is the total pressure of a mixture of the following gases. Oxygen with a partial pressure of 221 mmHg, nitrogen with a partial pressure of 467 mmHg, and helium with a partial pressure of 29 mmHg

Calculate current that results in magnetic dipole moment : A circular coil of 180 turns has aradius of 1.30 cm. (a) Calculate the current that results in a magnetic dipole moment of 2.30A·m2.(b) Find the maximum torque that the coil,carrying this current, can experience in a uniform 50.0 mT magnetic field

Determine the boys mass : a boy on a 2.2 kg skateboard initially at rest tosses a 7.5 kg jug of water in the forward direction. find the boy's mass

User Account

All Pages