File Edit View Insert Format Tools Data Window Help 93% [+] Wed 2:56 PM Q DE ... AutoSave . OFF GF projected income Model Search Sheet Home Insert Draw Page Layout Formulas Data Review View Le Share Comments + Calibri (Body) 11 " A" A " 25 v General Insert v EX AY - O. Paste B I U V E ~ |QA ~ E Conditional Format x Delete v Cell Formatting as Table Styles Format X v Sort & Filter Find & Ideas Select H32 fix B C D E F G H K L M N P Q Input Parameters Constants Demand (initial value 10000 Production Policy (Factor) 0.1 Production Quantity (Initial) 11000 Inflation Rate 2% Unit Price $14,000 KI 50000 Selling Price $15,000 Fixed Cost $2,00 K2 2000 Fixed Production Cost $2,040 Variable Cost $1,500 TK3 3000 Variable Production Cost $1,560 Year-End Discount for L $1,000,000 ork question online Calculations Year Yearly Demand suction Qua Sales Revenue Total Fixed Cost Total Variable Cost Total Cost MAW NEO 10000 11000 Net Income $149,000,000 522,440,000 $17,160,000 $39,600,000 12100 $164,000,000 $109,400,000 OOOTT $24,684,000 18,876,000 $43,560,000 12100 13310 $120,440,000 $180,500,000 527,152,40 13310 $20,763,600 $47,916,000 14641 $198,650,000 $132,584,000 14641 $29,867,640 22,839,960 $52,707,600 16105 $218,615,000 $32,854,404 $145,942,400 16105 17716 25,123,956 $57,978,360 $240,576,500 $36,139,844 27,636,352 $63,776,196 $160,636,640 $176,800,304 $688,841,753.11 NPV of the next 5 Years added to year 0 net income Forecast Income + B J - -+ 100%