Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data is shared below in the two excel spreadsheets labeled Balance Statement or Income Statement. 1.Prepare trend analysis on KPIs and determine those that

The data is shared below in the two excel spreadsheets labeled Balance Statement or Income Statement.

1.Prepare trend analysis on KPIs and determine those that require special attention in designing the audit plan and program.Include the trend analyses visualizations.

What, if any, issues/anomalies should be further analyzed?

2.Include in the ratios the most current interim information from the latest 10-Qs.

3.Using the conclusions and insights, plus the company's planspost pandemic, prepare a forecast of the company's income from operations for the first full post pandemic year.Provide details of what bases isused to forecast revenue and expenses and references/citations to sources of important information used.State the forecast assumptions and how they were developed. Disclose how the Company and their industry are thinking about the future.

4.Calculate the Beneish Model and note the conclusion on impact to the audit plan.

Please check my ratios and show how to complete the activity ratios? Where do the numbers come from?

image text in transcribedimage text in transcribedimage text in transcribed
EMERGENT BIOSDLUTIONS 1o-K AND 10-Q FINANCIAL INFORMATION Blance sheet 5 year period 2020-2016 Year Ending Year Ending Year Ending Year Ending Year Ending Dec 2020 Dec 2019 Dec 2018 Dec 2017 Dec 2016 title (Update) (Update) (Update) (Update) (Update) Cash & Equivalents 621.3 167.8 112.2 178.29 271.51 Short Term Investments 0 0 0 O 0 Cash and Short Term Investments 621.3 167.8 112.2 178.292 271.513 Accounts Receivable -Trade, Gross 234 0 0 0 0 Provision for Doubtful Accounts -3.1 0 0 0 0 Accounts Receivable -Trade, Net 272 270.7 262.5 143.653 138.478 Receivables Other 4.6 8.6 2.432 9.996 Total Receivables, Net 272 275.3 271.1 146.085 148.474 Inventories - Finished Goods 43.9 62.3 50.8 30.133 23.494 Inventories - Work In Progress 102.5 89.7 103.2 76.61 19.821 Inventories - Raw Materials 160.6 70.5 51.8 36.069 30.687 Total Inventory 307 222.5 205.8 142.812 74.002 Prepaid Expenses 46 20.4 31.5 17.157 16.229 Restricted Cash - Current 0.2 0.2 0.2 1.043 Deferred Income Tax - Current Asset Discountinued Operations - Current Asset 0 Other Current Assets, Total 0.2 0.2 0.2 1.043 0 Total Current Assets 1195.9 686.2 620.8 485.389 510.218 Buildings . Gross 2463 234.8 216.2 160.005 147.13 Land/Improvements , Gross 52.7 46.5 44.6 21.843 20.34 Machinery/Equipment - Gross 58.7 55.7 55.2 50.829 52.564 Construction in Progress Gross 183.4 81.5 71.8 100.088 77.813 Other Property/Plant/Equipment - Gross 393.1 358.9 293.9 206.819 190.157 Property/PIant/Equi merit, Total - Gross 934.2 777.4 681.7 539.584 488.004 Accumulated Depreciation, Total -259.1 -210.4 -171.5 -132.374 -111.556 Property/Plant/Equipment, Total - Net 675.1 567 510.2 407.21 376.448 Goodwill, Net 266.7 266.6 259.7 49.13 41.001 Intangibles - Gross 832.1 854 868.4 151.403 57.099 Accumulated Intangible Amortization -169 -112 -56.8 -31.806 23.234 Intangibles, Net 663.1 741.9 811.6 119.597 33.865 Defered Income Tax - Long Term Asset 13.4 13.4 2.834 6.096 Discontinued Operations - LT Asset 0 Other Long Term Assets 82.4 52.2 13.7 6.046 2.483 Other Long Term Assets, Total 82.4 65.6 27.1 8.88 8.579 Total Assets 2883.2 2327.3 2229.4 1070.206 970.111 Accounts Payable 136.1 94.8 80.7 41.751 34.649 Accrued Expenses 136.9 105.5 88.9 42.713 40.905 Notes Payable/Short Term Debt 0 0 0 0 20 Current Port. of LT Debt/Capital Leases 33.8 12.9 10.1 Customer Advances 10.6 13.232 7.036 Income Taxes Payable 4.5 Deferred Income Tax - Current Liability Discontinued Operations - Curr Liability 0 Other Current Liabilities 77.7 3.1 5.6 2.372 3.266 Other Current liabilities, Total 77.7 3.1 20.7 15.604 10.302 Total Current Liabilities 384.5 216.3 200.4 100.068 105.856 Long Term Debt 841 798.4 784.5 13.457 248.094 Total Long Term Debt 841 798.4 784.5 13.457 248.094 Total Debt 874.8 811.3 794.6 13.457 268.094 Deferred Income Tax - LT Liability 53.2 63.9 67.5 Deferred Income Tax 53.2 63.9 67.5 Minority Interest Other Long Term Liabilities 157.5 160.2 166.1 44.336 19.956 Discontinued Operations Liabilities 0 Other Liabilities, Total 157.5 160.2 166.1 44.336 19.956 Total Llabllltles 1436.2 1238.8 1218.5 157.861 373.906 Convertible Preferred Stock - Non Rdmbl 0 0 0 0 0 Preferred Stock - Non Redeemable, Net 0 0 0 0 0 Common Stock 0.1 0.1 0.1 0.05 0.041 Common Stock, Total 0.1 0.1 0.1 0.05 0.041 Additional Paid-In Capital 784.9 716.1 688.6 618.416 352.435 Retained Earnings (Accumulated Decit) 726.9 421.8 367.3 337.074 254.48 Treasury Stock - Common -39.6 -39.6 -39.6 -39.497 -6.42 Other Comprehensive Income -25.3 -9.9 -5.5 -3.698 -4.331 Other Equity, Total -25.3 -9.9 -5.5 -3.698 -4.331 Total Equity 1447 1088.5 1010.9 912.345 596.205 Total Liabilities 8' Shareholders' Equity 2883.2 2327.3 2229.4 1070.206 970.111 Shares Outs - Common Stock Primary Issue 53.1 51.7 51.2 49.40537 40.57406 Total Common Shares Outstanding 53.1 51.7 51.2 49.40537 40.57406 Treas Shares - Common Stock Prmry Issue 1.2 1.2 1.2 1.21444 0.42283 Shares Outstanding Preferred Issue 1 0 0 0 0 Total Preferred Shares Outstanding 0 0 0 0 Treasury Shares - Preferred Issue 1 0 0 0 0 Full-Time Employees 2200 1834 1705 1256 1098 Number of Common Shareholders 19 25 30 25 23 Accumulated Intangible Amort, Suppl. 169 112 56.8 31.806 23.234 Deferred Revenue - Current 10.6 13.232 7.036 Deferred Revenue - Long Term 55.5 85.6 62.5 17.259 8.433 Total Current Assets less Inventory 888.9 463.7 415 342.577 436.216 Quick Ratio 2.31183 2.14378 2.07086 3.42344 4.12084 Current Ratio 3.11027 3.17245 3.0978 4.85059 4.81993 Net Debt Incl. Pref.Stock & Min.lnterest 253.5 643.5 682.4 464.835 -3.419 Tangible Book Value, Common Equity 517.2 80 -60.4 743.618 521.339 Tangible Book Value per Share, Common Eq 9.74011 1.54739 -1.17969 15.05136 12.84907 Total Long Term Debt, Supplemental 885.5 822.5 808.8 14.529 long Term Debt Maturing within 1 Year 359 14.1 11.3 0.305 long Term Debt Maturing in Year 2 33.8 35.9 14.1 0.305 Long Term Debt Maturing in Year 3 363.6 33.7 35.9 0.305 Long Term Debt Maturing in Year 4 0.2 735.8 33.8 6.807 Long Term Debt Maturing in Year 5 6.807 Long Term Debt Maturing in 2-3 Years 397.4 69.6 50 0.61 Long Term Debt Maturing in 45 Years 0.2 735.8 33.8 13.614 long Term Debt Matur. in Year 6 & Beyond 452 3 713.7 0 Total Operating Leases, Supplemental 39.1 30.6 15.5 10.73 Operating Lease Payments Due in Year 1 6.7 4.5 3.4 1.626 Operating Lease Payments Due in Year 2 8.3 13.7 2.5 1.391 Operating Lease Payments Due in Year 3 8.3 1.96667 2.5 1.339 Operating Lease Payments Due in Year 4 3.7 1.96667 2 1.343 Operating Lease Payments Due In Year 5 3.7 1.96667 2.6 1.346 Operating Lease Pymts. Due in 2-3 Years 16.6 15.66667 5 2.73 Operating Lease Pymts. Due in 4-5 Years 7.4 3.93334 4.6 2.689 Oper. Lse. Pymts. Due in Year 6 & Beyond 8.4 6.49999 2.5 3.685 Pension Obligation - Foreign 49.2 35.3 Plan Assets - Foreign 27.6 20.6 Funded Status - Foreign -21.6 -14.7 Total Funded Status -21.6 -14.7 Total Plan Obligations 49.2 35.3 Total Plan Assets 27.6 20.6 Number of Patents Number of Products in Phase I 2 1 1 1 Number of Products in Phase II 1 3 Number of Products in Phase III 1 1 1 EMERGENT BIOSOLUTIONS 10-K AND IO-Q FINANCIAL INFORMATION Income Statement 5 year period 2020-2016 Year Year Year Year Year Ending Ending Ending Ending Ending Dec 2020 Dec 2019 Dec 2018 Dec 2017 Dec 2016 title (Update) (Update) (Update) (Update) (Update) Net Sales 1555.4 1106 782.4 560.873 488.782 Revenue 1555.4 1106 782.4 560.873 488.782 Total Revenue 1555.4 1106 782.4 560.873 488.782 Cost of Revenue 506.7 433.5 322.3 195.707 131.284 Cost of Revenue, Total 506.7 433.5 322.3 195.707 131.284 Gross Prot 1048.7 672.5 460.1 365.166 357.498 Sel|ing/Genera|/Administrative Expense 273.1 273.5 202.5 134.857 143.686 Labor & Related Expense 30.2 Selling/General/Admin. Expenses, Total 303.3 273.5 202.5 134.857 143.686 Research & Development 205.5 226.2 142.8 97.384 108.29 Amortization of Intangibles 59.8 58.7 25 8.6 Depreciation/Amortization 59.8 58.7 25 8.6 Restructuring Charge 0.04 Impairment-Assets Held for Use 29 Other Unusual Expense (Income) 17.3 Unusual Expense (Income) 46.3 0.04 Total Operating Expense 1121.6 991.9 692.6 436.588 383.26 Operating Income 433.8 114.1 89.8 124.285 105.522 Interest Expense - Non-Operating -31.3 -38.4 -9.9 -6.59 -7.617 Interest Expense, Net Non-Operating -31.3 -38.4 -9.9 -6.59 -7.617 Interest Income - Non-Operating 1.753 1.053 Interest/Invest Income - Non-Operating 1.753 1.053 Interest Inc.(Exp.),Net-Non-Op., Total -31.3 -38.4 -9.9 4.837 -6.564 Other Non-Operating Income (Expense) 4.7 1.7 1.6 0.815 0.263 Other, Net 4.7 1.7 1.6 0.815 0.263 Net Income Before Taxes 4072 77.4 815 118.633 99.221 Provision for Income Taxes 1021 22.9 23.1 35.839 36.697 Net Income After Taxes 3051 54.5 58.4 82.794 62.524 Minority Interest Net Income Before Extra. Items 3051 54.5 58.4 82.794 62.524 Discontinued Operations 0 0 -32.043 Extraordinary Item 0 4.3 -0.2 Tax on Extraordinary Items 21.295 Total Extraordinary Items 0 4.3 -0.2 -10.748 Net Income 305.1 54.5 62.7 82.594 51.776 Income Available to Com Excl ExtraOrd 305.1 54.5 58.4 82.794 62.524 Income Available to Com Incl ExtraOrd 305.1 54.5 62.7 82.594 51.776 Basic Weighted Average Shares 52.7 51.5 50.1 41.81643 40.18416 Basic EPS Excluding Extraordinary Items 5.78937 1.05825 1.16567 1.97994 1.55594 Basic EPS Including Extraordinary Items 5.78937 1.05825 1.2515 1.97516 1.28847 Diluted Net Income 305.1 54.5 62.7 82.594 51.776 Diluted Weighted Average Shares 53.8 52.4 51.4 50.32794 49.33511 Diluted EPS Excluding ExtraOrd Items 5.671 1.04008 1.13619 1.64509 1.26733 Diluted EPS Including ExtraOrd Items 5.671 1.04008 1.21984 1.64112 1.04948 DPS - Common Stock Primary Issue Gross Dividends - Common Stock 0 0 0 0 0 ImpairmentAssets Held for Use, Suppl. NonRecurring Items, Supplemental, Total Total Special Items 46.3 0.04 Normalized Income Before Taxes 453.5 77.4 81.5 118.673 99.221 Effect of Special Items on Income Taxes 11.60911 0.01208 Inc Tax Ex Impact of Sp Items 113.7091 22.9 23.1 35.85108 36.697 Normalized Income After Taxes 339.7909 54.5 58.4 82.82192 62.524 Normalized Inc. Avail to Com. 339.7909 54.5 58.4 82.82192 62.524 Basic Normalized EPS 6.44764 1.05825 1.16567 1.98061 1.55594 Diluted Normalized EPS 6.31582 1.04008 1.13619 1.64564 1.26733 Amort of Intangibles, Supplemental 59.8 58.7 25 8.6 6.9 Depreciation, Supplemental 54.7 52 37.2 33.972 31.329 Interest Expense, Supplemental 31.3 38.4 9.9 6.59 7.617 Interest Capitalized, Supplemental -2.156 Rental Expense, Supplemental 5.6 3.3 3.3 Stock-Based Compensation, Supplemental 51 26.7 23.2 15.213 18.477 Minority Interest, Supplemental Research & Development Exp, Supplemental 205.5 226.2 142.8 97.384 108.29 Audit Fees 3.4759 3.38368 3.53604 3.14758 4.84547 Audit-Related Fees 0.1 0.015 0.41804 0.002 0.002 Tax Fees 0.02727 0.24633 0.35652 0.37502 0.4778 All Other Fees 0 0.01 0 0 0 Gross Margin 67.42317 60.8047 58.80624 65.10672 73.14058 Operating Margin 27.88993 10.31646 11.47751 22.15921 21.58877 Pretax Margin 26.17976 6.99819 10.41667 21.15149 20.29964 Effective Tax Rate 25.07367 29.58656 28.34356 30.20998 36.98511 Net Profit Margin 19.61553 4.92767 7.46421 14.76163 12.7918 Normalized EBIT 480.1 114.1 89.8 124.325 105.522 Normalized EBITDA 594.6 224.8 152 166.897 143.751 Current Tax Domestic 62.8 1.4 1.8 29.441 29.244 Current Tax Foreign 14 11 6 0.356 1.002 Current Tax Local 277 11.6 2.4 2.983 2.331 Current Tax Total 104.5 24 10.2 32.78 32.577 Deferred Tax Domestic 11 1.9 11.8 -6.245 9.979 Deferred Tax - Foreign -3.5 -4.1 -1.9 9.896 -5.587 Deferred Tax - Local 0 1.1 3 -0.592 -0.272 Deferred Tax - Total -2.4 -1.1 12.9 3.059 4.12 Income Tax-Total 102.1 22.9 23.1 35.839 36.697 Interest Cost - Foreign 0.1 0.2 Service Cost - Foreign 1.9 1.3 Expected Return on Assets - Foreign -0.6 -0.5 Curtailments & Settlements - Foreign 1 Foreign Pension Plan Expense 2.4 1 Defined Contribution Expense - Domestic 6.6 5.1 3.1 2.7 2.5 Total Pension Expense 9 6.1 3.1 2.7 2.5 Discount Rate - Foreign 0.02 0.2 Expected Rate of Return - Foreign 3 3 Total Plan Interest Cost 0.1 0.2 Total Plan Service Cost 1.9 1.3 Total Plan Expected Return -0.6 -0.5 Year Ending Year Ending Year Ending Year Ending Year Ending Dec 2020 Dec 2019 Dec 2018 Dec 2017 Dec 2016 STEP 2: (Update) (Update) (Update) (Update) (Update) Short term liquidity ratios: extra info needed for ratios: Cash from Operating Activities 536 188 41.8 208.139 53.487 Current ratio=current assests/current liabilities 3.11 3.17 3.10 4.85 4.82 Quick ratio=liquid assets/current liabilities 622.01 169.05 113.51 179.73 272.82 Operating cash flow ratio=cash flow from operations/current liabilities 1.39 0.87 0.21 2.08 0.51 Activity ratios: receivables turnover=credit sales/receivables Days outstanding in accounts receivable=365 days/ receivable turnover Inventory turnover=COGS/Inventory Days of inventory on hand=365 days/Inventory turnover CCC cash conversion cycle=days of inventory outstanding + days sales outstanding - days payable outstanding Profitability ratios: Gross profit percentage=gross profitet sales 0.67 .61 0.59 0.65 0.73 Profit margin=net incomeet sales 0.20 0.05 0.08 0.15 0.11 Return on assets=net income/total assets 0.11 0.02 0.03 0.08 0.05 Return on equity=net income/stockholders' equity 0.21 0.05 0.06 0.09 0.09

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Michelle L. Hanlon, Robert P. Magee, Glenn M. Pfeiffer, Thomas R. Dyckman

6th Edition

1618533118, 978-1618533111

More Books

Students also viewed these Accounting questions

Question

6) Find the determinant of the matrix 0 1 T10 51 -4 509

Answered: 1 week ago

Question

3. How much information do we need to collect?

Answered: 1 week ago

Question

2. What types of information are we collecting?

Answered: 1 week ago

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago