i have included necessary attachments to complete this project on Kellogg. Competencies In this project, you will demonstrate your mastery of the following competencies: Analyze financial and investment decisions  that add value to the organization Analyze financing options to maximize investor value Scenario You are a financial analyst for the chosen business that you selected  during your Module Two Journal assignment. Your supervisor has  discovered last minute that your business’s board of directors is  looking for updates on the business’s financial health. Your supervisor  has asked you to write a report regarding the business’s current  financial health and the available financial options for improving the  business. You’ve also been asked to make recommendations as to which  options the business should choose to best support its financial health.  Your supervisor will then use your report to present to the business’s  board of directors, whose members all have varying levels of knowledge  in terms of finance. Directions Using the business you chose from the Project Two Business Options  List, create a report for your supervisor to share with the board of  directors during their presentation. Keep in mind that your report needs  to be easy for someone unfamiliar with finance to understand, as not  all of the board members for your business fully understand finance. Using Mergent Online, locate the most recent quarterly financial  statements for your chosen company, and use these statements to support  your analysis throughout the project. Refer to the Project Two Financial  Assumptions document located in the Supporting Materials section for  the assumptions you need in order to analyze the three available  financial options outlined in the Financial Analysis section of the  project directions. You are encouraged to use the Project Two Financial Analyst Report  template located in the What to Submit section to help complete this  project. Specifically, you must address the following: Financial Analysis: In this section of the report,  you will use the most recent quarterly financial statements for your  chosen business and the Project Two Financial Formulas spreadsheet  (located in the What to Submit section) to calculate appropriate  financial formulas for assessing the business’s financial health. You  will also analyze all three available financial options for improving  the business based on your calculations and the provided Project Two  Financial Assumptions document. Financial Calculations: Calculate accurate  financial formulas to assess the business’s current financial health.  Specifically, you must calculate the following:  Working capital Current ratio Debt ratio Earnings per share Price/earnings ratio Total asset turnover ratio Financial leverage Net profit margin Return on assets Return on equity Working Capital Management: Explain the impact of working capital management on the business’s operations. Provide examples to support your claims. Bond Investment: Analyze the risks and benefits of  the business choosing to invest in a corporate bond, including the  necessary ethical considerations, appropriate calculations, and examples  to support your analysis. Capital Equipment: Analyze the risks and benefits  of the business choosing to invest in capital equipment, including the  necessary ethical considerations, appropriate calculations, and examples  to support your analysis. Capital Lease: Analyze the risks and benefits of  the business choosing to purchase a capital lease, including the  necessary ethical considerations, appropriate calculations, and examples  to support your analysis. Financial Evaluation: In this section of the  report, you will evaluate the three available financial options for the  business and recommend which option(s) are the best for the business to  choose. Financing: Explain how a business finances its operations and expansion. Bond Investment: Assess the appropriateness of a  bond investment as a financing option for the business’s financial  health, using your financial analysis and other financial information to  your support claims. Capital Equipment: Assess the appropriateness of a  capital equipment investment as a financing option for the business’s  financial health, using your financial analysis and other financial  information to support your claims. Capital Lease: Assess the appropriateness of a  capital lease purchase as a financing option for the business’s  financial health, using your financial analysis and other financial  information to support your claims. Short-Term Financing: Explain how potential  short-term financing sources could help the business raise needed funds  for improving its financial health. Base your response on the business’s  current financial information. Future Financial Considerations: Describe the  business’s likely future financial performance based on its current  financial well-being and risk levels. Use financial information to  support your claims. Financial Recommendations: In this section of the  report, you will recommend which financing option(s) are the best for  the business to choose depending on its financial health. Financial Recommendation(s): Recommend the most  appropriate financing option(s) based on the business’s financial  health, including a rationale for why the option(s) are best

Prepare a financial plan for the company you select for your business plan using either Microsoft PowerPoint or Word. This financial plan will be included in your final business plan in your capstone course. Describe the business, including the type of business. Create the business case. Determine why funding is needed for the company. Determine the sources of funding. Considerself-funding, borrowing, equity, venture capital, etc. Evaluate the requirements of each funding source you determined appropriate. Analyze the associated risks of each funding source. Decide which sources are the best fit for your company based on the requirements of each. Justify your decision. Estimate the cost of capital for both short-term and long-term funding sources. Research current estimated APRs for your selected sources of funding. Consider creating a table or chart to display this information. Create a profit-and-loss statement for a 3-year period. Project revenue, stating realistic assumptions, such as growth per year, in your projections. Estimate direct costs, including capital, marketing, labor, and supply costs using Microsoft Excel.    

III. Justification: C. Financial impact. This section should discuss the project’s most likely financial implications and the consolidated financial projection with and without the project. Be sure to: 1. Project the incremental, annual, and cumulative cash benefits and outflows associated with the proposed expansion for the next seven to 10 years, using a spreadsheet or other relevant presentation vehicle to support your narrative. Be sure to justify your assumptions and methodology based on sound microeconomic and financial principles. For example, what assumptions have you made about demand, price, volume, capital purchase costs, incremental hiring, and so on? 2. Develop a consolidated financial projection of revenue, pretax income, and cash flow for the overall business, over that same number of years, both with and without the proposed investment. Use a spreadsheet or other relevant presentation vehicle to support your narrative, being sure to describe any relevant assumptions. V. Financing: In this section, compare the proposed loan to alternative financing methods. Specifically: A. Weigh the pros and cons of raising money using internal financing mechanisms versus seeking funding through global capital markets via loans, commercial paper, bonds, or equity financing. Which might be viable alternatives should the loan not be approved? Support your answer with appropriate research and evidence. B. Assess the viability of a business combination as a mechanism for expanding into the new market. Is this a reasonable option for the company? Why or why not? Support your answer with appropriate research and evidence. VI. Track Record: Use this section to persuade the lender that you are credit-worthy. You must: A. Convincingly argue that your organization is on solid financial footing, and thus at a low risk for default, supporting your argument with appropriate financial statements, ratios, and other indicators of financial performance and health. B. Convincingly argue for your organization’s trustworthiness, providing credible evidence of legal and ethical financial behavior. For example, this might include recent audit results; credit history; absence of significant lawsuits, recalls, or regulatory judgments; or other evidence designed to show that the company holds itself to the highest legal and ethical standards.