Use your understanding of human resource management and its four functional areas to create a complete and persuasive rationale for selecting one human resource professionals below for the opening described. Make a clear argument for the applicant having the appropriate skills, education, and experience for the role.In Microsoft Word, create a report that identifies the most appropriate applicant for the human resource role in the ad below. The rationale should be 1-2 pages and include the following:An assertive and persuasive statement naming the chosen candidate in a complete sentence or two so that the reader is prepared for the focus of the remainder of the report. Avoid phrases such as “I feel” or “In my opinion” as this choice is based on your analysis of the candidates and the open position.A description of the relevant skills demonstrated by the applicant that clearly connects the applicant to the functional area and position.A summary of the chosen applicant’s relevant experience/past roles showing upward mobility through the human resource hierarchy.A list of human resource goals accomplished (e.g., decreased turnover, increased transfer of knowledge, provide specific data as applicable)An explanation of why the candidate’s education/degrees are appropriate for the position.A final assessment of any additional qualifications, awards, or certifications that qualify the applicant for the role.Note: Be sure the document is free of grammar, mechanical, and syntax errors. Please use the following resources to assist you in your writing.

http://video.pbs.org/video/1174144492/1. What did the mural in Detroit illustrate? Why was the mural created?2. What was Fannie Mae? How were home loans related to segregation?3. How did the encouragement to buy homes affect the economy in the 1980s?4. What occurred when countries did not pay off their debts? What criticism was leveled against this?5. What factors contributed to the economic issues in Argentina?6. Has owning property changed the lives of people in Argentina?7. What is micro-finance?8. What are “black swans”? What is the relationship of “black swans” to the global economy?

Liam Richardson is the business manager for the Smith & Lyngate Insurance agencies in the state of Maryland. Liam is interested in increasing the number of agents in Baltimore and plans to buy an office building for the new operation. He has asked for your help in creating a loan analysis that summarizes information about the loans to cover the cost of the building.Go to the Loan Calculator worksheet. The cells in the range B6:B8 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not be used in a formula.Update the defined names in the worksheet as follows:Delete the Loan_Calculator defined name.Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows:In cell D6, start to enter a formula using the PMT function.For the rate argument, divide the Rate (cell D4) by 12 to use the monthly interest rate.For the nper argument, use the Term_in_Months (cell D5) to specify the number of periods.For the pv argument, use the Loan_Amount (cell B8) to include the present value.Liam wants to compare monthly payments for interest rates that vary from 3.95% to 5.15% and for terms of 120, 180, and 240 months. He has already set up the structure for a data table in the range A12:D25.Create a two-variable data table as follows to provide the comparison that Liam requests:In cell A12, enter a formula without using a function that references the monthly payment amount (cell D6) because Liam wants to compare the monthly payments.b.For cell B8, edit the defined name to use Loan_Amount as the name.2.In cell B8, calculate the loan amount by entering a formula without using a function that subtracts the Down_Payment from the Price. 3.Liam also wants to use defined names in other calculations to help him interpret the formulas.In the range D4:D8, create defined names based on the values in the range C4:C8.e.Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount.5.In cell D7, enter a formula without using a function that multiples the Monthly_Payment (cell D6) by the Term_in_Months (cell D5) and then subtracts the Loan_Amount (cell B8) from the result to determine the total interest.6.In cell D8, enter a formula without using a function that adds the Price (cell B6) to the Total_Interest (cell D7) to determine the total cost.b.Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.