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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 26, 2024

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

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?