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.?

 

  • 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

Problem 25(11)-6B
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")
134
Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")
0
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. 0%
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 "*"
1. 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
2. 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.
¸
3.
Cash Payback Period Average Rate Accept for
Proposal Years Months of Return Further Analysis?
A
B
C
D
4., 5. Net Present Value and Present Value Index
Present 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 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
8.
[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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018