Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 5000 2023 6000 2024 7000 2025 8000 2026 9000 2027 10000 2028 11000 Determine the following: a. NPV for the period 2022 through 2028; b. Total NPV using manual computation;

Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 5000 2023 6000 2024 7000 2025 8000 2026 9000 2027 10000 2028 11000 Determine the following: a. NPV for the period 2022 through 2028; b. Total NPV using manual computation;

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter16: Financial Planning And Forecasting

Section: Chapter Questions

Problem 2P: AFN EQUATION Refer to Problem 16-1. What additional funds would be needed if the companys year-end...

See similar textbooks

Similar questions

Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 50002023 60002024 70002025 80002026 90002027 100002028 11000 Determine the following: DO IT IN EXCELa. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.
ABC Enterprise would like to evaluate/analyze a potential investment.. 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 perio 2023 through 2029;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.
A reputable company plans to place an investment with a private equity firm with an amount of Php 10M for 2023. Considering all the risks involved, the prevailing discount rate is 12% and with a revenue stream/dividends below: 2019: 995,000.00 2020: 1.380,000.00 2021: 1.575,000.00 2022: 1,930,000.00 2023: 2,954,000.00 2024: 3.408,644.00 2025: 6,354.941.00 What is the NPV?
A reputable company plans to place an investment with a private equity firm with an amount of Php 10M for 2023. Considering all the risks involved, the prevailing discount rate is 12% and with a revenue stream/dividends below: 2023 2024 2025 2026 2027 2028 2029 995,000.00 1,380,000.00 1,575,000.00 1,930,000.00 2,954,000.00 3,408,644.00 6,354,941.00 Find the NPV.
ABM 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 perio 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate.
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; andd. IRR rate.EXCEL COMPUTATION AND FORMULA
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
Suppose your company wants to place an investment with a private equity firm with an amount of Php 200,000 for 2021. Considering all the risks involved, the prevailing discount rate is 12% and with a revenue stream/dividends below. Should the company invest? Why or why not? Year Cash flow 2022 5,000.00 2023 6,000.00 2024 7,000.00 2025 8,000.00 2026 9,000.00 2027 10,000.00 2028 11,000.00 Determine the following: a. NPV for the period 2022 through 2028; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate.
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 है
Calculate the risk-weighted asset for this amount. A Commercial Banking business line (15%) that reports positive profits in the last 3 years: $750,000.00 in 2017, $600,000.00 in 2018, $300,000.00 in 2019. For $550,000.00 MXN Select one: a.$82,500.00 MXN. b.$99,000.00 MXN. c.$28,500.00 MXN. d.$66,000.00 MXN.
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 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: