Managerial Accounting Comprehensive Problem #2 (need answered by Monday night 4/19)

ACCTG-Spring 2021 Comprehensive Problem #2 Due, Monday, April19th, 11:59 pm Gallatin, Inc., is deciding between investing in one of two machines in order to take on a new project. Each of the machines has an 8 vear life. At the end of the 8 years, the machine will be sold at salvage value. Working capital is invested in the project immediately and reverts back to the company for use elsewhere at the end of the project's life. Additionally, the machine used for project A will require a cash expenditure for a major overhaul at the end of 3 years. A summary of the information related to each of the investments is presented below. Project A Project B Annual cash sales (for each of the 8 years) $250,000 $400,000 Annual cash expenses (for each of the 8 years) $130,000 $250,000 Annual depreciation on new equipment (for each of the 8 years) $ 70,000 $ 93,750 Initial cost of new equipment $600,000 $800,000 Salvage value of new equipment in 8 years $ 40.000 $ 60.000 Working capital requirement $ 80.000 $120,000 Cost to overhaul new machine $ 25.000 1. Assuming Gallatin's discount rate is 8%, compute the net present value (NPV) of each of the projects & state which project is preferable from an NPV perspective. To receive credit, present your work in a manner that demonstrates your understanding of the inflows and outflows (ie, do not just provide an answer). (6 points) I recommend using the Excel spreadsheet template attached to this assignment. If you do so: Be sure to label any rows added. Indicate (perhaps highlight) which number is the final answer for each project, State (type in) which project is preferable. . 2. Compute the Internal rate of return (IRR) on each of the projects & state which project is preferable from an IRR perspective. Round your interest rate to two decimal places after the whole number (.e. 2.33%). (4 points) I recommend using the Excel spreadsheet template attached to this assignment. If you do so: Be sure to label any rows added Indicate (perhaps highlight) which number is the final answer for each project. . . A C D E G H 1 K L M N P 1 QUESTION #1 2 3 Discount Rate PROJECT A NET PRESENT VALUE Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 0.00 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 PROJECT B NET PRESENT VALUE Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 0.00 5 6 Initial Investment 7 Annual Cost Savings Salvage Value 9 Net Cash Infows Outflows) 10 Discount Rate 11 Present Value at Cash Flora's 12 13 14 15 16 17 Initial westment 18 Annual Cost Savings 19 Salvage Value 20 Net Cash Infos Outflows 21 Discount Rate 22 Present Value of Cash Flow's 23 24 25 QUESTION N2 26 27 28 Discount Rate 29 30 31 Initial Investment 32 Annual Cost Savings 33 Salvage Value 34 Net Cash Infows Outflows] 35 Discount Rate 36 Present Value of Cash Flows 37 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 PROJECT A IRR Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 0.00 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 PROJECT 1RR 39 40 Discount Rate Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 42 43 Initial Investment 44 Annual Cost Savings 45 Salvage Value 46 Net Cash Infows Outflows 47 Discount Rate 48 Present Value of Cash Flows 0.00 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 so ACCTG-Spring 2021 Comprehensive Problem #2 Due, Monday, April19th, 11:59 pm Gallatin, Inc., is deciding between investing in one of two machines in order to take on a new project. Each of the machines has an 8 vear life. At the end of the 8 years, the machine will be sold at salvage value. Working capital is invested in the project immediately and reverts back to the company for use elsewhere at the end of the project's life. Additionally, the machine used for project A will require a cash expenditure for a major overhaul at the end of 3 years. A summary of the information related to each of the investments is presented below. Project A Project B Annual cash sales (for each of the 8 years) $250,000 $400,000 Annual cash expenses (for each of the 8 years) $130,000 $250,000 Annual depreciation on new equipment (for each of the 8 years) $ 70,000 $ 93,750 Initial cost of new equipment $600,000 $800,000 Salvage value of new equipment in 8 years $ 40.000 $ 60.000 Working capital requirement $ 80.000 $120,000 Cost to overhaul new machine $ 25.000 1. Assuming Gallatin's discount rate is 8%, compute the net present value (NPV) of each of the projects & state which project is preferable from an NPV perspective. To receive credit, present your work in a manner that demonstrates your understanding of the inflows and outflows (ie, do not just provide an answer). (6 points) I recommend using the Excel spreadsheet template attached to this assignment. If you do so: Be sure to label any rows added. Indicate (perhaps highlight) which number is the final answer for each project, State (type in) which project is preferable. . 2. Compute the Internal rate of return (IRR) on each of the projects & state which project is preferable from an IRR perspective. Round your interest rate to two decimal places after the whole number (.e. 2.33%). (4 points) I recommend using the Excel spreadsheet template attached to this assignment. If you do so: Be sure to label any rows added Indicate (perhaps highlight) which number is the final answer for each project. . . A C D E G H 1 K L M N P 1 QUESTION #1 2 3 Discount Rate PROJECT A NET PRESENT VALUE Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 0.00 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 PROJECT B NET PRESENT VALUE Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 0.00 5 6 Initial Investment 7 Annual Cost Savings Salvage Value 9 Net Cash Infows Outflows) 10 Discount Rate 11 Present Value at Cash Flora's 12 13 14 15 16 17 Initial westment 18 Annual Cost Savings 19 Salvage Value 20 Net Cash Infos Outflows 21 Discount Rate 22 Present Value of Cash Flow's 23 24 25 QUESTION N2 26 27 28 Discount Rate 29 30 31 Initial Investment 32 Annual Cost Savings 33 Salvage Value 34 Net Cash Infows Outflows] 35 Discount Rate 36 Present Value of Cash Flows 37 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 PROJECT A IRR Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 0.00 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 PROJECT 1RR 39 40 Discount Rate Now Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total Net Present Value of Future Cash Flows 42 43 Initial Investment 44 Annual Cost Savings 45 Salvage Value 46 Net Cash Infows Outflows 47 Discount Rate 48 Present Value of Cash Flows 0.00 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 1.000 so