Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Kermit D. Larson, Paul B. W. Miller

5th Edition

0256091935, 978-0256091939

More Books

Students also viewed these Accounting questions