Question: 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
Get step-by-step solutions from verified subject matter experts
