Business quantitative analysis

/in /by

Ace your studies with our custom writing services! We've got your back for top grades and timely submissions, so you can say goodbye to the stress. Trust us to get you there!


Order a Similar Paper Order a Different Paper

Please see attached instructions. Throughout the entire course, two companies to analyze, Wicked Good Cupcakes and Cinemark (Cinemark is chosen company) 

 

This week, you will be evaluating the financial performance through ratio analysis of Wicked Good Cupcake company.

See the attached document for complete instructions and grading rubric.

Need this assignment by Sunday 7/16 6 pm (CST Central Standard time, US) 

Due Date: Sunday by 11:59 p.m of Unit 3

Total Point: 100

Instructions:

• On the Excel Financial Forecast worksheet fill in the information highlighted in red with data from your
company.

• Repeat the formulas in column C row 18-37 in column D. Doing this should allow you to adjust values in
the Fact and Assumptions part of column D and see its affect in row 18-27 of the same column.

• Using the Excel Financial Forecast worksheet, determine the ‘sensitivity’ of the model by adjusting the
values of growth rate in sales and cost of goods sold in column D. Increase and decreases the % values for
2017 and observe and record the results. Create an Excel chart for each (growth rate in sales and cost of
goods sold) the resulting impact on external funding required.

• Explain your observations on:
o How did adjusting growth rate of sale and cost of good sold affect the income statement and

balance sheet?
o What is External Funding Required and how was it affected by adjusting sales projections and cost

of goods sold?

Requirements:

• All questions posed must be addressed completely.

• Length: two-page Executive Summary

• Include the two charts.

• All sources used must be properly cited in APA format.

• Forecast model must be included with the word document.

Be sure to read the criteria, by which your assignment will be evaluated, before you write, and again after you
write.

Evaluation Rubric for Sensitivity of Financial Data Assignment

Criteria Exemplary Proficient Deficient

(18-20 Points) (13- 17 Points) (0 – 12 Points)

Growth Rate of
Sales Chart

Chart and evaluation are
clearly presented, including
all key details.

Chart and evaluation are
presented, though key
details may not be clearly or
completely presented.

Chart and evaluation are
inadequate or missing.

Cost of Goods Sold Chart and evaluation are
clearly presented, including
all key details.

Chart and evaluation are
clearly presented, including
all key details.

Chart and evaluation are
inadequate or is missing.

Results Analysis Analysis fully addresses the
results of the growth rate in
sales and cost of goods sold.

Analysis mostly addresses
the results of the growth
rate in sales and cost of
goods sold.

Analysis is inadequate or
missing.

Impact Analysis Analysis fully addresses how
the results may affect the
external funding.

Analysis mostly addresses
how the results may affect
the external funding.

Analysis is inadequate or
missing.

(9-10 Points) (7-8 Points) (0-6 Points)

Length 2 pages 1 page Less than 1 page or more
than 2 pages

Clear and
Professional
Writing and APA
Format

Writing and format are
clear, professional, APA
compliant, and error-free.

Few errors that do not
impede professional
presentation.

Errors impede professional
presentation; guidelines not
followed.

WGC Proforma Income

Wicked Good Cupcakes
Pro Forma Income Statement
Pro Forma Estimated Pro Forma
Actual Quarter Quarter Full Year Year
Ended 9-30-2017 Ended 12/31/2017 Ended 12/31/2017 Ended 12/31/2018
Units Sold 137000 205500 226050 259958
Sales 12650 13283 14611 16802
Cost of Goods Sold
Labor 2210 2321 2553 2935
Materials 2045 2147 2362 2716
Overhead 5685 5969 6566 7551
Delivery 305 320 352 405
Total CoGS 10245 10757 11833 13608
Gross Margin 2405 2525 2778 3194
Expense
Selling Expense 875 919 1011 1162
General & Admin 585 614 676 777
Total Expenses 1460 1533 1686 1939
Operating profit (EIBT) 945 992 1091
Interest 190 200 219 252
Profit before Taxes 755 793 872 1003
Income Taxes 272 286 314 361 [The first two heading levels get their own paragraph, as shown here. Headings 3, 4, and 5 are run-in headings used at the beginning of the paragraph.]
Net Income 483 507 558 642
Dividends 100 105 116 133
Retained Earnings 383 402 442 509
Depreciation 575 604 664 764
Net cash after divends 958 1006 1106 1272
Add back tax-adjusted interest 122 128 141 162
Add back divends 100 105 116 133
Cash flow from operations 1180 1239 1363 1567

