Using the data from Table 1 (Excel spreadsheet):

What is the expected excess return of a portfolio comprised of all three portfolios, A, B, & C, if the next period forecast is:

Beta measures hold over the period,

The expected market excess return is 5% next period, and

45% is invested in Portfolio A, 25% invested in Portfolio B, and 30% invested in Portfolio C.

(Submit your answer rounded to the nearest 10th percentage, e.g. 0.505 => 50.5)

AutoSave orr Final+Exam+Take+Home (2) Home InsertPage Layout Formulas Data Review View Insert Calibri (Body) 12 A A Wrap Text General Paste = Merge & Center, $, 96 , +00+00 Conditional Format Cell Sort & Formatting as Table Styles Format v Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1X Vfic Table 1. Excess returns of the three portfolios Check for Updates 1 able 1. Excess returns of the three portfolios Portfolio A Portfolio B Portfolio C 0.5172 0.0828 0.0744 0.252 0.2292 -0.1812 0.4524 0.2856 0.9444 1.1292 1.4412 24-0.0912-0.9012 1.482 -0.0 0.276 0.7068 -0.3792 0.1272 0.1848 0.282 0.3144 0.1548 -0.6348 0.6636 -0.0072 0.1548 0.1872 0.1416 0.756 0.9564 0.3588 0.6768 0.6144 0.4332 0.0492 -0.324 0.4836 0.4944 -0.504 0.0636 0.99720.2 1.1532 -0.546 0.0228 1.6116 0.2676 1.2816 1.6596 2.8404 1.5612 -0.7764 1.6392 2.274 0.4332 2.2884 -0.8904 0.9876 1.1232 -0.2328 3.132 6.018 2.8932 2.7816 2.7396 0.048 -0.0984 1.9884 0.2784 0.294 0.0504 -0.372 0.6588 -0.2088 -0.252 0.2364 -0.7512 0.3168 0.996 0.006 0.7968 -0.5208 0.6516 0.2124 -0.0792 -0.912 -0.6084 0.8652 Table 2 + Ready + 125% AutoSave oF Final+Exam+Take+Home (2) Q Search Sheet Home InsertPage Layout Formulas Data Review View Share ^ Insert Delete Format Calibri (Body) 12 A A Wrap Text General Merge & Center $%0Conditional Format Cell Formatting as Table Styles Paste Sort & Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates fr Table 1, Excess returns of the three portfolios -0.0492 0.792 0.0324 0.1836 0.0108 0.4272 0.0144 0.0144 -0.2328 0.4104 0.2184 0.2148 0.4464 -0.5652 0.8064 0.366 0.126 0.7164-0.4572 1.014 0.2112 0.204 0.2544 1.152 -0.342 1.5924 0.4812 0.576 0.6924 0.0972 1.6692 0.1392 -0.1728 1.2948 2.3052 4.2648 0.078 0.8736 -0.8508 3.2724 0.888 1.1544 0.546 0.1776 0.4836 -0.7176 0.7908 0.4644 0.402 0.1776 0.162 0.708 1.4556 0.4692 1.8024 0.6012 0.2652 0.33 38 0.0048-0.3816 -0.3924 0.6012 34 36 38 39 40 37 0.1092 0.1392 48 49 Table 1 Table 2 + Ready + 125%