Question

A1 G E D E Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specifty the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the green cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the ta in your formulas, usually the Given Data section. Given Data: Current Assets $50,000,00 Net Fixed Assets $250,000.00 T Long-term debt $100,000.00 Current Liabilities S30,000.00 a. Calculate Caraway's stockholders' equity. 11 12 Stockholders' Equity 13 14 b. What is the firm's net working capital? 15 16 Net Working Capital 17 18 c. If Caraway's current liabilitics consist of $20,000 in accounts payable and S10,000 in short-term debt (notes payable), what is the firn's net working capital? 19 Given Data: 20 Accounts Payable Short Term Debt 21 $20,000,00 22 $10,000,00 23 Net Working Capital 24 25 26 27 Requirements 1 Start Excel 2 In cell D13, by using cell refercnces, calculate the stockholders' equity. (1 pt.) 3 Is cell D17, by using cell references, calculate the net working capital. (1 pt.) 4 In cell D24, by using cell references, calculate the net working capital. (1 pt.) 5 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed 25 31 32 3-11 n

Answer 1

a
	Stockholders Equity	170000
	(Total assets- liabilities)
b
	NWC	20000
	(current assets- current liabilities)
c	Accounts payable	20000
	Short term debt	10000
	NWC	20000
	(current assets- current liabilities)

WORKINGS

Book1- Excel X AutoSave ( Off Sign in Tell me what you want to do File Formulas Review View Help Share Home Insert Draw Page Layout Data A A 9 Calibri General Wrap Text Conditional Format as Cell Formatting BIU Insert Delete Format Sort & Find & Paste A Merge & Center $% , o Filter Select Table Styles Clipboard Alignment Number Styles Cell: Editing Font C24 NWC C E E B 6 Current assets 50000 7 250000 Net Fixed assels 8 Long term debt 100000 9 Current liabilities 30000 10 11 12 = 1)6t1) / - D8-1)9 13 stockholders Equity (Total assets- liabilities) 14 15 16 17 D6 D9 NWC (current assets current liabilities) 10 20 21 Accounts payable 20000 22 10000 Short lerm debl 23 |-D6-D21-D22 NWC 24 25 (current assets- current liabilities) 26 Sheet1 +100% Ready P ENG 5:17 AM