A firm’s net working capital is proportional to its sales. Historically, inventory is 10.00% of sales,...
A firm’s net working capital is proportional to its sales. Historically, inventory is 10.00% of sales, accounts receivable is 20.00% of sales, and accounts payable is 12.00% of sales. Below, we have the sales forecast for the upcoming four years: (in millions)
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
|---|---|---|---|---|---|
| Sales | $5.43 | $8.81 | $14.08 | $17.75 | $19.00 |
What will be the balance sheet value of NWC for year 1? (answer in terms of millions, x.xx million)
What will be the investment in NWC for year 1? (answer in terms of millions. Answer will be a positive number)
What will be the balance sheet value of NWC for year 2? (answer in terms of millions)
What will be the investment in NWC for year 2? (answer in terms of millions, xx.xx million)
Homework Answers
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.
Add Answer to:
A firm’s net working capital is proportional to its sales. Historically, inventory is 10.00% of sales,...
You have the following information on Els’ Putters, Inc.: sales to working capital is 4.2 times,...
You have the following information on Els’ Putters, Inc.: sales to working capital is 4.2 times, profit margin is 30 percent, net income available to common stockholders is $6.30 million, and current liabilities are $5.6 million. What is the firm’s balance of current assets? (Enter your answer in millions of dollars rounded to 2 decimal places.)
A firm’s balance sheets for year-end 2011 and 2012 contain the following data. All items are...
A firm’s balance sheets for year-end 2011 and 2012 contain the following data. All items are in millions of dollars. Dec. 31, 2011 Dec. 31, 2012 Accounts receivable 37.0 34.0 Inventories 31.0 27.0 Accounts payable 27.0 14.0 a. Calculate the net working capital in 2011. (Enter your answer in millions rounded to 1 decimal place.) Net working capital $ million b. Calculate the net working capital in 2012. (Enter your answer in millions rounded to 1 decimal place.) Net working capital...
Using the attached information to develop and complete a Sources and Uses of Net Working Capital...
Using the attached information to develop and complete a Sources and Uses of Net Working Capital Statement below. The Change in the Net Working Capital Year Current Assets - Current Liabilities - Net Working Capital 2016 2017 Change in Net Working Capital The Sources and Uses of Net Working Capital Sources of NWC Uses of NWC Profits (Retained Earnings) S Payment of dividends Sales of fixed assets Purchase of fixed assets Sales of investments Purchase of investments Long-term loans taken...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales for...
Wildcat, Inc., has estimated sales (in
millions) for the next four quarters as follows:
Sales for the first quarter of the following year are projected
at $145 million. Accounts receivable at the beginning of the year
were $57 million. Wildcat has a 45-day collection period.
Wildcat’s purchases from suppliers in a quarter are equal to 50
percent of the next quarter’s forecast sales, and suppliers are
normally paid in 36 days. Wages, taxes, and other expenses run
about 20 percent...
The Malibu Corporation has annual credit sales of $34 million. The average collection period is 36...
The Malibu Corporation has annual credit sales of $34 million. The average collection period is 36 days. What is the average investment in accounts receivable as shown on the balance sheet? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Average receivables.
The Malibu Corporation has annual credit sales of $36 million. The average collection period is 38...
The Malibu Corporation has annual credit sales of $36 million. The average collection period is 38 days. What is the average investment in accounts receivable as shown on the balance sheet? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Average receivables.
Last year Miami Rivet had $5 million in operating income (EBIT). Its depreciation expense was $1...
Last year Miami Rivet had $5 million in operating income (EBIT). Its depreciation expense was $1 million, its interest expense was $1 million, and its corporate tax rate was 25%. At year-end, it had $14 million in operating current assets, $3 million in accounts payable, $1 million in accruals, $2 million in notes payable, and $15 million in net plant and equipment. Assume Miami Rivet has no excess cash. Miami Rivet uses only debt and common equity to fund its...
Current ratio = 2.6 times Credit sales $1,314m Average collection period 50 days Inventory turnover 1.50...
Current ratio = 2.6 times Credit sales $1,314m Average collection period 50 days Inventory turnover 1.50 times Total asset turnover 0.50 times Debt ratio 75% Use the above information to complete the balance sheet below. (Enter your answer in millions. Use 365 days a year.) Cash million million Current liabilities Accounts receivable $ 670 million million Long-term debt Inventory million 0 million Total debt Current assets 670 million million Stockholders' equity million 670 million Fixed assets $ 0 million Total...
Wildcat, Inc., has estimated sales in millions) for the next four quarters as follows: Sales Q1...
Wildcat, Inc., has estimated sales in millions) for the next four quarters as follows: Sales Q1 $125 Q2 $145 Q3 $165 Q4 $195 Sales for the first quarter of the year after this one are projected at $140 million. Accounts receivable at the beginning of the year were $55 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in...
Construct a balance sheet for Sophie's Sofas given the following data, including shareholders' equity. = =...
Construct a balance sheet for Sophie's Sofas given the following data, including shareholders' equity. = = Cash balances Inventory of sofas Store and property Accounts receivable Accounts payable Long-term debt $ 15,000 $250,000 $150,000 $ 27,000 $ 22,000 $220,000 = = BALANCE SHEET OF SOPHIE'S SOFAS Liabilities & Shareholders' Equity Assets Total assets 0 Total liabilities & shareholders' equity Butterfly Tractors had $19.00 million in sales last year. Cost of goods sold was $9.00 million, depreciation expense was $3.00 million,...
Using the attached information to develop and complete a Sources and Uses of Net Working Capital Statement below. The Change in the Net Working Capital Year Current Assets - Current Liabilities - Net Working Capital 2016 2017 Change in Net Working Capital The Sources and Uses of Net Working Capital Sources of NWC Uses of NWC Profits (Retained Earnings) S Payment of dividends Sales of fixed assets Purchase of fixed assets Sales of investments Purchase of investments Long-term loans taken...
Wildcat, Inc., has estimated sales (in
millions) for the next four quarters as follows:
Sales for the first quarter of the following year are projected
at $145 million. Accounts receivable at the beginning of the year
were $57 million. Wildcat has a 45-day collection period.
Wildcat’s purchases from suppliers in a quarter are equal to 50
percent of the next quarter’s forecast sales, and suppliers are
normally paid in 36 days. Wages, taxes, and other expenses run
about 20 percent...
The Malibu Corporation has annual credit sales of $34 million. The average collection period is 36 days. What is the average investment in accounts receivable as shown on the balance sheet? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Average receivables.
The Malibu Corporation has annual credit sales of $36 million. The average collection period is 38 days. What is the average investment in accounts receivable as shown on the balance sheet? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Average receivables.
Current ratio = 2.6 times Credit sales $1,314m Average collection period 50 days Inventory turnover 1.50 times Total asset turnover 0.50 times Debt ratio 75% Use the above information to complete the balance sheet below. (Enter your answer in millions. Use 365 days a year.) Cash million million Current liabilities Accounts receivable $ 670 million million Long-term debt Inventory million 0 million Total debt Current assets 670 million million Stockholders' equity million 670 million Fixed assets $ 0 million Total...
Wildcat, Inc., has estimated sales in millions) for the next four quarters as follows: Sales Q1 $125 Q2 $145 Q3 $165 Q4 $195 Sales for the first quarter of the year after this one are projected at $140 million. Accounts receivable at the beginning of the year were $55 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in...
Construct a balance sheet for Sophie's Sofas given the following data, including shareholders' equity. = = Cash balances Inventory of sofas Store and property Accounts receivable Accounts payable Long-term debt $ 15,000 $250,000 $150,000 $ 27,000 $ 22,000 $220,000 = = BALANCE SHEET OF SOPHIE'S SOFAS Liabilities & Shareholders' Equity Assets Total assets 0 Total liabilities & shareholders' equity Butterfly Tractors had $19.00 million in sales last year. Cost of goods sold was $9.00 million, depreciation expense was $3.00 million,...
Most questions answered within 3 hours.
-
After watching the lectures I am still having a hard time
understanding these equations.
1. The...
asked 57 minutes ago -
Testing:
H0:μ=56.9
H1:μ<56.9
Your sample consists of 23 subjects, with a mean of 56.3 and
standard...
asked 1 hour ago -
straight wire, labeled as Wire A, lies horizontally on a
tabletop and is oriented to run...
asked 1 hour ago -
For a Chi-Squared Goodness of Fit Test about a uniform
distribution, complete the table.
Round to...
asked 1 hour ago -
Milk of magnesia is only slightly soluble in water. Kc for the
reaction Mg(OHs)(s)>Mg2+(a) + 2OH-1(aq)...
asked 1 hour ago -
Excel's HYPGEOM.DIST function can be used to compute _____.
a. both hypergeometric probabilities and cumulative
hypergeometric...
asked 1 hour ago -
The rocket used for the human lunar missions was the Saturn V
rocket. At liftoff the...
asked 1 hour ago -
1. The East Street Bagel Shop has a weekly demand for 3,500
bagels, which they make...
asked 1 hour ago -
paraphrasing each paragraph
“Where two or more persons knowingly act together unlawfully,
the act of each...
asked 1 hour ago -
The lateral line system in fish is contained which of the
following?
chemoreceptors
photoreceptors
mechanoreceptors
odor...
asked 1 hour ago -
Find the y-intercept of y =-5 x. The y-intercept of y equals
negative 5 x is______...
asked 1 hour ago -
Customers arrive randomly at a gas station at the average rate
of 30 per hour, while...
asked 1 hour ago