QUESTION 3 3.1 Prepare a projected statement of comprehensive income for the year ended 31 December 2021 to determine the sales needed to produce a profit after tax that is 25% more than that for the year ending 31 December 2020. (Where applicable round of amounts to the nearest rand) INFORMATION: Calder Enterprises Statement of Comprehensive Income for the year ended 31 December 2020 R 5 445 000 (3 539 250) 1 905 750 (1 122 000) Sales Cost of sales Gross profit Operating expenses Income from operations 783 750 Interest expense (98 900) Profit before tax 684 850 Income tax (191 758) Profit after tax 493 092 Additional information: 1. Cost of sales is expected to be 60% of sales. 2. Operating expenses will increase by 4%. 3. Interest expense will increase to R120 000. 4. The tax rate will remain at 28% 3.2 Use the information from question 3.1 (not your solution) and calculate the following for the year ending 31 December 2020: 3.2.1 Gross margin 3.2.2 Net profit margin 3.2.3 Operating margin 3.2.4 Interest coverage
Q: Question No: 1 S LO: 2 The following information has been taken from the accounting records of Ahmed…
A: Hi student Since there are multiple questions, we will answer only first question. Since first…
Q: Question 1 Q.1.1 Study the extract from the statement of comprehensive income of Sandton Traders for…
A: Operating expenses refers to the day-to-day expenses a company incurs to run its business. These…
Q: QUESTION FIVE: The following information relates to the operations of the East L. Trading Company…
A: The ratio analysis helps to analyse the financial statements of the business.
Q: Q3: Hebron CO. provided the following partial-trial balance for the current year. Prepare a…
A: Amount($) Sales $ 225,400 Less - COGS $ 90,100 Gross Profit $ 135,300…
Q: Requirement 7. Calculate the following ratios as of January 31, 2025 for Milton Delivery Service:…
A: Return on Assets: Return on assets (ROA), which is often referred to as return on total assets, is a…
Q: Activity 2 Perform the vertical analysis of the ABC Corporation. ABC Trading Statement of…
A: Horizontal analysis: It means where the analysis is made with regard to two different periods…
Q: 6.6 Problem HYZEL Manufacturing Company presents the following: Statement of Comprehensive Income…
A:
Q: The following information was extracted from the financial statement of Barry for the year ended 31…
A: Formula: Inventory turnover days = 365 days / Inventory turnover ratio.
Q: QUESTION FIVE: The following information relates to the operations of the East L. Trading Company…
A: Current ratio and acid test ratio are the liquidity ratios that helps in analyzing the liquidity…
Q: The following information has been taken from the accounting records of Ahmed and Company in first…
A: Contribution margin / Profit volume ratio = Change in Profit / Change in Sales = ($25,000-$15,000) /…
Q: If Decker had a financing deficit, it could remedy the situation by a. buying back common stock…
A: Deficit means the expenditures are in excess of incomes. Financing deficit means arranging finance…
Q: Q1. Complete the statement provided, for a tax rate of 20% and calculate the Operating cash flow…
A: The inflow, as well as outflow of cash by conducting the ordinary business activities, is referred…
Q: QUESTION 4 (i) The London Ltd provided the following information regarding its operations: $…
A: Ratio analysis means where different ratio of various years of years companies has been compared and…
Q: 2020 P1,939,500 900,000 1,039,500 445,500 37,575 P 556,425 Percentage 2019 P1,674,675 843,975…
A: Formula: Revenue % = ( Revenue value / revenue ) x 100
Q: REVIEW: Use the following to answer questions 28 – 32 T&JR Corp reports the following income…
A: Calculation of Sales Sales = Net Sales + Sales Discounts Sales = $ 789,000 + $ 15,000 Sales = $…
Q: Exercise 6-22 Profit and loss data for Lota & Romy, Inc. for 2019 and 2020 follow: 2019 2020…
A: The Profit and Loss data are provided for the year 2019 and 2020. Required Prepare the Summary for…
Q: be the net income? a. 72000 b. 56000 c. 16000 d. 338000 Clear my choice Question 43 Not yet answered…
A: The trial balance consists of all the items of business transactions. It has assets, liabilities,…
Q: ACTUAL PROJECTED FOR THE YEAR ENDED 31 DECEMBER FOR THE YEAR ENDED 31 DECEMBER 2016 2017 2018 2019…
A: The gross profit margin formula, Gross Profit Margin = (Revenue – Cost of Goods Sold) / Revenue x…
Q: 6.6 Problem HYZEL Manufacturing Company presents the following: Statement of Comprehensive Income…
A: As only sub-parts 4, 5 and 6 are asked, therefore answering them accordingly. Retained earnings…
Q: The income statement for the year ended 31 December 2021 and the balance sheet as of 31 December…
A: A cash flow statement indicates cash inflow and cash outflow information of a particular time…
Q: Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000
A: Given by, year Sales 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020…
Q: 17. Halal Berhad’s comparative financial statements for the years ending 31 December 2020, and 2019,…
A: Fixed assets are those assets which are held for longer period of time. Long term liabilities are…
Q: Company is subject to an income tax rate of 30%. It has the provided the following data on December…
A: Ratio Analysis is a method of evaluation of the financial performances of an organisation during a…
Q: b. Prepare an income statement forecast for the fiscal year 2015 (ending January 30, 2016), based on…
A: Income statement is a statement that shows the total incomes and expenditure incurred or generated…
Q: Question 6 of / e an income statement through gross profit. MARIGOLD COMPANY Income Statement…
A: The profit a firm makes after deducting the costs of producing and selling its products, or the…
Q: Problem 2 The following income statement data presented by VGP Company for the years ended December…
A: SOLUTION FORMULAS 1- PRICE QUANTITY VARIANCE = (UNIT SOLD IN 2021 - UNIT SOLD IN 2020)/ RATE PER…
Q: Requirement 1. Prepare a horizontal analysis of the comparative income statement of McCormick…
A: In the given question, we are supposed to prepare a horizontal analysis of the comparative income…
Q: Direction: Answer what has been asked. Show your solution in another sheet of paper. 1. Below are…
A: Answer) Calculation of Return on Assets Return on Assets = Net Income/ Total Assets 2020: Return…
Q: Question 5 Financial statement analysis and ratios 1 The following ratios were provided for Laura…
A: The interpretation /comments on profitability, liquidity and financial stability is presented…
Q: Additional Information: (a) Gross profit rate for 2019 is 50%, which decreased by 5% in 2020 due to…
A: While preparing an income statement, we can use ratio analysis to find out the missing figures. For…
Q: Table 3.3 shows the December 31, 2018 pro forma balance sheet and income statements for R&E…
A: The company is estimating an external financing of $1.4 million even though they have $1.3 million…
Q: 4) Finance You estimate that the net income for a company next year is a uniform distribution with a…
A: The maximum and minimum are away from mean by number of standard deviations and that depends on the…
Q: 2020 2019 (dollars in millions) $ 37,580 2,231 1,318 $33,075 1,283 Net sales Earnings before taxes…
A: Solution:- Computation of Vertical and Horizontal analysis from the above information as follows:-
Q: Problem #1: On June 30, 2020, PSA Trading Co. has the following information: revenue from sales is…
A: As posted multiple independent questions we are answering only first question kindly repost the…
Q: Question 5 -/1 View Policies Current Attempt in Progress Marigold Corp.reported the following items…
A: Controllable Margin: The part of sales revenue over and above the variable costs is called the…
Q: 4. The following common size income statement Corporation for the two years ended December 2019, and…
A: Common size analysis of income statement shows each item of income statement as a percentage of…
Q: QUESTION 4 Use the information provided to answer the questions. 4.1 Study the ratios provided below…
A: Weighted Average Cost of Capital: It is the rate at which the company pays to all its shareholders…
Q: 47. Halal Berhad’s comparative financial statements for the years ending 31 December 2020, and 2019,…
A: Quick Ratio: It is a liquidity ratio and shows company's ability to use quick assets to retire its…
Q: СP 5-1 Consider the following information of Jones Corporation over four years: 2022 2021 2020 2019…
A: I am answering the first question as per bartleby guidelines. Please re-submit the remaining…
Q: STATEMENT OF COMPREHENSIVE INCOME Practice Set 12 1. The Swift Company presented the balances of…
A: Income statement is one of the financial statement that is being prepared for the purpose of…
Q: Calculate the gross profit margin for Pearson & Litt for 2020. Q.2 Explain the results of the gross…
A: Gross profit is the profit generated after deducting direct expenses related to the goods from the…
Q: Question 2 of 8 14 Poin Extract from Income Statement for the year ended 30 June 2020: R Sales 5 220…
A: Hi student Since there are multiple sub parts, we will answer only first three sub parts.
Q: Quinto Capital (Sept 1) P20,000 (Jan 1) P165,000 (Apr 1) 75,000 Requirements: Prepare journal…
A: note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…
Q: Problem #2 (Adapted) – Vertical Analysis The following date relate to Bravo Company for the year…
A: Vertical analysis is the method of analyzing financial statements of the company by finding out the…
Q: Oriental Manufacturing recently reported the following information: Net income is P600,000, ROA is…
A: Given, Net Income = P600,000 ROA = 8% Interest = P225,000 Tax rate = 35%
Q: TASK THREE: Income Statement for the year ended 31 December 2020 Edward Frankie Company Company…
A: Gross profit ratio = Gross profit/ Sales Net profit ratio = Net profit/ Sales Expense to sales ratio…
Q: PROBLEM 1 (Income Statement). Presented here are the o Determine the missing amounts. Sales COGS…
A: Below is the components of the income statement and their relation with one another. Income…
Q: QUESTION 4 E18.4 E18.4 (LO 2) Prepare vertical analysis. Operating data for Joshua Corporation are…
A: Income statement: It is one of the financial statements prepared by an organization. This statement…
Step by step
Solved in 2 steps with 2 images
- Prepare a projected statement of comprehensive income for the year ended 31 December 2021 to determine the sales needed to produce a profit after tax that is 25% more than that for the year ending 31 December 2020. (Where applicable round of amounts to the nearest rand) INFORMATION: Calder Enterprises Statement of Comprehensive Income for the year ended 31 December 2020 R Sales 5 445 000 Cost of sales (3 539 250) Gross profit Operating expenses Income from operations Interest expense 1905 750 (1 122 000) 783 750 (98 900) Profit before tax 684 850 Income tax (191 758) Profit after tax 493 092 Additional information: 1. Cost of sales is expected to be 60% of sales. 2. Operating expenses will increase by 4%. 3. Interest expense will increase to R120 000. 4. The tax rate will remain at 28% 3.2 Use the information from question 3.1 (not your solution) and calculate the following for the year ending 31 December 2020: 3.2.1 Gross margin 3.2.2 Net profit margin 3.2.3 Operating margin 3.2.4…Problem 1: Comparative income statements for 2020 and 2019 follow. Sales Cost of Sales Gross Profit Operating Expenses Operating Income Interest Expense Earnings Before Tax Income Taxes Net Income 2020 $9,434,000 7,075,400 $2,358,600 $2,201,360 1,367,690 1,365,060 $ 990,910 $836,300 157,500 126,000 $ 833,410 $ 710,300 400,000 317,200 $ 433,410 $ 393,100 2019 $7,862,000 5,660,640 Required: 4 a. Prepare a vertical common-size analysis of this statement for each year, using sales as the base. b. Comment briefly on the changes between the two years, based on the vertical common-size statement.Assignment COMPARATIVE STATEMENTS Sikat Manufacturing Corporation Income Statement For the year ended Dec. 31, 2020 and 202019 2020 2019 P 5,150,000 -150,000 5,000,000 3,200,000 1,800,000 Sales 4,250,000 na 250.000 4,000,000 2.600,000 1,400,000 Less: Sales Returns and Allowances Net Sales Less: Cost of Sales Gross Profit Less: Operating Expenses Selling Expenses General and Administrative Expenses Total Operating Expenses Operating Income Less: Interest expense Net Income before tax Less: Income tax.(32% ) Net Income 720,000 780,000 1,500,000 300,000 60,000 240,000 76,800 P 163.200 600,000 600,000 1,200,000 200,000 40,000 160,000 51,200 P 108,800 Sikat Manufacturing Corporation Balance Sheet Dec. 31, 2020 and 2019 2020 2019 ASSETS P 225,000 150,000 240,000 260,000 120,000 150,000 70,000 550,000 P1.765.000 P 1,520,000 Cash P140.000 125,000 180,000 160,000 145,000 170,000 80,000 520,000 Marketable Securities Accounts Receivable Inventories: Finished Goods Work-in-Process Raw Materials…
- Prepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023 INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000 Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000 Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000 EQUITY AND LIABILITIESEquity 3 760 000 Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000 Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000 B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…The financial data of Mammoth corporation for the year ended 31st December,2020 is as followsParticulars Variable expense as percentage of sales 66.67Interest Expense ($) 200DOL 5DFL 3Income tax rate 0.35Requirement:a) Prepare income statement for company.Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,788,322 211,362 571,823 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…
- Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,091,242 158,522 428,867 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported Horizon Period $ millions 2018 2019 2020 2021 2022 TerminalPeriod Sales $56,912 $57,766 $58,632 $59,512 $60,404 $61,008 NOPAT 2,492 2,542 2,580 2,619 2,658 2,684 NOA 4,032 4,097 4,158 4,221 4,284 4,327 Answer the following requirements assuming a discount rate (WACC) of 7.8%, a terminal period growth rate of 1%, common shares outstanding of 135.6 million, net nonoperating obligations (NNO) of $(6,129) million, which is negative because Humana’s nonoperating assets exceed its nonoperating liabilities, and no noncontrolling interest (NCI) on the balance sheet. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31, 2018. Instructions: Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and…Use the given statement of comprehensive income below in answering the question. DEF Company, Income Statement 2021 2020 Sales P10,200.00 P9,600.00 Cost of Goods Sold P3,000.00 P2,600.00 Gross Profit P7,200.00 P7,000.00 Operating Expenses P2,400.00 P2,200.00 Operating Profit P4,800.00 P4,800.00 Interest Expense P900.00 P800.00 Earnings before tax P3,900.00 P4,000.00 Income Tax P1,560.00 P1,600.00 Net Profit P2,340.00 P2,400.00 How many percent of the sales is the operating expenses in 2021 and 2020? A 8.82% and 8.33% 70.59% and 72.92% 29.41% and 27.08% 23.53% and 22.92%
- Use the given statement of comprehensive income below in answering the question. DEF Company, Income Statement 2021 2020 Sales P10,200.00 P9,600.00 Cost of Goods Sold P3,000.00 P2,600.00 Gross Profit P7,200.00 P7,000.00 Operating Expenses P2,400.00 P2,200.00 Operating Profit P4,800.00 P4,800.00 Interest Expense P900.00 P800.00 Earnings before tax P3,900.00 P4,000.00 Income Tax P1,560.00 P1,600.00 Net Profit P2,340.00 P2,400.00 What is the percent change of net profit? А -3.5% В 12.5% C) -12.5% -2.5%What is the company’s gross profit rate beginning January 1, 2020? A. 24% B. 21% C. 17% D. 20%Module pute Net Operating Profit after Tax Refer to the balance sheet information below for Home Depot. Feb. 3, 2019 Jan. 28, 2018 $35,891 $34,794 1,511 3,056 $37,402 $37,850 $14,177 $13,640 24,822 22,974 $38,999 $36,614 Operating assets Nonoperating assets Total assets $ millions Operating liabilities Nonoperating liabilities Total liabilities Net sales Operating expense before tax Net operating profit before tax (NOPBT) Other expense Income before tax Tax expense Net income Assume a statutory tax rate of 22%. a. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = Net income + NNE Net income NNE NOPAT $ 9,453 $ $ $91,973 78,772 13,201 828 12,373 2,920 $9,453 7,361 * $ 16814 b. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = NOPBT - Tax on operating profit NOPBT Tax on operating profit 7,361 * $ 10,296.78 x $ NOPAT -2936