Homework Help is Here – Start Your Trial Now!
Business
Accounting
FOR THE YEAR ENDED 31 DECEMBER FOR THE YEAR ENDED 31 DECEMBER 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 ACTIVITY RATIOS Net oredit sales Average Accoounts Receivable 103,556,074 3,658,887 126,914,911 4,401,909 146,017,343 5,384,517 27.12 91,191,108 99.883,557 104,811,637 104,771,358 103,107,206 98,811,127 97,733,407 6,478,112 15.42 4,404,739 7,289,064 14.38 6,276,075 4,977,095 20.72 4,803,411 20.57 4,683,139 ACCOUNTS RECEIVABLE TUF 20.70 28.30 28.83 16.69 20.87 365 Days 365 365 365 365 365 365 365 365 365 365 Trade Receivable Turnover 20.70 28.30 28.83 27.12 15.42 14.38 16.69 20.72 20.57 20.87 DAYS TO COLLECT 17.63 12.90 12.66 13.46 23.67 25.38 21.86 17.62 17.74 17.49 115,726,337 109,694,675 6,411,430 17.11 150,257,881 9,389,129 16.00 120,146,913 7,889,329 Cost of Goods Sold 132,420,585 7,823,844 94,617,560 116,350,606 118,752,363 113,105,302 112,535,184 Ave. Inventory Balanoe 5,732,881 9,130,956 7,734,548 7,527,148 8,029,258 14.49 7,969,449 14.90 INVENTORY TURNOVER 16.50 16.93 12.67 15.23 14.62 14.95 365 Days Inventory Turnover DAYS TO SELL 365 365 365 365 365 365 365 365 365 365 16.50 17.11 16.93 16.00 12.67 14.49 15.23 14.90 14.62 14.95 22.12 21.33 21.57 22.81 28.80 25.19 23.97 24.50 24.96 24.41 Net oredit purchases Average accounts payable 94,617,560 109,694,675 132,420,585 150,257,881 115,726,337 116,350,606 120,146,913 118,752,363 113,105,302 112,535,184 26,985,691 32,841,786 28,645,682 4.15 33,444,887 31,469,720 3.58 20,743,806 23,607,590 31.517.163 26,877,611 4.33 24,173,046 4.97 ACCOUNTS PAYABLE TURNO 4.56 4.65 4.91 4.77 3.52 3.38 Ave. Accounts Payable Cost of Goods Sold 20,743,806 23,607,590 26,985,691 31,517,163 32,841,786 26,877,611 24,173,046 28,645,682 33,444,887 31,469,720 94,617,560 109,694,675 132,420,585 150,257,881 115,726,337 116,350,606 120,146,913 118,752,363 113,105,302 112,535,184 0.22 0.22 0.20 0.21 0.28 0.23 0.20 0.24 0.30 0.28 Multiply by 365 days 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 DAYS TO PAY 80.02 78.55 74.38 76.56 103.58 84.32 73.44 88.05 107.93 102.07

