1. Complete the capital budgeting methods B5- FLI HOME 2 Comparison of Capital Budgeting Method - Excel REVIEW VIEW INERT PAGE LAYOUT FOLMULAS DATA Care Gare Wrap Test Merge Center $% 1 Conditional Format a Cell Formatting table Styles Syles Insert Delete Format Number Cade 0 A1 Laurman, Inc. is considering the following project: D E urman locis consider the following project Required investment in cui $ 1.750.000 Project lite 5 years 4 Salvage value 225 000 5 The project would provide net operating income each year as follows: 7 Sales 5 2,750.000 Variable 10000 Cestomarin $ 1.1 50.000 10 Fred expenses 11 Salaries and other fixed out of pode $ $20.000 13 Depreciation 350.000 15 Tocal fired expenses 3700 14 Net operating income 280 15 16 Costo Capital 1 19 1 1. the matching from the project 610.000 14 22. Complete the following timeline to compare the set present value of the future cash fows for this project. Don't forget to include the salvage value in year 5. 21 Year 2 Netch Sheets 1. Complete the capital budgeting methods IB FALLI Comparson of Cataludgeting Methodol REVIEW VIEW HOUE FORMULAS PAGE LAYOUT Son DATA 11 AA wp Text Merge Center S.%. Conditional Formatas Cell Formatting" Tablet Pute Insert Delete Format Cat A1 Lauman, Inc. is considering the following project C D G 189 Year 16 Cost of Capital 17 1 1 Compute the seashindow from the project 610.000 2. Complete the following timeline to compute the per present value of the forure cash flows for this projest. Don't forget to include the salvape valor in years 2 23 Net show 24 Discount Factory 1.000 23 ct value of the cash flows Ne presente 27 25. se NPV w..compare the present Vale of the cash flow from year 1:Do not include original investment of time pero 29 NPV Chows from Yen 13 Dedict the cost of the Nepal ACCEPT RUCTIN NPV Ubat function to compute the projecte internal rate of return Write the watement to ACCUTRECT dhe project based on IRR Compute the project pay back pertel Sheet 13 10 READY 100 1. Complete the capital budgeting methods Claus OU mm 33 IT Laman hem the finest TODO Photo the construm 15. Destinate the animal etmem | | ACONTENT ON MARO ACCETTREET NIE 1. Complete the capital budgeting methods B5- FLI HOME 2 Comparison of Capital Budgeting Method - Excel REVIEW VIEW INERT PAGE LAYOUT FOLMULAS DATA Care Gare Wrap Test Merge Center $% 1 Conditional Format a Cell Formatting table Styles Syles Insert Delete Format Number Cade 0 A1 Laurman, Inc. is considering the following project: D E urman locis consider the following project Required investment in cui $ 1.750.000 Project lite 5 years 4 Salvage value 225 000 5 The project would provide net operating income each year as follows: 7 Sales 5 2,750.000 Variable 10000 Cestomarin $ 1.1 50.000 10 Fred expenses 11 Salaries and other fixed out of pode $ $20.000 13 Depreciation 350.000 15 Tocal fired expenses 3700 14 Net operating income 280 15 16 Costo Capital 1 19 1 1. the matching from the project 610.000 14 22. Complete the following timeline to compare the set present value of the future cash fows for this project. Don't forget to include the salvage value in year 5. 21 Year 2 Netch Sheets 1. Complete the capital budgeting methods IB FALLI Comparson of Cataludgeting Methodol REVIEW VIEW HOUE FORMULAS PAGE LAYOUT Son DATA 11 AA wp Text Merge Center S.%. Conditional Formatas Cell Formatting" Tablet Pute Insert Delete Format Cat A1 Lauman, Inc. is considering the following project C D G 189 Year 16 Cost of Capital 17 1 1 Compute the seashindow from the project 610.000 2. Complete the following timeline to compute the per present value of the forure cash flows for this projest. Don't forget to include the salvape valor in years 2 23 Net show 24 Discount Factory 1.000 23 ct value of the cash flows Ne presente 27 25. se NPV w..compare the present Vale of the cash flow from year 1:Do not include original investment of time pero 29 NPV Chows from Yen 13 Dedict the cost of the Nepal ACCEPT RUCTIN NPV Ubat function to compute the projecte internal rate of return Write the watement to ACCUTRECT dhe project based on IRR Compute the project pay back pertel Sheet 13 10 READY 100 1. Complete the capital budgeting methods Claus OU mm 33 IT Laman hem the finest TODO Photo the construm 15. Destinate the animal etmem | | ACONTENT ON MARO ACCETTREET NIE
