Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Bartleby Related Questions Icon

Related questions

Question

Please answer fast. 

Table 7.7 Spreadsheet Pro Forma Income Statement fo
Карра, 2021-2026
Year 2021
2022
2023
2024
2025
2026
Income Statement (S 000)
1 Sales
75,000 88,358 103,234 119,777 138,149 158,526
2 Cost of Goods Sold
3
Raw Materials
(16,000) (18,665) (21,593) (24,808) (28,333) (32,193)
(18,000) (21,622) (25,757) (30,471) (35,834) (41,925)
41,000
Direct Labor Costs
5 Gross Profit
6 Sales and Marketing
7 Administrative
8 EBITDA
9 Depreciation
10 EBIT
4
64,498
(11,250) (14,579) (18,582) (23,356) (27,630) (31,705)
48,071
55,883
73,982
84,407
(13,500) (13,254) (15,485) (16,769)
(17,959) (20,608)
32,094
16,250
20,238
21,816
24,373
28,393
(5,500)
(5,450)
(5,405)
(6,865)
(7678)
(7,710)
10,750
14,788
16,411
17,508
20,715
24,383
11 Interest Expense (net)
(75)
10,675
(6,800)
(6,800)
9,611
(6,800)
10,708
(7,820)
12,895
(8,160)
12 Pretax Income
7,988
16,223
13 Income Tax
(3,736)
(2,796)
(3,364)
(3,748)
(4,513)
8,382
(5,678)
14 Net Income
6,939
5,193
6,247
6,960
10,545
expand button
Transcribed Image Text:Table 7.7 Spreadsheet Pro Forma Income Statement fo Карра, 2021-2026 Year 2021 2022 2023 2024 2025 2026 Income Statement (S 000) 1 Sales 75,000 88,358 103,234 119,777 138,149 158,526 2 Cost of Goods Sold 3 Raw Materials (16,000) (18,665) (21,593) (24,808) (28,333) (32,193) (18,000) (21,622) (25,757) (30,471) (35,834) (41,925) 41,000 Direct Labor Costs 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 4 64,498 (11,250) (14,579) (18,582) (23,356) (27,630) (31,705) 48,071 55,883 73,982 84,407 (13,500) (13,254) (15,485) (16,769) (17,959) (20,608) 32,094 16,250 20,238 21,816 24,373 28,393 (5,500) (5,450) (5,405) (6,865) (7678) (7,710) 10,750 14,788 16,411 17,508 20,715 24,383 11 Interest Expense (net) (75) 10,675 (6,800) (6,800) 9,611 (6,800) 10,708 (7,820) 12,895 (8,160) 12 Pretax Income 7,988 16,223 13 Income Tax (3,736) (2,796) (3,364) (3,748) (4,513) 8,382 (5,678) 14 Net Income 6,939 5,193 6,247 6,960 10,545
FV
PV =
n*T
Exercise 17
1+
Forecasting Income
Problem
1) By what percentage is Kappa's EBITDA expected to grow over the five-year period? By how much
would it grow if Kappa's market share remained at 10%?
2) Compute the EBITDA growth on an annual basis.
• Reminder: By cutting administrative costs immediately and
redirecting resources to new product development, sales, and
marketing, you believe Kappa can increase its market share
from 10% to 15% over the next five years.
1*5
FV
i =
PV
-1
Copyright AUAF 2021 - Pierre Rostan, PhD -
expand button
Transcribed Image Text:FV PV = n*T Exercise 17 1+ Forecasting Income Problem 1) By what percentage is Kappa's EBITDA expected to grow over the five-year period? By how much would it grow if Kappa's market share remained at 10%? 2) Compute the EBITDA growth on an annual basis. • Reminder: By cutting administrative costs immediately and redirecting resources to new product development, sales, and marketing, you believe Kappa can increase its market share from 10% to 15% over the next five years. 1*5 FV i = PV -1 Copyright AUAF 2021 - Pierre Rostan, PhD -
Expert Solution
Check Mark
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.
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education