Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Cost Estimating

Authors: Rodney D. Stewart

2nd Edition

0471857076, 978-0471857075

More Books

Students also viewed these Accounting questions