Finance Lab Two Homework

FN2640: Week 2 Banking and Finance

Lab 2.2/Bonds and Return

1

Estimate the weights (wi) for assets in the following portfolios given the following information about

the portfolio holdings:

Portfolio Price

Number of

Securities

A Stock A $25 200

Stock B $53 100

Stock C $119 100

B Bond A $975 10

Bond B $1,020 20

Bond C $888 10

Bond D $1,150 10

C Stock A $25 1,000

Stock C $119 500

Bond D $1,150 20

D Stock B $53 1,000

Stock C $119 100

Bond A $975 20

Bond B $1,020 10

Click here to access the worksheet for this assessment.

Source textbook: Melicher, R. W., & Norton, E. A. (2011). Introduction to finance: Markets,

investments, and financial management (14th ed.). Hoboken, NJ: John Wiley.

Submission Requirements:

Answer each problem in detail with a conclusion and results.

Submit your answer in a Microsoft Excel file, showing step-by-step solutions to all calculations.

Evaluation Criteria:

Click here to download the rubric that will be used to evaluate this lab.