How does using the capital investment tools help you decide what proposal to recommend to the company? (250words) Note. Please complete the attachment file below as well.?WRDF

250 words.

This assignment has two parts to it.

How does using the capital investment tools help you decide what proposal to recommend to the company? (250words)

Note. Please complete the attachment file below as well.

WRDFinMan14e_PR11-6B.xlsx

Pr. 25(11)-6B

Problem 25(11)-6B

Name:

Section:

# N-box Incorrects due to blanks COUNTIF(B15:AT24," ")

134

Score:

# N-box +B-box corrects COUNTIF(B15:AT24," ")

Key Code:

[Key code here]

Total SUM(AD13:AD15)

Instructions

134

Answers are entered in the cells with gray backgrounds.

Percentage =(AD16-AD13-AD14)/AD16

Cells with non-gray backgrounds are protected and cannot be edited.

An asterisk (*) will appear to the right, immediately above, or immediately below an incorrect entry.

Notes:

The essay answer will not be graded.

If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "

Enter a zero in cells you would otherwise leave blank.

If number-entry or blank-entry box is incorrect, returns "*"

Payback Period

If number-entry or blank-entry box is correct, returns single space, " "

Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.

Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.

Proposal A:

-year,

-month cash payback period

Net Cash

Cumulative

Year and Months

Flow

Net Cash Flows

Year 1

Year 2

Year 3

Year 4

Proposal B:

-year,

-month cash payback period

Net Cash

Cumulative

Year and Months

Flow

Net Cash Flows

Year 1

Year 2

Year 3

Year 4

Proposal C:

-year,

-month cash payback period

Net Cash

Cumulative

Year and Months

Flow

Net Cash Flows

Year 1

Year 2

Year 3

Year 4

Proposal D:

-year,

-month cash payback period

Net Cash

Cumulative

Year and Months

Flow

Net Cash Flows

Year 1

Year 2

Year 3

Year 4

Average Rate of Return

Proposal A:

Peggy Hussey: Income from operations

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Peggy Hussey: Investment required, including residual value

Proposal B:

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Proposal C:

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Proposal D:

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Cash Payback Period

Average Rate

Accept for

Proposal

Years

Months

of Return

Further Analysis?

4., 5.

Net Present Value and Present Value Index

Present

Value of

Net Cash

Value of Net

$1 at 12%

Flow

Cash Flow

Year 1

Year 2

Year 3

Year 4

Year 5

Total

Amount to be invested

Net present value

Present value index

Present

Value of

Net Cash

Value of Net

$1 at 12%

Flow

Cash Flow

Year 1

Year 2

Year 3

Year 4

Year 5

Total

Amount to be invested

Mark Sears: Enter as a negative

Peggy Hussey: Life of investment

Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Peggy Hussey: Income from operations

Peggy Hussey: Investment required, including residual value

Peggy Hussey: Life of investment

Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Peggy Hussey: Income from operations

Peggy Hussey: Investment required, including residual value

Peggy Hussey: Life of investment

Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Peggy Hussey: Income from operations

cpence: Enter number of years for pay-back.

Peggy Hussey: Investment required, including residual value

Peggy Hussey: Life of investment

cpence: Enter number of additional months needed for pay-back.

Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.

Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.

Highland Community College: An answer will appear here when all numbers are entered in the formula.

Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.

Mark Sears: Stop at payback point.

cpence: Enter number of years for pay-back.

cpence: Enter number of additional months needed for pay-back.

Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.

Mark Sears: Select proposals accepted for further analysis in Part 3 in alphabetical order.

Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.

Mark Sears: Stop at payback point.

cpence: Enter number of years for pay-back.

cpence: Enter number of additional months needed for pay-back.

Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.

Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.

Mark Sears: Stop at payback point.

cpence: Enter number of years for pay-back.

Mark Sears: Select proposals accepted for further analysis in Part 3 in alphabetical order.

Mark Sears: Enter as a negative

cpence: Enter number of additional months needed for pay-back.

Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.

Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.

Mark Sears: Stop at payback point.

Net present value

Present value index

6., 7.

Based on net present value calculated in Part 4, the proposals should be ranked as follows:

Rank 1

Rank 2

Based on present value index calculated in Part 5, the proposals should be ranked as follows:

Rank 1

Rank 2

[Key essay answer here]

Sol

