In the context of a one factor APT model, you are looking at the following three portfolios:

Portfolio	Expected return	Factor sensitivity
A	6	1.05
B	13	0.76
C	13	1.47

If you construct a composite portfolio "D" from B and C that has the same factor sensitivity as portfolio A, (similar to previous problem) and then go long D and short A (or the other way around) to create a riskless arbitrage profit, what would be your expected return?

Enter return as a percentage.

Hint: Solve for the weights within portfolio D. Then using those weights find the expected return on portfolio D (which is the weighted average of the component assets). Finally when you short one and long the other (you would obviously choose to short the one with the smaller return), your expected return would be the difference between the two returns.

The answer is 7.

Please show how to get to that in excel