Income Statement

Year Ending December 31, 2017

Sales revenue $6,075,000

Less: Cost of goods sold - 4,000,200

Gross Profit $2,074,800

Less: Operating Expenses

Selling expenses $650,000

General and administrative expenses 326,000

Lease payments 50,000

Depreciation expense 152,000

Total operating expense $1,178,000

Operating Profit (EBIT) $896,800

Less : Interest expense - 99,500

Net profit before taxes $797,300

Less: Taxes (rate = 40%) - 318,920

Net Profit after taxes $ 478,380

Earnings per share: $4.78

Dividends per share: $4.58

Balance Sheets

December 31

Assets 2017 2016

Current assets

Cash $ 25,000 $ 24,100

Accounts receivable 805,556 763,900

Inventories 700,625 763,445

Total current assets $1,531,181 $1,551,445

Gross fixed assets (at cost) $2,593,819 $1,691,707

Less: Accumulated depreciation 600,000 348,000

Net fixed assets $1,993,819 $1,343,707

Total assets $3,525,000 $2,895,152

Liabilities and Stockholders Equity

Current liabilities

Accounts payable $ 230,000 $ 400,450

Notes payable 311,000 370,000

Accruals 75,000 100,902

Total current liabilities $ 616,000 $ 871,352

Long-term debt $1,565,200 $ 700,000

Total liabilities $2,181,200 $1,571,352

Stockholders equity

Common stock (100,000 shares at $4 par)^a 400,000 400,000

Paid-in capital in excess of par value 643,800 643,800

Retained earnings 300,000 280,000

Total stockholders equity $1,343,800 $1,323,800

Total liabilities and stockholders equity $3,525,000 $2,895,152

Garcia Energys 100,000 shares of common stock closed on 12/31/ 17 at a price of $54.00 per share.

Garcia Energy Historical & Industry Average Ratios
Ratio	Actual 2015	Actual 2016	Actual 2017	Industry Average 2017
a. Net cash flow	$592,182	$615,869		Varies by size
b. Net operating profit after tax	$494,272	$518,086		Varies by size
c. Market value added	$2,984,667	$3,011,747		Varies by size
d. Current ratio	1.7	1.8		1.5
e. Quick ratio	1.0	0.9		1.2
f. Inventory turnover (times)	5.2	5.0		10.2
g. Days sales outstanding (DSO)	50.7 days	55.8 days		46 days
h. Fixed asset turnover (times)	4.1	3.7		3.9
i. Total asset turnover (times)	1.5	1.5		2.0
j. Debt-to-assets ratio	45.8%	52.8%		24.5%
k. Times interest earned ratio	10.2	10.9		12.5
l. EBITDA coverage ratio	8.6	8.0		7.75
m. Basic earnings power	24.0%	22.0%		21.5%
n. Net profit margin	6.0%	7.2%		1.2%
o. Return on assets (ROA)	12.2%	11.0%		2.4%
p. Return on common equity (ROE)	21.1%	26.3%		17.9%
q. Price/earnings (P/E) ratio	9.8	10.2		10.1
r. Market value/book (M/B) ratio	3.2	3.36		3.5

Hello, I need help filling out the Actual 2017 for column a through r.