Could you make a excel form calculated with expected year 1 revenues number is $997,300.

and analize for result and give short opinion.

Finance 4310 Capital Budgeting Project INPUT INFORMATION Expected Yr1 Revenues Expected Revenue Growth Rate Real discount rate nflation rate Nominal discount rate INITIAL INVESTMENT DEPRECIATION EXPENSE $205,000 A% Year DP B ase Percent Expense 1$287,000 2 $287,000 22% $63,14 COS $260,000 1596 $43.050 2% 6.08% 30% Shi Installation Depreciable Base $15,000 $287,000 3-5$287,000 21% $60.270 ate tax rate Expected life s COGS as % of Revenues Cash Processor cost ital 50% 12% $260,000 $12,000 $15,000 20,000 $40,000 Initial Investment $327,000 Ex nses as % of Re venues AFTERTAX SALVAGE VALUE Salvage Value Installation cost Expected Salvage Value Additional working capital 20,000 70% $14,000 AT SV CASH FLOW CALCULATIONS Revenues COGS 205.000 213,200 221,728 110,864 26,607 60,270 23,987 7,196 16,791 60,270 230,597 239,821 115,299 119,911 27.67228,779 60,27060,270 27.357 30,862 9,259 19,15021.603 60.270 60,270 14,000 40,000 79.420 135,873 102,500 106,600 24,60025,584 ating Expenses 34,850 10.455 24,395 12,513 43,050 rati 17,876 Taxes Aftertax Add back depreciation Aftertax salvage value Return of Working Capital Cash Flow ating income 63.140 67,445 75,653 77,061 Net Present Value (NPV $32,233