Find the ROA and Financial Leverage for Potbelly Corporation 2015. Use highlighted excel information, explain any rules and steps please HomeInsertDrawPage LayoutFormulasDataReviewViewData MiningAnalytic SolverO Tell mee ShareO CommentsA Aマ0.Cambria11!!22 Wrap Text vCustomA InsertvΣ.EX Delete vPasteBIUV田、A$ v % 2Sort &Ov FilterE E Merge & Center vConditional FormatFormatting as Table StylesCellFind &SelectIdeasSensitivityH Format vB38v fx 12/31/2014K1 Data Date Data Year- Fiscal38 31Dec1439 31Dec1540 31Dec1641 31Dec1742 31Dec1443 31Dec15Company NamePOTBELLY CORPTotal AssetsCash and Short-Term Investments63.0050Current Liabilities - TotalTotal Liabilities and Stockholders EquityTotal Liabilities35.622044.2940Net Income (Loss)Operating Activities - Net Cash26.55402014191.947020.8840191.94704.35802015POTBELLY CORPPOTBELLY CORPPOTBELLY CORPDEL TACO RESTAURANTSINCDEL TACO RESTAURANTS INC174.507032.006025.1820174.50705.628040.32002016175.445023.3790278150175.445051.20908.212045.96902017170.730025.530027.3520170.730053.4920-6.956041.81902014150.34700.23000.6600150.34705.9100-1.5250-0.84802015703.572010.194051.4530703.5720335.19504.757027.1680 Conditional FormatCellen v AvE Merge & Center v$ - % 9PasteBIUVFormatting as Table StylesA Format vH38V fx 191.947KMNH.Operating Activities - Net Cash Flow26.5540Total ReceivablesNet SalesTotal Interest and Related ExpenseNet Income Loss)4.3580Total LiabilitiesTotal Liabilities and Stockholders Equity191.9470135.62204.0160326.97900.17903844.29405.628040.32004.4610372.84900.221039174.507051.2090407.13100.134045.969041.819040175.44508.21203.787053.4920-6.95605.0870428.11100.124041170.73000.0000424.00205.9100-1.5250-0.84800.00100.000042150.3470703.5720335.19504.757027.16803.220015.208043349.824020.913057.54604.1410452.08306.427044727.1570

Answered: 38 : x v fx 12/31/2014 H Data Date Data…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Question

Find the ROA and Financial Leverage for Potbelly Corporation 2015. Use highlighted excel information, explain any rules and steps please

Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Data Mining
Analytic Solver
O Tell me
e Share
O Comments
A A
マ0.
Cambria
11
!!
22 Wrap Text v
Custom
A Insertv
Σ.
EX Delete v
Paste
BIUV
田、
A
$ v % 2
Sort &
Ov Filter
E E Merge & Center v
Conditional Format
Formatting as Table Styles
Cell
Find &
Select
Ideas
Sensitivity
H Format v
B38
v fx 12/31/2014
K
1 Data Date Data Year- Fiscal
38 31Dec14
39 31Dec15
40 31Dec16
41 31Dec17
42 31Dec14
43 31Dec15
Company Name
POTBELLY CORP
Total Assets
Cash and Short-Term Investments
63.0050
Current Liabilities - Total
Total Liabilities and Stockholders Equity
Total Liabilities
35.6220
44.2940
Net Income (Loss)
Operating Activities - Net Cash
26.5540
2014
191.9470
20.8840
191.9470
4.3580
2015
POTBELLY CORP
POTBELLY CORP
POTBELLY CORP
DEL TACO RESTAURANTSINC
DEL TACO RESTAURANTS INC
174.5070
32.0060
25.1820
174.5070
5.6280
40.3200
2016
175.4450
23.3790
278150
175.4450
51.2090
8.2120
45.9690
2017
170.7300
25.5300
27.3520
170.7300
53.4920
-6.9560
41.8190
2014
150.3470
0.2300
0.6600
150.3470
5.9100
-1.5250
-0.8480
2015
703.5720
10.1940
51.4530
703.5720
335.1950
4.7570
27.1680

Conditional Format
Cell
en v Av
E Merge & Center v
$ - % 9
Paste
BIUV
Formatting as Table Styles
A Format v
H38
V fx 191.947
K
M
N
H.
Operating Activities - Net Cash Flow
26.5540
Total Receivables
Net Sales
Total Interest and Related Expense
Net Income Loss)
4.3580
Total Liabilities
Total Liabilities and Stockholders Equity
191.9470
1
35.6220
4.0160
326.9790
0.1790
38
44.2940
5.6280
40.3200
4.4610
372.8490
0.2210
39
174.5070
51.2090
407.1310
0.1340
45.9690
41.8190
40
175.4450
8.2120
3.7870
53.4920
-6.9560
5.0870
428.1110
0.1240
41
170.7300
0.0000
424.0020
5.9100
-1.5250
-0.8480
0.0010
0.0000
42
150.3470
703.5720
335.1950
4.7570
27.1680
3.2200
15.2080
43
349.8240
20.9130
57.5460
4.1410
452.0830
6.4270
44
727.1570

Expert Solution

Step 1

Return on asset is the calculated by dividing net income by total asset.

formula:

$R O A = \frac{n e t i n c o m e}{t o t a l a v e r a g e a s s e t s}$

Financial leverage is found out by dividing assets by equity.

formula:

$f i n a n c i a l l e v e r a g e = \frac{a v e r a g e t o t a l a s s e t s}{e q u i t y}$

Step 2

according to excel,

Potbelly Corporation 2015:

net income = 5.6280

$\begin{array}{rcl} t o t a l s h a r e h o l d e r' s e q u i t y & = & (t o t a l s h a r e h o l d e r s e q u i t y + l i a b i l i t y) - t o t a l l i a b i l i t y \\ = & 174.5070 - 44.2940 \\ = & 130.213 \end{array}$

$\begin{array}{rcl} a v e r a g e t o t a l a s s e t & = & \frac{b e g i n n i n g + e n d i n g t o t a l a s s e t s}{2} \\ = & \frac{191.9470 + 174.5070}{2} \\ = & 183.227 \end{array}$

Step by step

Solved in 3 steps

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS