You work for a company that always pushes the envelope with respect to reporting revenues and expenses. You often disagree with
1 answer:
You might be interested in
Answer:
Project A is the better option than Project B.
Explanation:
The NPV of the project will decide which is the option with greater value to shareholders. As we can see that the NPV of Project A at 10% cost of capital is greater than the NPV of Project B at the same 10% cost of capital. So the best option here is Project A as is more in value than project B. Hence the CEO must select Project A.
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.
