Finish question 2 and 3 only. Following the instructions. Will add a file for reference too.
Question 3:
a. Create a Profitability Index (PI) calculator where PI =
SUM(PV of Positive CF)
SUM(PV of Negative CF)
To get started, you may use a discount rate (r) that equals 10% with the following cash flows (from year 0 to year 5):
-120,000; 39,000; 30,000; -21,000; 37,000; 46,000
a1. The column “CashFlow” is the only column that can be hard-coded.
a2. Must use the Excel table naming convention.
b. Write a subroutine and create a micro button “InputCashflow” that asks the user what each of the cashflow amount is and immediately fill in the cashflow in the table.
(Make sure you FIRST ask the user for the total number of periods so that you know how many times the For Next Loop needs to run.)
0 comments