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.
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.
Chapter15: Harvesting The Business Venture Investment
Section: Chapter Questions
Problem 1eM
Related questions
Question
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. |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 7 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you