Calculation Of Project IRR, NPV, And Sensitivity Analysis

Calculation of Project IRR

Calculation of project IRR:

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Initial Cash Flow: $3,000,000.00

Discounted Net Cash Flows at 19%

  Year

  Cash Flows

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

  PVF(@19 %

  PV

  1

  $1,100,000.00

  0.840336134

  $924,369.75

  2

  $1,450,000.00

  0.706164819

  $1,023,938.99

  3

  $1,300,000.00

  0.593415814

  $771,440.56

  4

  $950,000.00

  0.498668751

  $473,735.31

  $3,193,484.61

Discounted Net Cash Flows at 24 %

  Year

  Cash Flows

  PVF(@24%

  PV

  1

  $1,100,000.00

  0.806451613

  $887,096.77

  2

  $1,450,000.00

  0.650364204

  $943,028.10

  3

  $1,300,000.00

  0.524487261

  $681,833.44

  4

  $950,000.00

  0.422973598

  $401,824.92

  $2,913,783.23

  IRR=

  IRR = 22.46 %

  Answer 2:

  Calculation of NPV

  Year

  Cash Flows

  PVF(@15%

  PV

  1

  $1,100,000.00

  0.869565217

  $956,521.74

  2

  $1,450,000.00

  0.756143667

  $1,096,408.32

  3

  $1,300,000.00

  0.657516232

  $854,771.10

  4

  $950,000.00

  0.571753246

  $543,165.58

  $3,450,866.74

Initial Investment = $ 3,000,000.00

NPV = $3,450,866.74 – = $ 3,000,000.00

= $450,866.74

Answer 3:

The Company should accept this project as the NPV of the project is positive. The NPV in this case is $ 450,866.00. Also, the IRR is higher than the required rate of return.

Answer 4:

The depreciation is the expense that occurs every year to write off the plant and machinery. Basically, depreciation does not affect the cash flows, but in case of tax implication, the amount of depreciation is subtracted from the cash flow before subtracting the tax. Therefore, depreciation provides the tax benefits, which ultimately increases the amount of the cash flow (Peterson & Fabozzi, 2004).

Answer 5:

Sunk Cost = Sunk cost refers to that part of the project costs, which have been incurred and there is no chance to recover them. Sunk cost is just opposite to the variable cost, because it does not change with the change in the proposed course of action. This cost does not take part in decision making process as there is no relevance in taking this cost and if taken, then it does not affect the decision. Examples of sunk cost are the research cost that has been incurred before the starting the project, staff training cost, advertising cost, etc. In the present case of Air Jet Best Parts Inc., the cost that has been incurred before purchasing the machine is regarded as the Sunk cost and it does affect the decision for purchasing the machine (Bierman & Smidt, 2007).

Opportunity cost: Opportunity cost refers to the benefit that is foregone, when another course of alternative is chosen. In simple words, when an alternative is chosen over other alternative, then the cost of choosing that alternative is called as opportunity cost. Example of opportunity cost in the present case is when the company accepts another proposal whose NPV is greater than the recent alternative having NPV of $450,866.74 and the benefit that the company will loose for not accepting the recent project is regarded as the opportunity cost (Bierman & Smidt, 2007).

Answer 6:

Sensitivity analysis of the project

In the present case, sensitivity analysis of the project has been done for different rates of returns. For this purpose 14%, 16% and 18% rates have been selected.

NPV at 14 %

  Year

  Cash Flows

  PVF(@14%

  PV

  1

  $1,100,000.00

  0.877192982

  $964,912.28

  2

  $1,450,000.00

  0.769467528

  $1,115,727.92

  3

  $1,300,000.00

  0.674971516

  $877,462.97

  4

  $950,000.00

  0.592080277

  $562,476.26

  $3,520,579.43

NPV (14%) = $520,579.43

NPV at 16 %

  Year

  Cash Flows

  PVF(@16%

  PV

  1

  $1,100,000.00

  0.862068966

  $948,275.86

  2

  $1,450,000.00

  0.743162901

  $1,077,586.21

  3

  $1,300,000.00

  0.640657674

  $832,854.98

  4

  $950,000.00

  0.552291098

  $524,676.54

  $3,383,393.59

NPV (16%) = $383,393.59

NVP at 18 %

  Year

  Cash Flows

  PVF(@18%

  PV

  1

  $1,100,000.00

  0.847457627

  $932,203.39

  2

  $1,450,000.00

  0.71818443

  $1,041,367.42

  3

  $1,300,000.00

  0.608630873

  $791,220.13

  4

  $950,000.00

  0.515788875

  $489,999.43

  $3,254,790.38

NPV (18%) = $254,790.38

Following graph represent the relationship between r and NPV.

 

For analyzing the scenario, three possible cases of cash flows have been selected – most likely, moderate and worst. In all cases, the probability of the cash flow is given below:

 

  Year

  Cash Flows

  Most Likely

  PVF(@15%

  PV

  1

  $1,100,000.00

  $990,000.00

  0.869565217

  $860,869.57

  2

  $1,450,000.00

  $1,305,000.00

  0.756143667

  $986,767.49

  3

  $1,300,000.00

  $1,170,000.00

  0.657516232

  $769,293.99

  4

  $950,000.00

  $855,000.00

  0.571753246

  $488,849.02

  $3,105,780.07

  Year

  Cash Flows

  Moderate

  PVF(@15%

  PV

  1

  $1,100,000.00

  $880,000.00

  0.869565217

  $765,217.39

  2

  $1,450,000.00

  $1,160,000.00

  0.756143667

  $877,126.65

  3

  $1,300,000.00

  $1,040,000.00

  0.657516232

  $683,816.88

  4

  $950,000.00

  $760,000.00

  0.571753246

  $434,532.47

  $2,760,693.39

  Year

  Cash Flows

  Worst

  PVF(@15%

  PV

  1

  $1,100,000.00

$770,000.00

  0.869565217

  $669,565.22

  2

  $1,450,000.00

  $1,015,000.00

  0.756143667

  $767,485.82

  3

  $1,300,000.00

  $910,000.00

  0.657516232

  $598,339.77

  4

  $950,000.00

  $665,000.00

  0.571753246

  $380,215.91

  $2,415,606.72

On analyzing the scenario in different conditions it can be concluded that in case of most likely situation there is total NPV of $ 105780.07 whereas in case of worst situation the NPV is – $ 584,393.28. The NPV in this scenario is computed below:

<tablewidth=”100%” cellpadding=”0″ cellspacing=”0″ border=”1″>

Calculation of NPV

  Situation

  Probability

  NPV

  Total

  Most likely

  0.25

  $3,105,780.07

  $776,445.02

  Moderate

  0.50

  $2,760,693.39

  $1,380,346.70

  Worst

  0.25

  $2,415,606.72

  $603,901.68

  $2,760,693.39

There are many risks associated with the project, like market risk and specific risk. Market risk is the risk that arises with the change in the market prices. Examples of market risk are inflation in market, downfall in US dollar value and some other government intervention that leads to close the project. There are also some specified risks associated with this project, like if the expected cash flows are not generated according to the desired level and when whole project fails due to no demand in the market (Baker & English, 2011).

Task 5:

Answer 1(a):

The competitor chosen is Raytheon INC. that has issued “Raytheon 7.2%” having maturity date 15 august, 2027 and YTM of 4.16 % (Morning Star 2013). Let assumed that AirJet Best Parts Inc. has issued the bond having face value of $100.00 and coupon rate 7.2%. Therefore cost of debt is 4.16 %.

Answer 1(b):

Cost of debt (Bonds) = Current YTM of Bonds x (1-t)

                        = 4.16 (1-.034)

                        = 2.74 %

Answer 1(c):

Other method for calculation of cost of debt is as follows: (Pratt, 2003).

Cost of Debt (Kd) = (Amount of Interest / Amount of debt) X 100

Also when there is premium or discount the cost of debt is as follows

Cost of Debt (Kd) = Interest amount/ (Amount of debenture + Amount of premium) X 100

Cost of Debt (Kd) = Interest Amount/ (Amount of Debenture – Amount of Discount) X 100

Answer 1(d):

The coupon rate (based on the face value of the bond) determines the interest payment, but not necessary reflect the actual cost of the corporation’s debt. As the required return changes the price of the debt issue price also changes so that the actual interest payments and anticipated payments at the end gives the investors their revised required return (Pratt, 2003).

Answer 2:

Betas of the three competitors are as follows

  Competitors

  Beta

  Raytheon Co. 

  0.63

  Lockheed Martin Corporation

  0.6

  Northrop Grumman Corporation 

  1.03

Source: Yahoo Finance

Answer 2(a):

Average of beta: (0.63+ 0.60 + 1.03)/3 = 0.75

Risk free return = 3%, Market return = 4 %

Using CAPM model

Expected return = 3 % + 0.75(4%-3%)

                        = 3.75%

Answer 2(b):

Advantages of using CAPM model:

  • It is one the easiest method to calculate the expected return of the equity.
  • It considers only systematic risk that reflect that it assume real factors in computing the expected return.

Disadvantages of using CAPM model:

  • It assumes that market is stable.
  • It also assumes individuals can borrow and lend freely at a risk less rate of return.

Dividend growth model cannot be applied where company does declare any dividend or whose dividend per share is growing at a rate higher than cost of equity (Ke). This method also fails to deal with risk directly. On the contrary CAPM model has a wider approach as it deals with some restrictive assumptions. The main condition for using this model is that company’s share is quoted on the stock exchange and all the variables in this model are market determined.

Answer 3 (a):

Current value of stock = $ 50.00

Dividend paid = $ 2.93

Face Value (assumed) = $ 10.00

n = 10 years (assumed)

Cost of preferred stock:

                                    = 23 %

Answer 3(b):

The other method for calculating the cost of preferred stock is as follows

Kp = Amount of preference dividend/ Preference share capital

In adjustment case cost of preferred capital will change and can be calculated by following way:-

Kp = D/ NP

D = Annual preference dividend,

NP = Net proceed = Par value of Pref. share capital – discount – cost of floatation Or NP = Par value of pref. share capital + Premium

Answer 4:

WACC = (0.3 x 2.74 %) + (0.6 x 3.75%) + (0.10 x 23 %).

            = 5.372 %

Answer 5:

Yes, company should use WACC for all the projects because of the following reasons: (Besley & Brigham, 2008)

This method is easy to use as compare to other methods.

  • Same rate can be used for all the projects.
  • No separate calculation is required to calculate the other project cost of capital as it cover all the capital invested in the business.

Answer 6:

  Year

  Cash Flows

  PVF(@5.37%

  PV

  1

  $1,100,000.00

  0.949036728

  $1,043,940.40

  2

  $1,450,000.00

  0.900670711

  $1,305,972.53

  3

  $1,300,000.00

  0.854769584

  $1,111,200.46

  4

  $950,000.00

  0.811207729

  $770,647.34

  $4,231,760.73

Yes, company should accept the project as the in this case the NPV of the project is $ $1,231,760.73 which is mush higher than the actual earning (Besley & Brigham, 2008).

References

Baker, H. K., & English, P. (2011). Capital Budgeting Valuation: Financial Analysis for Today’s Investment Projects. John Wiley & Sons

Besley, S. & Brigham, E. F. (2008). Essentials of Managerial Finance. Cengage Learning.

Bierman, H., & Smidt, S. (2007). The Capital Budgeting Decision, Ninth Edition: Economic Analysis of Investment Projects. Routledge

Morning Star. (2013). Raytheon Company RTN. Retrieved 15 June 2013 from

Peterson, P. P., & Fabozzi, F. J. (2004). Capital Budgeting: Theory and Practice. John Wiley & Sons.

Pratt, S. P. (2003). Cost of Capital: Estimation and Applications. John Wiley & Sons.

Yahoo Finance. (2013). All data retrieved 15 June 2013 from

What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Premium Quality

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

On-Time Delivery

Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.

24/7 Customer Support

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

image

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

image

Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

Free Features $66FREE

  • Most Qualified Writer $10FREE
  • Plagiarism Scan Report $10FREE
  • Unlimited Revisions $08FREE
  • Paper Formatting $05FREE
  • Cover Page $05FREE
  • Referencing & Bibliography $10FREE
  • Dedicated User Area $08FREE
  • 24/7 Order Tracking $05FREE
  • Periodic Email Alerts $05FREE
image

Services offered

Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.

  • On-time Delivery
  • 24/7 Order Tracking
  • Access to Authentic Sources
Academic Writing

We create perfect papers according to the guidelines.

Professional Editing

We seamlessly edit out errors from your papers.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

image

Delegate Your Challenging Writing Tasks to Experienced Professionals

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

Categories
All samples
Essay (any type)
Essay (any type)
The Value of a Nursing Degree
Undergrad. (yrs 3-4)
Nursing
2
View this sample

It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate
image

Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

See How We Helped 9000+ Students Achieve Success

image

We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

  • Clear elicitation of your requirements.
  • Customized writing as per your needs.

We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

  • Proactive analysis of your writing.
  • Active communication to understand requirements.
image
image

We Handle Your Writing Tasks to Ensure Excellent Grades

We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.

  • Thorough research and analysis for every order.
  • Deliverance of reliable writing service to improve your grades.
Place an Order Start Chat Now
image

Order your essay today and save 30% with the discount code ESSAYHELP