The current financial position of your chosen company

SCENARIO You are the chief information officer (CIO) of one of the following publicly traded companies: Home Depot (ticker symbol: HD) Big 5 (ticker symbol: BGFV) Build-A-Bear (ticker symbol: BBW) You’ve been asked to propose a capital project for IT that includes a software component that will propel the company forward. As part of your responsibilities, the CEO has asked you to review the company’s financial statements and analyze the budget and cash flow for the IT department. Since the budget for Capital Expenditure projects has already been allocated, you will need to get the CEO and the board of directors to agree to spend more than they initially intended. Your project must not only be compelling but also show how the company’s 10-Q reports their profits or losses, as this may be a roadblock to moving forward. Create an IT project analysis and proposal report that will be presented to the CEO and board of directors for your chosen company by doing the following: A. Describe your idea for an IT investment project, referencing one of the strategic goals for your chosen company. The project must be focused on an operational IT solution, not a consumer product or service, and it must align with this strategic goal and include a software component or a SaaS solution. B. Download the most recent 10-Q financial statement obtained from the “SEC EDGAR Company Filings” web link for your chosen company and review the attached “Financial Formula Sheet” and the chosen company’s “Financial Fact Sheet,” and do the following: 1. Describe the current financial position of your chosen company. The descriiption must align with the company’s 10-Q financial statement and include all calculations, a justification for each of the ratios used, and the following components: • net income • retained earnings • two liquidity ratios • two solvency ratios • two profitability ratios • location of the data provided (e.g., tab, line, column) Note: Use the attached “Financial Formula Sheet” to determine which ratios to use for liquidity, solvency, and profitability. 2. Attach the company’s 10-Q financial statement obtained from the “SEC EDGAR Company Filings” web link to your submission as a spreadsheet. The 10-Q statement should be from within the last calendar year. Note: After searching for the company on the “SEC EDGAR Company Filings” web link, you can download the 10-Q statement by clicking “Interactive Data” and then “View Excel Document.” You can then save the spreadsheet to submit with your report. C. Compile the budgeted income statement using only the attached “Financial Fact Sheet” for your company. D. Describe your IT procurement plan based on your company’s “Financial Fact Sheet,” the budgeted income statement, and your IT investment project idea. Include a descriiption of the decisions you made regarding the following points: • resources (e.g., software, personnel, hardware) • leasing versus buying components Note: You may need to adjust the descriiption of your IT procurement plan after you have completed part E. 1. Justify the decisions you made regarding the resources and lease versus buy components in your IT procurement plan from part D, including the financial and technical benefits of each decision. E. Explain how your IT investment project idea will be funded based on the company’s “Financial Fact Sheet.” Include the following calculations in your explanation: • a detailed discussion of the marginal cost of capital (MCC) that supports your project proposal • weighted average cost of capital (WACC) • average rate of return (ARR) • net present value (NPV) F. Provide an executive summary of your findings and recommendations using the key points from parts A to E. G. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized. H. Demonstrate professional communication in the content and presentation of your submission.