I will need help answering tabs 2,9,10(1), 10 (2), and 10 (3)
Chap 9 #1 Chapter 9 - Assignment 1.4 Problem 1: Calculating Payback5 Points Siva, Inc., imposes a payback cutoff of three years for its international investment projects. The company has two international projects with the following projected cash flows: YearCash Flow (A)Cash Flow (B) 0$ (52,000)$ (55,000) 1$ 17,000$ 14,000 2$ 19,000$ 16,000 3$ 17,000$ 22,000 4$ 11,000$ 285,000 a) What is the precise payback period (in decimal form) for these two projects? b) Using payback period rules, should it accept either of them? Create your Original Solution Below - Be sure to show all calculations and clearly indicate answers. Project A: YearCash FlowCommulative Cash Flow 0-52,000-52,000 117000-35,000 219000-16,000 3170001,000 41100012,000 PayBack Period2.94 Project B: YearCash FlowCommulative Cash Flow 0-55,000-55,000 114000-41,000 216000-25,000 322000-3,000 4285000282,000 PayBack Period3.0105years Question 2: Project A has the lower payback period This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 9 #2 Chapter 9 - Assignment 1.4 Problem 2: Calculating Discounted Payback5 Points An investment project has annual cash inflows of $3,700, $4,800, $6,300, and $5,400, for the next four years, respectively. The discount rate is 12 percent. a) What is the discounted payback period if the initial cost is $6,200? b) What is the discounted payback period if the initial cost is $9,600? c) What is the discounted payback period if the initial cost is $11,800? Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs. Input area: Annual cash inflows: Year 1 Year 2 Year 3 Year 4 Discount rate Initial cost Initial cost Initial cost Output area: . Discounted payments: Year 1$ - 0 Year 2$ - 0 Year 3$ - 0 Year 4$ - 0 Payback period - 0 Payback period - 0 Payback period - 0 This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 9 #3 Chapter 9 - Assignment 1.4 Problem 3: Calculating AAR5 Points You're trying to determine whether to expand your business by building a new manufacturing line. The automated assembly line has an installation cost of $25 million, which will be depreciated straight-line to zero over its five-year life. The line has projected net income of $1,754,000, $1,820,500, $1,716,300, $1,352,000, and $1,097,400 over these five years. a) What is the project's average accounting return (AAR)? b) If the company's required return is 15%, should it pursue the project? Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs. Input area: Installation cost ($)$ 25,000,000 # of years5 Projected net income ($): Year 0$ 1,754,000 Year 1$ 1,820,500 Year 2$ 1,716,300 Year 3$ 1,352,000 Year 4$ 1,097,400 Acceptance Criteria (%)15% . Output area: . Average net income$1,548,040 Average book value$10,000,000 AAR15.48% DecisionAccept This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 9 #4 Chapter 9 - Assignment 1.4 Problem 4: Calculating IRR5 Points A firm evaluates all of its projects by applying the IRR rule. The firm's required rate of return for its projects is 15 percent. A proposed project is expected to have the following cash flows: YearCash Flow 0$ (250,000) 1$ 85,000 2$ 130,000 3$ 110,000 a) What is the IRR for this project? b) Should the firm accept this project? Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs. Input area: Required Return15% Annual cash flows: Year 0$ (250,000) Year 1$ 85,000 Year 2$ 130,000 Year 3$ 110,000 . Output area: . IRR13.73% Accept/RejectReject This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 9 #5 Chapter 9 - Assignment 1.4 Problem 5: Calculating NPV5 Points A firm evaluates all of its projects by applying the NPV decision rule. A proposed project is expected to have the following cash flows: YearCash Flow 0$ (250,000) 1$ 85,000 2$ 130,000 3$ 110,000 a) At a required return of 12 percent, what is the project's NPV? Should the firm accept this project? b) At a required return of 18 percent, what is the project's NPV? Should the firm accept this project? Create your Original Solution Below - Be sure to show all calculations and clearly indicate answers. Required Return15%Required Return18% Annual cash flows:Annual cash flows: Year 0$ (250,000)Year 0$ (250,000) Year 1$ 85,000Year 1$ 85,000 Year 2$ 130,000Year 2$ 130,000 Year 3$ 110,000Year 3$ 110,000 .. Output area: .. IRR13.73%IRR13.73% Accept/RejectRejectAccept/RejectReject This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 9 #6 Chapter 9 - Assignment 1.4 Problem 6: Problems with Profitability Index10 Points The Sloan Corporation is trying to choose between the following two mutually-exclusive design projects: YearCash Flow (A)Cash Flow (B) 0$ (76,500)$ (21,600) 1$ 37,200$ 11,700 2$ 37,200$ 11,700 3$ 37,200$ 11,700 a) Calculate the profitability index for both projects if the required return is 12 percent. Based on the profitability index decision rule, which project should the firm accept? b) Calculate the NPV for both projects if the required return is 12 percent. Based on the NPV decision rule, which project should the firm accept? c) Explain why your answers for (a) and (b) are different? Create your Original Solution Below - Be sure to show all calculations and clearly indicate answers. This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 10 #1 Chapter 10 - Assignment 1.4 Problem 1: Calculating Depreciation5 Points A piece of newly-purchased industrial equipment costs $1,240,000 and is classified as seven-year property under MACRS. Depreciation on this equipment will impact the company's taxes, and will therefore be a significant factor in determing whether the company should proceed with the purchase. a) Calculate the annual depreciation under MACRS for all eight years depreciation is allowed. b) Calculate the end-of-year book values for this equipment, using MACRS, for all eight years. Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs. Input area: Purchase Price ($) *7-year property under MACRS Output area: . Yr.Beginning Book ValueMACRSDepreciationEnding Book value 1$ 1,240,000.000.1429$ 177,196.00$ 1,062,804.00 21,062,804.000.2449303,676.00759,128.00 3759,128.000.1749216,876.00542,252.00 4542,252.000.1249154,876.00387,376.00 5387,376.000.0893110,732.00276,644.00 6276,644.000.0892110,608.00166,036.00 7166,036.000.0893110,732.0055,304.00 855,304.000.044655,304.00- 0 This is the Student Template, provided in the course materials by D. Kendall April 2020 Chap 10 #2 Chapter 10 - Assignment 1.4 Problem 2: Calculating Project OCF10 Points Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated straight-line to zero over its three-year life, after which time it will be worthless (zero salvage value). The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The applicable tax rate is 35 percent, and the required rate of return on the project is 12 percent. a) What is the Operating Cash Flow (OCF) for this project?