BS Comparatives

Use the excel files to complete the instructions listed on each of the following five tabs: the Working Trial Balance tab, the BS Comparatives tab, the IS 12-31-17 tab, the 2017 Cash Flows tab, and the 2017 Statement of RE tab. A FEW ITEMS TO NOTE for the Working Trial Balance tab: If there are no debits or credits for any particular account in the Adjusting Entries or Closing Entries columns, delete the question marks from the appropriate cells and leave those cells blank. Under the Adjusted T/B and Post Closing T/B columns, each account should have just one entry. For example, under Adjusted T/B, Accounts Payable should have a blank Debit column and some amount in the Credit column. Under Post Closing T/B, Accounts Payable should have a blank Debit column and some amount in the Credit column. If an account has no balance in either the Debit or Credit column, indicate no balance by formatting the cell to show $0 as a dash in the cell of that accounts normal balance. For example, if Accounts Payable has a balance of $0, the normal balance for A/P is a credit balance, so the Credit column should show a dash. The cell values for the Adjusted T/B, Closing Entries, and Post Closing T/B debit and credit columns should be made with formulas. Do not type the values into these cells. You SHOULD type the values into the Adjustments debit and credit columns.

Silver Tone Partners, Inc. BALANCE SHEETS As of December 31, 2017 & 2016 45 Instuctions for thel Peaianc for the comparative years by A. Please prepare the Balance Sheets & Variance columns for the comparative years by: 47 48 49 50 51 52 53 54 1. Typing the necessary account names from the Working Trial Balance 2. Linking by formula the dollar amounts for the comparative years from the Working Trial Balance 3. Creating the necessary formulas to foot and cross foot all columns/rows ensuring the figures mathematically add up and reconcile B. Create formulas for each ratio listed below to properly compute the ratios 56 57 58 59 60 61 62 63 64 65 RATIOS: Working Capital Current Ratio Quick Ratio (### to 1) Debt Ratio Equity Ratio Asset to Equity Debt to Equity Cash Ratio Working Trial Balance BS Comparatives IS 12-31-17 2017 Cash Flows2017 Statement of RE Silver Tone Partners, Inc. BALANCE SHEETS As of December 31, 2017 & 2016 45 Instuctions for thel Peaianc for the comparative years by A. Please prepare the Balance Sheets & Variance columns for the comparative years by: 47 48 49 50 51 52 53 54 1. Typing the necessary account names from the Working Trial Balance 2. Linking by formula the dollar amounts for the comparative years from the Working Trial Balance 3. Creating the necessary formulas to foot and cross foot all columns/rows ensuring the figures mathematically add up and reconcile B. Create formulas for each ratio listed below to properly compute the ratios 56 57 58 59 60 61 62 63 64 65 RATIOS: Working Capital Current Ratio Quick Ratio (### to 1) Debt Ratio Equity Ratio Asset to Equity Debt to Equity Cash Ratio Working Trial Balance BS Comparatives IS 12-31-17 2017 Cash Flows2017 Statement of RE