1)Using Excel, the data provided on the previous page, and the excel spreadsheet provided as part of this assessment, assuming Bruce and Wayne were to invest the $980,000 entirely in the BCG Growth Fund, use formulas to calculate:

a.The dollar amount allocated to each asset class

b.The weighted return for each asset class (as a percentage)

c.The weighted return for each asset class (as a dollar value)

Note: you are required to enter the correct formulae into the highlighted cells.This assessment is about using Excel formulas to calculate the results of this scenario:

Asset Class Performance BCG Growth Fund Allocation Weighted Return % S % Cash 2.00% 3.00% Fixed Interest 6.00% 10.00% Listed Property 12.50% 11.00% Australian Shares 7.80% 39.20% International Shares 9.50% 36.80% 100.00% $0.00 0.00% $0.00