Chapter 10 of 19 · Corporate Accounting and Financial Management

Forecasting Financial Statements

21 questionsasked in 13 of 15 attemptsOrder: by topic, latest first

Chapter weightageCh. 9Ch. 11
Questions per attemptTap a bar to filter
J19J24
June 2026Q. 3(b)5 marksSyllabus 2022

(b)Raj Ltd recently reported the following income Statement :

This year company is forecasting 25% increase in sales and it expects that its year end operating cost will be around 70% of sales. It is expected that tax rate, interest and dividend pay-out ratio will be constant.

You are required to compute projected Net Income and expected growth rate in dividend.

June 2026Q. 4A(ii)5 marksSyllabus 2022

(ii)Explain the components and factors of financial forecasting.

December 2025Q. 3(b)5 marksSyllabus 2022

(b)Yash Ltd. recently reported the following income Statement :

Particulars(INR in Crores)
Sales600
Operating Cost470
EBIT130
Interest40
EBT90
Taxes @ 40%36
EAT (Net Income)54
Dividend21.6
Retained Earnings32.4

This year company is forecasting 25% increase in sales and it expects that its year end operating cost will be around 70% of sales. It is expected that tax rate, interest and dividend pay-out ratio will be constant.

Calculate the following :

(i)Projected Net Income

(ii)Expected growth rate in dividend.

June 2025Q. 4(c)5 marksSyllabus 2022

(c)Calculate material consumed in production and payment for the inventory from the given figures. Assume entire purchase is on credit basis :

Particulars₹
Inventory in the beginning80,000
Credit Purchases3,20,000
Inventory in the end76,000
Trade payables in the beginning28,000
Trade payables at the end29,000
June 2025Q. 4A(i)5 marksSyllabus 2022

(i)

(i)Financial Forecasting is the start of budgeting process. Elucidate.

December 2024Q. 76 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

ABD Ltd. has forecast its sales for the next three months as follows :

May month : 12,000 units

June month : 20,000 units

July month : 25,000 units Opening stock as on 1st April is expected to be 5,000 units. Closing stock should equal 20% of the coming month’s sales needs. How many units should be produced in June ?

(A)20,000 units

(B)11,000 units

(C)21,000 units

(D)25,000 units

December 2024Q. 1(c)5 marksSyllabus 2022
Show the facts common to all parts of Q. 1

Komal is a third-generation businesswomen in the dairy business “Bharat Ghee & Co.”. The business is run under the brand “Pure Ghee”. The company prepares milk-based products and is known for good quality in the market. The sales are made through self-owned stores, other retailers at locations where self-owned stores are not present and online.

The business is run by Komal’s family on a strategic and operational basis. However, now the business is growing at a rapid pace. There is a need to get in professional management to run the business. “Bharat Ghee & Co.” hires a new CEO - Garima, who has three decades of experience in the dairy industry. Komal will now be Executive Chairman and provide a guiding role in the business. The first task that Garima has on hand is to identify issues that are hindering business growth.

Komal asks Garima to list major concerns that the business is facing :

l Lower margins where sales are made through other retailers and online. Online platforms are charging a big commission for making sales.

l High chance of spoilage due to perishable nature of the raw material. Due to perishable nature of material - inventories are kept at a negligible level.

l Capacity increase may be necessitated in the near future for which capital will have to be raised.

Garima requests the Accounts Head - Naina for key financial metrics of “Bharat Ghee & Co”. Naina provides the following details to Garima :

Key Financials of Bharat Ghee & Co :

Credit Revenue (₹)80,00,00,000/-
Cash Revenue20% of total sales
Gross Profit ratio30%
Indirect expenses (₹)10,00,00,000/-
Tax rate25%
Interest on debt12%
Interest amount (?)12,00,00,000/-
Debt to equity ratio2 : 1

Garima does some quick calculations to derive Return on Equity and Return on Capital Employed. Komal indicates willingness to contribute fresh equity in the business and payoff the loans. However, Garima is not in favour of repayment of loans.

Garima has made a business plan to change the strategy to decrease dependence from third party vendors. The new plan recommends creation of infrastructure to enable sales at locations which are serviced by channel partners. A new strategic business unit is to be created for implementation of the business plan.

The following infrastructure facilities need to be created :

Items(₹)
Cold chain warehousing facility15,00,00,000
New trucks5,00,00,000
Office premises3,00,00,000
Furniture and computers1,00,00,000

l The aforementioned infrastructure will be set up using debt and equity in the ratio of 2 : 1. The new debt will be raised at a rate of 14%.

l The average depreciation will be 30%.

l The above investment and raising of debt will be done on October 1. The organization follows an April to March financial year.

l The average receivables at the end of the financial year from the new business will be ₹ 10,80,00,000/-. The receivables turnover days will be 45 days. Assume 180 days to calculate receivables turnover ratio.

l The gross profit margin will be 20%.

l Indirect expenses other than depreciation will be ₹ 2,00,00,000/-.

l lncome tax rate is 25%.

Komal asks for the projected P&L before approving the required investment amount :

(c)Prepare the projected Profit & Loss Account of the new business unit.

December 2024Q. 3(c)4 marksSyllabus 2022

( c )Central Textiles Ltd. has provided you its historical revenue and cost data :

ParticularsAmount (Crore)
Revenues1,000
Variable Cost 70% of sales700
Fixed Cost115
Depreciation101
Income Tax25%

Central Textiles Ltd. management is attempting to project profitability for next year under different scenarios. The historical data will be the base case scenario. The details regarding optimistic scenario and worst-case scenario are given below :

ParticularsOptimistic ScenarioWorst-Case Scenario
Revenue change40% increase20% decrease
Variable cost65% of sales71 % of sales
Fixed cost113/- crore120/- crore
DepreciationSame as base caseSame as base case

