AFM131 Lecture 12: Frequently Asked Questions F17

90 views2 pages

greenkangaroo86

4 Dec 2017

School

University of Waterloo

Department

Accounting & Financial Management

Course

AFM131

Professor

Bob Sproule

For unlimited access to Class Notes, a Class+ subscription is required.

qq919649100 and 39920 others unlocked

AFM131 Full Course Notes

Verified Note

22 documents

Document Summary

Percentage of students who failed the course (based on students who completed the course) Percentage of students with a grade of at least. 80% (based on students who completed the course) The amount of work varies greatly across students and depends on your background and aptitude for accounting. We recommend 2 to 3 hours of work outside of class for every hour of lecture; in other words, 6 to 9 hours per week in addition to the lectures and tutorials. Do the work each week; trying to learn the material in the last couple of days before the exam is a recipe for failure. We strongly believe that the best way to succeed in afm 101 is to do the assigned work each week. That means, carefully read the textbook and work through the assigned problems. Work through the self-study quizzes; don"t look ahead at the answers because the answers aren"t available on the exams.

Related Questions

Adam is a part-time employee who earned $495.00 during the mostrecent pay period. He is married with two withholding allowances.Prior to this pay period, his year-to-date pay is $6,492.39. Howmuch should be withheld from Adam's gross pay for Social Securitytax for the most recent period, assuming no pre-tax deductions?

$40.02

$30.69

$37.92

$28.46

Julian is a part-time, nonexempt employee in Texas who earns$21.50 per hour. During the last biweekly pay period he worked 45hours. He is single with one withholding allowance (use thewage-bracket table). What is his net pay? (Donot roundinterim calculations,only round finalanswer to twodecimal points.)

