Fundamentals of Corporate Finance (4th Edition) (Berk, DeMarzo & Harford, The Corporate Finance Series)
Fundamentals of Corporate Finance (4th Edition) (Berk, DeMarzo & Harford, The Corporate Finance Series)
4th Edition
ISBN: 9780134475561
Author: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
Chapter 20, Problem 1CQ

Based on the forecasts in this case, use the following spreadsheet to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm’s net income over this period?

    1 Year 2016 2017 2018 2019 2020 2021
    2 Income Statement ($000s)
    3 Sales 100,000
    4 Cost of Goods Sold -45,333
    5 Gross Profit 54,667
    6 Sales and Marketing -15,000
    7 Administration -18,000
    8 EBITDA 21,667
    9 Depreciation -6,667
    10 EBIT 15,000
    11 Interest Expense (net) -1,021
    12 Pretax Income 13,979
    13 Income Tax -4,893
    14 Net Income 9,086

Blurred answer
Students have asked these similar questions
Suppose a firm has had the following historic sales figures. Year: Sales 2016 $1,900,000 2017 $2,150,000 2018 $1,800,000 2019 $2,400,000 2020 $2,000,000 What would be the forecast for next year's sales using the average approach? Next year's sales
Suppose a firm has had the following historic sales figures. Year: 2016 Sales $1,420,000 2017 $1,720,000 Next year's sales 2018 2019 2020 $1,600,000 $2,010,000 $1,770,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. 27
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,500,000 $1,670,000 $1,580,000 $2,160,000 $1,890,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. Next year's sales
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Entrepreneurial Finance
Finance
ISBN:9781337635653
Author:Leach
Publisher:Cengage
Text book image
Corporate Fin Focused Approach
Finance
ISBN:9781285660516
Author:EHRHARDT
Publisher:Cengage
Text book image
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license