Please solve for the weighted expected return rate, standard deviation, and income yield for the portfolio below. Would appreciate adding the excel formulas to solve each below.

Asset Class Expected Return Standard Deviation Income Yield Allocation $\%$ Value $ Large Cap Stocks $-$ Apple $8\%15\%3\%30\%$ $ $300,000\mathrm{.}00$ ISmall Cap Stocks $-$ Sonos $10\%18\%3\mathrm{.}5\%15\%$ $ $150,000\mathrm{.}00$ Ilnternational Stocks $-$ NVIDIA $12\%21\%4\%15\%$ $ $150,000\mathrm{.}00$ Emerging Markets Stocks $-$ Palantir $15\%26\%2\mathrm{.}5\%10\%$ $ $100,000\mathrm{.}00$ Bonds $-$ US Treasury Bonds $4\%3\%4\%20\%$ $ $200,000\mathrm{.}00$ ICommodities $-$ Gold $15\%28\%1\mathrm{.}5\%5\%$ $ $50,000\mathrm{.}00$ Cash $0\mathrm{.}5\%0\%0\mathrm{.}5\%5\%50,000\mathrm{.}00$