FOR THE YEAR ENDED 31 DECEMBER FOR THE YEAR ENDED 31 DECEMBER 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 ACTIVITY RATIOS Net oredit sales Average Accoounts Receivable 103,556,074 3,658,887 126,914,911 4,401,909 146,017,343 5,384,517 27.12 91,191,108 99.883,557 104,811,637 104,771,358 103,107,206 98,811,127 97,733,407 6,478,112 15.42 4,404,739 7,289,064 14.38 6,276,075 4,977,095 20.72 4,803,411 20.57 4,683,139 ACCOUNTS RECEIVABLE TUF 20.70 28.30 28.83 16.69 20.87 365 Days 365 365 365 365 365 365 365 365 365 365 Trade Receivable Turnover 20.70 28.30 28.83 27.12 15.42 14.38 16.69 20.72 20.57 20.87 DAYS TO COLLECT 17.63 12.90 12.66 13.46 23.67 25.38 21.86 17.62 17.74 17.49 115,726,337 109,694,675 6,411,430 17.11 150,257,881 9,389,129 16.00 120,146,913 7,889,329 Cost of Goods Sold 132,420,585 7,823,844 94,617,560 116,350,606 118,752,363 113,105,302 112,535,184 Ave. Inventory Balanoe 5,732,881 9,130,956 7,734,548 7,527,148 8,029,258 14.49 7,969,449 14.90 INVENTORY TURNOVER 16.50 16.93 12.67 15.23 14.62 14.95 365 Days Inventory Turnover DAYS TO SELL 365 365 365 365 365 365 365 365 365 365 16.50 17.11 16.93 16.00 12.67 14.49 15.23 14.90 14.62 14.95 22.12 21.33 21.57 22.81 28.80 25.19 23.97 24.50 24.96 24.41 Net oredit purchases Average accounts payable 94,617,560 109,694,675 132,420,585 150,257,881 115,726,337 116,350,606 120,146,913 118,752,363 113,105,302 112,535,184 26,985,691 32,841,786 28,645,682 4.15 33,444,887 31,469,720 3.58 20,743,806 23,607,590 31.517.163 26,877,611 4.33 24,173,046 4.97 ACCOUNTS PAYABLE TURNO 4.56 4.65 4.91 4.77 3.52 3.38 Ave. Accounts Payable Cost of Goods Sold 20,743,806 23,607,590 26,985,691 31,517,163 32,841,786 26,877,611 24,173,046 28,645,682 33,444,887 31,469,720 94,617,560 109,694,675 132,420,585 150,257,881 115,726,337 116,350,606 120,146,913 118,752,363 113,105,302 112,535,184 0.22 0.22 0.20 0.21 0.28 0.23 0.20 0.24 0.30 0.28 Multiply by 365 days 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 DAYS TO PAY 80.02 78.55 74.38 76.56 103.58 84.32 73.44 88.05 107.93 102.07

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

explain the image provided the Accounts receivable turn over, days to collect, Inventory turnover,Days to sell, accounts payable turnover,days to pay and give recommendation

