In: Accounting
Template for Fiscal Year Ended |
1Q2017 |
2Q2017 |
3Q2017 |
4Q2017 |
1Q2018 |
Net Revenue |
$20,453 |
$24,090 |
$22,090 |
$23,317 |
$24,538 |
Gross Margin |
|||||
SGA% |
|||||
Operating Income |
$5,225 |
$6,177 |
$5,594 |
$22,326 |
$7,708 |
Net Income |
$4,690 |
$5,200 |
$4,801 |
$21,204 |
$6,576 |
Debt Ratio |
67% |
69% |
69% |
70% |
64% |
Working Capital |
$99,909 |
$74,162 |
$94,308 |
$95,324 |
$104, 216 |
Current Ratio |
2.69 |
2.05 |
2.81 |
2.48 |
3.12 |
Quick Ratio |
2.36 |
1.94 |
2.67 |
2.52 |
2.96 |
Inventory Turnover Ratio |
|||||
ROE |
4.73% |
7.01% |
5.09% |
6.83% |
6.01% |
ROA |
0.02 |
0.02 |
0.02 |
0.09 |
0.03 |
ROI |
Please determine the following values for all quarters: 1) gross margin 2) SGA 3) inventory turnover ratio 4) ROI
Able to solve only this part of table:
Current Assets – Current Liabilities = working capital
CA – CL = 99,909
CA = 99,909 + CL
Current Ratio = Current Assets/Current Liabilities
2.69 = 99,909 + CL / CL
2.69 CL - CL = 99,909
CL = 99,909 / 1.69 = $59,118
So, CA = 59,118 * 2.69 = 159,027
Now, you can find the value of Inventory from quick ratio
Quick Ratio = Quick Assets / Current Liabilities
2.36 = Quick Assets / 59118
Quick Assets = 139,518
Inventory = Current Assets – Quick Assets
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
|
Current Liabilities |
59118 |
70630 |
52104 |
62713 |
49158 |
Current Assets |
159027 |
144792 |
146412 |
158037 |
153373 |
Quick Assets |
139518 |
137022 |
139118 |
155528 |
145508 |
Inventory (CA - QA) |
19509 |
7770 |
7294 |
2509 |
7865 |
Net Sales |
20453 |
24090 |
22090 |
23317 |
24538 |
Ratio = Net Sales/Inventory |
1.05 |
3.10 |
3.03 |
9.29 |
3.12 |