Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plz fill the needed numbers for the homework in the boxes!!! Project 2: The bicycle manufacturer has another opportunity presented to expand their current factory

plz fill the needed numbers for the homework in the boxes!!!

image text in transcribedimage text in transcribedimage text in transcribed
Project 2: The bicycle manufacturer has another opportunity presented to expand their current factory space to increase production and ultimately be able to reach new markets with their expanded manufacturing capacity. The company has determined the following information and assumptions for this new expansion idea: 1) The capital investment for this project will cost the company $300,000. Depreciation will be calculated over a 6 year life with no salvage value. The projected annual net income for each of the six years are as follows: Year 1: 9,000 Year 2: 10,000 Year 3: 14,000 Year 4: 18,000 Year 5: 25,000 Year 6: 40,000 Total 116,000 Instructions: Using the template below, a) compute the annual rate of return. b) prepare a table of the net annual cash flow and cumulative net cash flow. c) compute the payback period. d) compute the NPV using the determined 11% discount rate. Should the proposabie be accepted using this discount rate? e) compare the results from Project 1 to determine which project is more appealing. a) Compute the annual rate of return. bl Prepare a table of the net annual cash flow and cumulative net cash flow. (Hint: Don't forget about depreciation's impact on cash flow. Refer to M11 Excel Example!) Net Annual Cumulative Cash Flow Net Cash Flow d) Compute the NPV using the discount rate of 11% and the NPV Excel formula. You should list out your inputs in the provided spaces. Present value of cash inflows: 2 Present value of cash outflows: 1 Net present value 1 Is this proposal acceptable using this discount rate? Respond Yes or No. 2

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

Step: 3

blur-text-image

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

Horngrens Financial & Managerial Accounting The Financial Chapters

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

0133255573, 978-0133255577

More Books

Students also viewed these Accounting questions

Question

How are sediments formed on the earths surface?

Answered: 1 week ago

Question

5. How can I help others in the network achieve their goals?

Answered: 1 week ago