АCTUAL PROJECTED FOR THE YEAR ENDED 31 DECEMBER FOR THE YEAR ENDED 31 DECEMBER 2022 2016 2017 2018 2019 2020 2021 2023 2024 2025 ACTIVITY BATIOS Net credit sales 103,556,074 3,658,887 146,017,343 5,384,517 99,883,557 6,478,112 91,191,108 126,914,911 104,811,637 104,771,358 103,107,206 98,811,127 97,733,407 Average Accounts Receivable 4,404,739 4,401,909 7,289,064 6,276,075 4,977,095 4,803,411 4,683,139 ACCOUNTS RECEIVABLE TUF 20.70 28.30 28.83 27.12 15.42 14.38 16.69 20.72 20.57 20.87 365 Days 365 365 365 365 365 365 365 365 365 365 Trade Receivable Turnover 20.70 28.30 28.83 27.12 15.42 14.38 16.69 20.72 20.57 20.87 DAYS TO COLLECT 17.63 12.90 12.66 13.46 23.67 25.38 21.86 17.62 17.74 17.49 94,617,560 5,732,881 150,257,881 9,389,129 Cost of Goods Sold 109,694,675 132,420,585 115,726,337 116.350,606 120.146.913 118,752,363 113,105,302 112,535,184 Ave. Inventory Balance 6,411,430 7,823,844 9,130,956 8,029,258 7,889,329 7,969,449 7,734,548 7,527,148 INVENTORY TURNOVER 16.50 17.11 16.93 16.00 12.67 14.49 15.23 14.90 14.62 14.95 365 Days Inventory Turnover 365 365 365 365 365 365 365 365 365 365 16.50 17.11 16.93 16.00 12.67 14.49 15.23 14.90 14.62 14.95 DAYS TO SELL 22.12 21.33 21.57 22.81 28.80 25.19 23.97 24.50 24.96 24.41 Net oredit purchases Average accounts payable ACCOUNTS PAYABLE TURNO 109,694,675 23,607,590 132,420,585 26,985,691" 150,257,881 31,517,163 120,146,913 24,173,046 118,752,363 28,645,682 113,105,302 33,444,887 94,617,560 115,726,337 116,350,606 112,535,184 20,743,806 32,841,786 26,877,611 31,469,720 4.56 4.65 4.91 4.77 3.52 4.33 4.97 4.15 3.38 3.58 Ave. Accounts Payable Cost of Goods Sold 20,743,806 23,607,590 26,985,691 31,517,163 32,841,786 26,877,611 24,173,046 28,645,682 33,444,887 31,469,720 150,257,881 115,726,337 0.28 116,350,606 0.23 94,617,560 109,694,675 132,420,585 120,146,913 118.752,363 113,105,302 112,535,184 0.22 0.22 0.20 0.21 0.20 0.24 0.30 0.28 Multiply by 365 days 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 DAYS TO PAY 80.02 78.55 74.38 76.56 103.58 84.32 73.44 88.05 107.93 102.07
Transcribed Image Text:АCTUAL PROJECTED FOR THE YEAR ENDED 31 DECEMBER FOR THE YEAR ENDED 31 DECEMBER 2022 2016 2017 2018 2019 2020 2021 2023 2024 2025 ACTIVITY BATIOS Net credit sales 103,556,074 3,658,887 146,017,343 5,384,517 99,883,557 6,478,112 91,191,108 126,914,911 104,811,637 104,771,358 103,107,206 98,811,127 97,733,407 Average Accounts Receivable 4,404,739 4,401,909 7,289,064 6,276,075 4,977,095 4,803,411 4,683,139 ACCOUNTS RECEIVABLE TUF 20.70 28.30 28.83 27.12 15.42 14.38 16.69 20.72 20.57 20.87 365 Days 365 365 365 365 365 365 365 365 365 365 Trade Receivable Turnover 20.70 28.30 28.83 27.12 15.42 14.38 16.69 20.72 20.57 20.87 DAYS TO COLLECT 17.63 12.90 12.66 13.46 23.67 25.38 21.86 17.62 17.74 17.49 94,617,560 5,732,881 150,257,881 9,389,129 Cost of Goods Sold 109,694,675 132,420,585 115,726,337 116.350,606 120.146.913 118,752,363 113,105,302 112,535,184 Ave. Inventory Balance 6,411,430 7,823,844 9,130,956 8,029,258 7,889,329 7,969,449 7,734,548 7,527,148 INVENTORY TURNOVER 16.50 17.11 16.93 16.00 12.67 14.49 15.23 14.90 14.62 14.95 365 Days Inventory Turnover 365 365 365 365 365 365 365 365 365 365 16.50 17.11 16.93 16.00 12.67 14.49 15.23 14.90 14.62 14.95 DAYS TO SELL 22.12 21.33 21.57 22.81 28.80 25.19 23.97 24.50 24.96 24.41 Net oredit purchases Average accounts payable ACCOUNTS PAYABLE TURNO 109,694,675 23,607,590 132,420,585 26,985,691" 150,257,881 31,517,163 120,146,913 24,173,046 118,752,363 28,645,682 113,105,302 33,444,887 94,617,560 115,726,337 116,350,606 112,535,184 20,743,806 32,841,786 26,877,611 31,469,720 4.56 4.65 4.91 4.77 3.52 4.33 4.97 4.15 3.38 3.58 Ave. Accounts Payable Cost of Goods Sold 20,743,806 23,607,590 26,985,691 31,517,163 32,841,786 26,877,611 24,173,046 28,645,682 33,444,887 31,469,720 150,257,881 115,726,337 0.28 116,350,606 0.23 94,617,560 109,694,675 132,420,585 120,146,913 118.752,363 113,105,302 112,535,184 0.22 0.22 0.20 0.21 0.20 0.24 0.30 0.28 Multiply by 365 days 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 DAYS TO PAY 80.02 78.55 74.38 76.56 103.58 84.32 73.44 88.05 107.93 102.07
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Personal Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS