Fashion Trends, Inc.

Balance Sheet
For the Period Ended Dec. 31, 2017
2018* 2017 2016
Sales 7,100,000 6,148,000 5,134,000
Cost of Goods Sold 4,777,526 4,176,000 3,422,000
Gross Profit 2,322,474 1,972,000 1,712,000
Selling and G&A Expenses 747,492 588,000 590,000
Fixed Expenses 70,000 70,000 70,000
Depreciation Expense 528,000 478,000 446,000
EBIT 976,982 836,000 606,000
Interest Expense 149,540 186,000 182,000
Earnings Before Taxes 827,442 650,000 424,000
Taxes 330,977 195,000 127,200
Net Income 496,465 455,000 296,800

* Forecast

Notes
Tax Rate 40% 30% 30%

Additional Depreciation 50,000

Sorth-term Interest Rate 4%
Long-term Interest Rate 7%
Scenario Multiplier for part c 100%
DFN for Scenarios in part c (138,993)
 Fashion Trends, Inc.
Balance Sheet
As of Dec. 31, 2017
Assets 2018* 2017 2016
Cash and Equivalents 862,000 862,000 678,000
Accounts Receivable 1,085,660 1,006,000 730,000
Inventory 748,632 578,000 600,000
Total Current Assets 2,696,292 2,446,000 2,008,000
Plant & Equipment 9,838,000 9,338,000 8,644,000
Accumulated Depreciation 5,118,000 4,590,000 4,112,000
Net Fixed Assets 4,720,000 4,748,000 4,532,000
Total Assets 7,416,292 7,194,000 6,540,000
Liabilities and Owners' Equity
Accounts Payable 814,545 764,000 540,000
Short-term Notes Payable 158,000 158,000 198,000
Accrued Expenses 341,276 318,000 228,000
Total Current Liabilities 1,313,820 1,240,000 966,000
Long-term Debt 2,046,000 2,046,000 1,934,000
Total Liabilities 3,359,820 3,286,000 2,900,000
Common Stock 1,638,000 1,638,000 1,616,000
Retained Earnings 2,557,465 2,270,000 2,024,000
Total Shareholder's Equity 4,195,465 3,908,000 3,640,000
Total Liabilities and Owners' Equity 7,555,285 7,194,000 6,540,000

* Forecast
Discretionary Financing Needed -138,993.21 Surplus
Total Accumulated DFN -138,993.21

2017 Dividends 209,000

Net Addition to Plan and Equipment 500,000
Life of New Equipment in Years 10
Salvage Value of New Equipment 0
New Depreciation (Straight Line) 50,000
Iteration 0
Scenario Summary
Best Case Base Case Worst Case
Changing Cells:
Scenario_Multiplier_for_part_c 115% 100% 85%
Result Cells:
DFN (178,971) (138,993) (99,016)
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
 NVIDIA Corporation
Income Statement ($ in Millions)
For the Years 2012 to 2017
Jan-18* Jan-17 Jan-16 Jan-15 Jan-14 Jan-13
Sales 8,260 6,910 5,010 4,682 4,130 4,280
Cost of Goods Sold 3,354 2,648 2,002 1,862 1,623 1,828
Gross Income 4,906 4,262 3,008 2,820 2,507 2,453
Research & Development 2,210 1,463 1,331 1,360 1,336 1,147
Other SG&A 825 641 532 443 436 431
Depreciation Expense 187 187 197 220 239 226
Other Operating Expense 0 2 0 0 0 0
EBIT (Operating Income) 1,683 1,969 948 796 496 648
Nonoperating Income - Net 50 50 43 42 24 17
Interest Expense 58 58 47 46 10 3
Unusual Expense - Net 56 56 201 37 0 0
Pretax Income 1,619 1,905 743 755 510 662
Income Taxes 281 239 129 124 70 100
Net Income 1,338 1,666 614 631 440 563

Dividends per Share 0.54 0.49 0.40 0.34 0.31 0.08

Tax Rate 17.35% 12.55% 17.36% 16.46% 13.77% 15.03%

* Forecast

Interest Rate 2.50%

FactSet 2018 Revenue Forecast 8260

FactSet 2018 Tax Rate Forecast 17.35%
FactSet 2018 R&D Forecast 1713
Sales Multiplier for Scenarios 100%
DFN for Scenarios (1,537.81)

