Question

In: Accounting

Balance Sheet As of December 31,2016 Assets Cash and equivalents 295,500 Accounts receivable 875,000 Inventory 437,500...

Balance Sheet

As of December 31,2016

Assets

Cash and equivalents 295,500

Accounts receivable 875,000

Inventory 437,500

Total Current Assets 1,608,000

Plant and equipment 475,000

Accumulated depreciation (234,550)

Net Fixed Assets 240,450

Total Assets 1,848,450

Liabilities and Owner’s Equity

Accounts payable 306,250

Short-term notes payable 88,185

Other current liabilities 18,200

Total Current Liabilities 412,635

Long-term debt 495,800

Total Liabilities 908,435

Common Stock 700,000

Retained earnings 240,015

Total Shareholder’s Equity 940,015

Total Liabilities and Owner’s Equity 1,848,450ZHIAO-WAY Inc.

Income Statement

For the year Ended December 31, 2016

Sales 1,750,000

Cost of goods sold 1,225,000

Gross Profit 525,000

Selling and G & A Expenses 262,500

Fixed Expenses 43,750

Depreciation Expense 80,000

EBIT 138,750

Interest Expense 56,800

Earnings Before Taxes 81,950

Taxes @30% 24,585

Net Income 57,365

Note: Inv. Turnover uses C.G.S. instead of Sales for computation.

i.e.,

Inv. Turn = C.G.S. / Inv.

SPREADSHEET ASSIGNMENT # 1: “Zhiao-Way Inc.”/Fin502/WI18

“nc.” sells two grades of asphalt. In 2017 sales for the two grades were $1,200,000 for Grade 1,

and $865,000 for Grade 2. Cost of goods sold for the two grades were 68% and 60% of sales, respectively.

Selling and G & A expenses continued to increase at a rate of 14% a year. Fixed expenses increased to $75,000,

and $125,000 in depreciation allowance was taken.

also has $180,000 in short-term debt at 6% interest, and has increased its long-term debt by

$105,000 to partially pay for new equipment of $255,000. The remainder of the equipment was paid in cash.

All long-term debt carries an interest rate of 8%. The corporation’s tax rate is 30% in 2017. Accounts

receivable is at 38% of sales, and inventory at year end is 28% of sales. Accounts payable are held at 25% of

the cost of goods sold. Other current liabilities are $33,000. Common stock remained constant.

The firm retained 65% of its earnings, paying the remaining net income out as dividends. ( Round retained

earnings up to the next dollar.)

1. Prepare “Zhiao-Way Inc.”’s income statement, balance sheet and statement of cash flow for the year 2017,

and as of December 31, 2017. The firm’s 2016 statements are (next page):

2. Compute “.”’s free cash flow for 2017, and its Return On Invested Capital (ROIC) for the

years 2016, and 2017.

3. Given that “ Inc.”’s Weighted Average Cost of Capital (WACC) was 9.25% in 2016 and 2017,

compute its Economic Value Added (EVA) for the years, 2016 and 2017.

4. The industry averages are also provided. Compute “Zhiao-Way Inc.” ’s corresponding ratios for 2016 and

2017, and give a concise evaluation of “ Inc.”’s financial position.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!I have done the work I just want to double check.!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

FIN 502

SPREADSHEET ASSIGNMENT # 1: “ Inc.”/Fin502/WI18

1. Prepare “Inc.”’s income statement, balance sheet and statement of cash flow for the year 2017, and as of

December 31, 2017. The firm’s 2016 statements are (next page):

Income Statement

For the year Ended December 31, 2017

GRADE 1 GRADE 2 TOTAL

SALE $1,200,000 $865,000 $2,065,000

COST OF GOOD SOLD 68%/60% $816,000 $519,000 $1,335,000

GROSS PROFIT $730,000

SELLING EXP 14% MORE $299,250

DEPREDAITION $125,000

EBIT $305,750

INTERES EXPENS

SHORT TERM DEBT 6% $180,000 $10,800

LONG TERM DEBT 8% $105,000 $8,400

EBT $286,550

TAX 30% $85,965

PAT $200,585

RETAIN EARNINGS 65% $130,380

