Ch13test02a - Format Column F for Percentage and 1 Decimal...

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 - Test 02 BATTERIES, BATTERIES, BATTERIES PARTIAL COMPARATIVE BALANCE SHEET Year 2 and Year 1 Increase or Decrease Assets Year 2 Year 1 Current Assets Cash $108,000 $85,000 $23,000 27.1% Notes receivable $45,000 $35,250 $9,750 27.7% Accounts receivable $5,000 $3,500 $1,500 42.9% Supplies $12,350 $11,200 $1,150 10.3% Total Current Assets $170,350 $134,950 $35,400 26.2% Fixed Assets Professional equipment $55,000 $45,000 $10,000 22.2% Building $68,500 $63,250 $5,250 8.3% Total Fixed Assets $123,500 $108,250 $15,250 14.1% Total Assets $293,850 $243,200 $50,650 20.8% Directions: a. Total Current Assets, Fixed Assets, and Total Assets for Year 1 and Year 2. f.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Format Column F for Percentage and 1 Decimal place. Amount of Change Percent of Change 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 ch13test02a.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