Question
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started