23 G5 4 6 B D E F ACCESSORIES FOR LESS PARTIAL COMPARATIVE BALANCE SHEET Year...

Transcribed Image Text:

23 G5 4 6 B D E F ACCESSORIES FOR LESS PARTIAL COMPARATIVE BALANCE SHEET Year 2 and Year 1 Increase or Decrease Amount Assets Year 2 Year 1 of Change Percent of Change 8 Current Assets 9 Cash $77,000 $70,000 10 Notes receivable 29,000 25,000 11 Accounts receivable 6,000 4,000 12 Supplies 10,000 12,000 13 Total Current Assets 14 Fixed Assets 15 Professional equipment $52,000 $33,000 16 Building 58,000 55,000 17 Total Fixed Assets 18 Total Assets 19 20 21 22 23 24 Directions: a. Enter formulas in Columns C and D to total Current Assets, Fixed Assets, and Total Assets for Year 1 and Year 2. b. Format answers in Columns C and D for Currency. Set Decimal places to 0. Set Currency symbol to $. c. Enter formulas in the Amount of Change column to subtract Year 1 from Year 2 for each item. d. Format Column E for Currency. Set Decimal places to 0. Set Currency symbol to $. Set negative numbers to be shown in parentheses and in red. e. Enter formulas in the Percent column to divide the Amount of Change by Year 1 (original year) for each item. 25 26 f. Format Column F for Percentage and 1 Decimal place. 23 G5 4 6 B D E F ACCESSORIES FOR LESS PARTIAL COMPARATIVE BALANCE SHEET Year 2 and Year 1 Increase or Decrease Amount Assets Year 2 Year 1 of Change Percent of Change 8 Current Assets 9 Cash $77,000 $70,000 10 Notes receivable 29,000 25,000 11 Accounts receivable 6,000 4,000 12 Supplies 10,000 12,000 13 Total Current Assets 14 Fixed Assets 15 Professional equipment $52,000 $33,000 16 Building 58,000 55,000 17 Total Fixed Assets 18 Total Assets 19 20 21 22 23 24 Directions: a. Enter formulas in Columns C and D to total Current Assets, Fixed Assets, and Total Assets for Year 1 and Year 2. b. Format answers in Columns C and D for Currency. Set Decimal places to 0. Set Currency symbol to $. c. Enter formulas in the Amount of Change column to subtract Year 1 from Year 2 for each item. d. Format Column E for Currency. Set Decimal places to 0. Set Currency symbol to $. Set negative numbers to be shown in parentheses and in red. e. Enter formulas in the Percent column to divide the Amount of Change by Year 1 (original year) for each item. 25 26 f. Format Column F for Percentage and 1 Decimal place.