a.
To compute: Net profit margin for the year.
Introduction: Net income is the excess of revenue earned over its expenses. It helps the investors to analyze the profitability of the company and take appropriate decision, thereof.
b.
To compute: CAGR of revenue and net income using GEOMEAN function.
Introduction: Net income is the excess of revenue earned over its expenses. It helps the investors to analyze the profitability of the company and take appropriate decision, thereof.
c.
To compute: CAGR of revenue using AVERAGE function.
Introduction: Net income is the excess of revenue earned over its expenses. It helps the investors to analyze the profitability of the company and take appropriate decision, thereof.
d.
To present: Revenue and net income in column chart.
Introduction: Net income is the excess of revenue earned over its expenses. It helps the investors to analyze the profitability of the company and take appropriate decision, thereof.
Want to see the full answer?
Check out a sample textbook solutionChapter 1 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- Please explain how to answer these questions, including the formulas I should use, the steps I should follow, and which financial statements to look at if relevant. 1.5 Calculate the sustainable growth rate for Top Harvest using the financial results of 2020/21 and comment on how Top Harvest could improve their sustainable growth rate in the future. 1.7 Calculate the Economic Value Added for Top Harvest (using Total Assets and not Net Assets) and comment on the performance of the business and how they could improve the EVA 1.6 Calculate the Weighted Average Cost of Capital for Top Harvest using the following information:arrow_forwardZNet Co. is a web-based retail company. The company reports the following for the past year. The company’s CEO believes that sales for next year will increase by 20% and both profit margin (%) and the level of average invested assets will be the same as for the past year. 1. Compute return on investment for the past year. 2. Compute profit margin for the past year. 3. If the CEO’s forecast is correct, what will return on investment equal for next year? 4. If the CEO’s forecast is correct, what will investment turnover equal for next year? Sales . $5,000,000 Operating income . $1,000,000 Average invested assets . $12,500,000arrow_forwardWhich of the following statements about earnings per share (EPS) is correct? Multiple Choice EPS is an indicator of how well a company will perform in the future. Net income in dollar amount is a better measure to use in comparing different companies. EPS can be used to compare companies of different sizes. EPS is expected to remain constant over a period of time.arrow_forward
- You are creating a pro forma balance sheet for the upcoming year. You have already prepared a pro forma income statement, and are predicting total assets will increase by $185,000 due to the increase in sales you are anticipating. How will you choose to finance this new growth in order to make sure the balance sheet balances?arrow_forwardI just need assistance with h.arrow_forwardPROBLEM 11-17 Return on Investment (ROI) and Residual Income LO11-1, LO11-2 Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc. Balance Sheet Beginning Ending Balance Balance Assets Cash $ 140,000 $ 120,000 Accounts receivable 450,000 530,000 Inventory 320,000 380,000 Plant and equipment, net 680,000 620,000 Investment in Buisson, S.A. 280,000 170,000 250,000 Land (undeveloped) 180,000 Total assets $2,020,000 $2,100,000 Liabilities and Stockholders' Equity Accounts payable. $ 360,000 $ 310,000 Long-term debt Stockholders' equity 1,500,000 1,500,000 160,000 290,000 Total liabilities and stockholders' equity $2,020,000 $2,100,000 Joel de Paris, Inc. Income Statement Sales $4,050,000 Operating expenses Net operating income 3,645,000 405,000 Interest and taxes: Interest expense $150,000 Таx expense 110,000 260,000 Net income $ 145,000 The company paid dividends of $15,000 last year. The "Investment in Buisson, S.A.," on the balance sheet represents an…arrow_forward
- The image uploaded is the calculation of Cal Bank's Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.arrow_forwardWhich of the following is most likely true concerning the stability and trend of earnings? Question options: The stability and trend of earnings require at least five years of historical data to be meaningful. The stability and trend of earnings are key factors when calculating cost of sales. The stability and trend of earnings are not factored in the analysis of revenues. The stability and trend of earnings depend on the trend of a single industry.arrow_forwardSuppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's salesarrow_forward
- Kevin is an employee in the finance department at Easy Trader Co. and is performing some financial analysis on the company's current year's performance. Before he can begin looking at a variety of nonfinancial factors, including customer conversion rates and internal promotion scores, he will need to evaluate some financial performance measures. Which of the following provides the most accurate rationale for evaluating economic value added? ◇ Evaluating profitability using a consistent measure like earnings without interest ○ Understanding the cash implications of a company's primary operating activities ◇ Evaluating after-tax income earned beyond the company's cost of capital on its invested capital O Evaluating income earned beyond the minimum required investmentarrow_forwardUse the extended DuPont equation to provide a breakdown of Computrons projected return on equity. How does the projection compare with the previous years and with the industrys DuPont equation?arrow_forwardIn your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the firm's additional funds needed (AFN) for next year. The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = So Sales growth rate = g Last year's total assets = Ao* Last year's profit margin= PM -$14,440 B -$15,200 Ⓒ-$16,000 D-$16,800 $200,000 40% $135,000 20.0% Last year's accounts payable Last year's notes payable Last year's accruals Target payout ratio $50,000 $15,000 $20,000 25.0%arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning