i need to know the NPV, MIRR, PAYBACK, AND PROFITABILITY INDEX. This is all under annual cash flows.
23%. 2:24 PM module_7_-_chino_materials - Saved Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 123 Links Disabled - Links to external workbooks are not supported and have been disabled Close 6 This case is designed as an introduction to capital budgeting methods. 7 NPV, IRR, MIRR, PI, and Payback are included in the analysis 9 10 11 12 13 14 15 16 17 18 19 20 The model develops the project's cash flows on the basis of input cost and savings data, then calculates the above decision criteria. Note that this model was constructed specifically for this case, and hence project life and depreciation allowances are fixed. The spreadsheet sheet NPV-PROF contains a graph of the NPV profiles and the sheet MULTIPLE contains a graph of the multiple IRR project. If you are using the student version of the model, the model generating cells have been blanked out. Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. 22 INPUT DATA 23 New system: 24 Delivered cost 25 Installation 26 Salvage value 27 Annual savings KEY OUTPUT $285, 000 NPV $18,000 IRR $15,000 MIRR $7E, 000 Payback 0.00% 0.00% 0.00 0.00 Pl 30 31 32 Old system Current book value Current market value Removal cost $0 $4,000 $2, 500 Other data: 35 Cost of capital 36 Cost of borrowing 37 Roturn fnr tniral invostmonts 12-09 12.0% Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM module_7_-_chino_materials - Saved Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 123 Links Disabled - Links to external workbooks are not supported and have been disabled Close 17 18 19 20 21 22 23 24 25 26 27 Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. INPUT DATA KEY OUTPUT New system: Delivered cost Installation Salvage value Annual savings $285, 000 NPV $18,000 IRR $15,000 MIRR $7E, 000 Payback 0.00% 0.00% 0.00 0.00 Pl 29 30 31 32 Old system Current book value Current market value Removal cost $0 $4,000 $2, 500 35 36 37 38 39 40 Other data: Cost of capital Cost of borrowing Return for typical investments Tax rate 12-09 12.0% 14.0s 36.0% MODEL-GENERATED DATA 42 43 Cash flows at t-0: Cost of new system Installation End-of-project cash flows Salvage value> SV tax 45 Total cost Total 47 48 Proceeds from old equip Tax on proceeds Depreciation information Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM Battle, Cameron B. module_7_-_chino_materials - Saved File InsertDraw Formulas Data ReviewView Home 23 Close Links Disabled - Links to external workbooks are not supported and have been disabled 30% 40% 50% 60% 70% 80% 90% 100% 110% 120% 130% 140% 150% 160% 170% 180% 190% 120 121 122 123 IRR(2) 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 the two IRRs 21096 230% 240% 250% 270% 280% 290% 31096 330% 151 152 Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM Battle, Cameron B. module_7_-_chino_materials - Saved File InsertDraw Formulas Data ReviewView Home 23 Close Links Disabled - Links to external workbooks are not supported and have been disabled 30% 40% 50% 60% 70% 80% 90% 100% 110% 120% 130% 140% 150% 160% 170% 180% 190% 120 121 122 123 IRR(2) 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 the two IRRs 21096 230% 240% 250% 270% 280% 290% 31096 330% 151 152 Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM Battle, Cameron B. 2:24 PM Sun, December 23 File InsertDraw Formulas Data ReviewView Home 23 Close Links Disabled - Links to external workbooks are not supported and have been disabled 112 Analysis of the Multiple IRR Project 113 114 Cap cost NPV 115 116 CF 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 110% 120% 130% 140% 150% 160% 170% 180% 190% 200% 210% 220% 230% 240% 250% 260% 270% 118 NPV - 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 IRR(2) the two IRRs 142 143 144 ^^ NPV-PROFH MULTIPLEH Case 95H 23%. 2:23 PM module_7_-_chino_materials Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 23 Links Disabled - Links to external workbooks are not supported and have been disabled Close 74 75 76 Data Table for effect of cost savings MIRR IRR 78 79 80 81 82 Savings NPV MIRR Payback PI 35,000 50,000 60,000 70,000 80,000 NPV of 86 Data Table for effect of cost of capital: 87 88 Cap Cost 89 NPV IRR MIRRPayback Pl project 8. 0% 9.0% 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0% 17.0% 18.0% 91 92 95 97 98 100 1n1 Case 95H NPV-PROFH MULTIPLEH SUM 23%. 2:23 PM module_7_-_chino_materials Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 23 Links Disabled - Links to external workbooks are not supported and have been disabled Close 74 75 76 Data Table for effect of cost savings MIRR IRR 78 79 80 81 82 Savings NPV MIRR Payback PI 35,000 50,000 60,000 70,000 80,000 NPV of 86 Data Table for effect of cost of capital: 87 88 Cap Cost 89 NPV IRR MIRRPayback Pl project 8. 0% 9.0% 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0% 17.0% 18.0% 91 92 95 97 98 100 1n1 Case 95H NPV-PROFH MULTIPLEH SUM 23%. 2:23 PM module_7_-_chino_materials Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView Links Disabled - Links to external workbooks are not supported and have been disabled Close 53 Net invest. outlay Annual cash flows: Deprn A.T. Cost Saving 57 59 61 63 65 67 Year Tax saving Net CF Cum CF 0 69 70 71 72 73 74 75 76 Data Table for effect of cost savings NPV IRR TV MIRR Payback: PI Analysis of Short-Term Project: Cost Year 1 CF NPV IRR MIRR IRR 78 79 Savings NPV MIRR Payback PI Case 95H NPV-PROFH MULTIPLEH SUM 23%. 2:24 PM module_7_-_chino_materials - Saved Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 123 Links Disabled - Links to external workbooks are not supported and have been disabled Close 6 This case is designed as an introduction to capital budgeting methods. 7 NPV, IRR, MIRR, PI, and Payback are included in the analysis 9 10 11 12 13 14 15 16 17 18 19 20 The model develops the project's cash flows on the basis of input cost and savings data, then calculates the above decision criteria. Note that this model was constructed specifically for this case, and hence project life and depreciation allowances are fixed. The spreadsheet sheet NPV-PROF contains a graph of the NPV profiles and the sheet MULTIPLE contains a graph of the multiple IRR project. If you are using the student version of the model, the model generating cells have been blanked out. Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. 22 INPUT DATA 23 New system: 24 Delivered cost 25 Installation 26 Salvage value 27 Annual savings KEY OUTPUT $285, 000 NPV $18,000 IRR $15,000 MIRR $7E, 000 Payback 0.00% 0.00% 0.00 0.00 Pl 30 31 32 Old system Current book value Current market value Removal cost $0 $4,000 $2, 500 Other data: 35 Cost of capital 36 Cost of borrowing 37 Roturn fnr tniral invostmonts 12-09 12.0% Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM module_7_-_chino_materials - Saved Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 123 Links Disabled - Links to external workbooks are not supported and have been disabled Close 17 18 19 20 21 22 23 24 25 26 27 Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. INPUT DATA KEY OUTPUT New system: Delivered cost Installation Salvage value Annual savings $285, 000 NPV $18,000 IRR $15,000 MIRR $7E, 000 Payback 0.00% 0.00% 0.00 0.00 Pl 29 30 31 32 Old system Current book value Current market value Removal cost $0 $4,000 $2, 500 35 36 37 38 39 40 Other data: Cost of capital Cost of borrowing Return for typical investments Tax rate 12-09 12.0% 14.0s 36.0% MODEL-GENERATED DATA 42 43 Cash flows at t-0: Cost of new system Installation End-of-project cash flows Salvage value> SV tax 45 Total cost Total 47 48 Proceeds from old equip Tax on proceeds Depreciation information Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM Battle, Cameron B. module_7_-_chino_materials - Saved File InsertDraw Formulas Data ReviewView Home 23 Close Links Disabled - Links to external workbooks are not supported and have been disabled 30% 40% 50% 60% 70% 80% 90% 100% 110% 120% 130% 140% 150% 160% 170% 180% 190% 120 121 122 123 IRR(2) 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 the two IRRs 21096 230% 240% 250% 270% 280% 290% 31096 330% 151 152 Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM Battle, Cameron B. module_7_-_chino_materials - Saved File InsertDraw Formulas Data ReviewView Home 23 Close Links Disabled - Links to external workbooks are not supported and have been disabled 30% 40% 50% 60% 70% 80% 90% 100% 110% 120% 130% 140% 150% 160% 170% 180% 190% 120 121 122 123 IRR(2) 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 the two IRRs 21096 230% 240% 250% 270% 280% 290% 31096 330% 151 152 Case 95H NPV-PROFH MULTIPLEH 23%. 2:24 PM Battle, Cameron B. 2:24 PM Sun, December 23 File InsertDraw Formulas Data ReviewView Home 23 Close Links Disabled - Links to external workbooks are not supported and have been disabled 112 Analysis of the Multiple IRR Project 113 114 Cap cost NPV 115 116 CF 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 110% 120% 130% 140% 150% 160% 170% 180% 190% 200% 210% 220% 230% 240% 250% 260% 270% 118 NPV - 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 IRR(2) the two IRRs 142 143 144 ^^ NPV-PROFH MULTIPLEH Case 95H 23%. 2:23 PM module_7_-_chino_materials Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 23 Links Disabled - Links to external workbooks are not supported and have been disabled Close 74 75 76 Data Table for effect of cost savings MIRR IRR 78 79 80 81 82 Savings NPV MIRR Payback PI 35,000 50,000 60,000 70,000 80,000 NPV of 86 Data Table for effect of cost of capital: 87 88 Cap Cost 89 NPV IRR MIRRPayback Pl project 8. 0% 9.0% 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0% 17.0% 18.0% 91 92 95 97 98 100 1n1 Case 95H NPV-PROFH MULTIPLEH SUM 23%. 2:23 PM module_7_-_chino_materials Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView 23 Links Disabled - Links to external workbooks are not supported and have been disabled Close 74 75 76 Data Table for effect of cost savings MIRR IRR 78 79 80 81 82 Savings NPV MIRR Payback PI 35,000 50,000 60,000 70,000 80,000 NPV of 86 Data Table for effect of cost of capital: 87 88 Cap Cost 89 NPV IRR MIRRPayback Pl project 8. 0% 9.0% 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0% 17.0% 18.0% 91 92 95 97 98 100 1n1 Case 95H NPV-PROFH MULTIPLEH SUM 23%. 2:23 PM module_7_-_chino_materials Battle, Cameron B. File Home InsertDraw Formulas Data ReviewView Links Disabled - Links to external workbooks are not supported and have been disabled Close 53 Net invest. outlay Annual cash flows: Deprn A.T. Cost Saving 57 59 61 63 65 67 Year Tax saving Net CF Cum CF 0 69 70 71 72 73 74 75 76 Data Table for effect of cost savings NPV IRR TV MIRR Payback: PI Analysis of Short-Term Project: Cost Year 1 CF NPV IRR MIRR IRR 78 79 Savings NPV MIRR Payback PI Case 95H NPV-PROFH MULTIPLEH SUM
