Using excel, complete the following problems in your textbook:

Using excel, complete the following problems in your textbook:

[ad_1]

Using Excel, complete the following problems in your textbook:Payback and Discounted Payback: Problems 1, 3, and 4 on page 305Average Accounting Return: Problem 6 on page 306Net Present Value: Problem 8 on page 306IRR and MIRR: Problems 7 and 19 on pages 306 and 308Profitability Index: Problems 15 and 16 on page 307Comparing Investment Criteria: Problem 17 on page 308   Page 305Question 1. Calculating Payback[LO2] What is the payback period for the following set of cash flows?YearCash Flow0−$7,6001 1,9002 2,9003 2,3004 1,700Question 3. Calculating Payback[LO2] Siva, Inc., imposes a payback cutoff of three years for its international investment projects. If the company has the following two projects available, should it accept either of them?.YearCash Flow (A)Cash Flow (B)0−$45,000−$ 55,0001 16,000 13,0002 21,000 15,0003 15,000 24,0004 9,000 255,000 Question 4.  Calculating Discounted Payback[LO3] An investment project has annual cash inflows of $2,800, $3,700, $5,100, and $4,300, for the next four years, respectively. The discount rate is 14 percent. What is the discounted payback period for these cash flows if the initial cost is $5,200? What if the initial cost is $5,400? What if it is $10,400 Page 306Question6. Calculating AAR[LO4] You’re trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $15 million, which will be depreciated straight-line to zero over its four-year life. If the plant has projected net income of $1,754,000, $1,820,500, $1,716,300, and $1,097,400 over these four years, what is the project’s average accounting return (AAR)?Question 7.  Calculating IRR[LO5] A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent, should the firm accept the following project?YearCash Flow0−$26,0001 11,0002 14,0003 10,000Question 8. Calculating NPV[LO1] For the cash flows in the previous problem, suppose the firm uses the NPV decision rule. At a required return of 11 percent, should the firm accept this project? What if the required return is 24 percent?Page 307Question 15. Calculating Profitability Index[LO7] What is the profitability index for the following set of cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent?YearCash Flow0−$15,3001 9,4002 7,6003 4,300Question 16.Problems with Profitability Index[LO1,7] The Sloan Corporation is trying to choose between the following two mutually exclusive design projects:YearCash Flow (I)Cash Flow (II)0−$51,000−$14,4001 24,800 7,8002 24,800 7,8003 24,800 7,8001.  If the required return is 10 percent and the company applies the profitability index decision rule, which project should the firm accept?2.  If the company applies the NPV decision rule, which project should it take?3.  Explain why your answers in (a) and (b) are different. Page 308Question 17.   Comparing Investment Criteria[LO1,2,3,5,7] Consider the following two mutually exclusive projects:YearCash Flow (A)Cash Flow (B)0−$455,000−$65,0001 58,000 31,0002 85,000 28,0003 85,000 25,0004 572,000 19,000Whichever project you choose, if any, you require a return of 11 percent on your investment.1.  If you apply the payback criterion, which investment will you choose? Why?2.  If you apply the discounted payback criterion, which investment will you choose? Why?3.  If you apply the NPV criterion, which investment will you choose? Why?4.  If you apply the IRR criterion, which investment will you choose? Why?5.  If you apply the profitability index criterion, which investment will you choose? Why?6.  Based on your answers in (a) through (e), which project will you finally choose? Why? Question 19. MIRR[LO6] RAK Corp. is evaluating a project with the following cash flows:Year Cash Flow0−$41,0001 15,7002 19,4003 24,3004 18,1005 −9,400The company uses an interest rate of 10 percent on all of its projects. Calculate the MIRR of the project using all three methods.   “Is this question part of your assignment? We Can Help!”

"96% of our customers have reported a 90% and above score. You might want to place an order with us."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.

Scroll to Top