Prepare Profitability projection with the given data.

December 2023Q. 72 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Following is the summary of forecasted incomes and expenditures of AZ Ltd. for the months from January to March, 2024 :

MonthSalesPurchaseWages
(₹)(₹)(₹)
December’ 2360,00036,0009,000
January’ 2462,00038,0008,000
February’ 2464,00033,00010,000
March’ 2458,00039,0008,500

Cash balance on 01.02.2024 will be ₹ 5,000 Advance tax payable in March’24 is ₹ 10,000 If credit allowed by suppliers is two months and allowed to customers is one month, and lag in payment of wages one month. The expected closing balance of cash at the end of February’ 24 will be :

(A)₹ 21,000

(B)₹ 23,000

(C)₹ 36,000

(D)₹ 38,000

December 2023Q. 2(c)5 marksSyllabus 2022

(c)Y Ltd. recently reported the following income Statement :

(₹ in Crore)

Sales600
Operating Cost470
EBIT130
Interest40
EBT90
Taxes @ 40%36
EAT (Net Income)54
Dividend21.6
Retained Earnings32.4

This year company is forecasting 25% increase in sales and it expects that its year end operating cost will be around 70% of sales. It is expected that tax rate, interest and dividend pay-out ratio will be constant. You are required to compute projected Net Income and expected growth rate in dividend.

December 2022Q. 67 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Which of the following is not applicable to forecast?

(A)Has limited scope

(B)A tool for control

(C)Displays policy and programme to be followed

(D)All of the above

December 2020Q. 74 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Sales (in units) : Jan. 1,000, Feb. 2,000, Mar. 3,000, Apr. 4,000. 20% of the Sales are on cash basis and the balance on credit basis. Uniform Selling Price— ₹ 20 per unit. 50% of credit sales are collected in the month following the sales, 50% of the remaining in the second month and the balance in the third month. Calculate the total amount of Cash Sales and Collection from Debtors during the month of April :

(A)₹ 52,000

(B)₹ 36,000

(C)₹ 50,000

(D)None of the above

December 2020Q. 75 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Sales (in units): Jan. 1,000, Feb. 2,000, Mar. 3,000, Apr. 4,000, May 5,000. 25% of the Purchases are on cash basis and the balance on credit basis. Uniform Selling Price — ₹ 20 per unit. This price was fixed after adding 25% to cost. No stock remains at the end of a month. Purchases are made one month in advance and 50% of Credit purchases are paid within one month and the balance in two months. Calculate the total amount of Cash Purchases and Payment to Creditors during the month of April :

(A)₹ 62,000

(B)₹ 46,000

(C)₹ 50,000

(D)None of the above

December 2019Q. 68 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Puvi Ltd. provides the following information for the quarter ending 31st March, 2020 :

Expected Sales :

January, 2020₹ 25 lakh
February, 2020₹ 28 lakh
March, 2020₹ 30 lakh

Roughly 40% of the sales are for cash, 80% of credit sales are collected in the month following the month of sales and the balance of credit sales one month after that. The amount collected from debtors in the month of March, 2020, will be :

(A)₹ 10.96 Lakh

(B)₹ 28.44 Lakh

(C)₹ 22.96 Lakh

(D)₹ 16.44 Lakh

December 2018Q. 5(b) (CMA)5 marksCorporate and Management Accounting paper, Syllabus 2017

(b)The following is the information of Govind Trading Co. Ltd. :

Estimated annual sales₹ 20,00,000
Ratios—
Sales to shareholders’ fund2.5 times
Current debts (liabilities) to shareholders’ fund1 : 4
Current ratio3.6 times
Ratio of net sales to inventory4 times
Average collection period (taking 360 days in a year)36 days

You are required to calculate :

(i)Net worth or Shareholders’ fund

(ii)Current liabilities

(iii)Current assets

(iv)Inventory

(v)Debtors.

June 2026Q. 4(b)5 marksSyllabus 2022

(b)Solar Equipment Ltd. wants to arrange overdraft facilities with its bankers during the period March to May. Prepare a cash budget for the above period on the basis of the under-mentioned data indicating the extent of bank overdraft facilities, the company will require at the end of each month :

Additional Information :

(i)50% of the credit sales will be realized in the month following the month of sales and remaining 50% in the second month following the month of sales.

(ii)The creditors for purchases will be paid in the month following the month of purchases.

(iii)Workers are paid in the same month for their wages.

(iv)Cash at bank on 1st March, is estimated to be ₹ 1,250 lakh.

December 2024Q. 75 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Estimated wages for January month is ₹ 8,000 and for February month ₹ 8,800. If the delay in payment of wages is 1/2 month, the amount of wages to be considered in cash budget for the month of February will be ................

(A)₹ 8,000

(B)₹ 8,800

(C)₹ 12,400

(D)₹ 8,400

June 2023Q. 72 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Which is not the method of preparation of cash budget?

(A)Receipts and Payments Method

(B)Adjustment Profit and Loss Account Method

(C)Cash flow Method

(D)Balance Sheet Method

June 2022Q. 71 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Which of the following would be found in a Cash Budget ?

(A)Accrued expenditure

(B)Outstanding expenditure

(C)Capital expenditure

(D)All of the above

December 2021Q. 75 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Which is not the method of preparation of cash budget ?

(A)Receipts and payments method

(B)Adjusted profit and loss account method

(C)Balance sheet method

(D)Cash flow method

June 2021Q. 82 (CMA)1 markMCQCorporate and Management Accounting paper, Syllabus 2017

Which of the following would be found in a Cash budget ?

(A)Capital Expenditure

(B)Provision for doubtful debts

(C)Depreciation

(D)Accrued expenditure

No questions in this chapter match these filters.