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?

What's the data needed? 1. Demonstrate how to use Excel to solve

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!