Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Today is Dec 3 1 , Year 0 . You have been asked to manage $ 3 8 0 , 0 0 0 for Mrs
Today is Dec Year You have been asked to manage $ for Mrs C
Investment opportunities: There are two bonds which are appropriate for Mrs C Bond A matures
on Dec Year and offers per annum. Bond B matures on Dec Year and offers per annum.
All interest are paid out at the end of each year on Dec You can purchase the bonds in any amount
today, but you cannot short the bonds and you cannot purchase them at a later date. In addition, spare
cash can be held in a savings account which offers interest per annum, including at the end of Year
Expenses: Her son is going to university next year, and she wants to give him some money on Dec
Year and Dec Year She has not decided the exact amount that she will give him on each date. He
will need at least $ per year, and she wants to give him $ in total. She wants to give him
approximately the same amount each year, so she asks you to minimize the difference between the two gifts.
Line of credit: Mrs C has a line of credit that allows her to borrow at most $ She can take
out money on her line of credit on Dec of Year or Year Interest on the outstanding debt is payable
at per annum at the end of each year. She can repay parts or all of the principle on Dec of each year.
She wants to be debtfree on Dec Year
a Write a linear program to determine how Mrs C should invest her money andor borrow funds in
order to fund her son's education expenses over the next two years.
Do NOT argue foragainst any investment decisions before setting up your LP Your LP should be able
to identify suboptimal strategies. You may only assume that you will not keep cash on hand today.
b Use Gurobi in Python to solve your LP Submit your code.
c Using your solution from part b what investment advice will you give Mrs C State her investments,
borrowed funds, interest revenue, and interest expense at the end of each year. Also state the amounts
that she should give her son on Dec Year and Dec Year
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