I've had 3 tutors fail this assignment on course hero. I appealed the school for a final try. Please don't accept this assignment unless you are confident in your academic abilities. Attached are the formulas and number values. Thank you in advance for your help and I wish blessings on you and your family.

---------------------------------------------------------------------------------------------------------------------------

Sparkit Technologies Corporation is a diversified advanced technology company with headquarters in Houston, Texas, and offices and manufacturing plants throughout the world. Sparkit designs, manufactures, and markets advanced electronics, robotics, subassemblies, engines, and other types of systems for automotive, medical, aerospace, manufacturing, defense, governmental, and other applications.

At the end of the year, Sparkit had 45,000 total employees, an annual revenue of about $60 billion, an annual net income of about $3.8 billion, and an annual information technology budget of about $2.4 million. Sparkit is organized in a traditional hierarchical management structure with divisions structured according to function. The information technology department is responsible for all information technology functions within the firm.

REQUIREMENTS

Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.

You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.

Tasks may notbe submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .xlsx, .ppt).

Note: Refer to the Introduction section for instructions on how to access and download the Excel files used in this task. In order for your submission to be evaluated, ensure you have attached both Excel files to your submission.

A. Analyze the current ratio measure of liquidity for Sparkit using the attached Figure A1.2 Excel file by doing the following:

1. Discuss why it is important for Sparkit's financial manager to understand the current ratio.

2. Discuss how the current ratio influences Sparkit's IT department's decision-making.

3. Provide the current ratio values for Fiscal Year 2 from Figure A1.2, including how you calculated your answer.

4. Provide the final value for the current ratio, including how you calculated your answer.

B. Analyze the ratio of fixed assets to long-term liabilities measure of solvency for Sparkit using the attached Figure A1.2 Excel file by doing the following:

1. Discuss why it is important for Sparkit's financial manager to understand the ratio of fixed assets to long-term liabilities.

2. Discuss how the ratio of fixed assets to long-term liabilities influences Sparkit's IT department's operational sustainability.

3. Provide the ratio of fixed assets to long-term liabilities value for Fiscal Year 2 from Figure A1.2, including how you calculated your answer.

4. Provide the final value for the ratio of fixed assets to long-term liabilities, including how you calculated your answer.

C. Analyze the asset turnover measure of profitability for Sparkit using the attached Figures A1.1 and A1.2 Excel files by doing the following:

1. Discuss why it is important for Sparkit's financial manager to understand asset turnover.

2. Discuss how asset turnover influences Sparkit's IT department's productivity.

3. Provide the asset turnover values for Fiscal Year 1 and 2 from Figures A1.1 and A1.2, including how you calculated your answer.

4. Provide the final value for asset turnover, including how you calculated your answer.

D. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.

E. Demonstrate professional communication in the content and presentation of your submission.