Problem 25(11)-6B
Name:	Solution
Section:
Score:	ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right, immediately above, or immediately below an incorrect entry.
The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.	Payback Period
		Proposal A:	4 cpence: Enter number of years for pay-back.	-year,	0 cpence: Enter number of additional months needed for pay-back.	-month cash payback period
						Net Cash		Cumulative
	Year and Months					Flow		Net Cash Flows
	Year 1	full year Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.				$ 120,000 Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.		$ 120,000 Mark Sears: Stop at payback point.
	Year 2	full year				120,000		240,000
	Year 3	full year				110,000		350,000
	Year 4	full year				100,000		450,000
		Proposal B:	2 cpence: Enter number of years for pay-back.	-year,	4 cpence: Enter number of additional months needed for pay-back.	-month cash payback period
						Net Cash		Cumulative
	Year and Months					Flow		Net Cash Flows
	Year 1	full year Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.				$ 100,000 Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.		$ 100,000 Mark Sears: Stop at payback point.
	Year 2	full year				80,000		180,000
	Year 3	4 months				20,000		200,000
	Year 4	N/A				–		–
		Proposal C:	3 cpence: Enter number of years for pay-back.	-year,	6 cpence: Enter number of additional months needed for pay-back.	-month cash payback period
						Net Cash		Cumulative
	Year and Months					Flow		Net Cash Flows
	Year 1	full year Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.				$ 100,000 Mark Sears: In the year payback is achieved, enter only the amount needed to achieve payback.		$ 100,000 Mark Sears: Stop at payback point.
	Year 2	full year				90,000		190,000
	Year 3	full year				90,000		280,000
	Year 4	6 months				40,000		320,000
		Proposal D:	3 cpence: Enter number of years for pay-back.	-year,	0 cpence: Enter number of additional months needed for pay-back.	-month cash payback period
						Net Cash		Cumulative
	Year and Months					Flow		Net Cash Flows
	Year 1	full year Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount columns.				$ 200,000		$ 200,000
	Year 2	full year				180,000		380,000
	Year 3	full year				160,000		540,000
	Year 4	N/A				–		–
2.	Average Rate of Return
	Proposal A:
		$60,000 Peggy Hussey: Income from operations	¸	5 Peggy Hussey: Life of investment	=	5.3% Highland Community College: An answer will appear here when all numbers are entered in the formula.
		$450,000 Peggy Hussey: Investment required, including residual value		Peggy Hussey: Life of investment	¸	2 Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.
						Highland Community College: An answer will appear here when all numbers are entered in the formula.	Proposal B:
		$90,000 Peggy Hussey: Income from operations	¸	5 Peggy Hussey: Life of investment	=	18.0% Highland Community College: An answer will appear here when all numbers are entered in the formula.
		$200,000 Peggy Hussey: Investment required, including residual value		Peggy Hussey: Life of investment	¸	2 Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.
						Highland Community College: An answer will appear here when all numbers are entered in the formula.	Proposal C:
		$120,000 Peggy Hussey: Income from operations	¸	5 Peggy Hussey: Life of investment	=	15.0% Highland Community College: An answer will appear here when all numbers are entered in the formula.
		$320,000 Peggy Hussey: Investment required, including residual value		Peggy Hussey: Life of investment	¸	2 Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.
						Highland Community College: An answer will appear here when all numbers are entered in the formula.	Proposal D:
		$220,000 Peggy Hussey: Income from operations	cpence: Enter number of years for pay-back.	¸	5 Peggy Hussey: Life of investment	=	16.3% Highland Community College: An answer will appear here when all numbers are entered in the formula.
		$540,000 Peggy Hussey: Investment required, including residual value		Peggy Hussey: Life of investment	cpence: Enter number of additional months needed for pay-back.	¸	2 Peggy Hussey: Hint: When straight-line depreciation with no residual value is used, the average investment is 1/2 of the original cost.
		Mark Sears: For each year, select "full year" or select the number of months required in that year. If the year is past the payback point, select N/A and enter a zero in the amount Who We Are We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. Do you handle any type of coursework? Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication. Is it hard to Place an Order? 1. Click on the “Place order tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled. 2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price. 3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus. 4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page. 5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it. Services we offer ☑ Custom paper writing ☑ Question and answers ☑ Essay paper writing ☑ Editing and proofreading ☑ Plagiarism removal services ☑ Multiple answer questions Order Now Guarantee you ❖ Zero Plagiarism ❖ On-time delivery ❖ A-Grade Papers ❖ Free Revision ❖ 24/7 Support ❖ 100% Confidentiality ❖ Professional Writers My Account We Accept Order Now What our customers say Amazing services Your services are just amazing. My marketing plan was amazing and professional. Alex P. Greatest service ever Wasn’t sure when giving you guys my lab report. But you did it justice. Carl Tim Pretty amazing job Quality and attention to details in their products is hard to find anywhere else Lily Wills Best writers available I got A in my Capstone project. I will be back with all my nursing orders. Debbie Z Best grades guaranteed Was amazing to have my assignments complete way before the deadline. Lisa Jan Subject Covered Nursing and Healthcare English & Literature Communication & Media Business and Economics Finance and Accounting Law and Political science Computer Science and IT Quick links Manage orders Place orders Our Policies Privacy Policy Terms of Use © aquawritings.com. All Rights Reserved Place order

Aquawritings

Aquawritings

Who We Are

Do you handle any type of coursework?

Is it hard to Place an Order?

Amazing services

Greatest service ever

Pretty amazing job

Best writers available

Best grades guaranteed