Pro Forma Income Statement (Excel Spreadsheets). A Pro Forma Income Statement is a projected income...
70.2K
Verified Solution
Link Copied!
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!