please fill in using cell references and formulas thanks

N D P P D R S T U V C E H Nama Box H K L M 1 Current Designs inanufactures kayaks. Pedal Boals Inc. has approached Current Designs about using its rotomeld expertise and equipment to produce some pedal boat corponents for Pedal Boats Inc.. Current Designs is interested in exploring this opportunity, hut is concerned that the pedal boats are a different shape than the kayaks it currently produces Current Designs would need to buy an additional retomoldoven in order to produce the pedal boat components. This project clearly involves risks, and management wants to ensure the returns justify the risks. 7 As an intern at Current Desiens, you have been asked to prepare an initial evaluation of this proposal. To aid in your areysis, the following information and assumptions have been 3 provided. Present Value tables are include in the 2nd worksheet tab for your use. Enter labels, cell references, formulas, and typed answers where indicated. Cast of the new rotamaldaven $25,000 Useful Life of the new ratomoldoven in years 8 11 -Salvage Value of the new rocorold oven $8.000 -Depreciation Method Straight-Line 12 Discount Rate 15% -Projected Annual Net Income for this project $ 15,2010 13 14 1. Compute Annual Depreciation Expense. 2. Compute Met A Cash Flows 15 Deareciable Cost Formule LABEL Cell Reference 16 Estimated Life Cell reference LABEL Cell Reference 17 Annual Depreciation Experac Formula Nct Annual Cash Hows Formula 18 19 3. Compute the Payback Period 20 LABEL Cell Reference Formula years 21 LABEL Cell Reference 22 23 4. What is the approximate Internal Rate of Return Type 5. Based on the Internal Rate of Return, would this project be acceptable? Explain 24 of this project? Answer 25 Type Answer 26 6. Use the space below to create your ownt net present value analysis. Your analysis should show of 7. Based on your Net Present Value Analysis, would components used to compute net present value. In addition, you should, whenever possible, incorporate this project be acceptable? Explain. 29 formulas and cell references in your analysis. You do not have to use all of the space provided. If you prefer, 20 you can add an additional sheet to this file and create you analysis there. Type Answer 31 Cash Flow Discount Prescat Value 32 Factor 33 Type Cell reference Volve Formula 8. Change the tab name to Run I 34 Type Cell reference Value Formula 9. Copy the tab and name it Run 2 and update with Formula the following information: 36 Type Cell Reference Cost of the new rolomold oven $ 240,000 Formula Projected Annual Net Income $ 23,910 38 39 10. Save the file and upload to blackboard by the due date 40 41 42 35 Type 37 Type 42