Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three...

Free

90.2K

Verified Solution

Question

Accounting

Net Present Value Method, Present Value Index, and Analysis

United Bankshores, Inc. wishes to evaluate three capitalinvestment proposals by using the net present value method.Relevant data related to the proposals are summarized asfollows:

Branch
Office
Expansion
Computer
System
Upgrade
Install
Internet
Bill-Pay
Amount to be invested$575,292$377,600$191,050
Annual net cash flows:
Year 1286,000200,000123,000
Year 2266,000180,00085,000
Year 3243,000160,00062,000
Present Value of $1 at CompoundInterest
Year6%10%12%15%20%
10.9430.9090.8930.8700.833
20.8900.8260.7970.7560.694
30.8400.7510.7120.6580.579
40.7920.6830.6360.5720.482
50.7470.6210.5670.4970.402
60.7050.5640.5070.4320.335
70.6650.5130.4520.3760.279
80.6270.4670.4040.3270.233
90.5920.4240.3610.2840.194
100.5580.3860.3220.2470.162

Required:

1. Assuming that the desired rate of return is15%, prepare a net present value analysis for each proposal. Usethe present value of $1 table above. If required, use the minussign to indicate a negative net present value. If required, roundto the nearest dollar.

Branch Office ExpansionComputer System UpgradeInstall Internet Bill-Pay
Present value of net cash flow total$$$
Amount to be invested$$$
Net present value$$$

2. Determine a present value index for eachproposal. If required, round your answers to two decimalplaces.

Present Value Index
Branch Office Expansion
Computer System Upgrade
Install Internet Bill-Pay

3. Which proposal offers the largest amount ofpresent value per dollar of investment?

Answer & Explanation Solved by verified expert
4.1 Ratings (729 Votes)

Answer-1)-

Calculation of Net Present Value
Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay
Year Discount Factor (a) Cash Inflow (b) Present value (c=a*b) Cash Inflow (d) Present value (e=a*d) Cash Inflow (f) Present value (g=a*f)
$ $ $ $ $ $
1 0.870 286000 248820 200000 174000 123000 107010
2 0.756 266000 201133 180000 136105 85000 64272
3 0.658 243000 159777 160000 105203 62000 40766
TOTAL 609731 415308 212048
Capital Investment 575292 377600 191050
Net Present value 34439 37708 20998

2)-

Calculation of Project Profitability Index
Particulars Project Number
Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay
Net Present Value $ (A) 34439 37708 20998
Investment required $ (B) 575292 377600 191050
Profitability Index C=A/B 0.06 0.10 0.11

3)-Computer system upgrade proposal offers the largest amount of present value per dollar of investment.


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students