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 as per their target asset allocation, 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 formula into the highlighted cells of the spreadsheet provided.This assessment is about using Excel formulas to calculate the results of this scenario:

Asset Class Performance Risk Profile Allocation Weighted Return % % S Cash 2.00% 5.00% Fixed Interest 6.00% 25.00% Listed Property 12.50% 4.00% Australian Shares 7.80% 32.00% International Shares 9.50% 34.00% 100.00% $0.00 0.00% $0.00