Capital Budgeting Data

Capital Budgeting Data

  1. Suppose the company is considering a potential investment project to add to its portfolio.

Calculate the following items:

Don't use plagiarized sources. Get Your Custom Essay on
Capital Budgeting Data
Just from $13/Page
Order Essay
  1. The net present value (NPV) of the project is based on the outlay, cash flows yearly and yearly operating costs.  Yours does not agree with published result.  Your formula in the NPV cell should look like this: =NPV(F2,C14:G14)+B14, not +B140 [-6].
  2. The internal rate of return (IRR) of the project is also based on the outlay, cash flows yearly and yearly operating costs.  Yours agrees with published result.
  3. What are the implications of these calculations? Your summary was indicative of subject mastery and indicated that you have a grasp of the scenario, but comments should be based on accurate calculations [-6].
  4. In other words, based on each of the calculations, and being mindful of the need to balance portfolio risk with return, would you recommend that the company pursue the investment?  Discussion noted and a good job of presentation, thanks.

Why or why not? Be sure to substantiate your claims. Your comments were substantive and valuable to the conclusion of the assignment.

  1. What is the difference between NPV and IRR? Which one would you choose for evaluating a potential investment and why? Be sure to support your reasoning with evidence. I thought the following information is a great summary for your review and future utilization.

Key Differences Between NPV and IRR

The basic differences between NPV and IRR are presented below:

  • The amassing of all present values of the cash flows of an asset, regardless of positive or negative is known as Net Present Value. On the other hand, Internal Rate of Return is the discount rate at which NPV = 0.
  • The determination of NPV is calculated in absolute terms (meaning dollars), as compared to IRR’s notation determined as a percent.
  • The summary of NPV’s is to find surplus cash flow from the project.  IRR denotes the state of no profit no loss because… remember, NPV is set to equal Zero.  NPV emphases investment surpluses.  IRR is concentrated the point that the project breaks even with respect to cash flow
  • Results are more readily evident with NPV, however not with IRR. An example can explain this, In the case of positive NPV, the project is recommended (based on the hurdle rate set). Alternatively, if IRR = 10%, Cost of Capital < 10%, the project can be accepted, but if the Cost of Capital is equal to 16%, or any number higher than 10%, the project should be refused.
  • In term project cash flows are assumed to be reinvested at cut off rate in NPV.  Alternatively, cash flows from IRR are invested at the rate of IRR.
  • Timing of cash flows varies and should be considered.  IRR can be negative, or it will show multiple IRR’s.  This can make decisions more confusing. This complication is not evident in the NPV tool.
  • When the amount of initial investment is high, NPV constantly shows big cash inflows.  Then again, IRR will characterize viability of the project regardless of the initial investment. This means the IRR should demonstrate healthier results when compared to NPV.
  • NPV deals with dollars and IRR is percent return.  So, for budgeting purposes, NPV may be ahead to facilitate more efficient and effective decisions.
  • It is important that a line or two be dedicated to the crossover point…if any.




Yes, your discussion showed pertinent information and knowledge.  I always appreciate references to demonstrate actual research and not just thoughts and opinions.  I am encouraged by your efforts and look to see you “keep pulling the plow”.

Please be aware of the Turnitin Quotient.

I would be remiss if I didn’t at least ask this question.  Should we at all consider any of the following in analyzing these capital projects, such as: profitability index, Discounted profitability index, Pay back in years, Discounted payback in years, and sensitivity analyses?    Warm regards, Dr. Gary


Your formula in the NPV cell should look like this: =NPV(F2,C14:G14)+B14, not +B140

Recommendations must be based on accurate calculations

The Homework College
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We ensure that our writers and editors work within the work guidelines and follow all paper instructions to the letter. When placing an order, you choose the academic field and expert level (high school, college, university, or professional). Our team then assigns your paper to a writer with a respective qualification or degree to ensure that you receive quality work.

Professional and Experienced Academic Writers

We employ professional writers with more than two years of experience in academic and business writing. Most of our writers and editors are native English speakers to ensure quality and professional work. We are confident that our team of professional writers can handle all types of business and academic writing work.

Free Unlimited Revisions

We provide a free revision service for all orders. If you feel that our writers missed something, you can request a revision of your paper at no additional cost. When we deliver your work, you have seven days to go through it and request a revision or modification if you are not satisfied. You can also contact our support team directly for any clarifications and queries on revision.

Prompt Delivery and 100% Money-Back-Guarantee

We ensure that all papers are delivered on time. In case we need more time to master your paper requirements and deliver quality work, we may contact you and discuss a deadline extension. If a deadline extension is not feasible, depending on the work and submission deadlines, we guarantee a 100% refund.

Original & Confidential

To ensure that we deliver plagiarism-free work, we use various writing and plagiarism checking tools. Our professional editors' team carefully goes through all work and references used in papers to ensure proper referencing and that original work has been done. We also guarantee confidentiality in all the services that we provide.

24/7 Customer Support

Our support team is available round the clock for any customer queries and communication. We guarantee 24/7 customer support and assistance. Feel free to contact us at any time of day for questions and follow-ups.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

You do not have to spend sleepless nights worrying about your paper. We got you covered. We offer all kinds of writing services.


Essay Writing Service

Regardless of the type of academic paper you need and its urgency, we have writers on call ready to work on your paper. Feel free to choose the field, educational level, and type of paper you want, and we will deliver it at an affordable price. We are here for all your academic and business paper needs. With our round the clock service, we guarantee that you will receive your work on time.


Admission Essays & Business Writing Help

Admission essays are written by students wishing to join a college, graduate school or university, as applications for enrollment. We guarantee quality admission essays and business papers with our professional writing and customer care support services.


Editing Support

We have experienced academic writers and editors who are on standby to make all the necessary changed to your paper at your request. We ensure that your paper is polished and appropriately formatted (APA, Harvard, Chicago/Turabian, MLA formats) before it is delivered.


Revision Support

We provide revision support, where you can request a revision of a delivered paper if you feel that it can be improved or repolished. Your paper is checked by an experienced writer or editor for revamping and improvement upon a revision request. Revision service is free, and you can use it as many times as you wish until you are satisfied with your paper.