To construct: A spreadsheet to compute the payback period,
Payback Period:
It is ascertained when cost of project is divided by the annual cash flows of the respective project. The payback period is a method used in capital budgeting. It does not involve the
Internal Rate of Return (IRR):
IRR is also a technique of capital budgeting that includes the time value of money concept. The IRR of a project is shows as the profitability arises from the project. The IRR of a project is calculated with the help of NPV calculations.
Modified Internal Rate of Return(MIRR):
It is also a kind of technique used in capital budgeting while selecting a project. It is modified version of the IRR and commonly used in large scale business to purchase heavy investment.
Net Present Value (NPV):
NPV is a technique used in capital budgeting to see the project is profitable for the company or not. The selection is based on the result of NPV as if it is positive then it should be selected and in the case of negative NPV it should be rejected.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
- D. (1) Consider the following cash inflows of a financial product. Given that the market interest rate is 12%, what price would you pay for these cash flows? Year 0 1 2 3 4 Cash Flow 160 170 180 230arrow_forwardExplain why financial institutions generally engage in foreign exchange tradingactivities. Provide specific purposes or motivations behind such activities.arrow_forwardA. In 2008, during the global financial crisis, Lehman Brothers, one of the largest investment banks, collapsed and defaulted on its corporate bonds, causing significant losses for bondholders. This event highlighted several risks that investors in corporate bonds might face. What are the key risks an investor would encounter when investing in corporate bonds? Explain these risks with examples or academic references. [15 Marks]arrow_forward
- Two companies, Blue Plc and Yellow Plc, have bonds yielding 4% and 5.3%respectively. Blue Plc has a credit rating of AA, while Yellow Plc holds a BB rating. If youwere a risk-averse investor, which bond would you choose? Explain your reasoning withacademic references.arrow_forwardB. Using the probabilities and returns listed below, calculate the expected return and standard deviation for Sparrow Plc and Hawk Plc, then justify which company a risk- averse investor might choose. Firm Sparrow Plc Hawk Plc Outcome Probability Return 1 50% 8% 2 50% 22% 1 30% 15% 2 70% 20%arrow_forward(2) Why are long-term bonds more susceptible to interest rate risk than short-term bonds? Provide examples to explain. [10 Marks]arrow_forward
- Don't used Ai solutionarrow_forwardDon't used Ai solutionarrow_forwardScenario one: Under what circumstances would it be appropriate for a firm to use different cost of capital for its different operating divisions? If the overall firm WACC was used as the hurdle rate for all divisions, would the riskier division or the more conservative divisions tend to get most of the investment projects? Why? If you were to try to estimate the appropriate cost of capital for different divisions, what problems might you encounter? What are two techniques you could use to develop a rough estimate for each division’s cost of capital?arrow_forward
- Scenario three: If a portfolio has a positive investment in every asset, can the expected return on a portfolio be greater than that of every asset in the portfolio? Can it be less than that of every asset in the portfolio? If you answer yes to one of both of these questions, explain and give an example for your answer(s). Please Provide a Referencearrow_forwardHello expert Give the answer please general accountingarrow_forwardScenario 2: The homepage for Coca-Cola Company can be found at coca-cola.com Links to an external site.. Locate the most recent annual report, which contains a balance sheet for the company. What is the book value of equity for Coca-Cola? The market value of a company is (# of shares of stock outstanding multiplied by the price per share). This information can be found at www.finance.yahoo.com Links to an external site., using the ticker symbol for Coca-Cola (KO). What is the market value of equity? Which number is more relevant to shareholders – the book value of equity or the market value of equity?arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning