refer to sheet "model 1". perform a profit projection for the next 10 years. what is the profit in year 3 and year 10? Format: $1,000

View File fx Insert Function Home Insert Page Layout Formules Data Review 3 2A Lig O AutoSum Recently Financial Logical Test Date & Lockup & Math Used - - - - T Time ReferenceThis R ACROBAT Tell me what you want to Deine Name - Define Nome Trace Precedents Use in Formula - Trace Dependents Name Man Create from Selection Remove Am- Definedes More function G17 $50 2 Inputs 3 Price 4 Variable cost per unit 5 Fixed cost $10 $6,000 Background: A software company is considering translating its program into French. The fixed development cost is $6,000 every year. Each unit of the program sells for $50 and incurs a variable cost of $10 to produce. Currently, the size of the demand for the product is 120,000 units per year. The company estimates that the demand will grow by 5% a year for the next 10 years. Given a 10 year planning horizon, perform a profit projection for the company. Suppose that the software is made to order that is the sales voluminis identical to demand 120.000 7 Demand 8 Demand growth 11 Profit Model 12 Years from now Demand Total Revenue Total variable cost Fixed cost Profit