Assignment 1 FIN 1013 Case study analysis. Read the Case below regarding ABC Company. Use the information contained in the Case to fill out the Excel Document found in Moodle (ABCCompAssignmenti.xlsx) Work in your Group to follow the steps below for Assignment 1. Steps: 1) Construct Financial Statements using Excel. Your group's Job is to fill out the values for the years 2014 (current) and the 2015 (projected) in the Statement of Income and Statement of Financial Position (fill all the green cells). If no information is given about a particular value assume it is the same as last years. Pay close attention to the potential sources of financing, adjust the Statement of Income and Statement of Financial Position accordingly in excel. When you are finished with the Excel Document save it as Group#ABCCorpA1. All Values shown in Excel are in thousands of dollars. 2) Ratio Analysis (Read the CASE and complete step 1 FIRST) Calculate and analyze the following Ratios for the years 2014 and 2015. What do you notice about the change in these Ratios? Provide a brief explanation for the reason of the change, or whether the Ratios below should be any cause for concern. Current Ratio, Return on Assets, Quick Ratio, Net Working Captial I 3) Discussion Questions (Read the CASE and complete step 1 FIRST) i) Did you decide to Rent or Buy the Warehouse? Why? (Hint: Compare the cost of financing) ii) In the Statement of Financial Position explain why there are only zero's at the bottom, what does this signify? (Located on sheet 2 Row 47 in the excel file). *** iii) Explain your team's plan to finance the purchase of the additional inventory and warehouse? What is the total cost of the expansion? What is the total cost of financing for the expansion? (Hint: The company has been preapproved for a short- term loan, as well as has access to retained earnings from the previous year Assignment 1 FIN 1013 Case study analysis. Read the Case below regarding ABC Company. Use the information contained in the Case to fill out the Excel Document found in Moodle (ABCCompAssignmenti.xlsx) Work in your Group to follow the steps below for Assignment 1. Steps: 1) Construct Financial Statements using Excel. Your group's Job is to fill out the values for the years 2014 (current) and the 2015 (projected) in the Statement of Income and Statement of Financial Position (fill all the green cells). If no information is given about a particular value assume it is the same as last years. Pay close attention to the potential sources of financing, adjust the Statement of Income and Statement of Financial Position accordingly in excel. When you are finished with the Excel Document save it as Group#ABCCorpA1. All Values shown in Excel are in thousands of dollars. 2) Ratio Analysis (Read the CASE and complete step 1 FIRST) Calculate and analyze the following Ratios for the years 2014 and 2015. What do you notice about the change in these Ratios? Provide a brief explanation for the reason of the change, or whether the Ratios below should be any cause for concern. Current Ratio, Return on Assets, Quick Ratio, Net Working Captial I 3) Discussion Questions (Read the CASE and complete step 1 FIRST) i) Did you decide to Rent or Buy the Warehouse? Why? (Hint: Compare the cost of financing) ii) In the Statement of Financial Position explain why there are only zero's at the bottom, what does this signify? (Located on sheet 2 Row 47 in the excel file). *** iii) Explain your team's plan to finance the purchase of the additional inventory and warehouse? What is the total cost of the expansion? What is the total cost of financing for the expansion? (Hint: The company has been preapproved for a short- term loan, as well as has access to retained earnings from the previous year