Please answer them correctly. Here are short 3 problems. Please solve all 3 problems. I would...

Free

50.1K

Verified Solution

Question

Finance

Please answer them correctly. Here are short 3 problems. Pleasesolve all 3 problems. I would really appreciate your effort.Thanks.

1). Sandhill Communication Corp. is investing $8,373,700 in newtechnologies. The company’s management expects significant benefitsin the first three years after installation (as can be seen by thefollowing cash flows), and smaller constant benefits in each of thenext four years.

Excel Template
(Note: This template includes the problem statement as itappears in your textbook. The problem assigned to you here may havedifferent values. When using this template, copy the problemstatement from this screen for easy reference to the values you’vebeen given here, and be sure to update any values that may havebeen pre-entered in the template based on the textbook version ofthe problem.)

Year
1234-7
CashFlows$2,020,000$4,090,000$2,972,100$1,033,500

What is the discounted payback period for the project assuming adiscount rate of 10 percent? (Round answer to 2 decimalplaces, e.g. 15.25. If discounted payback period exceeds life ofthe project, enter 0 for the answer.)

The discounted payback periodfor the project is _______years.

2). Management of Cullumber, Inc., an aviation firm, isconsidering purchasing three aircraft for a total cost of$166,023,819. The company would lease the aircraft to an airline.Cash flows from the proposed leases are shown in the followingtable.

YearsCash Flow
1–4$20,855,000
5–775,950,000
8–1094,550,000

What is the IRR of this project? (Round answer to 2decimal places, e.g. 15.25%.)

The IRR of this project is_______%

3). Ivanhoe Specialties just purchased inventory-managementcomputer software at a cost of $1,449,950. Cost savings from theinvestment over the next six years will produce the following cashflow stream: $199,340, $304,240, $348,600, $524,250, $734,320, and$484,740. What is the payback period on this investment?(Round answer to 2 decimal places,e.g.15.25.)

Payback Period is _______?

Answer & Explanation Solved by verified expert
4.3 Ratings (711 Votes)

1. discounted payback = 4 + 218,293.949/641,722.19 = 4.34 years

Discount rate 10.0000%
Cash flows Year Discounted CF= cash flows/(1+rate)^year Cumulative cash flow
     (8,373,700.000) 0                     (8,373,700.00)                 (8,373,700.00)
       2,020,000.000 1                       1,836,363.64                 (6,537,336.36)
       4,090,000.000 2                       3,380,165.29               (3,157,171.074)
       2,972,100.000 3                       2,232,982.72                   (924,188.355)
       1,033,500.000 4                           705,894.41                   (218,293.949)
       1,033,500.000 5                           641,722.19                       423,428.24
       1,033,500.000 6                           583,383.81                 1,006,812.046
       1,033,500.000 7                           530,348.92                    1,537,160.96

2. IRR = 22.52%

Use IRR function in Excel

3. Payback = 4 + 73,520/734,320 = 4.10

Discount rate 0.0000%
Cash flows Year Discounted CF= cash flows/(1+rate)^year Cumulative cash flow
       (1,449,950.000) 0                     (1,449,950.00)                 (1,449,950.00)
             199,340.000 1                           199,340.00                 (1,250,610.00)
             304,240.000 2                           304,240.00                   (946,370.000)
             348,600.000 3                           348,600.00                   (597,770.000)
             524,250.000 4                           524,250.00                     (73,520.000)
             734,320.000 5                           734,320.00                       660,800.00
             484,740.000 6                           484,740.00                 1,145,540.000

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