Answered step by step
Verified Expert Solution
Question
1 Approved Answer
does anyone have the solutions for Case 7 Electric Car Financial Analysis in Problem Solving Cases In Microsoft Access and Excel? Electric Car Company CONSTANTS
does anyone have the solutions for Case 7 Electric Car Financial Analysis in Problem Solving Cases In Microsoft Access and Excel?
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 | |||
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