Question

In: Finance

Need assistance with Basic ROI, Payback Period, Net Present Value, Internal Rate of Return calculations.

Need assistance with Basic ROI, Payback Period, Net Present Value, Internal Rate of Return calculations.

Solutions

Expert Solution

The basic ROI formula is :

= Net profit/ Total investment * 100

It is a profitability ratio, that measures the how much net profit the business is generating.

Payback period : this measures how many days a project required, to recover the amount of investment made in the project.

For example, of the investment in the project is $10,000

CF0 = ($10,000)

CF1= $2,000

CF2= $3,000

CF3= $5,000

The cost of capital is 4.5%

So, the payback period is 3 years, as the project takes 3 years to recover the amount of investment made.

The net present value is the difference between the initial investment made in the project minus the present value of all the cash flows generated in the lifetime of the project.

So, the NPV is :

($80,000) + $22,000/1.045 + $33,000/1.045^2 + $50,000/1.045^3

= $15086.5502

The IRR is the rate at which the NPV is zero,

So,

($10,000) + $2,000/(1 + irr)^1 + $3,000/(1+ irr)^2 $5,000/(1 + irr) ^3 = 0

= 12.9777%

= 12.98 ( ronded off to two decimal places)

The NPV assumes that the cash flows are reinvetsed at the cost of capital, the IRR assumes that the cash flows are reinvested at the IRR.


Related Solutions

Payback period, net present​ value, profitability​ index, and internal rate of return​ calculations)  You are considering...
Payback period, net present​ value, profitability​ index, and internal rate of return​ calculations)  You are considering a project with an initial cash outlay of ​$73 comma 00073,000 and expected cash flows of ​$21 comma 17021,170 at the end of each year for six years. The discount rate for this project is 9.99.9 percent. a.  What are the​ project's payback and discounted payback​ periods? b.  What is the​ project's NPV? c.  What is the​ project's PI? d.  What is the​ project's...
Payback Period, Net Present Value, and Internal Rate of Return An organization’s initial outlay for a...
Payback Period, Net Present Value, and Internal Rate of Return An organization’s initial outlay for a proposed project is $2,000,000. Use the table below to calculate the payback period, net present value, and internal rate of return for the project. Free Cash Flows Year Amount Year Amount 1 $0.00 6 $0.00 2 $0.00 7 $0.00 3 $1,000,000.00 8 $500,000.00 4 $50.00 9 $500,000.00 5 $750,000.00 10 $500,000.00 As the CEO of the organization, if the firm’s cost of capital is...
Calculate the net present value, internal rate or return and payback period for an investment project...
Calculate the net present value, internal rate or return and payback period for an investment project with the following cash flows using a 5 percent cost of capital:                 Year                       0                              1                              2                              3                 Net Cash Flow   -$150,000             $62,000 $62,000 $62,000 Do you recommend the investment?                
Accounting Rate of Return Payback Period Net Present Value Internal Rate of Return Profitability Index 1)...
Accounting Rate of Return Payback Period Net Present Value Internal Rate of Return Profitability Index 1) Select three of the analytical tools and provide supportive statements explaining how each can be used to screen and/or rank future available projects. 2) Select one of the analytical tools listed and provide supportive statements explaining why you believe it provides the most important information in the decision process.
Calculate the payback period, net present value, profitability index, and internal rate of return for Project...
Calculate the payback period, net present value, profitability index, and internal rate of return for Project A. Assume a discount rate of 20%. Should the firm accept or reject Project A? Explain. If the firm must choose between Project A and Project B, which is the better choice? Explain. Under what circumstances should the modified internal rate of return be used instead of the standard internal rate of return? Project A Project B Year Cash Flow Year Cash Flow 0...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return [LO 11-1, 11-2, 11-3, 11-4] Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows:   Initial investment (for two hot air balloons) $ 402,000 Useful life 9 years Salvage value $ 51,000 Annual net income generated 34,572 BBS’s cost of capital 8 % Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return [LO 11-1, 11-2, 11-3, 11-4] Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows:   Initial investment (for two hot air balloons) $ 332,000 Useful life 6 years Salvage value $ 50,000 Annual net income generated 30,876 BBS’s cost of capital 10 % Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return [LO 11-1, 11-2, 11-3, 11-4] Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows:   Initial investment (for two hot air balloons) $ 402,000 Useful life 9 years Salvage value $ 42,000 Annual net income generated 35,778 BBS’s cost of capital 10 % Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return [LO 11-1, 11-2, 11-3, 11-4] Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows:   Initial investment (for two hot air balloons) $ 437,000 Useful life 9 years Salvage value $ 41,000 Annual net income generated 39,767 BBS’s cost of capital 10 % Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return [LO 11-1, 11-2, 11-3, 11-4] Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows:              Initial investment (for two hot air balloons)   $   432,000 Useful life      9   years Salvage value   $   45,000      Annual net income generated      37,152  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT