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
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
Get step-by-step solutions from verified subject matter experts
