Can u please give the horizontal analysis for this and interpret the results. Income statement for XYZ businessfor the period ending 31st of December 2010$INCOMEServices rendered94,60094,600EXPENSESSalaries(63,780)25,0006,50016,0001,0007,3001,0002,500412Telephone & internetWater & electricityProperty rates and taxesInsuranceAdvertising costsFuelStationeryBank charges / interest paidТах еxpense6543,414NET PROFIT30,820

Horizontal analysis - Horizontal Analysis is part of the analysis in which individuals get the idea…

Income statement for XYZ business for the period ending 31st of December 2010 INCOME Services rendered 94,600 94,600 EXPENSES Salaries (63,780) Telephone & internet Water & electricity Property rates and taxes Insurance 25,000 6,500 16,000 1,000 7,300 1,000 2,500 412 Advertising costs Fuel Stationery Bank charges / interest paid Tax expense 654 3,414 NET PROFIT 30,820

Income statement for XYZ business for the period ending 31st of December 2010 INCOME Services rendered 94,600 94,600 EXPENSES Salaries (63,780) Telephone & internet Water & electricity Property rates and taxes Insurance 25,000 6,500 16,000 1,000 7,300 1,000 2,500 412 Advertising costs Fuel Stationery Bank charges / interest paid Tax expense 654 3,414 NET PROFIT 30,820

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.5.1MBA

See similar textbooks

Similar questions

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…
This year Last year 1050 Assets Cash 1530 Marketable securities Accounts receivable Inventories Total current assets 1810 1220 2050 1770 2900 2790 8290 6830 Gross fixed assets 29480 28090 Less: Accumulated depreciation 14680 13140 Net fixed assets 14800 14950 Total assets Liabilities and Stockholders' Equity 23090 21780 Accounts payable Notes payable Accruals 1560 1540 2760 2160 190 350 Total current liabilities 4510 4050 Long-term debt Common stock Retained earnings Total stockholders' equity 5220 4970 9950 9950 3410 2810 13360 12760 Total liabilities and stockholders' equity 23090 21780
Do the calculations in excel, attach excel screenshots and explain the steps and formulas used for solving the problem. Following are the particulars available
Selected ratios formulars Unilever 2021 BOPP 2021 ROCE PBIT / net assets * 100 (32,424/39,406 *100 = - 82% 102,154 / 192,758 *100 =53% Net Assets Turnover Revenue / Net Assets 526,912 / 39,406 = 13 times 214,174 / 192,758 = 1 time Gross Profit Margin Gross profit / revenue *100 97,046 / 526,912 *100 18.4% 115,462 / 214,174 * 100 54% Net Profit Before Tax PBT / revenue * 100 (35,005) / 526,912* 100 = -6.6% 104,778 / 214,174* 100 =48.9% Current Ratio Current assets / current liabilities 214,665/341,171 = 0.5 139,104 / 30,368 = 4.5 Quick Ratio Current assets – inventory / current liabilities 214,665-91,627 /341,171 = 0.4 139,104 -13,248/ 30,368 = 4.1 Inventory Days Inventory / cost of sales * 365 days 91,627/ 429,866 *365 = 77 days 13,248 / 101,397 *365 = 47 days Receivable Days Receivables / cost of sales * 365 days 24,515 / 429,866 *365 =20 days 92,860 / 101,397 *365 =334 days Payable Days…
Harlan Mining Co. has recently decided to go public and has hired you as an independent CPA. One statement that the enterprise is anxious to have prepared is a statement of cash flows. Financial statements for 2025 are provided below. Cash Accounts receivable Inventory Property, plant, and equipment Less accumulated depreciation Accounts payable Income taxes payable Bonds payable Common stock Retained earnings COMPARATIVE BALANCE SHEETS 12/31/25 Sales revenue $608000 (320000) $408000 360000 384000 288000 $1440000 $176000 352000 360000 216000 336000 $1440000 INCOME STATEMENT For the Year Ended December 31, 2025 12/31/24 $960000 (304000) $8400000 $192000 216000 480000 656000 $1544000 $96000 392000 600000 216000 240000 $1544000
COMPUTATIONS: Given the following data for SUPERCALIFRAGILISTICEXPIALIDOCIOUS COMPANY for the year ended December 31, 200X: Cost of sales Distribution costs Administrative expenses PhP 5,400,000 1,350,000 1,000,000 200,000 Other income Php 1,400,000 320,000 9,000,000 50,000 Other expenses Net sales Finance costs Prepaid expenses Tax rate is at 30% 11..Gross income а. 3,600,000 b. 5,000,000 с. 2,130,000 d. 1,491,000 12. Total income а. 3,600,000 b. 5,000,000 с. 2,130,000 d. 1,491,000 13. Total expenses a. 1,320,000 b. 2,350,000 c. 2,870,000 d. 2,670,000 14. Income before tax a. 3,600,000 b. 1,491,000 c. 7,530,000 d. 2,130,000
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.
Income Statement For the Year Ending December 31, 20X1Sales (on credit)$ 2,106,000Cost of goods sold1,371,000Gross profit$ 735,000Selling and administrative expenses561,000*Note asteriskOperating profit (EBIT)S 174,000Interest expense33,900Earnings before taxes (EBT)S 140,100Taxes83,300Earnings after taxes (EAT)S 56,800*Selling and administrative expenses Note asteriskIncludes $42,700 in lease payments. Using the above financial statements for the Jackson Corporation, calculate the following ratios. Profitability ratios. Note: Do not round intermediate calculations. Input your answers as a percent rounded to 2 decimal places.
The following are the financial statement Quick Ltd. for the year ended 31st December 2020: Quick Ltd. Income statement For year ended 31st December 2020 $”000” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) Profit before tax 150.00 Tax (70.00) Profit after tax 80.00 Quick Ltd. Statement of financial position as at 31 December 2020 2019 $”000” $”000d” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…
Calculate the common-sized percentage 2023. for Gross Margin in
MANCOSA POSTGRADUATE DIPLOMA IN PRORCT MANAGEMENT QUESTION REQUIRED Use the information provided below to calculate the following ratios. Where applicable, und e answers to two decimal places 111 Gross profe margin 312 Operating profit margin 31.3 invertory turnover period 31.4 Trade recelvatles peried 31.5 Trade payables period 31 316 Current ratio 3.1.7 Acid test ratio 3.18 Return on capital employed 32 Comment on the control ef debtors by Saturn imited Sugpest TWO 2) ways in which Saturn Limited can improve its operating profit margin. 33 INFORMATION Excerpts of financial data of Satum Limited for 2019 are as follows: STATEMENT OF COMPREHINSIVE INCOME FOR THE YEAR ENDED 31 DECEMBER 2019 2600 00 Cost of sales Gros proft Operating profit 1400 000 600 000 40 000 S60 00 Interest expense Proft before tas Tan N STATEMENT OF FINANCIAL POSITION AS AT 31 DECEMBER: 2019 2008 ASSETS Non-current assets Inventories Accounts recelvable 780000 500 000 240 000 120 000 45L000 1250 p0 EQUITY AND…
B. Below is the Statement of Comprehensive Income of Q & A Trading Company: Percentage 2020 P1,939,500 900,000 1,039,500 445,500 37,575 P 556,425 2019 Percentage Revenue Cost of Goods Sold Gross Profit Selling and General Experses Other Experses Net Income P1,674,675 843,975 830,700 409,725 30,825 P 390,150 Requirements: Prepare a vertical aralysis for Q & A Trading Compary.