Wage Bracket Method Tables for Income TaxWithholding SINGLE Persons-BIWEEKLY PayrollPeriod (For Wages Paid through December 31,2015)
And the wages are		And the number of withholding allowances claimedis-
Atleast	But less than	0	1	2	3	4	5	6	7	8	9	10
Atleast	But less than	The amount of income tax to be withheld is-
$800	$820	$90	$67	$44	$26	$11	$0	$0	$0	$0	$0	$0
820	840	93	70	47	28	13	0	0	0	0	0	0
840	860	96	73	50	30	15	0	0	0	0	0	0
860	880	99	76	53	32	17	1	0	0	0	0	0
880	900	102	79	56	34	19	3	0	0	0	0	0
900	920	105	82	59	36	21	5	0	0	0	0	0
920	940	108	85	62	39	23	7	0	0	0	0	0
940	960	111	88	65	42	25	9	0	0	0	0	0
960	980	114	91	68	45	27	11	0	0	0	0	0
980	1,000	117	94	71	48	29	13	0	0	0	0	0
1,000	1,020	120	97	74	51	31	15	0	0	0	0	0
1,020	1,040	123	100	77	54	33	17	2	0	0	0	0
1,040	1,060	126	103	80	57	35	19	4	0	0	0	0
1,060	1,080	129	106	83	60	37	21	6	0	0	0	0
1,080	1,100	132	109	86	63	40	23	8	0	0	0	0
1,100	1,120	135	112	89	66	43	25	10	0	0	0	0
1,120	1,140	138	115	92	69	46	27	12	0	0	0	0
1,140	1,160	141	118	95	72	49	29	14	0	0	0	0
1,160	1,180	144	121	98	75	52	31	16	0	0	0	0
1,180	1,200	147	124	101	78	55	33	18	2	0	0	0
1,200	1,220	150	127	104	81	58	35	20	4	0	0	0
1,220	1,240	153	130	107	84	61	38	22	6	0	0	0
1,240	1,260	156	133	110	87	64	41	24	8	0	0	0
1,260	1,280	159	136	113	90	67	44	26	10	0	0	0
1,280	1,300	162	139	116	93	70	47	28	12	0	0	0
1,300	1,320	165	142	119	96	73	50	30	14	0	0	0
1,320	1,340	168	145	122	99	76	53	32	16	1	0	0
1,340	1,360	171	148	125	102	79	56	34	18	3	0	0
1,360	1,380	174	151	128	105	82	59	36	20	5	0	0
1,380	1,400	177	154	131	108	85	62	39	22	7	0	0
1,400	1,420	180	157	134	111	88	65	42	24	9	0	0
1,420	1,440	183	160	137	114	91	68	45	26	11	0	0
1,440	1,460	186	163	140	117	94	71	48	28	13	0	0
1,460	1,480	189	166	143	120	97	74	51	30	15	0	0
1,480	1,500	192	169	146	123	100	77	54	32	17	2	0
1,500	1,520	195	172	149	126	103	80	57	34	19	4	0
1,520	1,540	199	175	152	129	106	83	60	37	21	6	0
1,540	1,560	204	178	155	132	109	86	63	40	23	8	0
1,560	1,580	209	181	158	135	112	89	66	43	25	10	0
1,580	1,600	214	184	161	138	115	92	69	46	27	12	0
1,600	1,620	219	187	164	141	118	95	72	49	29	14	0
1,620	1,640	224	190	167	144	121	98	75	52	31	16	0
1,640	1,660	229	193	170	147	124	101	78	55	33	18	2
1,660	1,680	234	196	173	150	127	104	81	58	35	20	4
1,680	1,700	239	200	176	153	130	107	84	61	38	22	6
1,700	1,720	244	205	179	156	133	110	87	64	41	24	8
1,720	1,740	249	210	182	159	136	113	90	67	44	26	10
1,740	1,760	254	215	185	162	139	116	93	70	47	28	12
1,760	1,780	259	220	188	165	142	119	96	73	50	30	14
1,780	1,800	264	225	191	168	145	122	99	76	53	32	16
1,800	1,820	269	230	194	171	148	125	102	79	56	34	18
1,820	1,840	274	235	197	174	151	128	105	82	59	36	20
1,840	1,860	279	240	202	177	154	131	108	85	62	39	22
1,860	1,880	284	245	207	180	157	134	111	88	65	42	24
1,880	1,900	289	250	212	183	160	137	114	91	68	45	26
1,900	1,920	294	255	217	186	163	140	117	94	71	48	28
1,920	1,940	299	260	222	189	166	143	120	97	74	51	30
1,940	1,960	304	265	227	192	169	146	123	100	77	54	32
1,960	1,980	309	270	232	195	172	149	126	103	80	57	34
1,980	2,000	314	275	237	198	175	152	129	106	83	60	37
2,000	2,020	319	280	242	203	178	155	132	109	86	63	40
2,020	2,040	324	285	247	208	181	158	135	112	89	66	43
2,040	2,060	329	290	252	213	184	161	138	115	92	69	46
2,060	2,080	334	295	257	218	187	164	141	118	95	72	49
2,080	2,100	339	300	262	223	190	167	144	121	98	75	52
$2,100 and over			Use Table 2(a) for a SINGLE person on page 45. Also see theinstructions on page 43.
Page 52			Publication 15 (2015)

$818.40

$797.18

$825.99

$802.49

byzantiumporcupine251

Week One: Hands-on MIS Application Software ExerciseSolution

Store & Region Sales Database

This exercise helps students understand how a raw file of salestransactions can be analyzed to produce valuable information formanagers. Your challenge is to ask the right questionsabout the data and then present your case!

Import the data into Excel or Access (or compatiblespreadsheet/database). Use the data to perform the belowanalyses:

Analyze ALL THREE of the below items:

1.Best Performing Regions by TotalRevenue

2.Best Performing Stores by TotalRevenue

3.Best Selling Products by TotalRevenue

Select ONLY ONE of the below items:

A.Strongest Selling Period for eachProduct by Total Revenue

B.Strongest Selling Period for eachRegion by Total Revenue

C.Strongest Selling Period for eachStore by Total Revenue

Provide a business case â in the form of ONE descriptiveparagraph and ONE data table-- for eachanalysis. Each paragraph must refer to the informationpresented in the table using the labeled Table #. UseAPA format to label your tables.

SUBMITâ your final report with one WORDdocument and one EXCEL/ACCESS file.

