ch13qz02a - Total Assets for Year 1 and Year 2. b. Format...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 13 - Quiz 02 ACCESSORIES FOR LESS PARTIAL COMPARATIVE BALANCE SHEET Year 2 and Year 1 Increase or Decrease Assets Year 2 Year 1 Current Assets Cash $77,000 $70,000 $7,000 9.1% Notes receivable 29,000 25,000 $4,000 13.8% Accounts receivable 6,000 4,000 $2,000 33.3% Supplies 16,000 12,000 $4,000 25.0% Total Current Assets $128,000 $111,000 $17,000 13.3% Fixed Assets Professional equipment $52,000 $33,000 $19,000 36.5% Building 58,000 55,000 $3,000 5.2% Total Fixed Assets $110,000 $88,000 $22,000 20.0% Total Assets $238,000 $199,000 $39,000 19.6% Directions: f. Format Column F for Percentage and 1 Decimal place. Amount of Change Percent of Change a. Enter formulas in Columns C and D to total Current Assets, Fixed Assets, and
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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. g. Save the file as ch13qz02a.xls. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28...
View Full Document

This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online