CS Executive · Corporate Accounting and Financial Management · Forecasting Financial Statements
Kaveri Foods Ltd has current sales of ₹20,00,000 and total assets of ₹10,00,000, all of which vary with sales. Spontaneous liabilities are ₹2,00,000 and also vary with sales. Net profit margin is 6% and the dividend payout ratio is 50%. Sales are expected to rise by 20%. Using the percentage-of-sales method, what is the external funds requirement?
The external funds requirement is the rise in assets of ₹2,00,000 less the rise in spontaneous liabilities of ₹40,000 and retained earnings of ₹72,000, giving ₹88,000.
- A₹1,28,000Correct
- B₹1,00,000
- C₹2,00,000
- D₹56,000
Explanation
Increase in sales = 4,00,000. Increase in assets = 50% × 4,00,000 = 2,00,000 (assets/sales = 0.5). Increase in spontaneous liabilities = 10% × 4,00,000 = 40,000. New sales = 24,00,000; net profit = 1,44,000; retained = 72,000. EFR = 2,00,000 − 40,000 − 72,000 = 88,000. Hence the correct figure is ₹88,000, which is not listed.
Did you get it right without looking?
One question tells you little. A timed set on Forecasting Financial Statements shows your real accuracy, how long you take and where you lose marks.
More Forecasting Financial Statements questions
- Which statement about the sales forecast in the preparation of projected financial statements is most appropriate?
- A firm's budgeted credit sales are April Rs 2,00,000, May Rs 3,00,000 and June Rs 4,00,000. Customers pay 40% in the month following the sal…
- In the percentage-of-sales method of forecasting, which of the following correctly describes how the External Funds Requirement (EFR) is arr…
- Under the percentage of sales method of forecasting financial statements, which assumption is made about the items that are linked to sales?
- Sales of Kaveri Traders for the last three years were Rs 40 lakh, Rs 46 lakh and Rs 52 lakh respectively (oldest to latest). Using a simple …
- A firm expects credit sales of Rs 4,00,000 in March. Experience shows 60% is collected in the month of sale with a 2% discount, and 40% is c…