Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete tabs 3.1, 3.13, 3.24, 3.26, and 3.30 in the attached chapter 3 excel spreadsheet.An example tab is provide in the spreadsheet for your guidance.You
Complete tabs 3.1, 3.13, 3.24, 3.26, and 3.30 in the attached chapter 3 excel spreadsheet.An example tab is provide in the spreadsheet for your guidance.You must use formulas in the spreadsheet to show your work .
3.6. Working capital: The financial information for Laurel Electronics referred to in problem 3.5 is all book value. Suppose marking-to-market reveals that the market value of the firm's inventory is 20 percent below its book value and its receivables are 25 percent below its book value. The market value of its current liabilities is identical to the book value. What is the firm's net working capital using market values? What is the percentage change in net Cash and marketable securities (M/S) $1,235,455 Comment regarding market value of the balance sheet items Accounts payables $4,159,357 same as book value Inventory $7,121,599 20% below book value Accounts receivables $3,488,121 25% below book value Notes payable $1,151,663 same as book value Other current assets $ 121,455 Market values of Laurel Electronics' current assets and current liabilities Current assets Current Liabilities Cash and M/S $1,235,455 Accounts payables $ Accounts receivables $2,616,091 Notes payable Inventory $5,697,279 Other current assets 121,455 4,159,357 1,151,663 5.311,020 Total Current assets $9,670 280 Total Current liabilities $ Net working capital Percent change in Net Working Capital $4,359,260 -34.50% 3.6. Working capital: The financial information for Laurel Electronics referred to in problem 3.5 is all book value. Suppose marking-to-market reveals that the market value of the firm's inventory is 20 percent below its book value and its receivables are 25 percent below its book value. The market value of its current liabilities is identical to the book value. What is the firm's net working capital using market values? What is the percentage change in net Cash and marketable securities (M/S) $1,235,455 Comment regarding market value of the balance sheet items Accounts payables $4,159,357 same as book value Inventory $7,121,599 20% below book value Accounts receivables $3,488,121 25% below book value Notes payable $1,151,663 same as book value Other current assets $ 121,455 Market values of Laurel Electronics' current assets and current liabilities Current assets Current Liabilities Cash and M/S $1,235,455 Accounts payables $ Accounts receivables $2,616,091 Notes payable Inventory $5,697,279 Other current assets 121,455 4,159,357 1,151,663 5.311,020 Total Current assets $9,670 280 Total Current liabilities $ Net working capital Percent change in Net Working Capital $4,359,260 -34.50% Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started