Store & Region Sales Database
ID	StoreNo	SalesRegion	ItemNo	ItemDescription	UnitPrice	UnitsSold	WeekEnding
1	1	South	2005	17"Monitor	$229.00	28	10/27/10
2	1	South	2005	17"Monitor	$229.00	30	11/24/10
3	1	South	2005	17"Monitor	$229.00	9	12/29/10
4	1	South	3006	101Keyboard	$19.95	30	10/27/10
5	1	South	3006	101Keyboard	$19.95	35	11/24/10
6	1	South	3006	101Keyboard	$19.95	39	12/29/10
7	1	South	6050	PC Mouse	$8.95	28	10/27/10
8	1	South	6050	PC Mouse	$8.95	3	11/24/10
9	1	South	6050	PC Mouse	$8.95	38	12/29/10
10	1	South	8500	DesktopCPU	$849.95	25	10/27/10
11	1	South	8500	DesktopCPU	$849.95	27	11/24/10
12	1	South	8500	DesktopCPU	$849.95	33	12/29/10
13	2	South	2005	17"Monitor	$229.00	8	10/27/10
14	2	South	2005	17"Monitor	$229.00	8	11/24/10
15	2	South	2005	17"Monitor	$229.00	10	12/29/10
16	2	South	3006	101Keyboard	$19.95	8	10/27/10
17	2	South	3006	101Keyboard	$19.95	8	11/24/10
18	2	South	3006	101Keyboard	$19.95	8	12/29/10
19	2	South	6050	PC Mouse	$8.95	9	10/27/10
20	2	South	6050	PC Mouse	$8.95	9	11/24/10
21	2	South	6050	PC Mouse	$8.95	8	12/29/10
22	2	South	8500	DesktopCPU	$849.95	18	10/27/10
23	2	South	8500	DesktopCPU	$849.95	18	11/24/10
24	2	South	8500	DesktopCPU	$849.95	20	12/29/10
25	3	South	2005	17"Monitor	$229.00	38	10/27/10
26	3	South	2005	17"Monitor	$229.00	30	11/24/10
27	3	South	2005	17"Monitor	$229.00	3	12/29/10
28	3	South	3006	101Keyboard	$19.95	30	10/27/10
29	3	South	3006	101Keyboard	$19.95	32	11/24/10
30	3	South	3006	101Keyboard	$19.95	33	12/29/10
31	3	South	6050	PC Mouse	$8.95	25	10/27/10
32	3	South	6050	PC Mouse	$8.95	5	11/24/10
33	3	South	6050	PC Mouse	$8.95	26	12/29/10
34	3	South	8500	DesktopCPU	$849.95	28	10/27/10
35	3	South	8500	DesktopCPU	$849.95	27	11/24/10
36	3	South	8500	DesktopCPU	$849.95	29	12/29/10
37	4	North	2005	17"Monitor	$229.00	18	10/27/10
38	4	North	2005	17"Monitor	$229.00	20	11/24/10
39	4	North	2005	17"Monitor	$229.00	4	12/29/10
40	4	North	3006	101Keyboard	$19.95	12	10/27/10
41	4	North	3006	101Keyboard	$19.95	24	11/24/10
42	4	North	3006	101Keyboard	$19.95	36	12/29/10
43	4	North	6050	PC Mouse	$8.95	29	10/27/10
44	4	North	6050	PC Mouse	$8.95	11	11/24/10
45	4	North	6050	PC Mouse	$8.95	38	12/29/10
46	4	North	8500	DesktopCPU	$849.95	21	10/27/10
47	4	North	8500	DesktopCPU	$849.95	24	11/24/10
48	4	North	8500	DesktopCPU	$849.95	30	12/29/10
49	5	North	2005	17"Monitor	$229.00	27	10/27/10
50	5	North	2005	17"Monitor	$229.00	25	11/24/10
51	5	North	2005	17"Monitor	$229.00	23	12/29/10
52	5	North	3006	101Keyboard	$19.95	80	10/27/10
53	5	North	3006	101Keyboard	$19.95	82	11/24/10
54	5	North	3006	101Keyboard	$19.95	75	12/29/10
55	5	North	6050	PC Mouse	$8.95	65	10/27/10
56	5	North	6050	PC Mouse	$8.95	24	11/24/10
57	5	North	6050	PC Mouse	$8.95	55	12/29/10
58	5	North	8500	DesktopCPU	$849.95	55	10/27/10
59	5	North	8500	DesktopCPU	$849.95	57	11/24/10
60	5	North	8500	DesktopCPU	$849.95	47	12/29/10
61	6	East	2005	17"Monitor	$229.00	24	10/27/10
62	6	East	2005	17"Monitor	$229.00	85	11/24/10
63	6	East	2005	17"Monitor	$229.00	56	12/29/10
64	6	East	3006	101Keyboard	$19.95	52	10/27/10
65	6	East	3006	101Keyboard	$19.95	58	11/24/10
66	6	East	3006	101Keyboard	$19.95	69	12/29/10
67	6	East	6050	PC Mouse	$8.95	35	10/27/10
68	6	East	6050	PC Mouse	$8.95	39	11/24/10
69	6	East	6050	PC Mouse	$8.95	44	12/29/10
70	6	East	8500	DesktopCPU	$849.95	78	10/27/10
71	6	East	8500	DesktopCPU	$849.95	88	11/24/10
72	6	East	8500	DesktopCPU	$849.95	99	12/29/10
73	7	East	2005	17"Monitor	$229.00	34	10/27/10
74	7	East	2005	17"Monitor	$229.00	36	11/24/10
75	7	East	2005	17"Monitor	$229.00	35	12/29/10
76	7	East	3006	101Keyboard	$19.95	49	10/27/10
77	7	East	3006	101Keyboard	$19.95	47	11/24/10
78	7	East	3006	101Keyboard	$19.95	48	12/29/10
79	7	East	6050	PC Mouse	$8.95	45	10/27/10
80	7	East	6050	PC Mouse	$8.95	42	11/24/10
81	7	East	6050	PC Mouse	$8.95	45	12/29/10
82	7	East	8500	DesktopCPU	$849.95	55	10/27/10
83	7	East	8500	DesktopCPU	$849.95	57	11/24/10
84	7	East	8500	DesktopCPU	$849.95	55	12/29/10
85	8	East	2005	17"Monitor	$229.00	18	10/27/10
86	8	East	2005	17"Monitor	$229.00	17	11/24/10
87	8	East	2005	17"Monitor	$229.00	23	12/29/10
88	8	East	3006	101Keyboard	$19.95	22	10/27/10
89	8	East	3006	101Keyboard	$19.95	18	11/24/10
90	8	East	3006	101Keyboard	$19.95	22	12/29/10
91	8	East	6050	PC Mouse	$8.95	14	10/27/10
92	8	East	6050	PC Mouse	$8.95	16	11/24/10
93	8	East	6050	PC Mouse	$8.95	17	12/29/10
94	8	East	8500	DesktopCPU	$849.95	32	10/27/10
95	8	East	8500	DesktopCPU	$849.95	28	11/24/10
96	8	East	8500	DesktopCPU	$849.95	30	12/29/10

