Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am doing an Accounting project and I have to do a table with Ratio calculations like this one attached but using numbers from a
I am doing an Accounting project and I have to do a table with Ratio calculations like this one attached but using numbers from a company called Autodesk Inc.
This is what the table should look like after all the calculations have been found for Autodesk Inc.
Numbe Equation Column Column Column telumn Columns - Column - Column11 - Column Colum: Current Assets 1 Working Capital 22,495 1 2 Current Ratio Current Arts 47 349 Quick Awets 1.908842 1 Columns Currentini 24,754 Current Liabilities 24,754 Current Liabilities 24,74 Average AR" 7.220.50 Average Daily Sales 213.334747 Current Assets Quick Ratio 1.560312 1 Ques 13.122 1 . 4 AR Turnover 10.734156 4 Average AR Inventory 8427 End of Year AR/2 7.459 365 365 2.220.50 1 Beginning of Year AR 6.72 Sales 77,867 Beginning of Year 7 5 Number of Days Sales in Receivable 33.845949 5 Average Daily Sales 213.334247 Day 1 6 3.989867 6 Average Inventory End of Year Inv/2 8.744 365 8.585.50 Sales 72.367 Average AR 7.220.50 Cost of Goods Sold 34.255 Average Inventory B.SS.SO Fixed Assets (Net 56,584 Total Liabilities 72.05) / Average Inventory 8.SAS 50 Average Dally COGS 93.849315 Long Term Liabilities Cost of Goods Sold 34,255 7 91.481754 Days Inventory Turnover Number of Days' Sales in Inventory Ratio of Fred Assets to Long Term Liabilities 7 Average Daily COGS 365 93.849315 2 # 1.609292 / Total Ratio of Liabilities to Stockholder's Equity 0.889126 . - 14.43 10 ROA 81,050 Total Average Aasets 144.807.50 Average SP 79,271 10 Net Income 20.99 Net Income 20.899 Total Average Assets 144,807.50 Beginning of Year Assets 153,091 Beginning of Years 81,038 End of Year Assets/2 136,524 End of Year SE/2 77,504 . 11 ROE 26.36% 11 Average SE 79.271 Numbe Equation Column Column Column telumn Columns - Column - Column11 - Column Colum: Current Assets 1 Working Capital 22,495 1 2 Current Ratio Current Arts 47 349 Quick Awets 1.908842 1 Columns Currentini 24,754 Current Liabilities 24,754 Current Liabilities 24,74 Average AR" 7.220.50 Average Daily Sales 213.334747 Current Assets Quick Ratio 1.560312 1 Ques 13.122 1 . 4 AR Turnover 10.734156 4 Average AR Inventory 8427 End of Year AR/2 7.459 365 365 2.220.50 1 Beginning of Year AR 6.72 Sales 77,867 Beginning of Year 7 5 Number of Days Sales in Receivable 33.845949 5 Average Daily Sales 213.334247 Day 1 6 3.989867 6 Average Inventory End of Year Inv/2 8.744 365 8.585.50 Sales 72.367 Average AR 7.220.50 Cost of Goods Sold 34.255 Average Inventory B.SS.SO Fixed Assets (Net 56,584 Total Liabilities 72.05) / Average Inventory 8.SAS 50 Average Dally COGS 93.849315 Long Term Liabilities Cost of Goods Sold 34,255 7 91.481754 Days Inventory Turnover Number of Days' Sales in Inventory Ratio of Fred Assets to Long Term Liabilities 7 Average Daily COGS 365 93.849315 2 # 1.609292 / Total Ratio of Liabilities to Stockholder's Equity 0.889126 . - 14.43 10 ROA 81,050 Total Average Aasets 144.807.50 Average SP 79,271 10 Net Income 20.99 Net Income 20.899 Total Average Assets 144,807.50 Beginning of Year Assets 153,091 Beginning of Years 81,038 End of Year Assets/2 136,524 End of Year SE/2 77,504 . 11 ROE 26.36% 11 Average SE 79.271Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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