Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
An analysis of NPV and IRR for the Project
Answered

Question 1

Subsection a:

Use the discounting factor of 10% (cost of capital) the NPV is as shown below

Year

Cash flow

Discounting factor

Discounted cash flow

0

-100

                1.0000

  (100.0000)

1

10

                0.9091

         9.0909

2

10

                0.8264

         8.2645

3

10

                0.7513

         7.5131

4

10

                0.6830

         6.8301

5

10

                0.6209

         6.2092

6

10

                0.5645

         5.6447

7

10

                0.5132

         5.1316

8

10

                0.4665

         4.6651

9

10

                0.4241

         4.2410

10

10

                0.3855

         3.8554

11

10

                0.3505

         3.5049

12

10

                0.3186

         3.1863

13

10

                0.2897

         2.8966

14

10

                0.2633

         2.6333

15

10

                0.2394

         2.3939

NPV

   

    (23.9392)

NPV is $-23.9392, which implies that the project will not break-even within the period

Question b

Using the excel and the IRR function, the value of IRR is 6%. This value is less than the cost of capital of 10% and that explains why the NPV is negative.

Question c

The IRR rule states that a project should be accepted only if the value of IRR exceeds the cost of capital, otherwise the management should not undertake the project. In this case the value of IRR is 6% which is lower than the cost of capital of 10%. IRR rule is applicable as the NPV shows that the project is not economically viable.

Question c

Borrowing amortization schedule

 

Period

 

15

   
 

Rate

 

0.05

   
 

Payments

$7.71

   

 Year

Beginning balance

PMT

Interest

Principal

Ending balance

1

80

$7.71

$4.00

$3.71

$76.29

2

$76.29

$7.71

$3.81

$3.89

$72.40

3

$72.40

$7.71

$3.62

$4.09

$68.31

4

$68.31

$7.71

$3.42

$4.29

$64.02

5

$64.02

$7.71

$3.20

$4.51

$59.51

6

$59.51

$7.71

$2.98

$4.73

$54.78

7

$54.78

$7.71

$2.74

$4.97

$49.81

8

$49.81

$7.71

$2.49

$5.22

$44.60

9

$44.60

$7.71

$2.23

$5.48

$39.12

10

$39.12

$7.71

$1.96

$5.75

$33.37

11

$33.37

$7.71

$1.67

$6.04

$27.33

12

$27.33

$7.71

$1.37

$6.34

$20.99

13

$20.99

$7.71

$1.05

$6.66

$14.33

14

$14.33

$7.71

$0.72

$6.99

$7.34

15

$7.34

$7.71

$0.37

$7.34

$0.00

Year

Cash flow

Interest

Principal

Net cash flow

Discounting factor

0

-20

   

-20

 

-20

0

80

   

80

               1.0000

              80.0000

1

10

                 (4.00)

                 (3.71)

                   2.29

               0.9091

                2.0842

2

10

                 (3.81)

                 (3.89)

                   2.29

               0.8264

                1.8947

3

10

                 (3.62)

                 (4.09)

                   2.29

               0.7513

                1.7225

4

10

                 (3.42)

                 (4.29)

                   2.29

               0.6830

                1.5659

5

10

                 (3.20)

                 (4.51)

                   2.29

               0.6209

                1.4235

6

10

                 (2.98)

                 (4.73)

                   2.29

               0.5645

                1.2941

7

10

                 (2.74)

                 (4.97)

                   2.29

               0.5132

                1.1765

8

10

                 (2.49)

                 (5.22)

                   2.29

               0.4665

                1.0695

9

10

                 (2.23)

                 (5.48)

                   2.29

               0.4241

                0.9723

10

10

                 (1.96)

                 (5.75)

                   2.29

               0.3855

                0.8839

11

10

                 (1.67)

                 (6.04)

                   2.29

               0.3505

                0.8035

12

10

                 (1.37)

                 (6.34)

                   2.29

               0.3186

                0.7305

13

10

                 (1.05)

                 (6.66)

                   2.29

               0.2897

                0.6641

14

10

                 (0.72)

                 (6.99)

                   2.29

               0.2633

                0.6037

15

10

                 (0.37)

                 (7.34)

                   2.29

               0.2394

                0.5488

     

IRR

304%

NPV

              77.4378

Question d

The IRR is 304%

Question e

The NPV is now positive at 77.4378 this is consistent with the positive IRR. The cash used by the company is $20 and the rest amount was borrowed and repaid. Positive NPV shows positive cash flows for the company.

Question f

BU should go ahead with the project as it will get value out of investing in it.

Subsection a

This is not true. Though interest lowers the companies tax bills, it also increases the cost of operations and lowers profitability. Borrowings exposes a company to possible litigations if it fails to repay the borrowed amount and interests’ instalment in a timely basis. In addition, debts lower a company liquidity as money paid out as interest reduces a company’s cash flows. Considering these factors debts should be used for financing only when an organization derives higher benefits than the cost of debt. Therefore, maximum borrowings should only be recommended when the company derives higher value from borrowed capital than the cost paid to the financing institution as interests.

Subsection b

The statement is not true. Both debt and equity have advantages and disadvantages. The management should use a financing options that aligns with its financing objectives. For instance, if the gearing ratio of a company is high, it will be prudent to use equity financing to reduce the risk of debt exposure and cost of financing debts.

Subsection c

The NPV method is often faced with the challenge of examining the actual risk premium associated with undertaking a project. The uncertainty in the risk premium implies that the final discounting rate used while evaluating the whether to undertake a project or not may not be calculated with precision. The real value that an investors will get from a project may deviate from the anticipated value due to uncertainties surrounding assessment of the correct risk premium.

Subsection C

The statement is true. Betas measures volatility of a market price of a stock. Company with lower beta values shows that their stock prices are stable compared to the general trend of market. Their stability enables them to acquire a target at an attractive price as the owners of the target are likely to sell their shares to a company with a stable movement in its stock prices. Companies with higher betas will not attract investors whose stock has higher betas as there is no advantage attached to becoming acquired by such a company. Companies with higher betas introduces additional risk to a company with higher betas and they can only wish to buy them at lower prices to absorb the existing risk in the acquired firm.

The statement is true. Low leveraged companies have low levels of borrowings compared to equity. As a result, the lenders consider the management to be confident of the project they intend to undertake as they have already committed a significant portion of capital towards those projects. Therefore, if the project fails, the shareholders stand to lose more than the lenders and it is unlikely they could commit a significant amount of resource on a project bound to fail.

support
close