Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Principles of Financial Management (FINN1300)Project Fall 2021-2022 Suppose you are interested in evaluating ABC company's financial performance during 2019 and 2020. Use the information provided
Principles of Financial Management (FINN1300)Project Fall 2021-2022 Suppose you are interested in evaluating ABC company's financial performance during 2019 and 2020. Use the information provided on the excel sheet to answer the following questions, 1. Prepare the company's Balance sheet and Income Statement during 2019 and 2020. (3 marks) 2. Prepare the company's cash flow statement for the year 2020. (2 marks) 3. Calculate the financial ratios for the company in 2019 and 2020. (2 marks) Note: Purchases were %70 of the cost of goods sold in both years. 2019 2020 Financial Ratios Current ratio Quick ratio Inventory turnover Average age of inventory Average collection period Average payment period Asset turnover Debt ratio Debt to equity ratio Times interest earned ratio Grass profit margin Operating profit margin Net profit margin ROA ROE 4. Analyze the company's overall financial situation from a time series viewpoint. (2 marks) 5. Compile the Proforma Income statement for the year 2020 using percent of sales method. (1 mark) 06 o A fx II B Information for the year 2019 Marketable Securities 20,000 Accounts Receivable 60,000.00 Inventory 30,000.00 Number of shares outstanding 120,000.00 Other current assets 10,000.00 Propert, Plant and equipment 400,000.00 Machinery 80,000.00 Furniture 15,000.00 Vehicles 100,000.00 Paid in capital in excess of par value 600,000.00 Par value of stock 1.00 Notes payable 30,000.00 Accounts payable 30,000.00 Long term loan 89,000.00 Short term loan 20,000.00 Dividends 18,900.00 Cash 500,000.00 Accumulated depreciation 20,000.00 Sales 700,000.00 Depreciation expense 5,000.00 Selling expense 15,000.00 Cost of goods sold 450,000.00 Research and development expense 30,000.00 General and administrative expense 20,000.00 Interest expense 16,000.00 Tax rate 35% Utilities expense 30,000.00 Beginning balance of retained earnings 237,800.00 Principles of Financial Management (FINN1300)Project Fall 2021-2022 Suppose you are interested in evaluating ABC company's financial performance during 2019 and 2020. Use the information provided on the excel sheet to answer the following questions, 1. Prepare the company's Balance sheet and Income Statement during 2019 and 2020. (3 marks) 2. Prepare the company's cash flow statement for the year 2020. (2 marks) 3. Calculate the financial ratios for the company in 2019 and 2020. (2 marks) Note: Purchases were %70 of the cost of goods sold in both years. 2019 2020 Financial Ratios Current ratio Quick ratio Inventory turnover Average age of inventory Average collection period Average payment period Asset turnover Debt ratio Debt to equity ratio Times interest earned ratio Grass profit margin Operating profit margin Net profit margin ROA ROE 4. Analyze the company's overall financial situation from a time series viewpoint. (2 marks) 5. Compile the Proforma Income statement for the year 2020 using percent of sales method. (1 mark) 06 o A fx II B Information for the year 2019 Marketable Securities 20,000 Accounts Receivable 60,000.00 Inventory 30,000.00 Number of shares outstanding 120,000.00 Other current assets 10,000.00 Propert, Plant and equipment 400,000.00 Machinery 80,000.00 Furniture 15,000.00 Vehicles 100,000.00 Paid in capital in excess of par value 600,000.00 Par value of stock 1.00 Notes payable 30,000.00 Accounts payable 30,000.00 Long term loan 89,000.00 Short term loan 20,000.00 Dividends 18,900.00 Cash 500,000.00 Accumulated depreciation 20,000.00 Sales 700,000.00 Depreciation expense 5,000.00 Selling expense 15,000.00 Cost of goods sold 450,000.00 Research and development expense 30,000.00 General and administrative expense 20,000.00 Interest expense 16,000.00 Tax rate 35% Utilities expense 30,000.00 Beginning balance of retained earnings 237,800.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started