{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch13qz02a

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

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

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
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

{[ snackBarMessage ]}

Ask a homework question - tutors are online