Question: please show how to do with excel solver feature You have a new job as a Financial Planning assistant. Your client wants to invest money
please show how to do with excel solver feature
You have a new job as a Financial Planning assistant. Your client wants to invest money in stocks, bonds, and treasures that have the dividend yields shown in the table below. Your job is to allocate their money across these three investments such that the total dollars of bonds plus treasuries is greater than or equal to the total dollars of stocks. In addition, they have identified the maximum investment in each of those three investment types (also shown below). Maximize the dividends earned. Your answer will be the total dollars to be invested in Bonds (rounded to whole dollars). Use Scenario 5 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Stocks: yield % 1.22 1.33 1.44 1.55 0.97 Bonds: yield % 3.04 2.97 3.03 1.48 0.44 Treasuries: yield % 1.95 2.46 2.08 2.99 4.01 Stocks: $ max 70,000 150,000 1,110,000 440,000 777,000 Bonds: $ max 60,000 20,000 300,000 150,000 505.000 Treasuries: $ max 25,000 80,000 300,000 100,000 465,000
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
