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

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!