viridianswan15

I need these ratios:

Return on Assets

Return on Equity

Return on invested capital

Profit Margin

Gross Margin

Price to earnings

Asset Turnover

Fixed-Asset Turnover

Inventory Turnover

Collection Period

Days' sales in cash

Payables Period

Assets to Equity

Debt to assets

Debt to equity

Times Interest earned

Times Burden covered

Current Ratio

Acid Test

I need these calculated from bellow along with the common-sizeincome statement and common-size balance sheet from the five yearslisted below:

RUBY TUESDAY INC (RT)Statement of CASH FLOW
Fiscal year ends in May. USD in millionsexcept per share data.	2010-05	2011-05	2012-05	2013-05	2014-05	TTM
Cash Flows From Operating Activities
Net income	45	47	0	-39	-64	-8
Depreciation & amortization	64	64	68	63	57	53
Amortization of debt discount/premium andissuance costs			0	-1
Investment/asset impairment charges	3	7	31	44	25	11
Deferred income taxes	20	-1	-20	-16	2	-1
Stock based compensation	7	8	6	4	8	7
Inventory	-8	-2	6	-2	10	0
Prepaid expenses	-2	-1	-1	-2	-1	-3
Income taxes payable	10	-4	2	-1	0	2
Other working capital	-3	5	19	-19	-6	-26
Other non-cash items	4	-5	2	4	16	9
Net cash provided by operatingactivities	140	116	112	36	45	44
Cash Flows From Investing Activities
Investments in property, plant, andequipment	-18	-27	-38	-37	-28	-27
Property, plant, and equipmentreductions			6
Acquisitions, net		-4	-24
Other investing activities	8	6	22	59	22	16
Net cash used for investingactivities	-9	-24	-34	22	-6	-11
Cash Flows From Financing Activities
Debt issued			246
Debt repayment	-204	-91	-263	-27	-40	-16
Common stock issued	73
Common stock repurchased			-18	-30	-1	0
Excess tax benefit from stock basedcompensation		1	0	0	0	0
Other financing activities		-1	-5	4	0	0
Net cash provided by (used for) financingactivities	-131	-92	-40	-53	-41	-16
Net change in cash	0	0	38	5	-2	17
Cash at beginning of period	10	10	10	48	53	44
Cash at end of period	10	10	48	53	51	61
Free Cash Flow
Operating cash flow	140	116	112	36	45	44
Capital expenditure	-18	-27	-38	-37	-28	-27
Free cash flow	123	90	74	-1	17	17

RUBY TUESDAY INC (RT)CashFlowFlag BALANCE SHEET
Fiscal year ends in May. USD in millionsexcept per share data.	2010-05	2011-05	2012-05	2013-05	2014-05
Assets
Current assets
Cash
Cash and cash equivalents		10	48	53	51
Total cash		10	48	53	51
Receivables	10	7	1	1	1
Inventories	29	34	29	31	21
Deferred income taxes	14	14	27	7	3
Prepaid expenses	11				12
Other current assets	13	17	23	29	11
Total current assets	76	83	128	121	100
Non-current assets
Property, plant and equipment
Gross property, plant and equipment	1466	1597	1559	1448	1367
Accumulated Depreciation	-523	-566	-592	-589	-572
Net property, plant and equipment	943	1031	967	860	795
Goodwill		16	8
Intangible assets					13
Other long-term assets	44	57	71	62	49
Total non-current assets	988	1104	1045	922	857
Total assets	1064	1187	1174	1043	956
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	13
Capital leases		15	12	8	5
Accounts payable	23	30	35	15	26
Taxes payable	21	41	47	11	11
Accrued liabilities	27			25	55
Deferred revenues	8	9	9	13	17
Other current liabilities	22	24	29	32
Total current liabilities	115	119	132	106	114
Non-current liabilities
Deferred taxes liabilities	40	43	38	6	4
Deferred revenues	42	60	68	78	75
Other long-term liabilities	329	373	359	337	303
Total non-current liabilities	411	476	465	421	381
Total liabilities	526	595	597	526	495
Stockholders' equity
Common stock		1	1	1	1
Additional paid-in capital	98	105	91	68	76
Retained earnings	452	499	499	460	395
Accumulated other comprehensiveincome	-13	-13	-14	-11	-11
Total stockholders' equity	538	592	576	517	461
Total liabilities and stockholders'equity	1064	1187	1174	1043	956

RUBY TUESDAY INC (RT)CashFlowFlag INCOME STATEMENT
Fiscal year ends in May. USD in millionsexcept per share data.	2010-05	2011-05	2012-05	2013-05	2014-05	TTM
Revenue	1195	1265	1326	1251	1169	1137
Cost of revenue	982	1045	1106	1020	986	942
Gross profit	213	221	220	231	182	195
Operating expenses
Sales, General and administrative	71	86	115	139	137	117
Other operating expenses	68	69	101	59	115	87
Total operating expenses	138	155	215	198	252	204
Operating income	74	66	5	33	-70	-8
Interest Expense	17	13
Other income (expense)	1	0	-20	-55
Income before taxes	58	53	-15	-22	-70	-8
Provision for income taxes	12	6	-15	2	-5	0
Net income from continuing operations	45	47	0	-23	-65	-8
Net income from discontinuing ops				-16	1	0
Net income	45	47	0	-39	-64	-8
Net income available to commonshareholders	45	47	0	-39	-64	-8
Earnings per share
Basic	0.74	0.73		-0.65	-1.07	-0.13
Diluted	0.73	0.72		-0.65	-1.07	-0.13
Weighted average shares outstanding
Basic	62	64	63	61	60	60
Diluted	62	65	63	61	60	60
EBITDA	140	130	72	97	-12	45

champagneporcupine90

AFM131 Lecture 12: Frequently Asked Questions F17

AFM131 Full Course Notes

Document Summary

Get access

Related Documents

AFM131 Lecture Notes - Lecture 6: Regional Municipality Of Waterloo, North American Free Trade Agreement, John Tory

PHY131H1 Lecture Notes - Qr Decomposition, Academic Integrity, Simple Math

SOCL 3371 Chapter : SOCL 3371 Fall 2015 Syllabus 8

Related Questions