Valuation on Tesla

profilehabbasi
TESLAvaluationABBASIHAMMAD.xlsx

Sheet1

Expected Earning growth -32% 76% 325% 85.77% 125% 76% 88% 66% -24% 68%
32.00% 50 100 85 90 74 68
INCOME STATEMENT
12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27
Total Revenue $3,198,356.00 $4,046,025.00 $700,132.00 $11,758,751.00 $7,999,478.31 $14,103,880.20 $59,941,490.85 $111,353,307.55 $250,544,941.99 $440,959,097.91 $829,003,104.07 $1,376,145,152.75 $1,045,870,316.09
Cost Of Revenue $2,316,685.00 $3,122,522.00 $5,400,875.00 $9,536,264.00 $12,587,868.48
Gross Profit $881,671.00 $923,503.00 $1,599,257.00 $2,222,487.00
Operating Expenses
R&D $464,700.00 $717,900.00 $834,408.00 $1,378,073.00 $2,212,481.00 $3,590,554.00 $5,803,035.00 $9,284,856.00 $12,302,434.20
Sales General and Admin. $603,660.00 $922,232.00 $1,432,189.00 $2,476,500.00
Non-Recruiting items $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Other Operating Items $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Operating Income -$186,689.00 -$716,629.00 $667,340.00 $1,632,086.00
Add'l Income/Expense items $2,939.00 -$40,144.00 $119,802.00 $105,687.00 0.605488969
Earnings Before interest and Tax -$183,750.00 -$756,773.00 -$547,538.00 $1,737,773.00 0.622863202
Interest Expense $100,886.00 $118,851.00 $198,810.00 $471,259.00 0.6161948825
Earnings before Tax -$284,636.00 -$875,624.00 -$746,348.00 -$2,209,032.00 1.12
Income tax $9,404.00 $13,039.00 $26,698.00 $31,546.00 0.6
Minority Interest $0.00 $0.00 $98,132.00 $279,178.00
Equity Earnings/Loss unconsolidatied subsidiary $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Income-Cont. Operations -$294,040.00 -$888,663.00 -$674,914.00 -$1,961,400.00
NET INCOME -$294,040.00 -$888,663.00 -$674,914.00 $1,961,400.00
Net Income Applicable to common shareholders -$294,040.00 -$888,663.00 -$674,914.00 -$1,961,400.00
BALANCE SHEET
12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27
Cash and Cash Equivalents $1,923,660 $1,219,536 $3,498,735 $3,523,237
Short-Term Investments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Recievables $226,604 $168,965 $499,142 $515,381
Inventory $953,675 $1,277,838 $2,067,454 $2,263,537
Other Current Assets $76,134 $115,667 $194,465 $268,365
Total Current Assets $3,180,073 $2,782,006 $6,259,796 $6,570,520
Long term Assets
Long term investments $0 $0 $506,302 $456,652
Fixed Assets $2,596,011 $5,194,737 $9,117,037 $14,144,126
Good Will $0 $0 $0 $60,237
Intangible Assets $0 $12,816 $376,145 $361,502
Other assets $54,583 $78,380 $6,404,796 $7,062,335
Deferred Asset Charges $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $5,830,667 $8,067,939 $22,664,076 $28,655,372 $28,353,707 $28,052,042 $27,750,377 $27,448,712 $27,147,047 $26,845,382 $26,543,717 $26,242,052 $25,940,387 $25,638,722
Current Liabilites
Accounts Payable $1,046,829 $1,338,946 $3,070,369 $4,121,616
Short term debt/Current portion of long term debt $611,099 $627,927 $1,150,147 $896,549
Other Current Liabilites $449,238 $844,162 $1,606,489 $2,656,505
TOTAL CURRENT LIABILITIES $2,107,166 $2,811,035 $5,827,005 $7,674,670
Long-term debt $1,818,785 $2,021,093 $5,969,500 $9,418,319
Other Liabilites $642,539 $1,658,717 $4,101,872 $475,192
Deferred Liability Charges $292,271 $446,105 $851,790 $1,177,799
Misc. Stocks $58,196 $47,285 $375,823 $397,804
Minority Interest $0 $0 $785,175 $997,346
Total Liabilities $4,918,957 $6,984,235 $17,911,165 $24,418,130
Stock Holders Equity
Common Stocks $126 $131 $161 $169 $172 $178 $181 $189 $192 $200 $206 $215 $222 227
Capital Surplus $2,345,266 $3,409,452 $7,773,727 $9,178,024
Retained Earnings -$1,433,660 -$2,322,323 -$2,997,237 -$4,974,299
Treasury Stock $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Equity -$22 -$3,556 -$23,740 $33,348
Total Equity $911,710 $1,083,704 $4,752,911 $4,237,242
Total LIabilities & Equity $5,830,667 $8,067,939 $22,664,076 $24,655,372
Cash Flow
12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27
Net Income -$1,961,400 -$674,914 -$888,663 -$294,040
Cash flows - operating activities
Depreciation $1,727,040 $1,041,789 $500,644 $301,665 $301,665 $301,665 $301,665 $301,665 $301,665 $301,665 $301,665 $301,665 $301,665 $301,665
Net incom Adjustments $949,487 $301,289 $356,809 $191,863
Changes in Operating Activities
Accounts Recievables -$40,088 -$265,918 $21,905 -$183,658
Changes in Inventories -$178,850 -$632,867 -$369,364 -$1,050,264
Other Operating Activities -$1,594,657 -$1,776,030 -$1,234,091 -$65,130
Liabilities $1,316,992 $1,980,954 $1,088,261 $1,042,227
Net cash Flow - Operating -$60,654 -$123,829 -$524,499 -$57,337
Cash Flows - Investing Activities
Capital Expenditures -$4,081,354 -$1,440,471 -$1,634,850 -$969,885
Investments $0 $16,667 $0 -$16,710 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Investing Activities -$337,613 $7,374 -$38,701 -$3,849
Net cash flow - Investing -$4,418,967 -$1,416,430 -$1,673,551 -$990,444
Cash Flows - Financing Activities
Sale and Purchase of Stock $1,271,120 $2,067,078 $856,611 $489,615
Net Borrowings $3,385,588 $1,718,190 $683,937 $2,292,092
Other Financing Activities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Cash Flows Financing $4,414,864 $3,743,976 $1,523,523 $2,143,130
Effect of Exchange Rate $39,455 -$7,409 -$34,278 -$35,525
Net Cash Flow -$25,302 $2,196,308 $708,805 $1,059,824
Financial Ratios
12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27
Liquidity ratios
Current Ratio 86% 107% 99% 151%
Quick Ratio 56% 72% 54% 106%
Cash Ratio 46% 60% 43% 91%
Profitability Ratios
Gross Margin 19% 23% 23% 28%
Operating Margin 14% 10% 18% 6%
Pre-tax margin 19% 11% 22% 9%
Profit Margin 17% 10% 22% 9%
Pre -tax ROE 52% 16% 81% 31%
After tax ROE 46% 14% 82% 32%