Question: 6C-4.Create a three-tab (or sheet) Excel spreadsheet from scratch, sequentially naming each tab as follows: (a) Account Balances, (b) Financial Ratios, (c) Account Evaluation. Then,

 6C-4.Create a three-tab (or sheet) Excel spreadsheet from scratch, sequentially naming

6C-4.Create a three-tab (or sheet) Excel spreadsheet from scratch, sequentially naming each tab as follows: (a) Account Balances, (b) Financial Ratios, (c) Account Evaluation. Then, for the - 1. Account Balances tab, re-list all the account balances from the 20X5 and 20X4 trial balances that will be needed to calculate the ratios in the next, Financial Ratios tab. 2. Financial Ratios tab, recompute the financial ratios for 20X5. Perform the calculations on this second tab by linking to the accounts from the previous Account Balances tab. Include the given 12/31/20X4 and industry ratios; then add, by cell referencing, the calculations for 12/31/X5. The results for 12/31/X5 should be formatted to look similar to what has already been calculated for 12/31/X4. For example, the current ratio and times interest earned are expressed as numerical results carried out to one decimal place, while return on total assets and return on net worth are expressed as percentages carried out to one decimal place. See the partially completed working paper below for related guidance. 3. Account Evaluation tab, first label three main columns within - Anomalous 12/31/X5 Ratios, Suspect Account(s), Potential Reasons. Then, compare and contrast the 12/31/X5 ratios, just computed, to the prior-year ratios, industry averages, and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!