Widget Company
Balance Sheet
On 12/31/2016 & 12/31/2017
2016 2017
Assets
Current Assets
1 Cash 115,000.00 125,000.00
2 Marketable Securities 55,000.00 47,321.00
3 Certificate Deposit 70,000.00 110,000.00
4 Accounts Receivable 105,555.00 99,177.00
5 Inventory 329,221.00 317,875.00
6 Prepaid Expences 7,800.00 3,000.00
7 Other 5,900.00 222.00
Total Current Assets 688,476.00 702,595.00
Property and Equipment
Land & Buildings 135,670.00 135,670.00
Furniture Equipment 47,000.00 53,600.00
Machinary 55,920.00 55,920.00
Leasehold Improvement 21,200.00
Total Property & Equipment 238,590.00 266,390.00
Accumulated Depreciation & Amortization 67,500.00 92,870.00
Net Property & Equipment
Other Assets 460 470
Total Assets 927,066.00 968,985.00
Company
ce Sheet
16 & 12/31/2017
2016 2017
Liabilities
Current Liabilities
Notes Payable 121,450 124,870
Current Obligation Under Capital Leases 15,647
Taxes Payable 9,055 12,366
Accounts Payable 197,870 203,966
Accrued Salaries & Wages 57,643 61,322
Other Accued Expenses 29,900 24,540
Other Current Liabilities 700
Total Current Liabilities 416,618 442,711
Long-Term Debt 245,822 235,790
Other Liabilities 7,000 2,500
Total Liabilities 252,822 238,290
Stockholders Equity
Common Stock 75,000 75,000
Retained Earnings 116,466 120,584
Total Stockholder's Equity 191,466 195,584
Total Liabilities & Equity 860,906 876,585
Number to use: Operations: Formulas: Answers:
1 Addiction(+) 3
2 Subtraction (-) -1
Multiplication (*) 2
Division (/) 0.5
Power (^) 1
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
SUM> 170 SUM> 140
Item Amount Item Amount
Bread 50 Bread 50
Donuts 100 Donuts
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
SUM> 260 SUM>
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
Average> 42.5 Average> 35
Item Amount Item Amount
Bread 50 Bread 50
Donuts 100 Bdonuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
Average> 0 50
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
MIN> 20 MAX> 50
Item Amount Item Amount
Bread 50 Bread 50
Donuts 100 Bdonuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
MIN>MAX 100 0
Date Funcitions
Today's Date 3/14/2019
Your Birthday 10/31/2000
Datys until Your Birth 6708
Grace Period Days 12/15/2018
Bill Due on: 12/30/2238
First Name Last Name Last Name, First Name Full Name
Nancy Smith Smith, Nancy Nancy Smith
Andy North North,Andy Andy North
Jan Kotas Kotas,Jan Jan Kotas
Mariya Jones Jones,Mariya Mariya Jones
Steven Thorpe Thorpe,Steven Steven Thorpe
Michael Niepper Niepper,Michael Michael Niepper
Robert Zare Zare,Robert Robert Zare
Yvonne McKay McKay,Yvonne Yvonne McKay
Smith, Nancy
North,Andy
Kotas,Jan
Jones,Mariya
Thorpe,Steven
Niepper,Michael
Zare,Robert
McKay,Yvonne
CAPSLOCK SMALL CAPS Default Case
NANCY SMITH nancy smith Nancy Smith
ANDY NORTH andy north Andy North
JAN KOTAS jan kotas Jan Kotas
MARIYA JONES mariya jones Mariya Jones
STEVEN THORPE steven thorpe Steven Thorpe
MICHAEL NIEPPER michael niepper Michael Niepper
ROBERT ZARE robert zare Robert Zare
YVONNE MCKAY yvonne mckay Yvonne Mckay
If Statements
Melon 0
Orange 0
50 Less than 100
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
Apples 50 Pork 10
Fruit Amount Fruit Type Amount
Apples 50 Apples Fuji 50
Oranges 20 Oranges Florida 20
Bananas 60 Bananas Cavendish 60
Lemons 40 Lemons Rough 40
Apples 50 Apples Honeycrisp 50
Oranges 20 Oranges Navel 20
Bananas 60 Bananas Lady Finger 60
Lemons 40 Lemons Eureka 40
Apples 50 Apples Honeycrisp 50
Oranges 20 Oranges Navel 20
Bananas 60 Bananas Cavendish 60
Lemons 40 Lemons Eureka 40
Fruit SUMIF Fruit Type SUMIFS
Apples 150 Oranges Florida #VALUE!
Fruit Amount
Apples 50
Oranges 20
Bananas 60
Lemons 40
Apples 50
Favorite Treat Number of Voltes
Candy 18
Chips 40
Cookies 80
Pizza 12
Fa
90
80
70
60
50
40
30
20
10
0
Candy Chi ps
Favorite treats
Number of Vol tes
ndy Chi ps Cooki es Pi zza
Favorite Lunch Boys Girls
burgers 60 40
Hot Dogs 70 20
Pizza 60 60
Spaghhet 20 60
Tacos 35 5
Boys
burgers Hot Dogs Pi zza Spa ghhet Ta cos
