Using data from CABS, create pro forma income statements for 2017 CABS expects sales to increase by 5 (worst case), 10 (most likely) or 15 (best case) 2016 Sales $ 1,680 0 COGS 910 4 Gross profits (EBITDA) 769 6 Less Operating expenses SG A 389 0 Depreciation 79 0 Total operating expenses 468 0 EBITDA 301 6 Depreciation and amortization 79 0 EBIT 222 6 Interest expense 25 0 EBT 197 6 Taxes (40 ) 79 0 Net income $ 118 6

The Answer is in the image, click to view ...

Question: Using data from CABS, create pro forma income statements for 2017. CABS expects sales to increase by 5% (worst case), 10% (most likely) or 15%

Using data from CABS, create pro forma income statements for 2017. CABS expects sales to increase by 5% (worst case), 10% (most likely) or 15% (best case).

2016
Sales	$	1,680.0
COGS		910.4
Gross profits (EBITDA)		769.6
Less: Operating expenses
SG&A		389.0
Depreciation		79.0
Total operating expenses		468.0
EBITDA		301.6
Depreciation and amortization		79.0
EBIT		222.6
Interest expense		25.0
EBT		197.6
Taxes (40%)		79.0
Net income	$	118.6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

assets. 6. Using data from CABS, create pro forma income statements for 2017. CABS expects sales to increase by 5% (worst case), 10% (most likely) or 15% (best case). Using the percent of sales...

You are responsible for determining the future financing requirements for Premier Paper Company. The firm?s financial statements are posted on Isidore as Case II Financials. Complete a DuPont...

Questions 1-6. Thank you! Figure 1 Pro Forma Income Statements 2016 2017 2018 $5,340 1,716 3,624 CHEM-MED COMPANY Income Statements 20132015 (in 000) 2013 2014 2015 Net sales (all credit) $ 777...

Based on intense market research, the company expects sales to increase +15% (best case), +10% (most likely), or +5% (worst case). Using the % of sales method, and assuming only COGS and SG&A...

I need help with the following case study of Advance Financial Managemdnt Accounting. I have added pictures of the case along with the student instruction. Please help me with step by step process if...

prepare pro forma income statements, cash budgets and balance sheet for each quarter of 2017. Rocky Mountain Vacations Rocky Mountain Vacations (RMV) Ltd. is a retailer of recreational vehicles (RVs)...

Rocky Mountain Vacations Student Instructions Follow these steps in analyzing the case: 1. Assuming the status quo (no change to existing practices), prepare pro forma income statements, cash...

Income Statement - Percent - of - sales method 1 . Create a common size income statement using the following data: Sales $ 1 2 0 , COGS $ 6 0 , SG&A $ 3 0 , Depreciation $ 1 6 , Interest expense $ 2...

Case 1 - Company's] Purchase Decision This case is a simple capital budgeting exercise that should reinforce your understanding of the following topics: Incremental unlevered net income Free cash...

Seminar in Finance: Can you please help me figure out how to do the Sensitivity and Scenario analysis? Greatly appreciated! sensitivity analysis: Scenario Analysis: Case - Canyon Buff's Chemical...

Jing is concerned about having to repay her Old Age Security (OAS) pension that she receives. This is very stressful as she is on a very limited budget. She knows that if her income is over the...

Compare and contrast the requirements of IFRS 3 and IAS 37 in respect of restructuring provisions and contingent liabilities .

In general, a corporation can choose to use either the accrual or cash method of accounting no matter how large the corporation. true or false

(ANSWER IN 3-4 sentences each) 1) Turner v. Dolcefino and KTRK : (a) What statement made by Dolcefino on his KTRK broadcast was alleged by Turner to be defamatory? (b) What is a complete defense by...

V. Conclusion and follow-up A. Take any questions or concerns B. Establish next meeting time and what should be accomplished by then?

3 As the groups leader, do you have a responsibility to these interns to ensure that they get the most from their internship experience?

How do cognitive, psychological, and social forces affect decision making in groups youre currently involved in? Have these forces ever caused your group to make a poor decision? If so, how?