Correct formula to compute the npv of project

Assignment Help Finance Basics
Reference no: EM132035753

Consider the following projected cash flows in the indicated cells in Excel for years zero through 2, respectively: A1= -$1000, A2= $600, A3= $500. In addition, the firm's cost of capital of 9% is in cell A4. Which of the following would be the correct formula to compute the NPV of this project?

A) NPV(A4, A1:A3) B) NPV(A4, A2:A3) + A1

C) NPV(A4, A2:A3) - A1 D) Sum(A1:A3/(1+A4)^3

Reference no: EM132035753

Questions Cloud

How does the stage that comes after impact your stage : HCS 455 :How does the stage that precedes yours impact the stage you are discussing ?How does the stage that comes after impact your stage ?
Will beach view accept the project : Beach View has a cost of capital of 11%. Will Beach View accept the project?
Corporate taxes on the weighted average cost of capital : What is the impact of corporate taxes on the weighted average cost of capital?
Maximizing shareholder interests : How does maximizing the value of the corporation differs from maximizing shareholder interests?
Correct formula to compute the npv of project : In addition, the firm's cost of capital of 9% is in cell A4. Which of the following would be the correct formula to compute the NPV of this project?
Find a mortgage calculator on the internet : Also for each case show the total amount of interest paid at the end of the loan. You can find a mortgage calculator on the internet.
Company weighted average flotation cost : What is your company's weighted average flotation cost, assuming all equity is raised externally?
Calculate the cost of equity using the ddm method : The expected return of the market is 16 percent, and Treasury bills are yielding 7 percent. The most recent stock price for Floyd is $57.
What is the relationship between a methodology : What is the relationship between a Methodology, like Waterfall or Agile, and a Business Case?

Reviews

Write a Review

Finance Basics Questions & Answers

  Amount of savings as the monthly deposits

What would today's deposit amount have to be if the firm opted for one lump sum deposit today that would yield the same amount of savings as the monthly deposits after 10 years?

  Assignment on cost of debt and equity

The manager of Sensible Essentials conducted an excellent seminar explaining debt and equity financing and how firms should analyze their cost of capital. Nevertheless, the guidelines failed to fully demonstrate the essence of the cost of debt and..

  What is the effective or net cost of the large press

If the firm could purchase a press that would provide slightly better quality and $26,000 annual cash inflow for 10 years for a price of $120,000 which alternative would you recommend? Why?

  What was the firm net income of given year

Fine Breads Inc. paid out $26,000 common dividends during 2005, and it ended the year with $150,000 of retained earnings.

  How dividend payout and profitability ratios useful

Distinguish between retained earnings and accumulated other comprehensive income.-  How are dividend payout and profitability ratios useful to investors?

  Explain main goal a financial manager is trying to achieve

Explain the main goal a financial manager is trying to achieve and the types of decision financial manager makes.

  Would you be willing to but one of these bonds for 829 if

minneapolis health system has bonds outstanding that have four years remaining to maturity a coupon interest rate of 9

  What real interest rate

If investors receive a 6% interest rate on their bank deposits, what real interest rate will they earn if the inflation rate over the year is?

  Should she place it instead in any of the annuities

(Solving for r with annuities) Nicki Johnson, a sophomore mechanical engineering student, receives a call from an insurance agent, who believes that Nicki.

  Describe the volatility of currency

List the foreign currencies that the company Alliance Global Group Inc. has exposure and describe the volatility of each currency.

  Expected excess return of the market

If the expected excess return of the market portfolio is 5% which of these firms has a higher equity cost of? capital, and how much higher is? it?

  Amount of tuition revenue

On January 1, Eastern College received $1,270,000 from its students for the spring semester that it recorded in Unearned Tuition and Fees. The term spans four months beginning on January 2 and the college spreads the revenue evenly over the months..

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