Question: Can you do in excel and include the excel show formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study. Based on
Can you do in excel and include the excel show formulas
The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study. Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6. The sales price is expected to drop to $90,000 in year 7 due to increasing competition with 2% annual increase for year 8-12. Variable costs per unit are $45,000 with an estimated 4% annual rise from inflation in years 2-12 and incremental cash fixed costs total $15 million per year all 12 years.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
