Question

In: Finance

s. New Car Development Cost $12,000,000 Marketing Cost $250,000 New Car Variable Cost per car $49,600...

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?

Solutions

Expert Solution


Related Solutions

MiniMe Ltd has spent $250,000 on research and development of a new product. The marketing department...
MiniMe Ltd has spent $250,000 on research and development of a new product. The marketing department estimates that the company can annually sell 200,000 units of the product at $100 each for 4 years. The product will incur $50 per unit in manufacturing costs and fixed costs are expected to be $7 million per year. MiniMe will need to buy manufacturing equipment costing $5 million. The equipment will be depreciated at a CCA rate of 20% and will have a...
During 2019, Brent Industries, Inc. constructed a new manufacturing facility at a cost of $12,000,000. The...
During 2019, Brent Industries, Inc. constructed a new manufacturing facility at a cost of $12,000,000. The weighted average accumulated expenditures for 2019 were calculated to be $5,750,000. The company had the following debt outstanding at December 31, 2019: (a) 7 percent, five-year note to finance construction of the manufacturing facility, dated January 1, 2019, $4,000,000. (b) 9 percent, 20-year bonds issued at par on April 30, 2015, $8,400,000. (c) 7 percent, six-year note payable, dated March 1, 2017, $1,800,000. Required:...
Variable cost (per pound) Direct materials $3.75 Direct manufacturing labor 8.00 Variable overhead (manufacturing, marketing, distribution...
Variable cost (per pound) Direct materials $3.75 Direct manufacturing labor 8.00 Variable overhead (manufacturing, marketing, distribution and customer service) 2.05 Total variable cost per bowl $13.80 Fixes costs Manufacturing $12,000 Marketing, distribution, and customer service 214,800 Total fixed cost $226,800 Selling price $30 Expected sales, 19,500 units $585,000 Income tax rate 40% S.L. Brook and​ Company, a manufacturer of quality handmade walnut​ bowls, has had a steady growth in sales for the past 5 years.​ However, increased competition has led...
Oscar Inc. has a new product priced at $650 per unit. Variable cost is $350 per...
Oscar Inc. has a new product priced at $650 per unit. Variable cost is $350 per unit, and fixed costs are $300,000 per year. Quantity sold is expected to be 15,000 units per year. The new product will require an initial investment of $16 million, depreciation will be straight-line to zero for eight years, and salvage at the end of eight years is expected to be $2 million. Demand for the product is expected to be stable and to continue...
A new piece of equipment will have a fixed cost of $250,000 and the product it...
A new piece of equipment will have a fixed cost of $250,000 and the product it would produce has a variable cost of $22.50, and a selling price of $35. A. What is the break-even point? B. How many units must be sold to make a profit of $750,000? C. How many units must be sold to average $0.50 profit per unit? $0.75 profit per unit? And $2.50 per unit? D. If investors expect a 15% Return on Investment (ROI),...
A bike manufacturer has fixed costs of $250,000 and variable costs per bike of $55.00. The...
A bike manufacturer has fixed costs of $250,000 and variable costs per bike of $55.00. The bike sells for $150.00 per bike. A. How many Bikes must be sold to break even? B.If the fixed cost is increased, would the new breakeven point be higher or lower? C. If the variable cost per bike decreased, would the new break even point be higher or lower?
In evaluating the new IT software project, are the cost of $100,000 spent on marketing analysis? Explain your answer(s).
IT Software Project As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $100,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $450,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The equipment can be depreciated on a...
Tundra Tots is evaluating the proposed acquisition of new equipment at a cost of $250,000. In...
Tundra Tots is evaluating the proposed acquisition of new equipment at a cost of $250,000. In addition the equipment would require modifications at a cost of $20,000 plus shipping costs of $3,000. The equipment falls into the MACRS 3-year class, and will be sold after 3 years for $25,000. The equipment would require increased inventory of $4,000. The equipment is expected to save the company $25,000 per year in before-tax operating costs. The company's marginal tax rate is 30 percent...
You plan on purchasing a new car in 9 months. The cost of the car in...
You plan on purchasing a new car in 9 months. The cost of the car in 9 months will be $25,127. How much would you have to invest today to exactly pay for the new car if you investments earn 4.86% APR (compounded monthly)?
You are planning to buy a new car. The cost of the car is $50,000. You...
You are planning to buy a new car. The cost of the car is $50,000. You have been offered two payment plans: • A 10 percent discount on the sales price of the car, followed by 60 monthly payments financed at 9 percent per year. • No discount on the sales price of the car, followed by 60 monthly payments financed at 2 percent per year. If you believe your annual cost of capital is 9 percent, which payment plan...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT