The expected return of your portfolio can be calculated using Microsoft Excel if you know the expected return rates of all the investments in the portfolio. Using the total value of your portfolio, the value of each individual investment, and its respective return rate, your total expected return can be calculated quite simply.
You can also calculate the expected return of a portfolio outside of Excel by using a basic formula.
Calculating Total Expected Return in Excel
First, enter the following data labels into cells A1 through F1: Portfolio Value, Investment Name, Investment Value, Investment Return Rate, Investment Weight, and Total Expected Return.
In cell A2, enter the value of your portfolio. In column B, list the names of each investment in your portfolio. In column C, enter the total current value of each of your respective investments. In column D, enter the expected return rates of each investment.
In cell E2, enter the formula = (C2 / A2) to render the weight of the first investment. Enter this same formula in subsequent cells to calculate the portfolio weight of each investment, always dividing by the value in cell A2. In cell F2, enter the formula = ([D2*E2] + [D3*E3] + ...) to render the total expected return.
Example
In the example above, assume that the three investments are governmentissued bonds that carry annual coupon rates of 3.5%, 4.6%, and 7%, respectively.
After labeling all your data in the first row, enter the total portfolio value of $100,000 into cell A2. Then, enter the names of the three investments in cells B2 through B4. In cells C2 through C4, enter the values $45,000, $30,000, and $25,000, respectively. In cells D2 through D4, enter the respective coupon rates referenced above.
Next, in cells E2 through E4, enter the formulas = (C2 / A2), = (C3 / A2) and = (C4 / A2) to render the investment weights of 0.45, 0.3, and 0.25, respectively.
Finally, in cell F2, enter the formula = ([D2*E2] + [D3*E3] + [D4*E4]) to find the annual expected return of your portfolio. In this example, the expected return is:
= ([0.45 * 0.035] + [0.3 * 0.046] + [0.25 * 0.07])
= 0.01575 + 0.0138 + 0.0175
= .04705, or 4.7%

How do I calculate how long it takes an investment to double (AKA 'The Rule of 72') ...
Find out more about the rule of 72, what the rule of 72 measures and how to calculate the rule of 72 for investments using ... Read Answer >> 
What is the formula for calculating return on equity (ROE) in Excel?
Find out more about return on equity, the formula to calculate it and how to calculate return on equity in Microsoft Excel. Read Answer >> 
What is the difference between Macaulay duration and modified duration?
Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies ... Read Answer >> 
How can I calculate the Macaulay duration of a zerocoupon bond?
Find out more about a real estate investment trust's funds from operations and how to calculate the funds from operations ... Read Answer >> 
How do I calculate a price to sales ratio using Excel?
Learn what the price to sales ratio is, how to calculate the ratio using a formula, and how to calculate the price to sales ... Read Answer >> 
What is the formula for calculating working capital in Excel?
Find out more about working capital, what working capital measures and how to calculate a company's working capital using ... Read Answer >>

Insights
Cell Phone Evolution
Follow the evolution of cell phones from 20 pound bricks to the sleek smart phones of today. 
Personal Finance
6 Tips For Getting A Good Cell Phone Plan
Avoid overspending on cell service with this expert advice. 
Personal Finance
Schedule Loan Repayments with Excel Formulas
Calculate all the particulars of a loan using Excel, and set up a schedule of repayment for a mortgage or any other loan. 
Investing
Cellular Biomedicine and GE Healthcare Ink Pact
Cellular Biomedicine announced a research pact with GE Healthcare China. 
Investing
Rebalance Your Portfolio to Stay on Track
Like a tuneup for a car, this realignment should minimize trouble down the road. 
Personal Finance
How to Save Money on Your Cell Phone Plan
With hundreds of cell phone plans from dozens of carriers, consumers have more options than ever to save money and get a great value. 
Investing
Global Blood Sickle Cell Trial Moves Forward (GBT)
Global Blood Therapeutics secured FDA approval to proceed with a Phase 3 trial for its GBT440 drug to treat sickle cell disease. 
Financial Advisor
Measure Your Portfolio's Performance
Measure the success of your investment solely on the portfolio return may leave you blindsided to the risk you are taking. Learn three ratios that will help you evaluate your investment return. ...

Financial Modeling
The process by which a firm constructs a financial representation ... 
Protected Cell Company (PCC)
A Protected Cell Company (PCC) is a corporate structure, a single ... 
Annualized Total Return
Annualized total return gives the yearly return of a fund calculated ... 
Annual Return
Annual return is the compound average rate of return for a stock, ... 
Work Cell
The logical and strategic arrangement of resources in a business ... 
Formula Investing
Formula investing is a method of investing that rigidly follows ...