please do not answer the question if you are not going to give the formula for each column . for example what is r and n when finding the discount factor for year 1 and what are the value for r and n for year 1.

1. Complete the capital budgeting methods. Comparison of Capital Budgeting Methods - Excel REVIEW VIEW DATA FORMULAS PAGE LAYOUT FILE HOME INSERT General Wrap Text Calibri - 11 AA BA SEE $ - % Merge & Center ** Conditional Format as Cell Formatting Table Styles Styles - Paste BIU Number Alignment Font Clipboard Laurman, Inc. is considering the following project: v A1 D B A 1,750,000 5 years 225.000 $ 2,750,000 1,600,000 1,150,000 7 8 S 9 Laurman, Inc. is considering the following project: 2 Required investment in equipment 3. Project life 4 Salvage value 5 6 The project would provide net operating income cach year as follows: Sales Variable expenses Contribution margin 10 Fixed expenses: Salaries, rent and other fixed out of pocket costs 12 Depreciation 13 Total fixed expenses 14 Net operating income 15 16 Cost of Capital 17 18 1. Compute the annual net cash inflow from the project. $ 520.000 350.000 11 870,000 280,000 18% 630.000