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.

In our text Our Iceberg Is Melting, Kotter provides a story-based scenario of a situation needing a change intervention.Review the reading from our text and state how Kotter’s last four steps (5 through 8) were applied in the story (two paragraphs), and then reflect on an organizational change effort that you are familiar with from the past (you can use the same organizational change effort you used for Module One) using Kotter’s last four steps (5 through 8) to diagnose the strengths and weaknesses of the change effort.Make sure to include what was done well, what was done poorly, and what was lacking in the change effort (two paragraphs, for a total of four paragraphs).For additional details, please refer to the Module Two Journal Guidelines and Rubric document.

This e-portfolio assessment is designed to be used as both a learning tool and as a professional portfolio that you can include in your resume or applications for jobs. You want to begin developing your portfolio ideas during Week 3, even though it is not due until Week 8. In this assignment you are asked to choose any three of the four HRMN 302 course outcomes and reflect on your learning in our class.There are two distinct parts to this assignment. The first is your reflective ideas about your learning for three of the four course goals. The second is the actual creation of the E-portfolio on the Google Site. There is a partially completed portfolio provided for you at the very end of these instructions.For directions on how to create an E-portfolio/Google Site go to url https://goo.gl/pIMkbuThe four course outcomes for HRMN 302 are:Apply appropriate communication media and methods to various situational needs in organizational settings.Apply communication theories to organizational communication challenges.Recognize and respond constructively to cultural differences in communication.Analyze and assess the communication dynamics of an organization through the completion of a communication audit.Once your portfolio site is created, follow the specific instructions below.Begin with an Introduction page, develop at least one page for each of the three outcomes you've selected. Be sure to include a Reference page at the end.You will have a minimum of 5 pages. On each outcome page:Provide the specific course outcome you've selected.Explain in your own words and 1-2 paragraphs how each outcome relates to what you have learned in class.Post one artifact for each outcome (video, paper, chart, or any type of file you wish to use) and that demonstrates your mastery of each outcome. NOTE: the artifacts do not have to be newly created. You can use work you've developed previously.Explain, in detailed sentences and approx. 2-3 paragraphs how each artifact relates to the course outcome.Here is an example of a partially completed portfolio: https://sites.google.com/site/hrmnportfolio2011/