Answered step by step
Verified Expert Solution
Question
1 Approved Answer
## 1 Electric Car Company 2 3 CONSTANTS 2017 4 TAX RATE NA 5 MINIMUM CASH NEEDED TO START YEAR NA 6 PROJECTED CAPITAL
## 1 Electric Car Company 2 3 CONSTANTS 2017 4 TAX RATE NA 5 MINIMUM CASH NEEDED TO START YEAR NA 6 PROJECTED CAPITAL COSTS NA 7 RESEARCH AND DEVELOPMENT COSTS NA 8 FIXED COSTS NA 9 COST OF OPERATING A CHARGER STATION NA $ 10 INTEREST RATE ON DEBT OWED NA 11 12 INPUTS 13 COST OF GASOLINE (D/S/U) 14 GUARANTY CLAIM RATE (XX) 15 UNIT COST REDUCTION FACTOR 16 NUMBER OF NEW CHARGER LOCATIONS 17 UNITS-MARKET MOMENTUM EFFECT (% PTS) 18 19 SUMMARY OF KEY RESULTS 20 NET INCOME AFTER TAXES 21 END-OF-THE-YEAR CASH ON HAND 2018 2019 2020 20% 20% 20% ## $ 500,000,000 $ 500,000,000 $500,000,000 $ 500,000,000 $ 500,000,000 $500,000,000 100,000 $ 2% 100,000 $ 2% 100,000 2% 2017 2018 2019 2020 NA NA NA 1121 122 2017 2018 2019 2020 22 END-OF-THE-YEAR DEBT OWED 23 24 CALCULATIONS 2017 2018 2019 2020 25 CHARGER LOCATIONS 600 26 CHANGE IN UNITS SOLD (% POINTS) 27 MARKET MOMENTUM EFFECT 28 GAS PRICE EFFECT 29 NEW CHARGER LOCATION EFFECT 30 TOTAL CHANGE NA WWWWW NA NA NA NA 31 UNITS SOLD - SPORT 32 UNITS SOLD-FAMILY 53,000 0 33 CHANGE IN SELLING PRICE (% POINTS) 34 MARKET MOMENTUM EFFECT 35 GAS PRICE EFFECT 36 NEW CHARGER LOCATION EFFECT 37 TOTAL CHANGE WWWWW NA NA 2 2 NA NA NA 38 SELLING PRICE-SPORT 39 SELLING PRICE-FAMILY 5555 $ 75,000 $ $ 78,000 $ 40 UNIT COST SPORT 41 UNIT COST-FAMILY 42 INCOME STATEMENT AND 43 CASH FLOW STATEMENT 2017 2018 2019 2020 44 BEGINNING-OF-THE-YEAR CASH ON HAND NA 45 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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