How does using the capital investment tools help you decide what proposal to recommend to the company. NOTE: PLEASE USED THE ABOVE INFORMATION TO COMPLETE THE ATTACHMENT FILE.?

22 Jul How does using the capital investment tools help you decide what proposal to recommend to the company. NOTE: PLEASE USED THE ABOVE INFORMATION TO COMPLETE THE ATTACHMENT FILE.?

Posted at 03:31h in Business Finance - Accounting by

How does using the capital investment tools help you decide what proposal to recommend to the company.

NOTE: PLEASE USED THE ABOVE INFORMATION TO COMPLETE THE ATTACHMENT FILE.

WRDFinMan14e_PR11-6B1.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 Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. Do you need an answer to this or any other questions? Enjoy Our Services Secure Payments About Us We offer plagiarism free writing service…We write all type of coursework and assignments Quick Links Homepage Ask Question Blog Page Contact Us Recent Posts Examine the global criminal perspective of two types of transnational crimes Myers-Briggs Type Indicator (MBTI) We Accept © Copyright Essayabode— All Rights Reserved.

22 Jul How does using the capital investment tools help you decide what proposal to recommend to the company. NOTE: PLEASE USED THE ABOVE INFORMATION TO COMPLETE THE ATTACHMENT FILE.?

Pr. 25(11)-6B

Sol

About Us

Quick Links

Recent Posts

We Accept