Hello! Please help me with as much of this as you can. Thank you!Present Value of an Annuity of $1at Compound Interest (Partial Table)Year10%20%10.9090.83353.7912.991106.1454.192 AlphaBetaGammaAnnual net cash flow$fill in the blank 7f0ece094062012_1$fill in the blank 7f0ece094062012_2$fill in the blank 7f0ece094062012_3Present value factorfill in the blank 7f0ece094062012_4fill in the blank 7f0ece094062012_5fill in the blank 7f0ece094062012_6Present value of annual net cash flows$fill in the blank 7f0ece094062012_7$fill in the blank 7f0ece094062012_8$fill in the blank 7f0ece094062012_9Amount to be investedfill in the blank 7f0ece094062012_10fill in the blank 7f0ece094062012_11fill in the blank 7f0ece094062012_12Net present value$fill in the blank 7f0ece094062012_13$fill in the blank 7f0ece094062012_14$fill in the blank 7f0ece094062012_15 Question Content AreaFinal QuestionsAfter reviewing all your data, answer the following questions (1)-(3).1. What can you say about each proposal? (<, =, > 20%)ProposalInternal Rateof ReturnAlpha Beta Gamma 2. What can you say about these proposals? (A, B, C, A and B, B and C)a. HomeGrown would be breaking even (i.e., profit = 0) if Alpha’s proposal is chosen.b. Only Gamma’s proposal is yielding more than HomeGrown’s minimum desired rate of return.c. Gamma’s proposal is the only proposal that would be acceptable to HomeGrown. 3. Which proposal is the best choice for HomeGrown given the data collected? HomeGrown CompanyHomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is consideringopening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores.The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides on a more open floor plan, with less shelf space for products, revenue would be loweroverall. However, if HomeGrown decides on a very crowded floor plan, it may lose customers who appreciate a more open feel.As the project manager for HomeGrown, you are responsible for deciding which if any of the proposals to accept. HomeGrown's minimum acceptable rate of return is 20%. You receive the following data from thethree contractors:ProposalAlphaBetaGammaAlphaBetaType of Floor PlanVery open, like an indoor farmer's marketStandard grocery shelving and layout, minimal aisle spaceMix of open areas and shelving areasEstimated AverageAnnual IncomeProposal (after depreciation)$291,014272,019521,931GammaMethod ComparisonYou have computed estimates of annual cash flows and average annual income from customers for each of the three contractors' plans. You believe that the annual cash flows will be equal for each of the 10 years forwhich you are preparing your capital investment analysis. Your conclusions are presented in the following table.Estimated AverageAnnual Cash FlowInitial Costif Selected$351,145475,608592,819$1,472,0005,678,9002,125,560ResidualValue$0.000.000.00Compare methods of capital investment analysis in the following table to begin your evaluation of the three capital investment proposals Alpha, Beta, and Gamma. You decide to compare four methods: the averagerate of return, cash payback period, net present value, and internal rate of return methods. You begin by trying to eliminate any proposals that are not yielding the company's minimum required rate of return of 20%. Complete the following table, and decide whether Alpha, Beta, and/or Gamma should beeliminated because the average rate of return of their project is less than the company's minimum required rate of return.Complete the following table. Enter the average rates of return as percentages rounded to two decimal places.Estimated AverageAverageAverage RateAccept orProposalAnnual IncomeInvestmentof ReturnReject#볼링종목Alpha$291,014$ 1,472,00019.77 %RejectBeta272,0195,678,9004.79RejectGamma521,9312,125,56024.55AcceptCash Payback MethodYou've decided to confirm your results from the average rate of return by using the cash payback method.Using the following table, compute the cash payback period of each investment. If required, round the number of years in the cash payback period to a whole number.Cash PaybackPeriod in YearsProposalAlphaBetaGammaInitial Cost$1,472,0005,678,9002,125,560Annual NetCash Inflow$351,145475,608592,819124

Net Present Value = Present Value of Cash Inflows - Initial Investment Cash Payback = Initial…

Hello! Please help me with as much of this as you can. Thank you! Present Value of an Annuity of $1 at Compound Interest (Partial Table) Year 10% 20% 1 0.909 0.833 5 3.791 2.991 10 6.145 4.192 Alpha Beta Gamma Annual net cash flow $fill in the blank 7f0ece094062012_1 $fill in the blank 7f0ece094062012_2 $fill in the blank 7f0ece094062012_3 Present value factor fill in the blank 7f0ece094062012_4 fill in the blank 7f0ece094062012_5 fill in the blank 7f0ece094062012_6 Present value of annual net cash flows $fill in the blank 7f0ece094062012_7 $fill in the blank 7f0ece094062012_8 $fill in the blank 7f0ece094062012_9 Amount to be invested fill in the blank 7f0ece094062012_10 fill in the blank 7f0ece094062012_11 fill in the blank 7f0ece094062012_12 Net present value $fill in the blank 7f0ece094062012_13 $fill in the blank 7f0ece094062012_14 $fill in the blank 7f0ece094062012_15 Question Content Area Final Questions After reviewing all your data, answer the following questions (1)-(3). 1. What can you say about each proposal? (<, =, > 20%) Proposal Internal Rate of Return Alpha Beta Gamma 2. What can you say about these proposals? (A, B, C, A and B, B and C) a. HomeGrown would be breaking even (i.e., profit = 0) if Alpha’s proposal is chosen. b. Only Gamma’s proposal is yielding more than HomeGrown’s minimum desired rate of return. c. Gamma’s proposal is the only proposal that would be acceptable to HomeGrown. 3. Which proposal is the best choice for HomeGrown given the data collected?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 17E

See similar textbooks

Question Content Area

Final Questions

After reviewing all your data, answer the following questions (1)-(3).

1. What can you say about each proposal? (<, =, > 20%)

Proposal	Internal Rate of Return
Alpha
Beta
Gamma

2. What can you say about these proposals? (A, B, C, A and B, B and C)

a. HomeGrown would be breaking even (i.e., profit = 0) if Alpha’s proposal is chosen.

b. Only Gamma’s proposal is yielding more than HomeGrown’s minimum desired rate of return.

c. Gamma’s proposal is the only proposal that would be acceptable to HomeGrown.

3. Which proposal is the best choice for HomeGrown given the data collected?

HomeGrown Company
HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering
opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores.
The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides on a more open floor plan, with less shelf space for products, revenue would be lower
overall. However, if HomeGrown decides on a very crowded floor plan, it may lose customers who appreciate a more open feel.
As the project manager for HomeGrown, you are responsible for deciding which if any of the proposals to accept. HomeGrown's minimum acceptable rate of return is 20%. You receive the following data from the
three contractors:
Proposal
Alpha
Beta
Gamma
Alpha
Beta
Type of Floor Plan
Very open, like an indoor farmer's market
Standard grocery shelving and layout, minimal aisle space
Mix of open areas and shelving areas
Estimated Average
Annual Income
Proposal (after depreciation)
$291,014
272,019
521,931
Gamma
Method Comparison
You have computed estimates of annual cash flows and average annual income from customers for each of the three contractors' plans. You believe that the annual cash flows will be equal for each of the 10 years for
which you are preparing your capital investment analysis. Your conclusions are presented in the following table.
Estimated Average
Annual Cash Flow
Initial Cost
if Selected
$351,145
475,608
592,819
$1,472,000
5,678,900
2,125,560
Residual
Value
$0.00
0.00
0.00
Compare methods of capital investment analysis in the following table to begin your evaluation of the three capital investment proposals Alpha, Beta, and Gamma. You decide to compare four methods: the average
rate of return, cash payback period, net present value, and internal rate of return methods.

You begin by trying to eliminate any proposals that are not yielding the company's minimum required rate of return of 20%. Complete the following table, and decide whether Alpha, Beta, and/or Gamma should be
eliminated because the average rate of return of their project is less than the company's minimum required rate of return.
Complete the following table. Enter the average rates of return as percentages rounded to two decimal places.
Estimated Average
Average
Average Rate
Accept or
Proposal
Annual Income
Investment
of Return
Reject
#볼링종목
Alpha
$
291,014
$ 1,472,000
19.77 %
Reject
Beta
272,019
5,678,900
4.79
Reject
Gamma
521,931
2,125,560
24.55
Accept
Cash Payback Method
You've decided to confirm your results from the average rate of return by using the cash payback method.
Using the following table, compute the cash payback period of each investment. If required, round the number of years in the cash payback period to a whole number.
Cash Payback
Period in Years
Proposal
Alpha
Beta
Gamma
Initial Cost
$
1,472,000
5,678,900
2,125,560
Annual Net
Cash Inflow
$
351,145
475,608
592,819
12
4

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Present Value of an Annuity of $1 at Compound Interest (Partial Table)
Year	10%	20%
1	0.909	0.833
5	3.791	2.991
10	6.145	4.192

	Alpha	Beta	Gamma
Annual net cash flow	$fill in the blank 7f0ece094062012_1	$fill in the blank 7f0ece094062012_2	$fill in the blank 7f0ece094062012_3
Present value factor	fill in the blank 7f0ece094062012_4	fill in the blank 7f0ece094062012_5	fill in the blank 7f0ece094062012_6
Present value of annual net cash flows	$fill in the blank 7f0ece094062012_7	$fill in the blank 7f0ece094062012_8	$fill in the blank 7f0ece094062012_9
Amount to be invested	fill in the blank 7f0ece094062012_10	fill in the blank 7f0ece094062012_11	fill in the blank 7f0ece094062012_12
Net present value	$fill in the blank 7f0ece094062012_13	$fill in the blank 7f0ece094062012_14	$fill in the blank 7f0ece094062012_15