| Electric Car Company |
| CONSTANTS | 2017 | 2018 | 2019 | 2020 |
| TAX RATE | NA | 20% | 20% | 20% |
| MINIMUM CASH NEEDED TO START YEAR | NA | $ 1,000,000,000 | $ 1,000,000,000 | $ 1,000,000,000 |
| PROJECTED CAPITAL COSTS | NA | $ 2,000,000,000 | $ 2,000,000,000 | $ 2,000,000,000 |
| RESEARCH AND DEVELOPMENT COSTS | NA | $ 500,000,000 | $ 500,000,000 | $ 500,000,000 |
| FIXED COSTS | NA | $ 500,000,000 | $ 500,000,000 | $ 500,000,000 |
| COST OF OPERATING A CHARGER STATION | NA | $ 100,000 | $ 100,000 | $ 100,000 |
| INTEREST RATE ON DEBT OWED | NA | 2% | 2% | 2% |
| INPUTS | 2017 | 2018 | 2019 | 2020 |
| COST OF GASOLINE (D/S/U) | | NA | NA | NA |
| GUARANTY CLAIM RATE (.XX) | NA |
| UNIT COST REDUCTION FACTOR | NA |
| NUMBER OF NEW CHARGER LOCATIONS | NA |
| UNITS -- MARKET MOMENTUM EFFECT (% PTS) | NA |
| SUMMARY OF KEY RESULTS | 2017 | 2018 | 2019 | 2020 |
| NET INCOME AFTER TAXES | NA |
| END-OF-THE-YEAR CASH ON HAND | NA |
| END-OF-THE-YEAR DEBT OWED | NA |
| CALCULATIONS | 2017 | 2018 | 2019 | 2020 |
| CHARGER LOCATIONS | 600 |
| CHANGE IN UNITS SOLD (% POINTS) | NA |
| MARKET MOMENTUM EFFECT | NA |
| GAS PRICE EFFECT | NA |
| NEW CHARGER LOCATION EFFECT | NA |
| TOTAL CHANGE | NA |
| UNITS SOLD -- SPORT | 53,000 |
| UNITS SOLD -- FAMILY | 0 |
| CHANGE IN SELLING PRICE (% POINTS) | NA |
| MARKET MOMENTUM EFFECT | NA | 2 | 2 | 2 |
| GAS PRICE EFFECT | NA |
| NEW CHARGER LOCATION EFFECT | NA |
| TOTAL CHANGE | NA |
| SELLING PRICE -- SPORT | $ 75,000 |
| SELLING PRICE -- FAMILY | $ - 0 |
| UNIT COST -- SPORT | $ 78,000 |
| UNIT COST -- FAMILY | $ - 0 |
| INCOME STATEMENT AND
CASH FLOW STATEMENT | 2017 | 2018 | 2019 | 2020 |
| BEGINNING-OF-THE-YEAR CASH ON HAND | NA |
| REVENUE |
| AUTO SALES -- SPORT | NA |
| AUTO SALES -- FAMILY | NA |
| TOTAL REVENUE | NA |
| COSTS AND EXPENSES |
| COST OF SPORT AUTOS SOLD | NA |
| COST OF FAMILY AUTOS SOLD | NA |
| RESEARCH AND DEVELOPMENT COSTS | NA |
| CHARGER LOCATION OPERATING COSTS | NA |
| PRICE GUARANTY PAYMENTS | NA |
| FIXED COSTS | NA |
| TOTAL COSTS AND EXPENSES | NA |
| INCOME BEFORE INTEREST AND TAXES | NA |
| INTEREST EXPENSE | NA |
| INCOME BEFORE TAXES | NA |
| INCOME TAX EXPENSE | NA |
| NET INCOME AFTER TAXES | NA |
| SCHEDULED CAPITAL EXPENDITURES | NA |
| REPAYMENT TO NOTE HOLDERS | NA | $ 600,000,000 | $ 600,000,000 | $ 600,000,000 |
| NET CASH POSITION (NCP) BEFORE
BORROWING FROM BANK | NA |
| ADD: BORROWING FROM BANK | NA |
| EQUALS: END-OF-THE-YEAR CASH ON HAND | $ 9,000,000,000 |
| DEBT OWED | 2017 | 2018 | 2019 | 2020 |
| BEGINNING-OF-THE-YEAR DEBT OWED | NA |
| ADD: BORROWING FROM BANK | NA |
| LESS: REPAYMENT TO NOTEHOLDERS | NA |
| EQUALS: END-OF-THE-YEAR DEBT OWED | $ 3,000,000,000 |
jrsmith91
ElectricCarHighlighted.xlsx
