AutoSave ABCD Annual Financial Report and EBITDA Sample Home Draw Page Layout Formulas Data Review View Acrobat Tell me 14 Insert X ti -A A PA Wrap Text General () Euphemia (Headin... 10 BIU EX! Delete Format 27.0 U Paste A = e Verge & Center $ - % Insert Conditional Format Cel Formatting as Table Styles Sort & Filter Find Select Analyze Data L17 Xfx B C D E F G H J K L M N 2 INPUT YOUR FINANCIAL DATA 3 METRIC NAME 2016 2017 2018 2019 2021 4 5 5 7 3 E = Earnings and Profits (E&P) ) 2 0 1 2 3 REVENUES OPERATING EXPENSES OPERATING PROFIT DEPRECIATION INTEREST NET PROFIT TAX PROFIT AFTER TAX METRIC 1 METRIC 2 MET METRIC 3 METRIC 4 METRIC 5 METRIC 6 EBITDA 2015 $125,000.00 $65.000.00 $60,000.00 $4,500.00 $2,500.00 $54,000.00 $22,000.00 $32,000.00 $12.80 $18.20 . $19.10 $12.10 $0.75 $0.23 $61.000.00 $134,137.45 $70,962.31 $64.207.30 $4517.77 $2,745.82 $54,761.08 $23920 55 $34.943.49 $12.81 Stoco $18.59 $20.56 $12.22 $0.79 $0.25 $142,728.38 $75,924.87 $68,857.69 $4,656.92 $2,893.11 $55 860.82 $25,576.74 $38.418.53 $13.78 $19.22 $21.87 $12.59 $0.85 SO.27 $150,687.47 $78,901.28 $75,643.26 $4.974 21 $3.136.13 $59,747.96 $27,498.86 $39.895.05 $14.29 $20.17 $23.19 $13.71 $0.89 $0.28 $165,044.56 $81,674.37 $76,755.26 $5,02411 $3,148.53 561,483.59 $28,335.68 $40,607.74 $15.58 $20.48 $24.68 $13.76 $0.92 $0.30 2020 $180,026.64 $80,883.33 $77,317 84 $5,068.42 $3,338.31 $66,272.10 $29,424.53 $42.438.20 $16.79 $21.84 $26.40 $14.59 $1.00 50.31 $180,583.88 $94.419.46 $73.426.00 S5,546.89 $3,789.47 $67,474.86 $31,408.26 $50,247.68 $19.96 $26.02 $31.09 $14.92 E - E&P of a Corporation 4 5 6 51.04 7 $0.34 8 9 0 1 2 3 14 5 E = Earnings & Profits B-Before | = Interest Income and Expenses) ) Tax - Taxes Oncome) D - Depreciation A - Amortization (Figure 2) 2. Please see Figure 2 above. Figure 2 above shows the revenues and EBITDA calculation for a company. If you were told that the company was a partnership or limited liability company, how would that affect the importance of T in EBITDA? Would T be more important or less important? Please explain