Source: FactSet Fundamentals, Retrieved 15 July 2017

Jan-12
3,998
1,743
2,255
984
398
204
0
669
7
3
9
663
82
581

0.00
12.41%
 NVIDIA Corporation
Balance Sheet ($ in Millions)
For the Years 2012 to 2017
Jan-18* Jan-17 Jan-16 Jan-15 Jan-14
Assets
Cash & Short-Term Investments 1,766 1,766 596 497 1,151
Short-Term Investments 5,032 5,032 4,441 4,127 3,521
Accounts Receivable 847 826 505 474 426
Inventories 796 794 418 483 388
Other Current Assets 225 118 93 133 139
Total Current Assets 8,666 8,536 6,053 5,713 5,625
Gross Plant & Equipment 1,191 1,191 1,100 1,179 1,283
Accumulated Depreciation 670 670 634 622 700
Net Plant & Equipment 521 521 466 557 583
Other Assets 784 784 851 931 1,043
Total Assets 9,971 9,841 7,370 7,201 7,251
Liabilities & Shareholders' Equity
ST Debt & Current Portion LT Debt 800.0 800.0 1,413.0 0.0 2.9
Accounts Payable 602 485.0 296.0 293.2 324.4
Other Current Liabilities 1,065 503.0 642.0 602.8 621.1
Total Current Liabilities 2,467.4 1,788.0 2,351.0 896.0 948.4
Long-Term Debt 2,020 2,020 97 1,398 1,371
Other Liabilities 271 271 453 489 475
Total Liabilities 4,758 4,079 2,901 2,783 2,794
Common Equity 6,750 5,762 4,469 4,418 4,456
Total Liabilities & Shareholders' Equity 11,508 9,841 7,370 7,201 7,251

Shares Outstanding 649 649 569 563.07 594.52

Discretionary Financing Needed (1,537.81) Surplus

Accumulated DFN (1,537.81)
Iteration 0

Source: FactSet Fundamentals

Jan-13 Jan-12

431 253
3,297 2,876
454 336
420 340
173 99
4,775 3,905
1,289 1,157
713 596
576 560
1,061 1,087
6,412 5,553

0.0 0.0
356.4 335.1
619.8 594.9
976.2 930.0
19 21
589 456
1,585 1,407
4,828 4,146
6,412 5,553

624.96 616.37
Sales Research & Development
6,910 1,463 NVIDIA Corporation
5,010 1,331 Sales vs. Research & Developm
4,682 1,360 1,600
4,130 1,336 1,400 f(x) = 0.112238551379434 x + 727.505464368
4,280 1,147 R² = 0.492268628955087
1,200
3,998 984
1,000
800
600
400
200
0
3,500 4,000 4,500 5,000 5,500 6,000

C) There does appear to be a positive relationship

SUMMARY OUTPUT this period. The line has a positive slope, and the R
D) The regression output confirms the result in the
Regression Statistics the slope is not significant at the 95% level.
Multiple R 0.702
R Square 0.492
Adjusted R Square 0.365
Standard Error 138.028
Observations 6

ANOVA
df SS MS F Significance F
Regression 1 73,886.07 73,886.07 3.88 0.12
Residual 4 76,206.92 19,051.73
Total 5 150,093.00

CoefficientsStandard Error t Stat P-value Lower 95%

Intercept 727.51 281.27 2.59 0.06 (53.41)
Sales 0.11 0.06 1.97 0.12 (0.05)
 NVIDIA Corporation
Title Sales vs. Research & Development
NVIDIA Corporation
les vs. Research & Development

38551379434 x + 727.505464368674
8628955087

5,000 5,500 6,000 6,500 7,000 7,500

appear to be a positive relationship between Sales and R&D during

e line has a positive slope, and the R2 is about 0.50.
on output confirms the result in the chart, however, we can see that
significant at the 95% level.

ignificance F

Upper 95%
1,508.42
0.27
Scenario Summary
Best Case Base Case Worst Case
Changing Cells:
Sales Multiplier 115% 100% 85%
Result Cells:
DFN (1,739.67) (1,537.81) (1,335.95)
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
 NVIDIA Corporation
