YOU WILL CHOOSE OPTION 1:Write a 1-2 page executive summary, along with an appendix of supporting information, in which you analyze an organization's financial performance as well as their level of risk for lending and make and present a recommendation to help leadership make a loan decision.IntroductionThis portfolio work project will help you complete a thorough review of an organization’s financial performance as well as their level of risk for lending. Your recommendation will help leadership create a loan portfolio, and your executive summary will clearly and concisely communicate your review to others in the organization.ScenarioYou work for an organization that provides loans to businesses. You are working with a client who is requesting a loan that will require a review of financial and related performance documents. You have been asked to review the documents and summarize your findings in a loan recommendation for your management team.You may apply this scenario to either Option 1 or Option 2, described in Requirements below.Your RoleYou are a loan manager for a lending organization, and your responsibilities include reviewing loan requests and providing recommendations in regard to whether the loan requests should be funded.RequirementsOption 1:Your client works for Ace Company. Assume Ace Company requested a $3 million 10-year loan to purchase production equipment and develop accompanying software. Use the Ace Company Data document for this option.Option 2:Use a firm or scenario of your choosing.Before choosing a company, read the assessment thoroughly to ensure:The company fits the assessment requirements.You have access to the financial statements and related performance documents needed to assess risk and make a loan recommendation. You will need information for this year and last year.You can distribute the financial statements and related performance documents without disclosing confidential company information.Loan RecommendationTo arrive at your recommendation, analyze the financial performance of the requesting company and present it to your organization’s upper-management team. The management team will take your recommendation into consideration as they finalize loan requests.Analyze the company's performance and performance trends. Include the following in your analysis:Analyze the trend for accounts receivable collections. Identify the trend.Explain the relevance of the trend.Determine if the trend is improving or getting worse.Compare the company's average inventory turnover to the industry average inventory turnover rate. Note that the average industry turnover rate for Ace Company is 10 times per year. Consider whether the company’s average inventory turnover is higher or lower than the industry average.Explain whether a higher or lower average is better.Determine whether the trend is improving or getting worse.Evaluate the company's short-term and long-term credit worthiness based on financial performance and trend (comparing this year to last year). Include in your evaluation: Information about performance and trends.Information about other relevant financial information you consider important to the decision.Your recommendation regarding whether the bank should grant the loan based on the financial data.Deliverable FormatThe management team of your organization requests this information in the form of a 1–2 page executive summary along with a title page, references page, and appendix of supporting information. The executive summary must highlight the key findings from your review and will provide your recommendation and rationale. The appendix must include data used in your analysis for others to review. Assume that this document is the only communication in regard to your analysis and recommendation and that you will not be with the team to explain anything as it deliberates. In other words, the documentation you provide must be well organized and include information for the management team to clearly see your recommendation and rationale.Related company report standards:The executive summary is a professional document and should therefore follow the corresponding MBA Academic and Professional Document Guidelines, including single-spaced paragraphs.In addition to the executive summary, include: A title page.A references page.Appendix with supporting materials. If you are using a firm or scenario of your choosing, ensure faculty has sufficient information to understand how you reached your recommendation.At least two APA-formatted references.

Before starting this class, many of you probably thought that Excel was simply a spreadsheet program used by accountants. In reality, Excel has functions that we can use in our daily lives. For this assignment, draft a two-page essay in which you describe how Excel can be used in each of the following areas of daily life: home (e.g., saving money, budgeting, tracking expenses, keeping up with maintenance or projects); work (e.g., creating graphs or charts for presentations); and school (e.g., tracking classes, time management). While the examples given may be used in your description, be specific about how you personally can benefit from using Excel in these areas. Also, you are encouraged to think about and describe other ways that Excel can be used in these areas. Since this essay is reflective in nature, outside sources are not required. Use 12-point Times New Roman font, double spacing, and paragraph format for your essay.