Question: Miller Tools is considering a new project that requires an initial investment of $81,300 for fixed assets, which will be depreciated straight line to zero

Miller Tools is considering a new project that requires an initial investment of $81,300 for fixed assets, which will be depreciated straight line to zero over the projects 3 year life. The project is expected to have fixed costs of $37,600 a year, and a contribution margin of $18.40. The tax rate is 34 percent and the discount rate is 15 percent. What is the financial break even point. Need problem solved in excel. Answers 2,950, 4,217, 2,200, 2,483, 3,667 units

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!