Question
The following investments are available to Finco: a. Investment 1: For each dollar invested at time 0 (where time 0 = now), Finco receives $0.
The following investments are available to Finco:
a. Investment 1: For each dollar invested at time 0 (where time 0 = now), Finco receives $0. 10 at
time 1 (time 1 = one year from now, and so on), and $1.30 at time 2 (the original $1.00 plus a
return of $0.30).
b. Investment 2: For each dollar invested at time 1, Finco receives $1.60 at time 2 (the original $1.00
plus a return of $0.60).
c. Investment 3: For each dollar invested at time 2, Finco receives $1.20 at time 3 (the original $1.00
plus a return of $0.20).
d. At any time, leftover cash can be invested in Tbills, which pay 10% per year. At time 0, Finco has
$10,000. At most, $5,000 can be invested in any one of investments 1, 2, or 3. Determine how to
maximize Finco's cash on hand at time 3.
Inputs Dollars invested in Investment 1, Investment 2, Investment 3, TBills at time 0, TBills at
time 1, & TBills at time 2
Outputs: Cash inflows & Outflows at Time 0, 1, 2, & 3 from Investment 1, Investment 2,
Investment 3, TBills at time 0, TBills at time 1, & TBills at time 2.
Net Cash (Cash available + Inflows - Outflows) at time 0, 1, 2, & 3
Test to confirm that investment constraints are not violated.
Build Solution using Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started