I need to generate a 2016 Pro-forma Income Statement and Balance Sheet for Tesla Motors based on the forecast below. There are no instructions in the text and I am getting lost in YouTube instructional videos and accounting principles instead of completing the spreadsheets. If anyone can complete the income statement and balance sheet or at least point me in the right direction, I would appreciate it.

Forecast of economy, industry, and company

Over 400,000 preorders for Teslas model 3 expecting completion of late 2017.

Preorders of $1,000 refundable deposit

Accident happened with autopilot just prior to 2 billion acceptance of stock

Missed production quota for quarter 2 by 15%

Autopilot feature is a niche as well as electric in which competition is far away

GM Bolt (no autopilot) selling comparable to model 3 and comes out a year earlier.

GM has the capital and balance sheet to price their vehicle much lower than teslas to destroy sales on model 3 due to their higher income through other sales.

Equation of regression line is y= -2.107298238E + 12 + 1047826000 * x

R=.9822 x= year y= revenue close to 1 so sales are accurate

Sales projected for 2016 are 5,117,216,000 or 5.1 billion.

In Millions of USD (except for per share items)

12 months ending 2015-12-31

12 months ending 2014-12-31

12 months ending 2013-12-31

12 months ending 2012-12-31

Revenue

4,046.03

3,198.36

2,013.50

413.26

Other Revenue, Total

-

-

-

-

Total Revenue

4,046.03

3,198.36

2,013.50

413.26

Cost of Revenue, Total

3,122.52

2,316.68

1,557.23

383.19

Gross Profit

923.5

881.67

456.26

30.07

Selling/General/Admin. Expenses, Total

922.23

603.66

285.57

150.37

Research & Development

717.9

464.7

231.98

273.98

Depreciation/Amortization

-

-

-

-

Interest Expense(Income) - Net Operating

-

-

-

-

Unusual Expense (Income)

-

-

-

-

Other Operating Expenses, Total

-

-

-

-

Total Operating Expense

4,762.65

3,385.05

2,074.78

807.54

Operating Income

-716.63

-186.69

-61.28

-394.28

Interest Income(Expense), Net Non-Operating

-

-

-

-

Gain (Loss) on Sale of Assets

-

-

-

-

Other, Net

-41.65

1.81

22.6

-1.83

Income Before Tax

-875.62

-284.64

-71.43

-396.08

Income After Tax

-888.66

-294.04

-74.01

-396.21

Minority Interest

-

-

-

-

Equity In Affiliates

-

-

-

-

Net Income Before Extra. Items

-888.66

-294.04

-74.01

-396.21

Accounting Change

-

-

-

-

Discontinued Operations

-

-

-

-

Extraordinary Item

-

-

-

-

Net Income

-888.66

-294.04

-74.01

-396.21

Preferred Dividends

-

-

-

-

Income Available to Common Excl. Extra Items

-888.66

-294.04

-74.01

-396.21

Income Available to Common Incl. Extra Items

-888.66

-294.04

-74.01

-396.21

Basic Weighted Average Shares

-

-

-

-

Basic EPS Excluding Extraordinary Items

-

-

-

-

Basic EPS Including Extraordinary Items

-

-

-

-

Dilution Adjustment

-

-

0

0

Diluted Weighted Average Shares

128.2

124.54

119.42

107.35

Diluted EPS Excluding Extraordinary Items

-6.93

-2.36

-0.62

-3.69

Diluted EPS Including Extraordinary Items

-

-

-

-

Dividends per Share - Common Stock Primary Issue

-

-

0

0

Gross Dividends - Common Stock

-

-

-

-

Net Income after Stock Based Comp. Expense

-

-

-

-

Basic EPS after Stock Based Comp. Expense

-

-

-

-

Diluted EPS after Stock Based Comp. Expense

-

-

-

-

Depreciation, Supplemental

-

-

-

-

Total Special Items

-

-

-

-

Normalized Income Before Taxes

-

-

-

-

Effect of Special Items on Income Taxes

-

-

-

-

Income Taxes Ex. Impact of Special Items

-

-

-

-

Normalized Income After Taxes

-

-

-

-

Normalized Income Avail to Common

-

-

-

-

Basic Normalized EPS

-

-

-

-

Diluted Normalized EPS

-6.93

-2.36

-0.62

-3.69

In Millions of USD (except for per share items)	As of 2015-12-31	As of 2014-12-31	As of 2013-12-31	As of 2012-12-31
Cash & Equivalents	1,196.91	1,905.71	845.89	201.89
Short Term Investments	-	-	-	-
Cash and Short Term Investments	1,196.91	1,905.71	845.89	201.89
Accounts Receivable - Trade, Net	168.97	226.6	49.11	26.84
Receivables - Other	-	-	-	-
Total Receivables, Net	168.97	226.6	49.11	26.84
Total Inventory	1,277.84	953.67	340.36	268.5
Prepaid Expenses	115.67	76.13	27.57	8.44
Other Current Assets, Total	22.63	17.95	3.01	19.09
Total Current Assets	2,782.01	3,180.07	1,265.94	524.77
Property/Plant/Equipment, Total - Gross	3,974.46	2,121.86	878.64	609.77
Accumulated Depreciation, Total	-571.13	-292.59	-140.14	-57.54
Goodwill, Net	-	-	-	-
Intangibles, Net	-	-	-	-
Long Term Investments	-	-	-	-
Other Long Term Assets, Total	91.2	54.58	30.07	27.12
Total Assets	8,067.94	5,830.67	2,416.93	1,114.19
Accounts Payable	916.15	777.95	303.97	303.38
Accrued Expenses	321.59	197.65	68.05	30.09
Notes Payable/Short Term Debt	0	0	0.18	0
Current Port. of LT Debt/Capital Leases	627.93	611.1	7.72	55.21
Other Current liabilities, Total	945.37	520.47	295.23	150.43
Total Current Liabilities	2,811.03	2,107.17	675.16	539.11
Long Term Debt	2,068.38	1,876.98	586.12	401.5
Capital Lease Obligations	-	-	12.86	9.96
Total Long Term Debt	2,068.38	1,876.98	598.97	411.46
Total Debt	2,696.30	2,488.08	606.88	466.67
Deferred Income Tax	-	-	5.23	-
Minority Interest	-	-	-	-
Other Liabilities, Total	2,104.82	934.81	470.44	38.92
Total Liabilities	6,984.23	4,918.96	1,749.81	989.49
Redeemable Preferred Stock, Total	-	-	-	-
Preferred Stock - Non Redeemable, Net	-	-	-	-
Common Stock, Total	0.13	0.13	0.12	0.12
Additional Paid-In Capital	3,409.45	2,345.27	1,806.62	1,190.19
Retained Earnings (Accumulated Deficit)	-2,322.32	-1,433.66	-1,139.62	-1,065.61
Treasury Stock - Common	-	-	-	-
Other Equity, Total	-3.56	-0.02	-	-
Total Equity	1,083.70	911.71	667.12	124.7
Total Liabilities & Shareholders' Equity	8,067.94	5,830.67	2,416.93	1,114.19
Shares Outs - Common Stock Primary Issue	-	-	-	-
Total Common Shares Outstanding	131.43	125.69	123.09	114.21