As an assistant vice president at a regional bank, your boss has tasked you and the other AVPs to work in a group to acquire $100 million of residential mortgages to be securitized in a pass-through MBS. There must be between 250–300 mortgages in the portfolio, none of them with a maturity below 200 months or greater than 360 months. In the interest of time, your boss suggests that the group assign group members to find (meaning create some hypothetical) a group of diverse mortgages (meaning each with a different interest rate, principal amount, and maturity) and then as a group, aggregate each member’s mortgages into a pool to calculate the portfolio WAC and WAM. Your group task is to provide your boss with a summary spreadsheet that shows the individual mortgages and the portfolio’s WAC and WAM calculations, along with a memo of at least 300 words that explains the following:The number of residential mortgages in the portfolio and the range of principal values, interest rates, and maturitiesThe residential mortgage portfolio’s WAC and WAMA discussion of the WAC of the pass-through MBS the group has created and whether it represents a coupon rate indicative of a high credit quality or a lower credit quality pool of mortgages. Include in the discussion the MBS issue’s spread over the comparable Treasury rate.Include in your analysis at least 1 outside source for the Treasury rate.

Portfolio Project #1 provides data from a hypothetical organization. The data can be found at the bottom of the page. You will create a strategic plan that aligns the human resources (HR) function with the organization’s mission, vision, and objectives. The overall scope of the Portfolio Project is to create a “Shared Services” structure for HR that will be housed at the organization’s corporate offices. Most of us are aware of the term “purpose statement” but are unsure of its real meaning within an organization. It is a statement describing the organization’s purpose, or the reason for its existence. The purpose of an organization reflects a desired position in the marketplace. It should accurately answer to the questions below. The purpose statement is the written summary of those answers. Who are we? What do we do? For whom do we do this? How do we know when we are getting it done? The purpose statement is the written summary of those answers. The most effective purpose statements are short, concise, and direct. A good purpose statement is between 2–3 sentences. Answer the four questions above and create a purpose statement for your HR department. Submit the answers to the four questions and the purpose statement to your instructor for review. Required Topics - Be sure to cover the following: Strategic Contribution, Personal Credibility, HR Delivery Metrics, Key Performance Measurements (KPM), Action Plan for each functional area, HR mission statement, HR vision statement and objectives. Your strategic plan should include: Title Page Table of Contents Executive Summary Body of your plan Conclusion Reference Page Appendix (optional) Submission requirements: Ten pages minimum (not including the title page, table of contents, reference page or appendix) will be needed to complete the project. Support your analysis and recommendations with 5 credible sources documented in accordance with the CSU-Global Guide to Writing and APA Requirements.