Answered step by step
Verified Expert Solution
Question
1 Approved Answer
it to use the $3million to allocate to Treasury bills say 30% for Treasury bills 35%for cd and 35% for money market account. but you
it to use the $3million to allocate to Treasury bills say 30% for Treasury bills 35%for cd and 35% for money market account. but you need to calculate and decide which investments is worthy or putting more money and why?
it about a portfolio
if you were given $3 million to invest in a comblonition of T-bills, Certificate of deposit and Money Market accounts. No more. than 3 5 % of the porfolio can be invested in any individual secarsity I bills, CDs and money market accounts suming that the I bills used are of 56 days with Investment role of 1.585%, sent role of 1.585%, pri price per $100, with discount price a 99.758111 and a T-bill of saweets price price 0.264% per $100, drocount per 99.737111 - Assuming that T-bill of saweets with investment rake of 1.85% are for CDs are yied C DJ Summing yearly that and Aran percentage 1.7% minthly. or - Anonat percentage yield Apy and 1.5% compounded daily. money Compounded Assuming is 1.6% market daily 10 based on the above gosumption which investment will be profitable to invest more and why i (2) A detailed description of the upside and down of each investment. 13) use excel/spreadsheet to include all cell formulas for all Calculations and a summoon of recomendations of the analysis if you were given $3 million to invest in a comblonition of T-bills, Certificate of deposit and Money Market accounts. No more. than 3 5 % of the porfolio can be invested in any individual secarsity I bills, CDs and money market accounts suming that the I bills used are of 56 days with Investment role of 1.585%, sent role of 1.585%, pri price per $100, with discount price a 99.758111 and a T-bill of saweets price price 0.264% per $100, drocount per 99.737111 - Assuming that T-bill of saweets with investment rake of 1.85% are for CDs are yied C DJ Summing yearly that and Aran percentage 1.7% minthly. or - Anonat percentage yield Apy and 1.5% compounded daily. money Compounded Assuming is 1.6% market daily 10 based on the above gosumption which investment will be profitable to invest more and why i (2) A detailed description of the upside and down of each investment. 13) use excel/spreadsheet to include all cell formulas for all Calculations and a summoon of recomendations of the analysisStep 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