Income Statement ($ in Millions)
For the Years 2012 to 2017
Jan-18* Jan-17 Jan-16 Jan-15 Jan-14 Jan-13
Sales 8,260 6,910 5,010 4,682 4,130 4,280
Cost of Goods Sold 2,480 2,648 2,002 1,862 1,623 1,828
Gross Income 5,780 4,262 3,008 2,820 2,507 2,453
Research & Development 1,567 1,463 1,331 1,360 1,336 1,147
Other SG&A 633 641 532 443 436 431
Depreciation Expense 187 187 197 220 239 226
Other Operating Expense 0 2 0 0 0 0
EBIT (Operating Income) 3,393 1,969 948 796 496 648
Nonoperating Income - Net 50 50 43 42 24 17
Interest Expense 58 58 47 46 10 3
Unusual Expense - Net 56 56 201 37 0 0
Pretax Income 3,329 1,905 743 755 510 662
Income Taxes 578 239 129 124 70 100
Net Income 2,752 1,666 614 631 440 563

Dividends per Share 0.54 0.49 0.40 0.34 0.31 0.08

Tax Rate 17.35% 12.55% 17.36% 16.46% 13.77% 15.03%

* Forecast

Interest Rate 2.50%

FactSet 2018 Revenue Forecast 8260

FactSet 2018 Tax Rate Forecast 17.35%
FactSet 2018 R&D Forecast 1713
Sales Multiplier for Scenarios 100%
DFN for Scenarios (2,951.07)

Source: FactSet Fundamentals, Retrieved 15 July 2017

Jan-12
3,998
1,743
2,255
984
398
204
0
669
7
3
9
663
82
581

0.00
12.41%
 NVIDIA Corporation
Balance Sheet ($ in Millions)
For the Years 2012 to 2017
Jan-18* Jan-17 Jan-16 Jan-15 Jan-14
Assets
Cash 1,523 1,766 596 497 1,151
Short-Term Investments 5,364 5,032 4,441 4,127 3,521
Accounts Receivable 847 826 505 474 426
Inventories 796 794 418 483 388
Other Current Assets 111 118 93 133 139
Total Current Assets 8,641 8,536 6,053 5,713 5,625
Gross Plant & Equipment 1,150 1,191 1,100 1,179 1,283
Accumulated Depreciation 670 670 634 622 700
Net Plant & Equipment 480 521 466 557 583
Other Assets 734 784 851 931 1,043
Total Assets 9,854 9,841 7,370 7,201 7,251
Liabilities & Shareholders' Equity
ST Debt & Current Portion LT Debt 1,193 800.0 1,413.0 0.0 2.9
Accounts Payable 602 485.0 296.0 293.2 324.4
Other Current Liabilities 556 503.0 642.0 602.8 621.1
Total Current Liabilities 2,351.2 1,788.0 2,351.0 896.0 948.4
Long-Term Debt 2,020 2,020 97 1,398 1,371
Other Liabilities 271 271 453 489 475
Total Liabilities 4,642 4,079 2,901 2,783 2,794
Common Equity 8,163 5,762 4,469 4,418 4,456
Total Liabilities & Shareholders' Equity 12,805 9,841 7,370 7,201 7,251

Shares Outstanding 649 649 569 563.07 594.52

Discretionary Financing Needed (2,951.07) Surplus

Accumulated DFN (2,951.07)
Iteration 0

Source: FactSet Fundamentals

Jan-13 Jan-12

431 253
3,297 2,876
454 336
420 340
173 99
4,775 3,905
1,289 1,157
713 596
576 560
1,061 1,087
6,412 5,553

0.0 0.0
356.4 335.1
619.8 594.9
976.2 930.0
19 21
589 456
1,585 1,407
4,828 4,146
6,412 5,553

624.96 616.37
Scenario Summary
Current Values: Best Case Base Case Worst Case
Changing Cells:
$B$30 100% 115% 100% 85%
Result Cells:
$B$31 (2,951.07) (3,818.99) (2,951.07) (2,083.14)
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
 Date S&P 500 XEL NVDA BAC TSCO Equal Weight Portfolio
