Question

In: Finance

REGRESSION AND INVENTORIES Jasper Furnishings has $250 million in sales. The company expects that its sales...

REGRESSION AND INVENTORIES

Jasper Furnishings has $250 million in sales. The company expects that its sales will increase 11% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows:

Inventories = $40 + 0.26(Sales)

  1. Given the estimated sales forecast and the estimated relationship between inventories and sales, what are your forecasts of the company's year-end inventory level? Enter your answer in millions. For example, an answer of $25,000,000 should be entered as 25. Round your answer to two decimal places.
    $ million

  2. What are your forecasts of the company's year-end inventory turnover ratio? Round your answer to two decimal places.

Solutions

Expert Solution


Related Solutions

REGRESSION AND RECEIVABLES Edwards Industries has $320 million in sales. The company expects that its sales...
REGRESSION AND RECEIVABLES Edwards Industries has $320 million in sales. The company expects that its sales will increase 13% this year. Edwards' CFO uses a simple linear regression to forecast the company's receivables level for a given level of projected sales. On the basis of recent history, the estimated relationship between receivables and sales (in millions of dollars) is as follows: Receivables = $10.25 + 0.10(Sales) a.Given the estimated sales forecast and the estimated relationship between receivables and sales, what...
REGRESSION AND RECEIVABLES Edwards Industries has $400 million in sales. The company expects that its sales...
REGRESSION AND RECEIVABLES Edwards Industries has $400 million in sales. The company expects that its sales will increase 14% this year. Edwards' CFO uses a simple linear regression to forecast the company's receivables level for a given level of projected sales. On the basis of recent history, the estimated relationship between receivables and sales (in millions of dollars) is as follows: Receivables = $13.50 + 0.13(Sales) Given the estimated sales forecast and the estimated relationship between receivables and sales, what...
Jasper Company has sales on account and for cash. Specifically, 60% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 60% of its sales are on account and 40% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $525,000 for April, $535,000 for May, and $560,000 for June. The beginning balance of Accounts Receivable is $307,400 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 40% Sales on...
Jasper Company has sales on account and for cash. Specifically, 64% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 64% of its sales are on account and 36% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $515,000 for April, $525,000 for May, and $550,000 for June. The beginning balance of Accounts Receivable is $298,700 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June April May June Cash sales 36% Sales on...
ABC Company currently has sales of $250 million. The company's sales are expected to grow 20%...
ABC Company currently has sales of $250 million. The company's sales are expected to grow 20% next year (year 1) and 10% during year 2. The analyst expects the company to have a net profit margin of 8% each year, a dividend payout ratio of 50%, 15 million shares of common stock outstanding over the time horizon, and sell for a p/e ratio of 15 at the end of year 2. If the required rate of return is 20%, then...
Parramore Corp has $20 million of sales, $3 million of inventories, $2 million of receivables, and...
Parramore Corp has $20 million of sales, $3 million of inventories, $2 million of receivables, and $1 million of payables. Its cost of goods sold is 75% of sales, and it finances working capital with bank loans at an 7% rate. Assume 365 days in year for your calculations. Do not round intermediate steps. 1-What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places. days 2-If Parramore could lower its inventories...
Parramore Corp has $10 million of sales, $3 million of inventories, $2 million of receivables, and...
Parramore Corp has $10 million of sales, $3 million of inventories, $2 million of receivables, and $3 million of payables. Its cost of goods sold is 75% of sales, and it finances working capital with bank loans at a 6% rate. Assume 365 days in year for your calculations. What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places.   days If Parramore could lower its inventories and receivables by 11% each...
Parramore Corp has $17 million of sales, $2 million of inventories, $3 million of receivables, and...
Parramore Corp has $17 million of sales, $2 million of inventories, $3 million of receivables, and $3 million of payables. Its cost of goods sold is 85% of sales, and it finances working capital with bank loans at an 7% rate. Assume 365 days in year for your calculations. Do not round intermediate steps. a. What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places. b. If Parramore could lower its...
Parramore Corp has $17 million of sales, $3 million of inventories, $2 million of receivables, and...
Parramore Corp has $17 million of sales, $3 million of inventories, $2 million of receivables, and $1 million of payables. Its cost of goods sold is 70% of sales, and it finances working capital with bank loans at an 9% rate. Assume 365 days in year for your calculations. Do not round intermediate steps. What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places.   days If Parramore could lower its inventories...
Parramore Corp has $10 million of sales, $1 million of inventories, $3 million of receivables, and...
Parramore Corp has $10 million of sales, $1 million of inventories, $3 million of receivables, and $1 million of payables. Its cost of goods sold is 70% of sales, and it finances working capital with bank loans at an 6% rate. Assume 365 days in year for your calculations. Do not round intermediate steps. What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places.   days If Parramore could lower its inventories...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT