Pro Forma Income Statement (Excel Spreadsheets). A Pro Forma Income Statement is a projected income...

70.2K

Verified Solution

Question

Accounting

Pro Forma Income Statement (Excel Spreadsheets). A Pro Forma Income Statement is a projected income statement. For our purpose, youre expected to project income for a 5-year period for Moderna. You will need to research the company. You will need to secure the companys latest Annual Report and Security Exchange Commission (SEC) filings. The Pro Forma Income Statement needs to clearly delineate the appropriate assumptions, calculations, and logical competitive positions determined from your analyses. The objective is to have your Pro Forma Income lay out a blueprint for what you believe Moderna needs to do to continue to be successful in a globally challenging industry.

* In Millions of USD (except for per share items)
Period Ending: 2020 31/12 2019 31/12 2018 31/12 2017 31/12
Total Revenue 803.39 60.21 135.07 205.82
Revenue 803.39 60.21 135.07 205.82
Other Revenue, Total - - - -
Cost of Revenue, Total 7.93 - - -
Gross Profit 795.46 - - -
Total Operating Expenses 1566.54 605.93 548.33 475.18
Selling/General/Admin. Expenses, Total 188.27 109.62 94.25 64.72
Research & Development 1370.34 496.31 454.08 410.46
Depreciation / Amortization - - - -
Interest Expense (Income) - Net Operating - - - -
Unusual Expense (Income) - - - -
Other Operating Expenses, Total - - - -
Operating Income -763.14 -545.72 -413.27 -269.36
Interest Income (Expense), Net Non-Operating 16.12 32.24 23.96 13.36
Gain (Loss) on Sale of Assets - - - -
Other, Net 2.51 -1.24 4.9 -
Net Income Before Taxes -744.51 -514.72 -384.41 -256
Provision for Income Taxes 2.55 -0.69 0.33 -0.08
Net Income After Taxes -747.06 -514.02 -384.73 -255.92
Minority Interest - - - -
Equity In Affiliates - - - -
U.S GAAP Adjustment - - - -
Net Income Before Extraordinary Items -747.06 -514.02 -384.73 -255.92
Total Extraordinary Items - - - -
Net Income -747.06 -514.02 -384.73 -255.92
Total Adjustments to Net Income - - -17.12 -13.93
Income Available to Common Excluding Extraordinary Items -747.06 -514.02 -401.86 -269.84
Dilution Adjustment - - - -
Diluted Net Income -747.06 -514.02 -401.86 -269.84
Diluted Weighted Average Shares 381.33 330.8 328.8 324.41
Diluted EPS Excluding Extraordinary Items -1.96 -1.55 -1.22 -0.83
DPS - Common Stock Primary Issue - - - -
Diluted Normalized EPS -1.96 -1.55 -1.22 -0.83

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students