Vikings Inc., is developing a pro forma income statement for the coming year. The chief financial officer estimates that sales will be $150,000,000. If gross profits are historically 36% of sales, what is the expected cost of goods sold (in dollars)? a) $36,000,000 b) $54,000,000 c) $64,000,000 d) $96,000,000 NOTE: In your Excel spreadsheet, all calculations must be included

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take pictures) Company X, S.A.'s current sales are 12.5 million. An increase of 5% is estimated for next year, and its uncollectible accounts will go from the current 1% to 1.5%. What is the change in profit due to this customer behavior? A) 1,500 B) 3,000 C) 4,500 D) 5,000   (Choose a option)

Assuming costs vary with sales and a 20 percent increase in sales is projected, create the pro forma income statement. Create a pro forma Balance Sheet. All items will vary with sales. What is the plug variable in order for this to balance? Suppose no dividend is planned to be issued next year. What is the plug variable?

Jace Furnishings has $325 million in sales. The company expects that its sales will increase 8% this year. Jace'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 = $30 + 0.105(Sales) 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? Write out your answer completely. For example, 5 million should be entered as 5,000,000. Do not round intermediate calculations. Round your answer to the nearest dollar.$   What are your forecasts of the company's year-end inventory turnover ratio? Do not round intermediate calculations. Round your answer to two decimal places. x