Balance Sheet Income Statement Ashmont Cycles Balance Sheet As of December 31, 2019 and 2020 2019 2020 8,000 2,500 67,000 1,500 500 79,500 29,000 (2.400 26,600 106,100 9,000 7.000 70,000 4,100 700 90,800 49,000 14.800) 44.209 135,000 Assets Cash Accounts receivable Inventory Prepaid expenses Other current assets Total current assets Property, plant, and equipment Accumulated depreciation Net property, plant, and equipment Total Assets Liabilities Accounts payable Line of credit Current portion of long-term debt Accrued expenses Total Current Liabilities Long-term debt Total Liabilities Owner's Equity Contributed capital Retained earnings Total Owner's Equity 3,000 10,000 6,000 1.100 20,100 16,000 36,100 4.000 10.000 5.000 2.000 21,000 14.000 35,000 50,000 20.000 70,000 60,000 40.000 100,000 Ashmont Cycles Income Statement For the year ended December 31, 2019 and 2020 2019 2020 $177,000 190.000) 87.000 $300,000 (100,000 200.000 Sales Cost of goods sold Gross Profit Operating Expense: Selling, general and administrative expenses Utilities expense Rent expense Depreciation and amortization Total operating expenses Operating Income Interest expense Income before Income Taxes Income taxes (35%) Net Income (20,000) (4.000) (10,000) 12400 (36,400) 50,600 (1.2001 49,400 (17.290) $32, 110 (50,000) (3,500) (14,000) 2.400) 169.900) 130,100 1.200 128.900 (45,115) $83,785 Suppose you are interested in evaluating Ashmont Cycles Corporation. Given the corporation's income statement and balance sheet, answer the following questions: 1. Calculate the Ashmont Cycles Corporation financial ratios for the years 2019 and 2020. (3 marks) Financial ratio 2019 2020 Current ratio Inventory turnover Average collection period Total asset turnover Debt ratio Debt to equity ratio Times interest earned ratio Gross profit margin Operating profit margin Net profit margin Return on Assets(ROA) Return on equity (ROE) 2. Analyze the overall financial situation from a time-series viewpoint. Break your analysis into an evaluation of the firm's liquidity, activity, debt, and profitability. (2 marks) 3. Prepare the cash flow statement for Ashmont Cycles Corporation for the year ended December 319 2020 using the indirect method. (3 marks) 4. Ashmont Cycles Corporation estimates its sales for the 2021 financial year will be $500,000. No new borrowing was obtained and therefore, the interest expense will remain unchanged $1,200 during 2021. Compile the Pro forma Income statement for Ashmont Cycles Corporation for the year 2021 using percent of sales method. (2 marks) Balance Sheet Income Statement Ashmont Cycles Balance Sheet As of December 31, 2019 and 2020 2019 2020 8,000 2,500 67,000 1,500 500 79,500 29,000 (2.400 26,600 106,100 9,000 7.000 70,000 4,100 700 90,800 49,000 14.800) 44.209 135,000 Assets Cash Accounts receivable Inventory Prepaid expenses Other current assets Total current assets Property, plant, and equipment Accumulated depreciation Net property, plant, and equipment Total Assets Liabilities Accounts payable Line of credit Current portion of long-term debt Accrued expenses Total Current Liabilities Long-term debt Total Liabilities Owner's Equity Contributed capital Retained earnings Total Owner's Equity 3,000 10,000 6,000 1.100 20,100 16,000 36,100 4.000 10.000 5.000 2.000 21,000 14.000 35,000 50,000 20.000 70,000 60,000 40.000 100,000 Ashmont Cycles Income Statement For the year ended December 31, 2019 and 2020 2019 2020 $177,000 190.000) 87.000 $300,000 (100,000 200.000 Sales Cost of goods sold Gross Profit Operating Expense: Selling, general and administrative expenses Utilities expense Rent expense Depreciation and amortization Total operating expenses Operating Income Interest expense Income before Income Taxes Income taxes (35%) Net Income (20,000) (4.000) (10,000) 12400 (36,400) 50,600 (1.2001 49,400 (17.290) $32, 110 (50,000) (3,500) (14,000) 2.400) 169.900) 130,100 1.200 128.900 (45,115) $83,785 Suppose you are interested in evaluating Ashmont Cycles Corporation. Given the corporation's income statement and balance sheet, answer the following questions: 1. Calculate the Ashmont Cycles Corporation financial ratios for the years 2019 and 2020. (3 marks) Financial ratio 2019 2020 Current ratio Inventory turnover Average collection period Total asset turnover Debt ratio Debt to equity ratio Times interest earned ratio Gross profit margin Operating profit margin Net profit margin Return on Assets(ROA) Return on equity (ROE) 2. Analyze the overall financial situation from a time-series viewpoint. Break your analysis into an evaluation of the firm's liquidity, activity, debt, and profitability. (2 marks) 3. Prepare the cash flow statement for Ashmont Cycles Corporation for the year ended December 319 2020 using the indirect method. (3 marks) 4. Ashmont Cycles Corporation estimates its sales for the 2021 financial year will be $500,000. No new borrowing was obtained and therefore, the interest expense will remain unchanged $1,200 during 2021. Compile the Pro forma Income statement for Ashmont Cycles Corporation for the year 2021 using percent of sales method. (2 marks)