Problem 1 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%...


Please show the solution in excel format :) thank you


Problem 1<br>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?<br>2022<br>5000<br>2023<br>6000<br>2024<br>7000<br>2025<br>8000<br>2026<br>9000<br>2027<br>10000<br>2028<br>11000<br>Determine the following:<br>a. NPV for the period 2022 through 2028;<br>b. Total NPV using manual computation;<br>c. Total NPV using the Excel function; and<br>d. IRR rate.<br>

Extracted text: Problem 1 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? 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; c. Total NPV using the Excel function; and d. IRR rate.

Jun 02, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?