Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. 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.

Financial Ratios

2019

2020

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

Gross profit margin

Operating profit margin

Net profit margin

ROA

ROE

image text in transcribed
image text in transcribed

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. 1. Prepare the companys Balance sheet and Income Statement during 2019 and 2020. (3 marks)

  1. 2. Prepare the companys cash flow statement for the year 2020. (2 marks)

  1. 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.

Financial Ratios

2019

2020

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

Gross profit margin

Operating profit margin

Net profit margin

ROA

ROE

  1. 4. Analyze the companys overall financial situation from a time series viewpoint. (2 marks)

  1. 5. Compile the Pro forma Income statement for the year 2020 using percent of sales method. (1 mark)

image text in transcribed
Information for the year 2019 Marketable Securities 20,000.00 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% 30,000.00 Beginning balance of retained earnings 237,800.00 Information for the year 2020 Marketable Securities 10,000.0 Accounts Receivable 50,000.00 Inventory 10,000.00 Number of shares outstanding 100,000.00 Other current assets 40,000.00 Propert, Plant and equipment 381,000.00 Machinery 60,000.00 Furniture 70,000.00 Vehicles 120,000.0L Paid in capital in excess of par value 420,000.00 Par value of stock 1.00 Notes payable 30,000.00 Accounts payable 5,000.00 Long term loan 60,000.00 Short term loan 13,500.00 Dividends 16,000.00 Cash 300,000.00 Accumulated depreciation 25,000.00 Sales 900,000.00 Depreciation expense 5,000.00 Selling expense 20,000.00 Cost of goods sold 600,000.00 Research and development expense 30,000.00 General and administrative expense 40,000.00 Interest expense 10,000.00 Tax rate 35% Utilities expense 45,000.00 Beginning balance of retained earnings Utilities expense Information for the year 2019 Marketable Securities 20,000.00 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% 30,000.00 Beginning balance of retained earnings 237,800.00 Information for the year 2020 Marketable Securities 10,000.0 Accounts Receivable 50,000.00 Inventory 10,000.00 Number of shares outstanding 100,000.00 Other current assets 40,000.00 Propert, Plant and equipment 381,000.00 Machinery 60,000.00 Furniture 70,000.00 Vehicles 120,000.0L Paid in capital in excess of par value 420,000.00 Par value of stock 1.00 Notes payable 30,000.00 Accounts payable 5,000.00 Long term loan 60,000.00 Short term loan 13,500.00 Dividends 16,000.00 Cash 300,000.00 Accumulated depreciation 25,000.00 Sales 900,000.00 Depreciation expense 5,000.00 Selling expense 20,000.00 Cost of goods sold 600,000.00 Research and development expense 30,000.00 General and administrative expense 40,000.00 Interest expense 10,000.00 Tax rate 35% Utilities expense 45,000.00 Beginning balance of retained earnings Utilities expense Information for the year 2019 Marketable Securities 20,000.00 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% 30,000.00 Beginning balance of retained earnings 237,800.00 Information for the year 2020 Marketable Securities 10,000.0 Accounts Receivable 50,000.00 Inventory 10,000.00 Number of shares outstanding 100,000.00 Other current assets 40,000.00 Propert, Plant and equipment 381,000.00 Machinery 60,000.00 Furniture 70,000.00 Vehicles 120,000.0L Paid in capital in excess of par value 420,000.00 Par value of stock 1.00 Notes payable 30,000.00 Accounts payable 5,000.00 Long term loan 60,000.00 Short term loan 13,500.00 Dividends 16,000.00 Cash 300,000.00 Accumulated depreciation 25,000.00 Sales 900,000.00 Depreciation expense 5,000.00 Selling expense 20,000.00 Cost of goods sold 600,000.00 Research and development expense 30,000.00 General and administrative expense 40,000.00 Interest expense 10,000.00 Tax rate 35% Utilities expense 45,000.00 Beginning balance of retained earnings Utilities expense

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Research On Professional Responsibility And Ethics In Accounting Volume 21

Authors: Cynthia Jeffrey

1st Edition

1787549739, 9781787549739

More Books

Students also viewed these Accounting questions