Question

In: Finance

Study the following Pro-Forma Statement of Comprehensive Income of Dhikim Ltd for the month ending 28...

Study the following Pro-Forma Statement of Comprehensive Income of Dhikim Ltd for the
month ending 28 February 2019.


You will be required to use the information provided to:
2.1 Calculate the following for February 2019.
2.1.1 Cost of Sales (1 mark)
2.1.2 Taxation (1 mark)
2.1.3 Profit after Taxation (1 mark)


2.2 Prepare the Pro-Forma Statement of Comprehensive Income for the month ending March
2019.


Note: use the format provided for February 2019
Information


Pro-Forma Statement of Comprehensive income of Dhikim Ltd for the month ending 28
February 2019

R

Sales

400 000

Cost of sales

2.1.1

Gross Profit (25% of sales)

?

Operating Income

50 000

Operating expenses

(120 000)

Operating profit

?

Interest Income

27 000

Interest Expense

(14 000)

Profit before tax

?

Taxation (30%)

2.1.2

Profit after tax

2.1.3

Additional information
- Sales is forecasted to increase by 10% in March 2019
- The Gross Margin for March 2019 remains unchanged from February 2019
- Operating Income and Operating Expenses for March 2019 will vary in proportion to sales
from February 2019 (percentage of sales).
- There was no change to interest receipts and payments for March 2019 from February
2019
- The tax rate remains the same for March 2019

Solutions

Expert Solution

FEBRUARY.2019 R
a Sales 400000
b=a-c Cost of sales 300000 (400000-100000)
c=a*25% Gross Profit (25% of sales) 100000 (400000*25%)
d Operating Income 50000
e Operating expenses -120000
f=c+d+e Operating profit 30000 (100000+50000-120000)
g Interest Income 27000
h Interest Expense -14000
i=f+g+h Profit before tax 43000 (30000+27000-14000)
j=i*30% Taxation (30%) 12900 (43000*30%)
k=i-j Profit after tax 30100 (43000-12900)
MARCH.2019 R
a Sales 440000 (400000*(1+0.1))
b=a-c Cost of sales 330000
c=a*25% Gross Profit (25% of sales) 110000 (440000*25%)
d Operating Income 55000 (50000*(1+0.1)
e Operating expenses -132000 (120000*(1+0.1)
f=c+d+e Operating profit 33000
g Interest Income 27000
h Interest Expense -14000
i=f+g+h Profit before tax 46000
j=i*30% Taxation (30%) 13800 (46000*30%)
k=i-j Profit after tax 32200 (46000-13800)

Related Solutions

How to develop pessimistic and optimistic pro forma statements of comprehensive income?
How to develop pessimistic and optimistic pro forma statements of comprehensive income?
• Describe pro forma income and the importance of pro forma income in the evaluation of...
• Describe pro forma income and the importance of pro forma income in the evaluation of the income statement. Choose at least two items that are excluded from pro forma income. Suggest to management why including the items would be misleading to investors and creditors.
PRO FORMA INCOME STATEMENT Austin Grocers recently reported the following 2016 income statement (in millions of...
PRO FORMA INCOME STATEMENT Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 15% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 65% of sales. Austin's tax rate, interest expense, and dividend payout ratio...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company...
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company for 2013 and an expected sales growth rate of 6.61 % for​ 2014, prepare a pro forma income statement for 2014. First, find the percentage of each income statement line from 2013 as a percent of sales. ​(Round to three decimal​ places.) Sales Revenue $22,811,000 ____ % Cost of goods sold $-11,638,000 ___% Selling, general, and administrative expenses $-3,973,000 ____% Depreciation expenses $ -1,369,000...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s Oil Service Company: Actual Sales 3rd QTR                    Estimated Sales 4th QTR July        $1,200,000                               Oct.                $3,000,000 Aug.       $1,400,000                              Nov. $5,000,000 Sept.     $1,600,000                              Dec.                $7,000,000 ****************************************************************** Actual Purchases 3rd QTR             Estimated Purchases 4th QTR July       $1,000,000                              Oct.                  $3,000,000 Aug.      $1,500,000                               Nov.    $4,000,000 Sept.     $2,000,000                               Dec.               $1,000,000 __________________________________________________________________ One-half (50 percent) of the sales each month are...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. 1.Create the pro forma statements. 2. What’s the plug variable here? 3. If Fire Corp pays half of income as dividend,...
You have developed the following pro forma income statement for your​ corporation:   LOADING.... It represents the...
You have developed the following pro forma income statement for your​ corporation:   LOADING.... It represents the most recent​ year's operations, which ended yesterday. Your supervisor in the​ controller's office has just handed you a memorandum asking for written responses to the following​ questions: a.  If sales should increase by 25 ​percent, by what percent would earnings before interest and taxes and net income​ increase? b.  If sales should decrease by 25 ​percent, by what percent would earnings before interest and...
Discuss the simplified procedures used to prepare and evaluate the pro forma income statement and the...
Discuss the simplified procedures used to prepare and evaluate the pro forma income statement and the pro forma balance sheet. What ethical issues do you believe are present in these procedures and how does the SOX Act address these concerns? In your response, you should also discuss the judgmental approach.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT