Question: need help asap need in excel format with formula please 1. A company buys a Computer Numerical Control (CNC) mill for $200,000. Maintenance is expected

need help asap
need in excel format with formula please  need help asap need in excel format with formula please 1.

1. A company buys a Computer Numerical Control (CNC) mill for $200,000. Maintenance is expected to be $5,000 per year. The life of the machine is expected to be 10 years. Revenues should be $10,000 every month from a preferred customer. The labor costs are $6,000 a month. Major maintenance on the machine is needed every 5 years at $20,000. At the end of 10 years (120 months), the machine should be worth no more than $150,000 assuming it has been regularly maintained. Create the cash flow for this opportunity and find the PW at a 12% minimum attractive rate of return

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!