Common-size-analysis-template.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Common-size-analysis-template.xlsx as PDF for free.
More details
- Words: 256
- Pages: 4
Common Size Analysis Template
Notes This Excel model is for educational purposes only and should not be used for any other reason. All content is Copyright material of CFI Education Inc. https://corporatefinanceinstitute.com/
© 2019 CFI Education Inc.
All rights reserved. The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected
No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any form by any means, including photocopying, recordin
Strictly Confidential
ormulas, and code, are protected under international copyright and trademark laws. including photocopying, recording, or other electronic or mechanical methods,
© Corporate Finance Institute®. All rights reserved.
Common Size Analysis Income Statement
Company A
Percent
Company B
Percent
100,000
100%
550,000
100%
COGS
70,000
70%
390,000
71%
Gross Profit
30,000
30%
160,000
29%
10,000
10%
37,000
7%
Advertising
3,000
3%
11,900
2%
General and Administrative
2,000
2%
10,800
2%
Total Operating Expenses
15,000
15%
59,700
11%
Operating Income Interest Expense Income Before Income Taxes Income Tax Expense
15,000 2,000 13,000 3,000
15% 2% 13% 3%
100,300 28,000 72,300 26,000
18% 5% 13% 5%
Net Income
10,000
10%
46,300
8%
Revenue
Operating Expenses Research and Development
Regular Profit Analysis 600,000
100%
500,000
80%
400,000
60%
300,000
40%
200,000
20%
100,000 -
Common Size Profit Anal
Company A Revenue
Company B Net Income
0%
Company A Revenue
Co Net Income
This file is for educational purposes only. E&OE
Corporate Finance Institute® https://corporatefinanceinstitute.com/
on Size Profit Analysis
ny A Revenue
Company B Net Income
Notes This Excel model is for educational purposes only and should not be used for any other reason. All content is Copyright material of CFI Education Inc. https://corporatefinanceinstitute.com/
© 2019 CFI Education Inc.
All rights reserved. The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected
No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any form by any means, including photocopying, recordin
Strictly Confidential
ormulas, and code, are protected under international copyright and trademark laws. including photocopying, recording, or other electronic or mechanical methods,
© Corporate Finance Institute®. All rights reserved.
Common Size Analysis Income Statement
Company A
Percent
Company B
Percent
100,000
100%
550,000
100%
COGS
70,000
70%
390,000
71%
Gross Profit
30,000
30%
160,000
29%
10,000
10%
37,000
7%
Advertising
3,000
3%
11,900
2%
General and Administrative
2,000
2%
10,800
2%
Total Operating Expenses
15,000
15%
59,700
11%
Operating Income Interest Expense Income Before Income Taxes Income Tax Expense
15,000 2,000 13,000 3,000
15% 2% 13% 3%
100,300 28,000 72,300 26,000
18% 5% 13% 5%
Net Income
10,000
10%
46,300
8%
Revenue
Operating Expenses Research and Development
Regular Profit Analysis 600,000
100%
500,000
80%
400,000
60%
300,000
40%
200,000
20%
100,000 -
Common Size Profit Anal
Company A Revenue
Company B Net Income
0%
Company A Revenue
Co Net Income
This file is for educational purposes only. E&OE
Corporate Finance Institute® https://corporatefinanceinstitute.com/
on Size Profit Analysis
ny A Revenue
Company B Net Income
More Documents from "Muhammad Farooq"
Muhammad Farooq
May 2020 4
Common-size-analysis-template.xlsx
November 2019 9
70.thetell-tleheart.pdf
May 2020 14
5
November 2019 54
110
November 2019 75