Sales

12650 13282.5 14610.750000000002 16802.362499999999

Time Period

Sales in $

Total CoGS

10245 10757.25 11832.975 13607.921249999999

Time Period

Cost in $

Pro-Forma Year Ended 12-31-18

WGC Proforma Balance Sheet

Wicked Good Cupcakes
612/1/201 Pro Forma Income Statement
Actual Pro Forma Pro Forma
Assets 9/30/17 Change Ended 12/31/2017 Change Ended 12/31/2018
Current Assets
Cash 1450 5% 1523 10% 1675
Accounts Receivable 4250 5% 4463 10% 4909
Raw Materials 1500 5% 1575 10% 1733
Finished Goods 4050 5% 4253 10% 4678
Total Current Assets 11250 5% 11813 10% 12994
Fixed Assets
Land 2500 5% 2625 10% 2888
Plant and equipment 20800 5% 21840 10% 24024
Less Accumulated depreciation 8350 5% 8768 10% 9644
Net plant and equipment 12450 5% 13073 10% 14380
Total Fixed Assets 14950 5% 15698 10% 17267
Other Assets 1250 5% 1313 10% 1444
Total Assets 27450 5% 28823 10% 31705
Liabilities and Net Worth
Current Liabilities
Accounts Payable 1120 5% 1176 10% 1294
Notes Payable 3000 5% 3150 10% 3465
Due Contractor 3400 5% 3570 10% 3927
Accrued taxes 1250 5% 1313 10% 1444
Total current liabilities 8770 5% 9209 10% 10129
Long-term liabilities 8500 5% 8925 10% 9818
Common Stock 4250 5% 4463 10% 4909
Retained earnings 5930 5% 6227 10% 6849
Total Liabilities and net worth 27450 5% 28823 10% 31705
Funds required

Charts

Sales

12650 13282.5 14610.750000000002 16802.362499999999

Time Period

Sales in $

Total CoGS

10245 10757.25 11832.975 13607.921249999999

Time Period

Cost in $

Data

Order Details for December 2016
Order ID Order Date Customer ID Address City State Country Salesperson Region Shipped Date Shipper Name Ship Name Ship Address Ship City Ship State Flavor Unit Price Quantity Revenue Shipping Fee
1389 12/01/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA Lemon $5.95 64 $380.80 $118.66
1390 12/02/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA Chocolate $5.95 82 $487.90 $392.29
1391 12/03/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA Chocolate $5.95 17 $101.15 $5.13
1421 12/04/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Shipping Company C Anna Bedecs 123 1st Street Seattle WA Vanilla $5.95 88 $523.60 $148.14
1378 12/03/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West 12/05/16 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA Apple $5.95 89 $529.55 $81.59
1412 12/04/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West 12/06/16 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA Strawberry $5.95 49 $291.55 $90.25
1413 12/05/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West 12/07/16 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA Red Velvet $5.95 29 $172.55 $239.12
1432 12/06/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West Thomas Axerr 123 3rd Street Los Angelas CA Strawberry $5.95 12 $71.40 $17.04
1376 12/07/16 4 123 4th Street New York NY USA Andrew Cencini East 12/09/16 Shipping Company C Christina Lee 123 4th Street New York NY Chocolate Biscuits Mix $5.95 97 $577.15 $93.70
1406 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company A Christina Lee 123 4th Street New York NY Apple $5.95 62 $368.90 $117.94
1407 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company A Christina Lee 123 4th Street New York NY Vanilla $5.95 91 $541.45 $13.72
1410 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company C Christina Lee 123 4th Street New York NY German Chocolate $5.95 25 $148.75 $9.00
1431 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East Christina Lee 123 4th Street New York NY Raspbery $5.95 33 $196.35 $175.03
1379 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Apple $5.95 25 $148.75 $96.00
1396 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI German Chocolate $5.95 85 $505.75 $115.43
1404 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Chocolate $5.95 100 $595.00 $122.40
1414 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI German Chocolate $5.95 13 $77.35 $31.00
1424 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI German Chocolate $5.95 41 $243.95 $43.78
1429 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Strawberry $5.95 12 $71.40 $200.85
1430 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Red Velvet $5.95 68 $404.60 $225.62
1383 12/07/16 7 123 7th Street Boise ID USA Nancy Freehafer North Ming-Yang Xie 123 7th Street Boise ID Vanilla $5.95 64 $380.80 $279.68
1418 12/07/16 7 123 7th Street Boise ID USA Nancy Freehafer North Ming-Yang Xie 123 7th Street Boise ID Chocolate $5.95 15 $89.25 $33.00
1375 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Lemon $5.95 28 $166.60 $24.47
1381 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Chocolate $5.95 36 $214.20 $45.44
1397 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR Raspbery $5.95 82 $487.90 $318.16
1398 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR Strawberry $5.95 47 $279.65 $41.51
1409 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Red Velvet $5.95 29 $172.55 $300.85
1416 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Coffee $5.95 18 $107.10 $34.00
1425 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR Raspbery $5.95 67 $398.65 $82.88
1394 12/09/16 9 123 9th Street Salt Lake City UT USA Robert Zare West 12/11/16 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT Strawberry $5.95 85 $505.75 $165.75
1395 12/09/16 9 123 9th Street Salt Lake City UT USA Robert Zare West 12/11/16 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT Red Velvet $5.95 18 $107.10 $61.39
1423 12/09/16 9 123 9th Street Salt Lake City UT USA Robert Zare West 12/11/16 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT Red Velvet $5.95 34 $202.30 $68.58
1382 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company B Roland Wacker 123 10th Street Chicago IL Chocolate $5.95 93 $553.35 $26.42
1384 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company A Roland Wacker 123 10th Street Chicago IL Strawberry $5.95 84 $499.80 $220.50
1385 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company A Roland Wacker 123 10th Street Chicago IL Red Velvet $5.95 72 $428.40 $150.48
1386 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company A Roland Wacker 123 10th Street Chicago IL German Chocolate $5.95 60 $357.00 $56.86
1417 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company B Roland Wacker 123 10th Street Chicago IL Lemon $5.95 81 $481.95 $62.83
1419 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East Shipping Company A Roland Wacker 123 10th Street Chicago IL Chocolate $5.95 96 $571.20 $21.32
1387 12/11/16 11 123 11th Street Miami FL USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL Raspbery $5.95 67 $398.65 $22.75
1388 12/11/16 11 123 11th Street Miami FL USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL Coffee $5.95 48 $285.60 $13.63
1420 12/11/16 11 123 11th Street Miami FL USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL Apple $5.95 81 $481.95 $378.00
1408 12/12/16 12 123 12th Street Las Vegas NV USA Mariya Sergienko West 12/14/16 Shipping Company B John Edwards 123 12th Street Las Vegas NV Strawberry $5.95 25 $148.75 $8.00
1399 12/25/16 25 789 25th Street Chicago IL USA Laura Giussani East 12/27/16 Shipping Company A John Rodman 789 25th Street Chicago IL Red Velvet $5.95 99 $589.05 $99.00
1426 12/25/16 25 789 25th Street Chicago IL USA Laura Giussani East 12/27/16 Shipping Company A John Rodman 789 25th Street Chicago IL Strawberry $5.95 74 $440.30 $84.48
1400 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL German Chocolate $5.95 49 $291.55 $106.71
1401 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL Raspbery $5.95 72 $428.40 $72.95
1402 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL Coffee $5.95 99 $589.05 $191.27
1427 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL Red Velvet $5.95 24 $142.80 $164.15
1405 12/27/16 27 789 27th Street Las Vegas NV USA Mariya Sergienko West 12/29/16 Shipping Company B Karen Toh 789 27th Street Las Vegas NV Chocolate $5.95 17 $101.15 $27.00
1380 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Coffee $5.95 19 $113.05 $89.15
1392 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Apple $5.95 38 $226.10 $36.67
1393 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Vanilla $5.95 25 $148.75 $45.54
1415 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Raspbery $5.95 25 $148.75 $20.00
1422 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Strawberry $5.95 92 $547.40 $365.15
1377 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Chocolate $5.95 23 $136.85 $29.33
1403 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Lemon $5.95 10 $59.50 $13.86
1411 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Raspbery $5.95 48 $285.60 $23.00
1428 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Raspbery $5.95 41 $243.95 $193.01
1370 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company A Christina Lee 123 4th Street New York NY Strawberry $5.95 81 $481.95 $255.15
1371 12/05/16 4 123 4th Street New York NY USA Andrew Cencini East 12/07/16 Shipping Company A Christina Lee 123 4th Street New York NY Red Velvet $5.95 83 $493.85 $461.90
1372 12/06/16 4 123 4th Street New York NY USA Andrew Cencini East 12/08/16 Shipping Company A Christina Lee 123 4th Street New York NY German Chocolate $5.95 75 $446.25 $26.25
1373 12/07/16 12 123 12th Street Las Vegas NV USA Mariya Sergienko West 12/09/16 Shipping Company B John Edwards 123 12th Street Las Vegas NV Raspbery $5.95 97 $577.15 $183.33
1374 12/08/16 12 123 12th Street Las Vegas NV USA Mariya Sergienko West 12/10/16 Shipping Company B John Edwards 123 12th Street Las Vegas NV Coffee $5.95 61 $362.95 $291.82
1368 12/27/16 27 789 27th Street Las Vegas NV USA Mariya Sergienko West 12/29/16 Shipping Company B Karen Toh 789 27th Street Las Vegas NV Chocolate $5.95 19 $113.05 $25.80
1369 12/28/16 27 789 27th Street Las Vegas NV USA Mariya Sergienko West 12/30/16 Shipping Company B Karen Toh 789 27th Street Las Vegas NV Vanilla $5.95 60 $357.00 $20.16

