Please show the excel solutions. Thank you :) Problem 2ABM 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 yearsDiscount rate - 14%a. NPV for the perio 2023 through 2029;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.

The Net Present Value: Managers constantly use capital budgeting tools to assess prospective…

Answered: Problem 2 ABM Enterprise would like to…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 9PB: Joliet Company is considering two alternative investments. The company requires an 18% return from...

See similar textbooks

Similar questions

Simple Investment Allocation Case: This year, 2022 ABM Company selected your team to manage their allotted budget amounting to 10 million pesos for investment diversification portfolio. Your team was assigned to handle the said account. What would you choose? Other investment assets or Alternatives to fixed income and equities
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
NPV Analysis; Sensitivity Analysis; Data Tables in Excel This assignment is designed tointroduce you to the preparation of both a one-variable and a two-variable Data Table in Excel. Suchtables are useful for conducting and reporting the results of a series of what-if analyses. Assume thata hypothetical 5-year investment would require a net investment outlay of $350,000 and would haveannual (after-tax) cash inflows of $100,000. Assume, too, that the company considering this investment uses a 10% discount rate (weighted-average cost of capital) for present-value calculations.Required1. Consult the specified online help file (Microsoft website) regarding the preparation of Data Tables. (Seefootnote 27.)2. Prepare a one-variable Data Table where you depict the NPV of the proposed investment at each of thefollowing discount rates: 8% to 12%, in increments of 0.5%. Round your answers to nearest whole dollar. 3. Prepare a two-variable Data Table where, in addition to the 10 discount rates…
Net present value method, present value index, and analysis for a service company First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Instructions 1. Assuming that the desired rate of return is 15%, prepare a net present value analysis for each project. Use the present value table appearing in Exhibit 2 of this chapter. 2. Determine a present value index for each project. (Round to two decimal places.) 3. Which project offers the largest amount of present value per dollar of investment? Explain.
Joliet Company is considering two alternative investments. The company requires an 18% return from its investments. Compute the IRR for both Projects and recommend one of them. For further instructions on internal rate of return in Excel, see Appendix C.
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:
Simple Investment Allocation Case: This year, 2022 ABM Company selected your team to manage their allotted budget amounting to 10 million pesos for investment diversification portfolio. Your team was assigned to handle the said account. Question: How would you allocate funds?
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.…
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, . use the Pl to determine which projects the company should accept. What is the Pl of project A? i Data Table (Round to two decimal places.) (Click on the following icon o in order to copy its contents into a spreadsheet.) Cash Flow Project A -%241,900,000 $150,000 $350,000 Project B Year 0 $2,300,000 $1,150,000 $950 000 $750,000 $550,000 Year 1 Year 2 Year 3 $550,000 Year 4 $750,000 $950,000 4% Year 5 $350.000 Discount rate 18% Print Done
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%
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 Called-down Paid in capital Mgmt Fees $26 $31 $21 $10 $12 2015 2016 2017 2018 2019 What is the carried interest in 2019? O $9.85 O $5.40 $9.12 4 O $11.20 Table 8 Operating NAV before Carried NAV after Results Distributions Interest Distributions Distributions -$14 $6 $11 $41 $46 $5 $10 है
Daymore plc is currently considering three investment opportunities. The following is the details of the investments:-Project A:-1. initial outlay $80m2. Future net inflows Year 1: $190mYear 2: $10mProject B:-1. initial outlay $140m2. Future net inflows Year 1: $180mYear 2: $120mProject C:-1. initial outlay $90m2. Future net inflows Year 1: $10mYear 2: $220mThe company has a capital budget that is restricted in the year of the investment and it will not be possible to undertake all three projects in full. The investment opportunities are independent of one another and each project is divisible (that is, it is possible to undertake part of an investment and to receive a pro-rata return). The cost of capital of the company is 12% and the company uses the net present value method of investment appraisal.Required:Calculate and determine the ranking of the three investment opportunities? (The ranking for the first choice, second choice, and third choice is 1, 2, and 3 respectively). Show…

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Fundamentals Of Financial Management, Concise Edi…

Finance

ISBN:

9781337902571

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS