Question: What's the data needed? 1. Demonstrate how to use Excel to solve a system of linear equations using matrices. The average annual return (over 5-year
What's the data needed?

1. Demonstrate how to use Excel to solve a system of linear equations using matrices. The average annual return (over 5-year period prior to May 1, 2013) of three mutual lIldS offered by AXA Equitable is shown in the table: Mutual Fund Avera e Annual Return Moderate Allocations 8.85% Equity 500 Index 16.00% Barclays U.S. Aggregate Bond Index 421% Source: hps://www.sec.gov/Archives/edgar/data/l160168/000119312513192136/d523412d497.htm Suppose you have $10,000 to invest in these three funds. You want to invest $200 more in the Moderate Allocations fund that you will in the Equity 500 Index fund. a. Assuming the accounts will earn the annual rates shown, how much should you invest for a year in each fund if you want average return to be 9%? b. How much should you invest in each fund if you want your average return to be 10%? c. How much if you want 12%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