Sales by Rep – Final

Row Labels Sum of Revenue
Nancy Freehafer $17,137.58
Andrew Cencini $12,368.90
Anne Larsen $12,065.27
Michael Neipper $10,514.50
Laura Giussani $7,421.07
Mariya Sergienko $6,942.86
Robert Zare $2,814.65
Jan Kotas $979.25
Grand Total $70,244.08

Sales by Rep for Dec 2014

Total

Nancy Freehafer Andrew Cencini Anne Larsen Michael Neipper Laura Giussani Mariya Sergienko Robert Zare Jan Kotas 17137.579999999998 12368.9 12065.27 10514.5 7421.07 6942.8600000000006 2814.65 979.25

Pivot Table Diagram

Article: How Do Pivot Tables Work?
Source: http://www.excelcampus.com/pivot-tables/pivot-tables-work/

http://www.excelcampus.com/pivot-tables/pivot-tables-work/

Source

Author: Jon Acampora
Source: http://www.excelcampus.com/charts/pivot-tables-dashboards-part-1
Description: Follow along with the video at the link above and learn how to
create your first pivot table and pivot chart.

http://www.excelcampus.com/charts/pivot-tables-dashboards-part-1

image1.png

WGC Proforma Income

Wicked Good Cupcakes
Pro Forma Income Statement
Pro Forma Estimated Pro Forma
Actual Quarter Quarter Full Year Year
Ended 9-30-2017 Ended 12/31/2017 Ended 12/31/2017 Ended 12/31/2018
Units Sold 137000
Sales 12650
Cost of Goods Sold
Labor 2210
Materials 2045
Overhead 5685
Delivery 305
Total CoGS 10245
Gross Margin 2405
Expense
Selling Expense 875
General & Admin 585
Total Expenses 1460
Operating profit (EIBT) 945
Interest 190
Profit before Taxes 755
Income Taxes 272
Net Income 483
Dividends 100
Retained Earnings 383
Depreciation 575
Net cash after divends 958
Add back tax-adjusted interest 122
Add back divends 100
Cash flow from operations 1180

WGC Proforma Balance Sheet

Wicked Good Cupcakes
612/1/201 Pro Forma Income Statement
Actual Pro Forma Pro Forma
Assets 9/30/17 Change Ended 12/31/2017 Change Ended 12/31/2017
Current Assets
Cash 1450
Accounts Receivable 4250
Raw Materials 1500
Finished Goods 4050
Total Current Assets 11250
Fixed Assets
Land 2500
Plant and equipment 20800
Less Accumulated depreciation 8350
Net plant and equipment 12450
Total Fixed Assets 14950
Other Assets 1250
Total Assets 27450
Liabilities and Net Worth
Current Liabilities
Accounts Payable 1120
Notes Payable 3000
Due Contractor 3400
Accrued taxes 1250
Total current liabilities 8770
Long-term liabilities 8500
Common Stock 4250
Retained earnings 5930
Total Liabilities and net worth 27450
Funds required

Sheet1

