On tab 2 I need to calculate the the blanks but im unable to do so or dont know how the information is for case 12 working computers inc for finance class. I need to develop a discounted cash flow analysis for the bernoulli division from 2004-2009 the working board has asked for a net present value and internal rate of return when making decision in the past. also need to determine the terminal value for the division at the end of 2009

Assumed Revenue Projection with Investment 12/31/2003 12/31/2004 12/31/2005 12/31/2006 12/31/2007 12/31/2008 12/31/2009 180,000 150,000 189,000 246,000 264,000 264,000 264,000 495 495.00 495.00 495.00 495.00 495.00 495.00 Units Units Sold Unit price New Bernoulli Device Revenue Product 1 Assumed Revenue projection without Investment Units Sold x Unit Price 89,100,000 74,250,000 93,555,000 121,770,000 130,680,000 130,680,000 130,680,000 12/31/2003 12/31/2004 12/31/2005 12/31/2006 12/31/2007 12/31/2008 12/31/2009 180,000 150,000 102,000 57,000 48,000 48,000 48,000 495 495.00 495.00 495.00 495.00 495.00 495.00 Units Sold x Unit Price 89,100,000 74,250,000 50,490,000 28,215,000 23,760,000 23,760,000 23,760,000 Units Units Sold Unit price Current Bernoulli Device Revenue Product 1 Units Sold with new invesment Sales COGS - 54% of Sales Gross Profit Operating Expenses - 26% of Sales 20052009 Research and Development Depreciation 2004 COGS at 60% of Sales Gross Profit Operating Expenses - 24% of Sales Depreciation EBIT Income Tax at 34% Ulevered Net Income Free Cash Flow Depreciation Capital Expenditures Free Cash Flow Project Cost of Capital Discount Factor PV of Free Cash Flow 2007 2008 2009 130,680,000.00 (70,567,200.00) 60,112,800.00 130,680,000.00 (70,567,200.00) 60,112,800.00 130,680,000.00 (70,567,200.00) 60,112,800.00 (35,820,000.00) (24,324,300.00) (33,976,800.00) (33,976,800.00) (33,976,800.00) (31,660,200.00) (18,000,000.00) (3,600,000.00) 15,111,000.00 (5,137,740.00) 9,973,260.00 (5,760,000.00) 18,594,000.00 (6,321,960.00) 12,272,040.00 (3,420,000.00) 22,716,000.00 (7,723,440.00) 14,992,560.00 (2,160,000.00) 23,976,000.00 (8,151,840.00) 15,824,160.00 (1,080,000.00) 25,056,000.00 (8,519,040.00) 16,536,960.00 14.50% 1.000 0.873 0.763 0.666 0.582 0.508 2004 2005 2006 2007 2008 2009 74,250,000.00 50,490,000.00 44,550,000.00 30,294,000.00 29,700,000.00 20,196,000.00 28,215,000.00 16,929,000.00 11,286,000.00 23,760,000.00 14,256,000.00 9,504,000.00 23,760,000.00 14,256,000.00 9,504,000.00 23,760,000.00 14,256,000.00 9,504,000.00 Income Tax at 34% Units Sold without new invesment Sales 2006 74,250,000.00 93,555,000.00 121,770,000.00 (40,095,000.00) (50,519,700.00) (65,755,800.00) 34,155,000.00 43,035,300.00 56,014,200.00 EBIT Unlevered Net Income Free Cash Flow Depreciation Capital Expenditures Free Cash Flow Project Cost of Capital Discount Factor PV of Free Cash Flow 2005 17,820,000.00 (3,780,000.00) 43,740,000.00 (14,871,600.00) 28,868,400.00 12,117,600.00 (3,780,000.00) 28,533,600.00 (9,701,424.00) 18,832,176.00 6,771,600.00 (3,780,000.00) 14,277,600.00 (4,854,384.00) 9,423,216.00 5,702,400.00 (3,780,000.00) 11,426,400.00 (3,884,976.00) 7,541,424.00 5,702,400.00 (3,240,000.00) 11,966,400.00 (4,068,576.00) 7,897,824.00 5,702,400.00 (1,620,000.00) 13,586,400.00 (4,619,376.00) 8,967,024.00 3,780,000.00 3,780,000.00 3,780,000.00 3,780,000.00 3,240,000.00 1,620,000.00 32,648,400.00 14.50% 0.508 16,589,544.79 22,612,176.00 13,203,216.00 11,321,424.00 11,137,824.00 10,587,024.00 0.444 10,034,816.54 0.388 5,117,305.22 0.338 3,832,279.38 0.296 3,292,690.96 0.258 2,733,499.70