Fill in the chart with the proper answers and calculations that the assumed risk$-$free rate is $5\%.$ PLEASE SHOW ALL EXCEL FORMULAS

Initially assume that exchange rate between $ and Pound and $ and Euro$$is expected to be stable $($no change during the year$).$ Assume that risk free rate is $5\%.$

What are the expected returns, standard deviations of returns and sharp ratios of$$US&UK portfolios$$with different mixes such as $100\%$ invested in US$,0\%$ in UK; $90\%$ invested in US$,10\%$ in UK; $80\%$ invested in US$,20\%$ in UK;$...$; $10\%$ invested in US$,90\%$ in UK; $0\%$ invested in US$,100\%$ in UK$?$ Replace $!$s with the right info at the above table with the help of Excel formulas.

What are the expected returns and standard deviations of returns of$$US & Spain portfolios$$with different mixes such as $100\%$ invested in US$,0\%$ in Spain; $90\%$ invested in US$,10\%$ in Spain; $80\%$ invested in US$,20\%$ in Spain;...; $10\%$ invested in US$,90\%$ in Spain; $0\%$ invested in US$,100\%$ in Spain? Replace $*$s with the right info at the above table with the help of Excel formulas.