Facts and Assumptions
Year 2015 2016 2017
Net sales $ 20,613 $ 27,828
Growth rate in sales 35% 50%
Cost of goods sold 86% 86%
Gen., sell,, and admin. Expenses 12% 11%
Long-term debt $ 760 $ 760 $ 760
Current portion long-term debt $ 100 $ 100 $ 100
Interest rate 10% 10%
Tax rate 45% 45%
Dividend/earnings after tax 50% 50%
Current assets 29% 29%
Net fixed assets $ 100 $ 100 $ 100
Current liabilities 14.5% 14.4%
Owners’ equity $ 1,730
INCOME STATEMENT
Year 2015 2016 2017
Net sales $ 27,828
Cost of good sold 23,932
Gross profit 3,896
Gen., sell,, and admin. exp. 3,339
Interest expense 86
Earnings before tax 471
Tax 212
Earnings after tax 259
Dividends paid 129
Additions to retained earnings 129
BALANCE SHEET
Current assets $ 8,070
Net fixed assets 100
Total assets 8,170
Current liabilities 4,035
Long-term debt 760
Equity 1,859
Total liabilities and shareholders’ equity 6,654
EXTERNAL FUNDING REQUIRED $ 1,516

Cash Flow Statement

Cash Flow Statement 2016
($ Thousands)
Cash Flow from Operating Activities Line(s) Used (e.g., 2015 Accounts Payable – 2016 Accounts Payable)
Net income
Change in Accounts Payable
Change in Accounts Receivable
Change in Inventory
Other Adjustments:
Accrued Expenses
Depreciation Expense
Income Taxes
Net Cash provided by Operating Activities
Cash Flow from Investing Activities Line(s) Used
Sale of Plant, Property and Equipment
Purchase of Assets (Intangibles)
Sales of other assets
Income from short term investments (assumption from IS)
Net Cash used in Investing Activities
Cash Flows from Financing Activities Line(s) Used
Additions to long-term debts
Cash dividends
Repurchase of Treasury Stock
Net cash used in Financing Activities
Increase/Decrease in cash and cash equivalents
Cash and Cash Equivalents at the beginning of the period
Cash and Cash Equivalents at the end of the period
ERROR:#REF! ERROR:#REF!

Balance Sheet

ANNUAL BALANCE SHEET
($ Thousands)
31-Dec-15 31-Dec-16
ASSETS
Cash & Short-Term Investments $17.11 $25.05
Net Receivables $1.62 $1.84
Inventories $42.72 $39.68
Prepaid Expenses $0.00 $0.00
Other Current Assets $3.38 $2.93
Total Current Assets $64.84 $69.49
Gross Plant, Property & Equipment $63.75 $58.28
Accumulated Depreciation $36.16 $32.61
Net Plant, Property & Equipment $27.58 $25.67
Intangibles $5.88 $6.01
Other Assets $6.16 $5.81
TOTAL ASSETS $104.47 $106.98
LIABILITIES
Long Term Debt Due In One Year $0.00 $0.00
Accounts Payable $10.59 $11.91
Taxes Payable $1.87 $2.01
Accrued Expenses $7.19 $6.91
Other Current Liabilities $1.88 $1.85
Total Current Liabilities $21.54 $22.67
Long Term Debt $6.95 $19.79
Deferred Taxes $1.16 $2.32
Other Liabilities $3.04 $2.43
TOTAL LIABILITIES $32.68 $47.21
EQUITY
Common Stock $0.07 $0.06
Capital Surplus $27.25 $24.31
Retained Earnings $73.89 $61.10
Less: Treasury Stock $29.42 $25.71
TOTAL EQUITY $71.79 $59.77
TOTAL LIABILITIES & EQUITY $104.47 $106.98
Common Shares Outstanding $5.14 $5.05

Income Statement

Annual Income Statement
($ Thousands, except per share )
2015 2016
Sales $179.24 $164.28
Cost of Goods Sold $95.71 $91.99
Gross Profit $83.53 $72.29
Selling, General, & Administrative Exp. $56.36 $50.65
Operating Income Before Deprec. $27.17 $21.64
Depreciation,Depletion,&Amortization $5.85 $5.89
Operating Profit $21.33 $15.74
Interest Expense $0.88 $0.56
Non-Operating Income/Expense $0.93 $0.31
Special Items $0.00 $0.00
Pretax Income $21.38 $15.49
Total Income Taxes $7.23 $5.60
Income Before Extraordinary
Items & Discontinued Operations $14.15 $9.90
Savings Due to Common Stock Equiv. $0.00 $0.00
Adjusted Net Income $14.15 $9.90
EPS Basic from Operations $0.26 $0.19
EPS Diluted from Operations $0.25 $0.19
Dividends Per Share $0.02 $0.00
Com Shares for Basic EPS $5.06 $5.12
Com Shares for Diluted EPS $5.21 $5.27
Writerbay.net

Looking for top-notch essay writing services? We've got you covered! Connect with our writing experts today. Placing your order is easy, taking less than 5 minutes. Click below to get started.


Order a Similar Paper Order a Different Paper