**Complete below problems in an Excel spreadsheet. Be sure to show the work** (you will find problems attached):

**Complete below problems in an Excel spreadsheet. Be sure to show the work** (you will find problems attached):

- Problem 6-1: Portfolio beta
- Problem 6-2: Rate of return
- Problem 6-3: Capital Asset Pricing Model (CAPM)
- Problem 6-4: Calculating beta
- Problem 6-5: Portfolio rate of return
- Problem 6-6: Standard deviation
- Problem 6-7: Holding period gain and return

- Problem 6-1: Portfolio beta
- Problem 6-2: Rate of return
- Problem 6-3: Capital Asset Pricing Model (CAPM)
- Problem 6-4: Calculating beta
- Problem 6-5: Portfolio rate of return
- Problem 6-6: Standard deviation
- Problem 6-7: Holding period gain and return