solve the two pls Direction: Create an appropriate graph for each business data table.Table 1- Product ProfitProduct20152016201720182019Product AP180,580P490,225P160,326P100,017P260,134Product BP780,970P820,262P480,640P480,640P480,640Product CP240,236P310,390P790,022P710,009P810,474Table 2- December ExpensesDecember ExpensesRent ExpenseP 10,000Utilities ExpenseP5,000Advertising ExpenseP5,000Salaries ExpenseP25,000Transportation ExpenseP2,000Supplies ExpenseP7,000Miscellaneous ExpenseP1,500

Analysis of financial statements is one of the major activities while making any financial decisions…

Answered: Direction: Create an appropriate graph…

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

ChapterC1: Eco Products, Inc

Section: Chapter Questions

Problem bA

See similar textbooks

Similar questions

Given a profit margin = 15%, ROE = 25%, D/E = 1.25, and assets = $600, please calculate sales.
Solvency and Profitability Trend Analysis (Graph Picture from A-D is on the buttom for references) Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate…
Prepare a vertical analysis scheduleHere is the operating data for Yalis Cleaning, Inc.:2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150PurposeThe purpose of this problem is to demonstrate an understanding of preparing a vertical analysis schedule.InstructionsAfter analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenueas the base amount. Round percentages to two decimal places.GuidanceFor formatting guidance, see the vertical analysis examples that are provided in Chapter 13 of the textbook.
Provide the missing data in the following tabulation: Division Alpha Bravo Charlie Revenue 11500000 Operating profit 920000 210000 Average operating assets 800000 Margin 4,00% 7,00% Turnover 5 Return on investment (ROI) 20% 14%
Performing vertical analysis The Randall Department Stores, Inc. chief executive officer (CEO) has asked you to compare the company’s profit performance and financial position with the averages for the industry. The CEO has given you the company’s income statement and sheet as well as the industry average data for retailers. Requirements Prepare a vertical analysis for Randall for both its income statement and balance sheet. 2 Compare the company’s profit performance and financial position with the average for the industry.
A financial analyst for Simon Manufacturing prepared the following report: Customers Customer-Level Operating Income Customer Revenue A $5041.00 $26,250 B $4202.00 $30,000 C $3368.00 $15,000 D $1069.50 $7,300 E $984.80 $5,100 F $844.80 $4,400 G $336.60 $1,800 H $252.00 $4,500 I ($168.00) $2,400 J ($676.00) $2,600 What is the cumulative customer-level operating income as a percentage of customer level operating income for the top 4 most profitable (operating income) customers? 1) 17.4% 2) 89.7% 3) 85.0% 4) 79.1%
Highlight the data in column B, the 2nd column next to year column., the Revenue ($m) data. Then create a Column Chart illustrating the Revenue ($m) data. Year Revenue ($ million) IVA ($ million) Establishments (Units) Enterprises (Units) Employment (Units) Wages ($ million) Corporate profits ($ billion) 2002 19429.1 11352.6 16633.0 15452.0 349652.0 10095.2 1124.9 2003 19200.9 11385.2 16638.0 15413.0 395140.0 10086.6 1279.5 2004 19787.6 12425.6 16932.0 15686.0 403789.0 11088.0 1520.9 2005 20294.5 12541.8 16835.0 15649.0 394396.0 11162.6 1703.0 2006 21337.1 13678.0 19024.0 17841.0 397106.0 11687.3 1827.9 2007 21578.0 14071.1 24087.0 22741.0 404551.0 12266.9 1657.8 2008 21953.0 12777.7 23113.0 21907.0 446480.0 11543.4 1363.7 2009 21737.9 12508.1 22827.0 21598.0 449850.0 11430.2 1459.8 2010 20628.1 13236.7 22578.0 21368.0 412348.0 11881.0 1798.8 2011 21082.2 13314.9 22817.0 21619.0 422687.0 12200.7 1844.6 2012 22140.3 14792.9 24514.0 23280.0 454038.0 13202.2…
Excel Online Structured Activity: Balance Sheet Analysis Consider the following financial data for J. White Industries: Total assets turnover: 1.2Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 27%Total liabilities-to-assets ratio: 45%Quick ratio: 0.90Days sales outstanding (based on 365-day year): 29.5 daysInventory turnover ratio: 4.0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Complete the balance sheet and sales information in the table that follows for J. White Industries. Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income StatementInformation Sales $ fill in the blank 2 Cost of goods sold $ fill in the blank 3 Balance Sheet Cash $ fill in the blank 4 Accounts payable $ fill in the blank 5 Accounts receivable $ fill in the blank 6 Long-term debt $…
Q.Use the ABC system to prepare a product-line profitability report for FS.
1. Company ABC produces and sells product X. Using information given below calculate Total Revenue (TR), Average Revenue (AR) and Marginal Revenue (MR).. Solution should be Excel format Quantity Price per product (EUR) Total Revenue (EUR) Average Revenue (EUR) Marginal Revenue (EUR) 1 100 100 100 100 2 95 190 95 90 3 90 270 90 80 4 85 340 85 70 5 80 400 80 60 6 75 450 75 50 7 70 490 70 40 8 65 520 65 30 9 60 540 60 20 10 50 500 50 -40
Use the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store. B. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.
Classify each of the following performance measures into the balanced scorecard perspective to which it relates: financial perspective, internal operations perspective, learning and growth perspective, or customer perspective. A. Number of improved products B. Time from packaging to delivery or display C. Production costs D. Number of customer suggestions E. Sales mix revenues F. Number of repeat customers

SEE MORE QUESTIONS

Recommended textbooks for you

Entrepreneurial Finance

Finance

ISBN:

9781337635653

Author:

Leach

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Entrepreneurial Finance

Finance

ISBN:

9781337635653

Author:

Leach

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

College Accounting, Chapters 1-27 (New in Account…

Accounting

ISBN:

9781305666160

Author:

James A. Heintz, Robert W. Parry

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

SEE MORE TEXTBOOKS