The selection of an appropriate discount rate for determining net present value of a particular investment proposal does not dep
1 answer:
You might be interested in
Answer:
Let Lt = Loan in period t , t= 1...4
It = Investment in period t, t= 1...4
These are the decision variables
The objective is to maximize the net income which is the difference between Loan and investment in period 4
Investment income in period 4 = 110% of I4 = 1.1I4
Expense and loan in period 4 = 1.085 L4
So,
Maximize Z = 1.1I4-1.085 L4
Constraints
L1<= 3000
I1<= 4500
L1-I1= 100( Payroll payment)
L2<= 7000
I2<= 8000
L2+1.1I1-1.085L1-I2=120
L3<=4000
I3<= 6000
L3+1.12I2-1.085L2-I3=150
L4<=5000
I4<=7500
L4+1.13*I3-1.085L3-I4=100
1.10I4-1.085L4>=0
Lt, It>=0
Putting this in excel sheet,
See remaining part in pictures attached.
Explanation:
See pictures attached.
