ABC Enterprise would like to evaluate/analyze an investment proposal. Given the following: Investment amount - 450,000 (2022) Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14% a. NPV for the period 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate. EXCEL COMPUTATION

ABC Enterprise would like to evaluate/analyze an investment proposal. Given the following: Investment amount - 450,000 (2022) Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14% a. NPV for the period 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate. EXCEL COMPUTATION

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.3.1P

See similar textbooks

Similar questions

Using the following information, calculate the RAROC. •Risk-Adjusted Return: $80,000•Loan Amount: $3,000,000•Capital Requirement: 10%•Capital Ratio: 75% a) 28.75% b) 33.33% c) 35.56% d) 38.25%
Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
Cash Payback Period, Net Present Value Method, and Analysis Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Plant Expansion Retail Store Expansion Year 1 2 3 4 5 Total Year 1 2 Each project requires an investment of $294,000. A rate of 15% has been selected for the net present value analysis. Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.893 0.870 0.833 0.797 0.756 0.694 3 4 5 $162,000 132,000 114,000 103,000 33,000 $544,000 6 7 8 9 10 Required: 0.909 0.826 $135,000 159,000 109,000 76,000 65,000 $544,000 0.943 0.890 0.840 0.751 0.792 0.683 0.747 0.621 0.705 0.564 0.665 0.627 0.592 0.558 0.712 0.658 0.636 0.572 0.567 0.497 0.507 0.432 0.513 0.452 0.376 0.467 0.404 0.327 0.424 0.361 0.284 0.386 0.322 0.247 1a. Compute the cash payback period for each project. Cash Payback Period 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 Plant Expansion Retail Store Expansion 1b. Compute the net present value.…
Calculate the HPR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Period Cashflow 0 -14100 1 3300 2 3300 3 3100 4 2800
Use Table 8 to answer the next two questions. Assume the committed capital is $100, the management fee is 2.00%, and the carried interest is 20.00%. Year 2015 2016 2017 2018 2019 $5.40 What is the carried interest in 2019? Called-down Paid in capital Mgmt Fees $26 $31 $21 O $11.20 $9.12 $9.85 $10 $12 Table 8 Operating NAV before Carried NAV after Results Distributions Interest Distributions Distributions -$14 $6 $11 $41 $46 $5 $10
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, , use the PI to determine which projects the company should accept. ..... What is the Pl of project A? (Round to two decimal places.)
Calculate/estimate the IRR(s) for a 6-year project with the following cash flows: CF0 = -50, CF1 =28 = CF2 = CF3 = CF4 = CF5, and CF6 = -93. In Excel, plot the NPV (= Y axis) against r (= discountrate), using r = 0%, 2%, and so on until you find all IRRs in the chart. Identify/estimate all IRRs.
Calculate the EAR of the following investment, entered as a percentage (Example: if your answer is 0.145, enter 14.5) Year Number Cashflow 0 -11400 1 3500 2 3000 3 3100 4 2800 Your Answer:
The internal rate of return method is used by Testerman Construction Co. in analyzing a capital expenditure proposal that involves an investment of $143,920 and annual net cash flows of $35,000 for each of the six years of its useful life. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Determine the internal rate of return for the proposal. %
Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. Invested Amount 15,500 23,000 35,000 56,000 $ 67 67 $ $ $ i = 5% 5% 11% 6% n = 12 6 18 14 Future Value
Compute the Payback Period, Discounted Payback Period, Net Present Value, Internal Rate of Return, and Productivity Index of all four alternatives based on cash flow. use 10 percent for the cost of capital in the calculations. For the Payback Period and for the Discounted Payback Period, compute to the midyear points. ALL Information is in the PNGs!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Use the information provided to answer the questions.5.1 Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5.5.1.1 Calculate the Payback Period of Project A (expressed in years, months and days). 5.1.2Calculate the Accounting Rate of Return (on average investment) of Project B (expressed to twodecimal places). 5.1.3 Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). 5.1.4 Use your answers from question 5.1.3 to recommend the project that should be chosen. Motivateyour choice.