CFA Level I · CFA Level I Exam · Introduction to Financial Statement Modeling
A company forecasts revenue of 800 million for next year. Its days of inventory on hand is expected to be 45 days, based on COGS of 480 million. Using a 365-day year, forecast ending inventory is closest to:
Ending inventory is about 59 million. Days of inventory on hand is applied to cost of goods sold, so 480 million times 45 divided by 365 equals roughly 59 million. Using revenue as the base would wrongly overstate inventory at about 98 million.
- A40 million
- B59 millionCorrect
- C98 million
Explanation
Inventory = COGS x days/365 = 480 x 45/365 = 59.18 million. Using revenue of 800 instead of COGS gives 98.6 million, which is the wrong base. Using 480/365 without multiplying fully, or 30 days, would give around 40.
Did you get it right without looking?
One question tells you little. A timed set on Introduction to Financial Statement Modeling shows your real accuracy, how long you take and where you lose marks.
More Introduction to Financial Statement Modeling questions
- An analyst forecasts industry sales of 50 billion next year and expects the company's market share to rise from 12% to 14%. Industry sales w…
- After completing a base-case forecast, an analyst changes revenue growth, margin and capital expenditure assumptions to see the effect on pr…
- A restaurant chain has 200 restaurants at the start of the year and plans to open 20 new ones, all at mid-year. Average revenue per restaura…
- An analyst forecasts a manufacturer's revenue by first estimating total market volume growth from industry data (top-down) and then adjustin…
- A bottom-up forecast projects a company's revenue growth at 18%, while the analyst's top-down view has industry growth of 5%. The forecast w…
- An analyst builds a revenue forecast by starting from the company's recent growth rate and adjusting it only slightly, even though industry …