ASAP excel template

Problem: Investing for maximum total return Imagine that you work as a financial advisor. You have a client who would like to invest $750,000 in hotels You have barmwed down your options to the following list Company Acme Chemical DynaStar Engle Vision Micromodeling OptiPro Sabre Susten Interest Rate 8.68% 9.109 10.00% 8.85% 9.15% 9.1% Years to Maturity Rating 1 - Excellent 10 3. Good 6 1 - Fair 10 1 - Excellent 7 3. Cool 1 2. Very Good The interest rate describes the return of the investment as the simple interest earned over the length of the bond's life. That is, if $100 is invested in Acne Chemnical, the return at the end of the years will be PV = 10000865 = 88.65 1. No more thiti 25% of the total de should be invested in any one investment 2. At least had should be invested in long-term bonds that mature in ten years or more 3. No more than 35% of the total funds should be invested in the combination of DynaStar. Eagle Vision and Optipto And the list stipulation is that all $750,000 must be invested If the goal is to maximize your clients total return on the investment, how much should they invest in each of the six bonds? What is the corresponding maximum total return they can expect to receive? Problem: Investing for maximum total return Imagine that you work as a financial advisor. You have a client who would like to invest $750,000 in hotels You have barmwed down your options to the following list Company Acme Chemical DynaStar Engle Vision Micromodeling OptiPro Sabre Susten Interest Rate 8.68% 9.109 10.00% 8.85% 9.15% 9.1% Years to Maturity Rating 1 - Excellent 10 3. Good 6 1 - Fair 10 1 - Excellent 7 3. Cool 1 2. Very Good The interest rate describes the return of the investment as the simple interest earned over the length of the bond's life. That is, if $100 is invested in Acne Chemnical, the return at the end of the years will be PV = 10000865 = 88.65 1. No more thiti 25% of the total de should be invested in any one investment 2. At least had should be invested in long-term bonds that mature in ten years or more 3. No more than 35% of the total funds should be invested in the combination of DynaStar. Eagle Vision and Optipto And the list stipulation is that all $750,000 must be invested If the goal is to maximize your clients total return on the investment, how much should they invest in each of the six bonds? What is the corresponding maximum total return they can expect to receive