In: Finance
s.
New Car Development Cost |
$12,000,000 |
Marketing Cost |
$250,000 |
New Car Variable Cost per car |
$49,600 |
New Car Fixed Costs per Year |
$35,000,000 |
New Car Sales Volume Year 1 |
5,750 |
New Car Sales Volume Year 2 |
6,437 |
New Car Sales Volume Year 3 |
4,744 |
New Car Sales Volume Year 4 |
3,325 |
New Car Sales Volume Year 5 |
2,723 |
New Car Unit Price |
$80,000 |
New Car Equipment |
450,000,000 |
New Car Equipment Depreciation |
7 Year MACRS Schedule |
Value of Equipment after 5 Years |
355,000,000 |
Existing Car Sales Volume if New Car is not introduced Year 1 |
12,000 |
Existing Car Sales Volume if New Car is not introduced Year 2 |
10,750 |
Existing Car Sales Volume if New Car is not introduced Year 3 |
8,700 |
Price of Existing Car |
$35,000 |
Variable Cost per Existing Car |
$19,950 |
Fixed Cost of Existing Cost Per Year |
$25,000,000 |
Sales Volume of Existing Car if New Car is introduced Year 1 |
11,000 |
Sales Volume of Existing Car if New Car is introduced Year 2 |
9,750 |
Sales Volume of Existing Car if New Car is introduced Year 3 |
7,700 |
Existing Car Unit Price if New Car is introduced |
$32,000 |
New Working Capital of the Project, changes occur in Year 1 |
20% of Sales |
Corporate Tax Rate |
25% |
Cost of Capital |
14% |
New Car Development Cost |
$12,000,000 |
Marketing Cost |
$250,000 |
New Car Variable Cost per car |
$49,600 |
New Car Fixed Costs per Year |
$35,000,000 |
New Car Sales Volume Year 1 |
5,750 |
New Car Sales Volume Year 2 |
6,437 |
New Car Sales Volume Year 3 |
4,744 |
New Car Sales Volume Year 4 |
3,325 |
New Car Sales Volume Year 5 |
2,723 |
New Car Unit Price |
$80,000 |
New Car Equipment |
450,000,000 |
New Car Equipment Depreciation |
7 Year MACRS Schedule |
Value of Equipment after 5 Years |
355,000,000 |
Existing Car Sales Volume if New Car is not introduced Year 1 |
12,000 |
Existing Car Sales Volume if New Car is not introduced Year 2 |
10,750 |
Existing Car Sales Volume if New Car is not introduced Year 3 |
8,700 |
Price of Existing Car |
$35,000 |
Variable Cost per Existing Car |
$19,950 |
Fixed Cost of Existing Cost Per Year |
$25,000,000 |
Sales Volume of Existing Car if New Car is introduced Year 1 |
11,000 |
Sales Volume of Existing Car if New Car is introduced Year 2 |
9,750 |
Sales Volume of Existing Car if New Car is introduced Year 3 |
7,700 |
Existing Car Unit Price if New Car is introduced |
$32,000 |
New Working Capital of the Project, changes occur in Year 1 |
20% of Sales |
Corporate Tax Rate |
25% |
Cost of Capital |
14% |
New Car Development Cost |
$12,000,000 |
Marketing Cost |
$250,000 |
New Car Variable Cost per car |
$49,600 |
New Car Fixed Costs per Year |
$35,000,000 |
New Car Sales Volume Year 1 |
5,750 |
New Car Sales Volume Year 2 |
6,437 |
New Car Sales Volume Year 3 |
4,744 |
New Car Sales Volume Year 4 |
3,325 |
New Car Sales Volume Year 5 |
2,723 |
New Car Unit Price |
$80,000 |
New Car Equipment |
450,000,000 |
New Car Equipment Depreciation |
7 Year MACRS Schedule |
Value of Equipment after 5 Years |
355,000,000 |
Existing Car Sales Volume if New Car is not introduced Year 1 |
12,000 |
Existing Car Sales Volume if New Car is not introduced Year 2 |
10,750 |
Existing Car Sales Volume if New Car is not introduced Year 3 |
8,700 |
Price of Existing Car |
$35,000 |
Variable Cost per Existing Car |
$19,950 |
Fixed Cost of Existing Cost Per Year |
$25,000,000 |
Sales Volume of Existing Car if New Car is introduced Year 1 |
11,000 |
Sales Volume of Existing Car if New Car is introduced Year 2 |
9,750 |
Sales Volume of Existing Car if New Car is introduced Year 3 |
7,700 |
Existing Car Unit Price if New Car is introduced |
$32,000 |
New Working Capital of the Project, changes occur in Year 1 |
20% of Sales |
Corporate Tax Rate |
25% |
Cost of Capital |
14% |
Can you and your team prepare the income statement table, the operating cash flow (OCF) table, and the total cash flow from assets (CFFA) table for this project?