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: DO IT IN EXCEL 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.

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: DO IT IN EXCEL 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.

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

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?
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: 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 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
Public Islamic Bank Bhd with excess fund of MYR9,000,000 decided to place Islamic Negotiable Instrument of Deposit (INID) with CIMB under the mudharabah (profit sharing) basis. The following are the details : Issuance date : 31 December 2021 Maturity date : 31 December 2022 Transaction date : 15 October 2022 PSR : 80:20 Expected dividend rate : 10.5% Profit : Quarterly dividend What is the expected amount received by Public Islamic at the end of the INID maturity?