ZHIAO-WAY INC BALANCE SHEET AS OF DECEMBER 31 2017

ASSETS LIABILITY & EQUITY

CASH AND EQUIVALENT 244580 ACC PAYBLE 25% COGS 333750

ACC RECIVEBLE 25% COGS 784700 SHORT TERM NOTE PAYBLE 180000

INVENTORY 28% SALE 578200 OTHER CURENT LIABILITES 33000

TOTAL CURRENT ASSET 1607480 TOTAL CURENT LIABILITES 546750

PLANT AND EQUIPMENT 730000 LONG TERM DEBT 600800

ACCUMULATED DEPRECIATION 359550 TOTAL LIABILITES 1147550

NET FIX ASSET 370450 COMMON STOCKS 700000

RETAIN EARNINGS 130380

Mb

TOTAL ASSET 1977930 TOTAL SHERHOLDER EQUITY 1977930

Cash Flow Statement Dec 2017

Operating Activity

Net income $200,585.00

Depreciation $125,000.00

Acount Reciveble $90,300.00

Inventory -$140,700.00

Acount Payble $152,500.00

Other curent liability $15,000.00

Cash Flow From Operating Activity $442,685.00

Investing Activity

Plant and Equipment -$255,000.00

Cash Flow From Investing Activity $187,685.00

Financing Activity

Short Term note payble $91,815.00

Long term note Payble $105,000.00

Comon stock $-

Divident paid $-

Add beginning cash balance $295,500.00

Ending cash Balance $680,000.00

2. Compute “ Inc.”’s free cash flow for 2017, and its Return On Invested Capital (ROIC) for the years 2016,

and 2017.

Free cash Flow = EBIT *(1-Tax) + Depreciation – Capital Expentiture – Change Working capital

FCF= 305750 * 0.7 + 125000 – 255000 – 375085

FCF= - 291060

ROIC= NOPAT/ INVESTED CAPITAL

2016 ROIC= 57365/1848450=3.1%

2017 ROIC=200585/ 1431180= 14%

3. Given that Inc.”’s Weighted Average Cost of Capital (WACC) was 9.25% in 2016 and 2017, compute its

Economic Value Added (EVA) for the years, 2016 and 2017.

EVA=NOPAT –WACC (OPERATING CAPITAL)

2016 EVA= 57365- (9.25%* 297815) = 57365-27547=29817

2017 EVA=200585- (9.25%*571035) =200585-52820=147764

Expert Solution



	Errors you made

1	Interest on Long term Notes
	=	105000+495800	*	8%
	=	600800	*	8%
	=		48064		48064
2	You have forgot to take fixed expense of 75000
3	Income statement		Revised
	EBT		171886			299250
	Tax		51565.8
	PAT		120320.2
	Dividends		42112
	Transfer to Retained earning		78208

4	Balance sheet

	Asset
	Cash & cash equilients			432423
	Accounts receivable			784700	875000	90300
	Inventory			578200	437500	140700
	Total current assets			1795323	2165773
	Plant & equipement			730000
	Less; Accumulated depreciation			359550
	Net fixed assets			370450
	Total assets			2165773

	Liabilities & Owner's equity
	Accounts payable			333750	306250	27500
	Short term Notes payable			180000
	Other current liabilties			33000
	Long term Notes payable			600800
	Total Liabilities			1147550
	Common stock			700000
	Retained earnings			318223
	Total shareholder's equity			1018223
	Total Liabilities & Owner's equity			2165773

4	Cash flow
	EBT			120320.2
	Depreication			125000
	Accounts receivable			90300
	Inventory			-140700
	Other current liabilties			14800
	Accounts payable			27500
	Cash flow from operating activities			237220.2

	Investing activities
	Purchase of plant			-255000
	Cash flow from Investing activities			-255000
	Financing activities
	Short term Notes payable			91815
	Long term Notes payable			105000
	Dividend paid			-42112
	Cash flow from financing activities			154703
	Total cash inflow			136923
	Beginning cash balance			295500
	Ending cash balance			432423
				432423


FCF	=	230750	*0.70	+125000	-(-8100)	-255000
	=	108850

Calculate EVA accordingly, as per your assumption of operating capital

Thank you

ekkarill92 answered 1 year ago

SMC, Inc. Balance Sheet December 31, 2018 Assets Cash ... $34,500 Accounts receivable .25,000 Inventory ..10,000...

SMC, Inc. Balance Sheet December 31, 2018 Assets Cash ... $34,500 Accounts receivable .25,000 Inventory ..10,000 Supplies .. 200 Total assets.. $69,700 Liabilities and Stockholders’ Equity Liabilities: Accounts payable .. $12,000 Salaries payable .. 1,000 Income taxes payable .. 3,675 Total liabilities.. $16,675 Stockholders’ equity: Capital stock (10,000 shares outstanding).. $25,000 Retained earnings .. 28,025 Total stockholders’ equity ...53,025 Total liabilities and stockholders’ equity.. $69,700 SMC, Inc. Income Statement For the Year Ended December31,2018 Sales revenue .. $110,000 Rent revenue.....

Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts...

Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts Receivable $25,000.00 Inventory $10,000.00 Inventory $15,000.00 Total current assets $45,000.00 Total current assets $50,000.00 Net Plant and equipment $50,000.00 Net Plant and equipment $60,000.00 Total assets $95,000.00 Total assets $110,000.00 Liabilities and equity Liabilities and equity Accounts payable $5,000.00 Accounts payable $7,000.00 Accruals $2,000.00 Accruals $3,000.00 Notes payable $10,000.00 Notes payable $5,000.00 Total current liabilities $17,000.00 Total current liabilities $15,000.00 Long term debts $25,000.00...

Exam 3 Softbyte Inc. Balance Sheet December 31, 2012 Assets Cash $500,000 Accounts Receivable 700,000 Inventory...

Exam 3 Softbyte Inc. Balance Sheet December 31, 2012 Assets Cash $500,000 Accounts Receivable 700,000 Inventory 300,000 Property, Plant & Equipment 900,000 Accumulated Depreciation (100,000) 800,000 Total Assets $2,300,000 Liabilities & Equity Accounts Payable $300,000 Notes Payable 1,000,000 Common Stock 500,000 Retained Earnings 500,000 Total Liabilities & Equity $2,300,000 Instructions: Open the balances in the T-accounts (general ledger). Post the journal entries to the T-accounts (general ledger). Prepare an income statement, statement of retained earnings, balance sheet, and statement of...

Exam 2 Softbyte Inc. Balance Sheet December 31, 2012 Assets Cash $500,000 Accounts Receivable 700,000 Inventory...

Exam 2 Softbyte Inc. Balance Sheet December 31, 2012 Assets Cash $500,000 Accounts Receivable 700,000 Inventory 300,000 Property, Plant & Equipment 900,000 Accumulated Depreciation (100,000) Total Assets $2,300,000 Liabilities & Equity Accounts Payable $300,000 Notes Payable 1,000,000 Common Stock 500,000 Retained Earnings 500,000 Total Liabilities & Equity $2,300,000 Instructions: Open the balances in the T-accounts (general ledger). Post the journal entries to the T-accounts (general ledger). Prepare an income statement, statement of retained earnings, balance sheet, and statement of cash...

SMC, Inc. Balance Sheet December 31, 2017 Assets Cash ......................................................................................................... $34,500 Accounts receivable ...................................................................

SMC, Inc. Balance Sheet December 31, 2017 Assets Cash ......................................................................................................... $34,500 Accounts receivable ................................................................................ 25,000 Inventory .................................................................................................. 10,000 Supplies ................................................................................................... 200 Total assets.............................................................................................. $69,700 Liabilities and Stockholders’ Equity Liabilities: Accounts payable ............................................................................. $12,000 Salaries payable ............................................................................... 1,000 Income taxes payable ...................................................................... 3,675 Total liabilities.......................................................................................... $16,675 Stockholders’ equity: Capital stock (10,000 shares outstanding).................................... $25,000 Retained earnings ............................................................................ 28,025 Total stockholders’ equity ....................................................................... 53,025 Total liabilities and stockholders’ equity................................................ $69,700 SMC, Inc. Income Statement For the Year Ended December31,2017 Sales revenue .............................................................................................

