Economics Homework Help

PLEASE REVIEW ALL REQUIREMENTS AND DELIVERABLES. PLEASE ONLY ACCEPT BID IF YOU ARE CONFIDENT IN YOUR ABILITY TO COMPLETE THE QUESTION IN FULL. EXCEL ANALYSIS WITH SUPPLEMENTAL WORD EXPLAINATION.

Overview

The final project for this course is the creation of a portfolio. You are to solve all problems using the Excel spreadsheet. You will select two stocks, two bonds, an equity index (S & P 500, Russell 1000, Wilshire 5000, etc.) and a risk-free asset (Treasury bill, note, or bond) of your choice. The securities should be those of well known companies with investment grade bonds and high-quality, blue chip stocks. As you know, the risk-free asset is a Treasury security. The quality of the companies would make it easier for you to find the financial data/information. You will solve all the problems outlined in the Main Elements section using an Excel spreadsheet

Prompt will not copy/paste properly. Please refer to the attached Prompt.docx

Main Elements

Create a portfolio for two stocks, two bonds, an equity index (S & P 500, Russell 1000, Wilshire 5000, etc.) and a risk-free asset (Treasury bill, note, or bond) of your choice. Complete the following sections in the portfolio:

10 Main Elements; some with supporting written components

|

Find Attached

Prompt

Rubric. Please Review.

4 Excel Workbooks. Useful templates. You won’t need all of them, but quite a few will be of use.

Deliverables:

Excel Workbook. Please complete all work in Microsoft Excel; Preferably all in one Workbook with several Sheets.

Word document for supporting written components [requirements in bold]

In 7 days please provide (Word .docx)

Or as soon as you have it done.

Please choose securities from the US Market. [NASDQ, S&P500, US Bond, ect]

Topic

• Stocks
  • .
  • .
• Bonds
  • .
  • .
• Index Company
  • .
• Risk Free Asset
  • .
  • .