does anyone have the solutions for Case 7 Electric Car Financial Analysis in Problem Solving...

90.2K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students