a) Net operating profit after tax(NOPAT) = Net income + Interest * (1 - Tax rate)
2017 : Tax rate = 37% or 0.37
NOPAT = $19,301 + $2,214 * (1 - 0.37)
NOPAT = $19,301 + $1,394.82
NOPAT = $20,695.82
b) Net operating assets (NOA) = Operating assets - Operating liabilities
Here, Operating assets = Total assets
Operating liabilities = Accounts payable - Accrued liabilities
i) 2016 (NOA) = $1,62,460 - ($7,990 + $7,160)
2016 (NOA) = $1,62,460 - $15,150 = $1,47,310
ii) 2017 (NOA) = $1,80,810 - ($9,530 + $7,760)
2017 (NOA) = $1,80,810 - $17,290 = $1,63,520
c) Free cash flow to the firm = Net profit + Interest * (1 - Tax rate) + Depriciation - Capital expenditure - Changes in working capital
Here, for 2017 : Depriciation = 0
i) Capital expenditure = Plant assets (Year 2017 - year 2017)
Capital expenditure = $1,15,890 - $1,05,000
Capital expenditure = $10,890
ii) Changes in working capital = Working capital for 2017 - Working capital for 2016
Here, Working capital = Accounts recievables + Inventory - Accounts payable - Accrued liabilities
Working capital (2017) = $11,100 + $40,140 - $9,530 - $7,760 = $33,950
Working capital (2016) = $10,680 + 35,250 - $7,990 - $7,160 = $30,780
Changes in working capital = $33,950 - $30,780
Changes in working capital = $3,170
Now,
Free cash flow to the firm = $19,301 + $2,214 * (1 - 0.37) + 0 - $10,890 - $3,170
Free cash flow to the firm = $6,635.82
d) Weighted average cost of capital (WACC) = (Weight of debt * Cost of debt after tax) + Weight of equity * Cost of equity)
Here, for 2017,
Debt = $41,630, Equity = $1,21,890
Total capital (Debt + Equity) = $41,630 + $1,21,890
Total capital = $1,63,520
Weight of debt = Debt / Total capital = $41,630 / $1,63,520 = 0.26
Weight of equity = Equity / Total capital = $1,21,890 / $1,63,520 = 0.74
i) Cost of debt after tax = (Before tax interest / Debt) * (1 - Tax rate)
Cost of debt after tax = ($2,214 / $41,630) * (1 - 0.37)
Cost of debt after tax = 0.0532 * 0.63 = 0.0335
ii) Cost of equity using CAPM
Cost of equity = Rf + Beta * (Rf - Rm)
Rf (Risk free rate) = 3.5% or 0.035
Beta = 0.9
Rf - Rm (Risk premium) = 5% or 0.05
Cost of equity = 0.035 + 0.9 * 0.05
Cost of equity = 0.08
Now,
WACC = (0.26 * 0.0335) + (0.74 * 0.08)
WACC = 0.0087 + 0.0592
WACC = 0.0679 or 6.79%
e) Residual operating income = Operating income - (WACC * Net operating assets)
For 2017 :
Residual operating income = $32,850 - (0.0679 * $1,63,520)
Residual operating income = $32,850 - $11,103
Residual operating income = $21,747
GOLDSMITH INC. Balance Sheet at December 31, 2017 2016 2017 $ 11,530 $ 13,680 Cash 11,100 Accounts Receivable 10,680 In...
CRUZ, INC Comparative Balance Sheets December 31, 2017 2017 2016 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Furniture Accum. depreciation-Furniture Total assets Liabilities and Equitv Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long-term) Total liabilities Equity Common stock, $5 par value Retained earnings Total liabilities and equity $ 89,000 22,100 46,900 88,000 4,000 161,000 113,300 38,200 80,000 4,900 212,100 98,800 (15,300) (8,600) $295,600 $265,700 $ 13,900 19,600 4,600 2,600 26,800 69,000...
Peace Corporation Comparative Balance Sheet December 31, 2017 and 2016 2017 2016 Assets Current Assets: Cash and Cash Equivalents Accounts Receivable Merchandise Inventory Prepaid Expenses Total Current Assets s 2.284 2,044 1,340 1,125 1,697 7,365 1,920 1,870 2,078 6,993 18,313 15,126 $ 25,678 $ 22,119 Other Assets Total Assets Liabilities Current Liabilities Long-term Liabilities Total Liabilities 7,113 8,342 2,186 11,773 10,528 4,660 Stockholders' Equity Common Stock, no par Retained Eamings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 5,691 5,900...
The current sections of Scoggin Inc.'s balance sheet at December 31, 2016 and 2017, are presented here. Scoggin's net income for 2017 was $153,000. Depreciation expense was $24,000 2017 2016 Current assets Cash $105,000 $99,000 Accounts Receivable 110,000 89,000 Inventory 158,000 172,000 Prepaid expenses 27,000 23,000 Total current assets $400,000 $ 382,000 Current Liabilities Accrued expense possible $15,000 $. 5,000 Accounts payable 85,000 92,000 Total current liabilities. $100,000 $ 97,000 Prepare the net cash provided by operating activities section on...
ORIOLE COMPANY Balance Sheets December 31 2017 2016 Current assets Cash and cash equivalents Accounts receivable (net) $330 660 600 $360 590 530 Inventory Prepaid expenses 120 160 Total current assets 1,710 1,640 Investments 200 200 Property, plant, and equipment (net) Intangibles and other assets Total assets 420 380 530 510 $2,860 $2,730 $1,090 $980 550 520 Current liabilities Long-term liabilities Stockholders' equity-common Total liabilities and stockholders' equity 1,220 1,230 $2,860 $2,730 ORIOLE COMPANY Income Statements For the Year Ended...
The comparative balance sheet for Fair Isle Travel Services,
Inc., for December 31, 2017 and 2016
The following information is taken from the records of Fair Isle
Travel Services, Inc.:
Assets 2017 2016 $ Current assets: Cash Accounts receivable Inventory Prepaid insurance Total current assets 40,000 $ 19,000 82,000 84,000 59,000 16,000 10,000 14,000 191,000 $ 133,000 $ Land Equipment Less: Accumulated depreciation $ 100,000 $ 115,000 77,000 61,000 (16,000) (10,000) $ 352,000 $ 299,000 Total assets We were unable...
The comparative balance sheet for Desmond Isle Travel Services, Inc., for December 31, 2017 and 2016, is as follows: (Click the icon to view the comparative balance sheet.) The following information is taken from the records of Desmond Isle Travel Services, Inc.: (Click the icon to view the transaction data) Desmond Isle Travel Services, Inc., uses the indirect method for preparing the statement of cash flows. Prepare the operating section of the statement of cash flows for 2017. (Use parentheses...
The comparative balance sheet for Mosaic Travel Services, Inc., for December 31, 2017 and 2016, is as follows: E(Click the icon to view the comparative balance sheet.) The following information is taken from the records of Mosaic Travel Services, Inc. (Click the icon to view the transaction data.) Prepare the statement of cash flows (indirect method) for Mosaic Travel Services, Inc., for 2017 Prepare the statement one section at a time. (Use parentheses or a minus sign for numbers to...
The comparative balance sheet for Fair Isle Travel Services, Inc., for December 31, 2017 and 2016, is as follows: (Click the icon to view the comparative balance sheet.) The following information is taken from the records of Fair Isle Travel Services, Inc.: (Click the icon to view the transaction data) Prepare the statement of cash flows (indirect method) for Fair Isle Travel Services, Inc., for 2017 Prepare the statement one section at a time. (Use parentheses or a minus sign...
The comparative balance sheet for Majestic Travel Services, Inc., for December 31, 2017 and 2016, is as follows: (Click the icon to view the comparative balance sheet.) The following information is taken from the records of Majestic Travel Services, Inc. (Click the icon to view the transaction data.) Prepare the statement of cash flows (indirect method) for Majestic Travel Services, Inc., for 2017 Increase in wages payable Increase in interest payable 15,000 1,000 2,000 (10,400) Increase in income taxes payable...
At December 31 2017 2016 2015 Assets Cash $ 31,800 $ 35,625 $ 37,800 Accounts receivable, net 89,500 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $ 523,000 $ 445,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,900 $ 75,250 $ 51,250 Long-term notes payable secured by mortgages on plant assets 98,500 101,500 83,500 Common stock, $10 par value 163,500 163,500 163,500 Retained earnings 131,100 104,750 79,250...