Question: how do you enter this into excel using the pmt function? 4. Three mutually exclusive design alternatives are being considered. The estimated sales and cost

how do you enter this into excel using the pmt function?
4. Three mutually exclusive design alternatives are being considered. The estimated sales and cost data for each alternative are given below. The MARR is 20% per year Investment cost $30,000 $60,000 $40,000 Estimated units 15,000 20,000 18,000 to be sold/year Unit selling price, $3.10 $4.40 $3.70 $/unit $/unit (fixed costs) Variable costs, $1.00 $1.40 $0.90 Annual expenses $15,000 $30,000 $25,000 Market value Useful life $10,000 $10,000 $10,000 10 years 10 years 10 years
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