7/31/2012 1.39% 3.13% -2.03% -10.27% 2.60% -1.64%
8/31/2012 2.25% -4.81% 3.62% 8.86% 5.81% 3.37%
9/28/2012 2.59% 0.34% -4.92% 10.65% -1.36% 1.18%
10/31/2012 -1.84% 1.94% -10.24% 5.55% -2.22% -1.24%
11/30/2012 0.57% -4.24% 0.61% 5.79% 1.63% 0.95%
12/31/2012 0.91% -0.27% 2.42% 17.86% 3.35% 5.84%
1/31/2013 5.18% 4.02% 0.00% -2.50% 6.05% 1.89%
2/28/2013 1.35% 3.31% 3.89% -0.71% 3.73% 2.55%
3/29/2013 3.75% 4.46% 1.35% 8.46% 3.23% 4.38%
4/30/2013 1.92% 7.03% 7.33% 1.07% -1.37% 3.52%
5/31/2013 2.34% -9.66% 5.61% 10.96% -0.19% 1.68%
6/28/2013 -1.34% -0.37% -2.97% -5.78% -9.31% -4.61%
7/31/2013 5.08% 5.68% 2.81% 13.53% 10.83% 8.21%
8/30/2013 -2.90% -6.78% 2.70% -3.29% -0.20% -1.89%
9/30/2013 3.14% -0.09% 5.49% -2.19% -2.06% 0.29%
10/31/2013 4.60% 4.53% -2.39% 1.23% 2.77% 1.53%
11/29/2013 3.04% -2.91% 3.27% 13.24% -4.46% 2.29%
12/31/2013 2.54% 0.70% 2.70% -1.52% -3.90% -0.51%
1/31/2014 -3.46% 3.47% -2.00% 7.58% -4.19% 1.22%
2/28/2014 4.57% 4.78% 17.60% -1.32% 2.77% 5.96%
3/31/2014 0.84% 1.22% -2.55% 4.12% -10.27% -1.87%
4/30/2014 0.74% 4.97% 3.12% -11.98% 2.60% -0.32%
5/30/2014 2.34% -3.48% 3.35% 0.00% 3.62% 0.87%
6/30/2014 2.06% 5.80% -2.42% 1.58% -6.38% -0.35%
7/31/2014 -1.38% -4.44% -5.61% -0.78% -9.21% -5.01%
8/29/2014 4.00% 4.06% 11.63% 5.51% -10.87% 2.58%
9/30/2014 -1.40% -4.24% -5.15% 6.29% -19.03% -5.53%
10/31/2014 2.44% 10.10% 5.91% 0.65% -6.14% 2.63%
11/28/2014 2.69% 1.40% 7.77% -0.70% 7.40% 3.97%
12/31/2014 -0.25% 6.73% -4.39% 5.29% 1.36% 2.25%
1/30/2015 -3.00% 4.48% -4.21% -15.32% 18.92% 0.97%
2/27/2015 5.75% -5.99% 15.30% 4.36% 9.19% 5.71%
3/31/2015 -1.58% -0.39% -5.14% -2.35% -1.45% -2.33%
4/30/2015 0.96% -2.58% 6.07% 3.51% -8.62% -0.41%
5/29/2015 1.29% 0.41% 0.17% 3.58% -3.80% 0.09%
6/30/2015 -1.94% -4.56% -9.13% 3.46% -0.03% -2.57%
7/31/2015 2.09% 7.74% -0.79% 5.05% 1.48% 3.37%
8/31/2015 -6.03% -2.71% 13.16% -8.61% -11.29% -2.36%
9/30/2015 -2.47% 5.99% 9.65% -4.35% -4.26% 1.76%
10/30/2015 8.43% 0.62% 15.09% 7.70% 0.05% 5.87%
11/30/2015 0.29% 0.08% 12.22% 3.87% -8.78% 1.85%
12/31/2015 -1.58% 1.61% 3.91% -3.17% -10.60% -2.06%
1/29/2016 -4.96% 6.43% -11.13% -15.98% 16.00% -1.17%
2/29/2016 -0.14% 3.46% 7.46% -11.46% 4.03% 0.87%
 3/31/2016 6.78% 6.65% 13.62% 8.39% 6.33% 8.75%
4/29/2016 0.39% -4.28% -0.28% 7.69% -10.27% -1.78%
5/31/2016 1.79% 3.35% 31.83% 1.58% -4.08% 8.17%
6/30/2016 0.26% 9.10% 0.62% -9.97% 5.94% 1.42%
7/29/2016 3.69% -1.79% 21.46% 9.19% -10.81% 4.51%
8/31/2016 0.14% -5.96% 7.62% 11.91% 6.63% 5.05%
9/30/2016 0.02% 0.30% 11.71% -3.04% 9.99% 4.74%
10/31/2016 -1.82% 1.00% 3.85% 5.43% 15.18% 6.37%
11/30/2016 3.70% -6.11% 29.76% 28.45% -0.96% 12.78%
12/30/2016 1.98% 5.21% 15.77% 4.64% -0.89% 6.18%
1/31/2017 1.89% 1.52% 2.29% 2.44% -5.92% 0.08%
2/28/2017 3.97% 5.78% -6.93% 9.01% -3.19% 1.17%
3/31/2017 0.11% 2.54% 7.34% -4.13% -1.48% 1.07%
4/28/2017 1.03% 1.35% -4.25% -1.06% -1.28% -1.31%
5/31/2017 1.41% 6.35% 38.54% -3.66% 0.25% 10.37%
6/30/2017 0.63% -3.51% 0.14% 8.25% -8.11% -0.81%
 XEL
15.00%

10.00%

5.00%

f(x) = 0.18590565003211 x + 0.00988388448272515

0.00% R² = 0.0132001995088115

-5.00%

-10.00%

-15.00%
-8.00% -6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00%

BAC
40.00%

30.00%

20.00%

10.00% f(x) = 1.27274348367109 x + 0.00706615798443119

R² = 0.195535263701875
0.00%

-10.00%

-20.00%
-8.00% -6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00%

Equal Weight Portfolio

15.00%

10.00%

f(x) = 0.731139909937953 x + 0.00978239848149119

5.00% R² = 0.297896011498415

0.00%

-5.00%

-10.00%
-8.00% -6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00%
 0.00%

-5.00%

-10.00%
-8.00% -6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00%
 NVDA
50.00%

40.00%

30.00%

20.00%

10.00% f(x) = 1.22507602934419 x + 0.0308991056781717

R² = 0.120282047432868
0.00%

-10.00%

-20.00%
-8.00% -6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00%

TSCO
25.00%
20.00%
15.00%
10.00%
5.00%
0.00% f(x) = 0.240834476704431 x − 0.0087195542193633
-5.00% R² = 0.0082629495330846

-10.00%
-15.00%
-20.00%
-25.00%
-8.00% -6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00%

All of the R2 are pretty low, but the equally weighted portfolio has the
highest R2.
Xcel Energy Output

Regression Statistics
Multiple R 0.1149
R Square 0.0132
Adjusted R Square (0.0038)
Standard Error 0.0447
Observations 60

ANOVA
df SS MS F Significance F
Regression 1 0.0016 0.0016 0.7759 0.3820
Residual 58 0.1160 0.0020
Total 59 0.1176

Coefficients Standard Error t Stat P-value Lower 95%

Intercept 0.0099 0.0063 1.5714 0.1215 (0.0027)
S&P 500 0.1859 0.2111 0.8808 0.3820 (0.2366)

NVIDIA Output

Regression Statistics
Multiple R 0.3468
R Square 0.1203
Adjusted R Square 0.1051
Standard Error 0.0922
Observations 60

ANOVA
df SS MS F Significance F
Regression 1 0.0674 0.0674 7.9302 0.0066
Residual 58 0.4930 0.0085
Total 59 0.5604

Coefficients Standard Error t Stat P-value Lower 95%

Intercept 0.0309 0.0130 2.3833 0.0205 0.0049
S&P 500 1.2251 0.4350 2.8161 0.0066 0.3543
Upper 95%
0.0225
0.6084

Upper 95%
0.0569
2.0959
Date Sales Cash SUMMARY OUTPUT
Jan-12 3,997.93 253.31
Jan-13 4,280.16 430.62 Regression Statistics
Jan-14 4,130.16 1,151.01 Multiple R 0.7877
Jan-15 4,681.51 496.65 R Square 0.6204
Jan-16 5,010.00 596.00 Adjusted R Square 0.5255
Jan-17 6,910.00 1,766.00 Standard Error 392.5123
Observations 6

ANOVA
df SS
Regression 1 1,007,163.1063
Residual 4 616,263.5845
Total 5 1,623,426.6909

Coefficients Standard Error

Intercept (1,221.2989) 799.8386
Sales 0.4144 0.1621

Forecast Sales 8,260.00 Cash vs. Sales

Forecast Cash 2,201.57 2,000
1,800
1,600
f(x) = 0.41439133 x − 1221.2
1,400
1,200
Cash 1,000
800
600
400
200
0
3,500 4,500 5,500 6,50
Sales
 MS F Significance F
1,007,163.1063 6.5372 0.0629
154,065.8961

t Stat P-value Lower 95% Upper 95%

(1.5269) 0.2015 (3,442.0069) 999.4090
2.5568 0.0629 (0.0356) 0.8644

Cash vs. Sales

2,000
1,800
1,600
f(x) = 0.41439133 x − 1221.298937
1,400
1,200
1,000
Cash

800
600
400
200
0
3,500 4,500 5,500 6,500 7,500
Sales
 Cash vs. Sales
2,000
1,800
1,600
1,400 f(x) = 0.414391329862867 x − 1221.29893693666
1,200
1,000
Cash

800
600
400
200
0
3,500 4,000 4,500 5,000 5,500 6,000 6,500 7,000 7,500
Sales

Forecast Sales 8,260.00

Forecast Cash 2,201.64
6

00 7,500
 Jan-18* Jan-17 Jan-16 Jan-18*
Sales 8,260 6,910 5,010 Sales 8,260
Cost of Goods Sold ? 2,648 2,002 Cost of Goods Sold 3,233
Jan-17 Jan-16
6,910 5,010
2,648 2,002
Discretionary Financing Needed 84,296 =IF(B1>0,"Deficit",IF(B1<0,"Surplus","Balanced"))
 2017 2016
Interest Expense =IF(B6=0,C2,B3*B5+B4*B6) 175
Long-Term Debt 2,000
Notes Payable 500
Rate on LTD 10%
Rate on S.T. Notes 5%
Iteration 1
Date Sales 8,000.00
7,000.00
2012 3,997.93 6,000.00
2013 4,280.16 f(x)
5,000.00 = 494.3205 x + 3104.838
4,000.00
2014 4,130.16
3,000.00
2015 4,681.51 2,000.00
2016 5,010.00 1,000.00
0.00
2017 6,910.00 2012 2013 2014 2015 2016 2017
2018 6,565.08
104.838

2016 2017
Date Sales Cash SUMMARY OUTPUT
Jan-12 3,997.93 253.31
Jan-13 4,280.16 430.62 Regression Statistics
Jan-14 4,130.16 1,151.01 Multiple R 0.7877
Jan-15 4,681.51 496.65 R Square 0.6204
Jan-16 5,010.00 596.00 Adjusted R Square 0.5255
Jan-17 6,910.00 1,766.00 Standard Error 392.5123
Observations 6

ANOVA
df SS
Regression 1 1,007,163.1063
Residual 4 616,263.5845
Total 5 1,623,426.6909

Coefficients Standard Error

Intercept (1,221.2989) 799.8386
Sales 0.4144 0.1621
 MS F Significance F
1,007,163.1063 6.5372 0.0629
154,065.8961

t Stat P-value Lower 95% Upper 95%

(1.5269) 0.2015 (3,442.0069) 999.4090
2.5568 0.0629 (0.0356) 0.8644
Date Sales Cash SUMMARY OUTPUT
Jan-12 3,997.93 253.31
Jan-13 4,280.16 430.62 Regression Statistics
Jan-14 4,130.16 1,151.01 Multiple R 0.7877
Jan-15 4,681.51 496.65 R Square 0.6204
Jan-16 5,010.00 596.00 Adjusted R 0.5255
Jan-17 6,910.00 1,766.00 Standard Er 392.5123
Observation 6

ANOVA
df SS MS
Regression 1 1,007,163.1063 1,007,163.1063
Residual 4 616,263.5845 154,065.8961
Total 5 1,623,426.6909

Coefficients Standard Error t Stat

Intercept (1,221.2989) 799.8386 (1.5269)
Sales 0.4144 0.1621 2.5568
 F Significance F
6.5372 0.0629

P-value Lower 95% Upper 95%

0.2015 (3,442.0069) 999.4090
0.0629 (0.0356) 0.8644