BALANCE SHEET ASSETS LIABILITY AND EQUITY CASH 23 ACCOUNTS PAYABLE 1,245 CASH EQUIVALENTS 435...

BALANCE SHEET ASSETS LIABILITY AND EQUITY CASH 23 ACCOUNTS PAYABLE 1,245 CASH EQUIVALENTS 435 ACCRUED EXPENSES 1,549 ACCOUNTS RECEIVABLE 1,827 DEFFERED TAX LIABILITY 712 INVENTORY 2,876 PROPERTY,PLANT, EQUIP 3,567 LONG-TERM DEBT 3,678 TOTAL ASSESTS 8,728 PREFFERED STOCK 432 COMMON EQUITY 1,112 LIABILITIES AND EQUITY $8,728 INCOME STATEMENT REVENUES 7,493 OPERATING EXPENSES 6,321 INTEREST EXPENSE 221 INCOME BEFORE TAX 951 INCOME TAX 295 NET INCOME 656 PREFFERED DIVIDENDS 26 NET INCOME AVAILABLE TO COMMON 630 Reformulate the following balance...

Devin E Corporation Balance Sheet As of December 31, 2015 2014 Assets: Cash & Cash Equivalents...

Devin E Corporation Balance Sheet As of December 31, 2015 2014 Assets: Cash & Cash Equivalents $41,900 $25,000 Accounts Receivable 24,000 6,250 Inventory 30,000 36,000 Current Assets 95,900 67,250 Land 25,000 10,000 Equipment 42,000 38,500 Less: Accumulated Depreciation (14,000) (7,000) 53,000 41,500 Total Assets 148,900 108,750 Liabilities: Accounts Payable 17,500 22,500 Accrued Salaries Payable 5,500 8,000 Rent Expense Payable 2,200 1,000 Income Tax Payable 6,900 4,000 Current Liabilities 32,100 35,500 Long-term notes payable 50,000 30,000 Total Liabilities 82,100 65,500...

Balance Sheet for J & P Industries 2018 Current assets Cash 215 Accounts receivable 310 Inventory...

Balance Sheet for J & P Industries 2018 Current assets Cash 215 Accounts receivable 310 Inventory 328 Total current assets 853 Fixed assets Net plant and equipment 6,527 Total assets 7,380 Current liabilities Accounts payable 298 Notes payable 1,427 Total currrent liabilities 1,725 Long-term debt 2,308 Owners' equity Common stock and paid in surplus 1,000 Retained earnings 2,347 Total owners' equity 3,347 Total liabilities and owners' equity 7,380 Income Statement for J & P Sales 4,053.00 Cost of goods sold...

Balance Sheet ASSETS Cash $96,000 Accounts receivable 31,000 Inventory 41,000 Prepaid expenses 18,000 Total current assets...

Balance Sheet ASSETS Cash $96,000 Accounts receivable 31,000 Inventory 41,000 Prepaid expenses 18,000 Total current assets $186,000 Gross plant and equipment 403,000 Accumulated depreciation (69,000) Total assets $520,000 LIABILITIES AND OWNERS' EQUITY Accounts payable $89,000 Accrued liabilities 62,000 Total current liabilities $151,000 Long-term debt 130,000 Common stock 206,000 Retained earnings 33,000 Total liabilities and equity $520,000 Income Statement Sales* $211,000 Cost of goods sold (85,000) Gross profit $126,000 Selling, general, and administrative expenses (27,000) Depreciation expenses (28,000) Operating income $71,000...

Hamby Corporation Balance Sheet June 30 Assets Cash $ 71,000 Accounts receivable 131,000 Inventory 45,500 Plant...

Hamby Corporation Balance Sheet June 30 Assets Cash $ 71,000 Accounts receivable 131,000 Inventory 45,500 Plant and equipment, net of depreciation 215,000 Total assets $ 462,500 Liabilities and Stockholders’ Equity Accounts payable $ 76,000 Common stock 307,000 Retained earnings 79,500 Total liabilities and stockholders’ equity $ 462,500 The company managers have made the following additional assumptions and estimates: Estimated sales for July, August, September, and October will be $260,000, $280,000, $270,000, and $290,000, respectively. All sales are on credit and...