60.1K

Verified Solution

Link Copied!

tudions: Following the requirements below, please complete a report showing your findings. The sport must be completed in Word or Excel. Handwritten copies will not be accepted! equirements: 1. for Company P and Company K please complete the following a. Perform Horizontal Analysis for each line Item on Company P and Company Income Statement 30 points d. Perform Vertical Analysis for 2020 Income Statement for Company P and Company K. It is not necessary to complete Vertical Analysis for 2019. 20 points e After completing requirements (a) and (b) please answer the following questions. 15 points 1. Which company had the higher increase in total revenue from 2019 to 2020? IL Which company had the higher increase in net income from 2019 to 2020? points. 1. Cost of Revenue (CDGS) is what percentage of total revenue for Company K? iv. Cost of Revenue (CDGS) is what percentage of total revenue for Company P? 2. Ratios. The following Ratios MUST BE CALCULATED for Company P and Company K for the year 2020. Please show the formula a. Current Ratio 10 points b. Inventory Turn-over. 10 points Gross Profit Percentare. 10 points d. After completing requirement a, b and c (above) please answer the following questions Based on the Ratios for each company 1. Which company had the higher Gross Profit Percentage? 5 points 2. How many days does Company Psell through their inventory? 5 points. 3. How many days does Company K sell through their inventory? 5 points. 4. Based on the answers in questions 2 and 3, which company is selling through their inventory quicker? 5 points IL Which company has the best current ratio? (Please refer to your notes) 5 points. -- - E15 A---East ABOA Company 2020 and 2015 Financial Statements Income Statement 12/31/2020 12/31/2019 33,014,000 37,266,000 13.433.000 14,619,000 19.581.000 22,647,000 9,757.000 12 114,000 Breakdown > Total Revenue Cost of Revenue Gross Profit > Operating Expense Operating Income > Net Non Operating interest Inc > Other Income Experise Pretax income Tax Provision > Net Income Common Stockhold 9.824,000 10.533,000 -1,067,000 -383,000 992.000 636,000 9.749,000 10,786,000 1.981.000 1,801,000 7.747.000 8.920,000 IP 2 2 3 $ 4 5 6 7 H- tab w E 20 T Y - Pute Formation Clipboard Calibrio A A A A BIU XX A.2.4-2.. Pagraph Company K Balance Sheet Breakdown 12/31/2020 12/31/2019 Total Assets 87.296,000 86,381,000 Current Assets 19.240,000 20,411,000 > Cash Cash Equivalents & S 10.914,000 11.175.000 > Receivables 3.144,000 3.971.000 > Inventory 3.266.000 3.379.000 1916.000 1,886,000 Prepaid Assets > Total non-current assets 68.056,000 65,970.000 Total Liabilities Net Minority Int. 66,012.000 65,283,000 > Current Liabilities 14,601.000 26,973,000 > Total Non Current Liabilities 51.411,000 38.310,000 > Total Equity 21.284,000 21,098,000 Company P 2020 and 2019 Financial Statements Company P Income Statement Breakdown > Total Revenue Tested Type here to search A Breakdown 12/31/2020 Total Revenue 12/31/2019 67.161.000 70.372.000 Cost of Revenue 31.797.000 30.132.000 Gross Profit 38.575.000 37,029.000 28/495.000 26.738.000 10.080.000 10.291.000 > Operating Expense Operating Income > Net Non Operating interest in > Other Income Expense Pretax income 1128.000 9:35.000 117.000 44.000 9.099.000 9.312.000 Tax Provision 1994.000 1.959.000 > Net Incom 7.220.000 7314,000 DH Aasba ET Company P Balance Sheet 0 reakdown 12/31/2020 12/31/2019 Total Assets 92.918.000 78,547,000 Current Assets 23.001.000 17,645,000 > Cash, Cash Equivalents 85 9.551,000 5,738,000 > Receivables 3.404.000 7.822.000 > Inventory 4.172.000 3.338.000 Prepaid Assets 874,000 747.000 Restricted Cash > Total non-current assets 69.917.000 60.902.000 Total Liabilities 79.366.000 63.679.000 > Current Liabilities 23.372.000 20.461.000 >> Total Non Current Liabilities 55.994000 43,218,000 Total Equity 13.552.000 14.868.000 O 02- X Cai AaB --AKA EES V- LA...A. EN D Company P Balance Sheet O reakdown 12/31/2020 12/31/2019 Total Assets 92,918,000 78,547,000 Current Assets 23.001.000 17,645,000 > Cash, Cash Equivalents & S. 9,551,000 5.738,000 > Receivables 8,404 000 7,822,000 > Inventory 4.172.000 3,338,000 Prepaid Assets 374,000 747,000 Restricted Cash 0 > Total non-current assets 69.917.000 60.902.000 Total Liabilities 79,366.000 63,679,000 > Current Liabilities 23.372.000 20,461,000 > Total Non Current Liabilities -- 55.994,000 43.218.000 Total Equity 13.552.000 14,868,000 Type here to search O tudions: Following the requirements below, please complete a report showing your findings. The sport must be completed in Word or Excel. Handwritten copies will not be accepted! equirements: 1. for Company P and Company K please complete the following a. Perform Horizontal Analysis for each line Item on Company P and Company Income Statement 30 points d. Perform Vertical Analysis for 2020 Income Statement for Company P and Company K. It is not necessary to complete Vertical Analysis for 2019. 20 points e After completing requirements (a) and (b) please answer the following questions. 15 points 1. Which company had the higher increase in total revenue from 2019 to 2020? IL Which company had the higher increase in net income from 2019 to 2020? points. 1. Cost of Revenue (CDGS) is what percentage of total revenue for Company K? iv. Cost of Revenue (CDGS) is what percentage of total revenue for Company P? 2. Ratios. The following Ratios MUST BE CALCULATED for Company P and Company K for the year 2020. Please show the formula a. Current Ratio 10 points b. Inventory Turn-over. 10 points Gross Profit Percentare. 10 points d. After completing requirement a, b and c (above) please answer the following questions Based on the Ratios for each company 1. Which company had the higher Gross Profit Percentage? 5 points 2. How many days does Company Psell through their inventory? 5 points. 3. How many days does Company K sell through their inventory? 5 points. 4. Based on the answers in questions 2 and 3, which company is selling through their inventory quicker? 5 points IL Which company has the best current ratio? (Please refer to your notes) 5 points. -- - E15 A---East ABOA Company 2020 and 2015 Financial Statements Income Statement 12/31/2020 12/31/2019 33,014,000 37,266,000 13.433.000 14,619,000 19.581.000 22,647,000 9,757.000 12 114,000 Breakdown > Total Revenue Cost of Revenue Gross Profit > Operating Expense Operating Income > Net Non Operating interest Inc > Other Income Experise Pretax income Tax Provision > Net Income Common Stockhold 9.824,000 10.533,000 -1,067,000 -383,000 992.000 636,000 9.749,000 10,786,000 1.981.000 1,801,000 7.747.000 8.920,000 IP 2 2 3 $ 4 5 6 7 H- tab w E 20 T Y - Pute Formation Clipboard Calibrio A A A A BIU XX A.2.4-2.. Pagraph Company K Balance Sheet Breakdown 12/31/2020 12/31/2019 Total Assets 87.296,000 86,381,000 Current Assets 19.240,000 20,411,000 > Cash Cash Equivalents & S 10.914,000 11.175.000 > Receivables 3.144,000 3.971.000 > Inventory 3.266.000 3.379.000 1916.000 1,886,000 Prepaid Assets > Total non-current assets 68.056,000 65,970.000 Total Liabilities Net Minority Int. 66,012.000 65,283,000 > Current Liabilities 14,601.000 26,973,000 > Total Non Current Liabilities 51.411,000 38.310,000 > Total Equity 21.284,000 21,098,000 Company P 2020 and 2019 Financial Statements Company P Income Statement Breakdown > Total Revenue Tested Type here to search A Breakdown 12/31/2020 Total Revenue 12/31/2019 67.161.000 70.372.000 Cost of Revenue 31.797.000 30.132.000 Gross Profit 38.575.000 37,029.000 28/495.000 26.738.000 10.080.000 10.291.000 > Operating Expense Operating Income > Net Non Operating interest in > Other Income Expense Pretax income 1128.000 9:35.000 117.000 44.000 9.099.000 9.312.000 Tax Provision 1994.000 1.959.000 > Net Incom 7.220.000 7314,000 DH Aasba ET Company P Balance Sheet 0 reakdown 12/31/2020 12/31/2019 Total Assets 92.918.000 78,547,000 Current Assets 23.001.000 17,645,000 > Cash, Cash Equivalents 85 9.551,000 5,738,000 > Receivables 3.404.000 7.822.000 > Inventory 4.172.000 3.338.000 Prepaid Assets 874,000 747.000 Restricted Cash > Total non-current assets 69.917.000 60.902.000 Total Liabilities 79.366.000 63.679.000 > Current Liabilities 23.372.000 20.461.000 >> Total Non Current Liabilities 55.994000 43,218,000 Total Equity 13.552.000 14.868.000 O 02- X Cai AaB --AKA EES V- LA...A. EN D Company P Balance Sheet O reakdown 12/31/2020 12/31/2019 Total Assets 92,918,000 78,547,000 Current Assets 23.001.000 17,645,000 > Cash, Cash Equivalents & S. 9,551,000 5.738,000 > Receivables 8,404 000 7,822,000 > Inventory 4.172.000 3,338,000 Prepaid Assets 374,000 747,000 Restricted Cash 0 > Total non-current assets 69.917.000 60.902.000 Total Liabilities 79,366.000 63,679,000 > Current Liabilities 23.372.000 20,461,000 > Total Non Current Liabilities -- 55.994,000 43.218.000 Total Equity 13.552.000 14,868,000 Type here to search O

Answer & Explanation Solved by verified expert

See Answer