Clipboard 136 x A O E F G H I J K L M Current Designs manufactures Layak Pedal Bouts, Inc. has approached Current Des about to expertise and equipment to produ some pedal boat components for Pedal Boats Current interested in exploring this opportunity, but is concerned that the pedalboats a different shape than the last currently produces Current Des would need to buy an add e d oven in order to produce the pede bout components. This project dearly involves and management wants to ensure the returns to the risks As an internat Current Designs, you have been asked to prepare an initial evaluation of this proposal. To aid in your analysis, the following indormatio and assumptions have been provided. Present le tables we include in the and worksheet tab for your use Enter labels, cell references formulas, and typed answers where indicated. 350.000 SH.000 -Useful ute of the new rotomoldoven in years Depreciation Method Projected Annual Net Income for this project -Cost of the new rotomoldoven 1 Salvage Value of the new rotomoldoven 2 Discount Rate 1. Compute Annuel Depreciation Expense Depreciable Cost Estimated Life Annual Depreciation Expense 2. Come A ceh SMD Period Compute the Pay a Cost 1 Ann Cash Flows O Type here to search M6 X 600 23What is the approximate internal Mate of 24 Return of this project? Based on your Net Present Value Analysis, project bearple Expo 276 Use the space below to create your own we present valor analysis. Your analysis should 28 show all components used to compute nel present value. In addition, you should whenever 20 possible, incorporate formules and cell references in your analysis. You do not have to use 30 all of the space provided. If you prefer, you can add an additional heart to this file and 31 create your analysis there Cash Flow Discount 34 Type Cell reference Cell reference Value Value & Change the tab l e ! 9. Copy the tab and name Run 2 and update with the following information: Cost of the new rolomoldoven $ 200.000 Projected Annual Net Income $ 23.900 10. Save the file and upload to blackboard by the d Run 2 than 1 PRESENT VALUE TABLES Select destination and press ENTER or the Paste Type here to search De C D E F G H I J K Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 15% 1 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.901 0.893 0.87 0.925 0.907 0.89 0.873 0.857 0.842 0.826 0.812 0.797 0.756 0.889 0.864 0.84 0.816 0.794 0.772 0.751 0.731 0.712 0.658 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.659 0.636 0.572 5 0.822 0.784 0.747 0.713 0.681 0.65 0.621 0.593 0.567 0.497 6 0.79 0.746 0.705 0.666 0.63 0.596 0.564 0.535 0.507 0.432 0.76 0.711 0.665 0.623 0.583 0.547 0.513 0.482 0.452 0.376 0.731 0.677 0.627 0.582 0.54 0.502 0.467 0.434 0.404 0.327 9 0.703 0.645 0.592 0.544 0.5 0.46 0.424 0.391 0.361 0.284 10 0.676 0.614. 0.558 0.508 0.463 0.422 0.386 0.352 0.322 0.247 13 11 0.65 0.585 0.527 0.475 0.429 0.388 0.35 0.317 0.287 0.215 14 12 0.625 0.557 0.497 0.444 0.397 0.356 0.319 0.286 0.257 0.187 15 13 0.601 0.53 0.469 0.415 0.368 0.326 0.29 0.258 0.229 0.163 0.577 0.505 0.442 0.388 0.34 0.299 0.263 0.232 0.205 0.141 1715 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.123 18 16 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.107 19 17 0.513 0.436 0.371 0.317 0.27 0.231 0.198 0.17 0.146 0.093 20 18 0.494 0.416 0.35 0.296 0.25 0.2120.18 0.153 0.13 0.081 21 19 0.475 0.396 0.331 0.276 0.232 0.194 0.164 0.138 0.116 0.07 200.456 0.377 0.312 0.250 0.215 0.178 0.149 0.124 0.104 0.061 ANALYSIS PRESENT VALUE TABLES 16 14 # O Type here to search C D E F G H I J K Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 15% 1 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.901 0.893 0.87 0.925 0.907 0.89 0.873 0.857 0.842 0.826 0.812 0.797 0.756 0.889 0.864 0.84 0.816 0.794 0.772 0.751 0.731 0.712 0.658 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.659 0.636 0.572 5 0.822 0.784 0.747 0.713 0.681 0.65 0.621 0.593 0.567 0.497 6 0.79 0.746 0.705 0.666 0.63 0.596 0.564 0.535 0.507 0.432 0.76 0.711 0.665 0.623 0.583 0.547 0.513 0.482 0.452 0.376 0.731 0.677 0.627 0.582 0.54 0.502 0.467 0.434 0.404 0.327 9 0.703 0.645 0.592 0.544 0.5 0.46 0.424 0.391 0.361 0.284 10 0.676 0.614. 0.558 0.508 0.463 0.422 0.386 0.352 0.322 0.247 13 11 0.65 0.585 0.527 0.475 0.429 0.388 0.35 0.317 0.287 0.215 14 12 0.625 0.557 0.497 0.444 0.397 0.356 0.319 0.286 0.257 0.187 15 13 0.601 0.53 0.469 0.415 0.368 0.326 0.29 0.258 0.229 0.163 0.577 0.505 0.442 0.388 0.34 0.299 0.263 0.232 0.205 0.141 1715 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.123 18 16 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.107 19 17 0.513 0.436 0.371 0.317 0.27 0.231 0.198 0.17 0.146 0.093 20 18 0.494 0.416 0.35 0.296 0.25 0.2120.18 0.153 0.13 0.081 21 19 0.475 0.396 0.331 0.276 0.232 0.194 0.164 0.138 0.116 0.07 200.456 0.377 0.312 0.250 0.215 0.178 0.149 0.124 0.104 0.061 ANALYSIS PRESENT VALUE TABLES 16 14 # O Type here to search