Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calibri 11 B / USA CE LABEL A B D E F G H 1 J Current Designs manufactures kayaks. Pedal Boats, Inc. has approached

image text in transcribed
image text in transcribed
Calibri 11 B / USA CE LABEL A B D E F G H 1 J Current Designs manufactures kayaks. Pedal Boats, Inc. has approached Current Designs about using its rotomold expertise and equipment to K M produce some pedal boat components for Pedal Boats Inc.. Current Designs is interested in exploring this opportunity, but is concerned that the pedal boats are a different shape than the kayaks it currently produces. Current Designs would need to buy an additional rotomold oven in order to produce the pedal boat components. This project clearly involves risks, and management wants to ensure the returns justify the risks. As an intern at Current Designs, you have been asked to prepare an initial evaluation of this proposal. To aid in your analysis, the following information and assumptions have been provided. Present Value tables are include in the 2nd worksheet tab for your use. Enter labels, cell references, formulas, and typed answers where indicated. $256,000 -Cost of the new rotomold oven 8 Useful Life of the new rotomold oven in years -Salvage Value of the new rotomold oven $8.000 -Depreciation Method Straight-Line 15% $15,200 Projected Annual Net Income for this project -Discount Rate 1. Compute Annual Depreciation Expense. 2. Compute Net Annual Cash Flows Cell Reference LABEL Formula Depreciable Cost LABEL Cell Reference Estimated Life Cell reference Formula Net Annual Cash Flows Formula Annual Depreciation Expense Formula years 3. Compute the Payback Period. LABEL LABEL Cell Reference Cell Reference 5. Based on the Internal Rate of Return, would this project be acceptable? Expl Type Answer 4. What is the approximate Internal Rate of Return of this project? Type Answer K M N O P 7. Based on your Net Present Value Analysis, would this project be acceptable? Type Anwer G 1 6. Use the space below to create your own net present value analysis. Your analysis should show all components used to compute net present value. In addition, you should, whenever possible, incorporate formules and cell references in your analysis, You do not have to use all of the space provided. If you prefer, you can add an additional sheet to this file and create your analysis there. Cash Flow Discount Present Value Factor 3 Type Cell reference Value Formula 4 Type Cell reference Value Formula 5 Type Formula Cell Reference 7 Type Formula 8 9 0 1 12 13 34 35 46 47 a. Change the tab name to Huni 1 9. Copy the tab and name it Run 2 and update with the following information Gost of the new rolomoldoven $240.000 Projected A Netin.com $23,910 5 Type 10. Save the file and upload to blackboard by the due date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Analytics Data Science For The Accounting Profession

Authors: J. Christopher Westland

1st Edition

3030490904, 9783030490904

More Books

Students also viewed these Accounting questions

Question

Define the concept of functional autonomy as employed by Allport.

Answered: 1 week ago

Question

Define and discuss affirmative action.

Answered: 1 week ago

Question

Discuss diversity management.

Answered: 1 week ago