Please see attached. All questions are to be performed in Excel. The work must be completed by Tuesday evening at 8pm ET

Chapter 5 Homework Please note: all the questions are essay-type questions and you should attempt and answer each question in Excel. No. 4 Your firm is considering two projects with the following cash flows. In which discount rate range will the company prefer Project A, in which discount rate range will the company prefer Project B, and in which discount rate range will the company not invest? No. 7 You are considering purchasing a machine to produce golf balls. The cost of the machine is $100,000 and its expected life span is 8 years. The machine will have an annual production of 550,000 balls. The price of a golf ball is today $0.20, and it's expected to rise by 10% each year. The material used to produce a golf ball costs $0.08 and it's expected to rise by 2% a year. To operate the machine you'll need two workers, each earning an annual salary of $30,000. According to their contracts their salaries will rise by 7% a year starting in the third year. The real discount rate is 4%, the expected inflation is 5%, and the corporate tax rate is 40%. a. Calculate the NPV of the project using nominal values. b. Repeat the calculation using real values. No. 10 Your firm has to replace one of its fender-bender machines. One of your financial wizards has determined that the appropriate discount rate for the machine cash flows is 10%. Your firm has two alternatives. a. Fender-bender Machine A costs $400,000 and produces annual cash flows of $200,000 at the end of each of its 6 years of life. b. Fender-bender Machine B costs $200,000 but has only a 2-year life. However, it produces a $300,000 annual cash flow at the end of each of these 2 years. Calculate the equivalent annuity cash flow (EAC) and determine which machine is preferable. No. 14 You have a factory that produces light bulbs. Your old machine is costing a lot of money lately in repairs and you are considering replacing it. You have two offers. You sell each light bulb for $0.40, the discount rate is 12%, and the corporate tax rate 40%. a. Which machine would you prefer to buy if your annual production is1,000,000 light bulbs? b. At what level of production will you change your answer? No. 17 Hunter Brothers Inc. needs to buy printers for its offices. It can buy expensive laser printers or much cheaper (but shorter-lived) inkjets. Here are some relevant facts: A laser printer costs $1,000 and an inkjet costs $250. A laser printer has an anticipated life of 6 years, but an inkjet has an anticipated life of only 2 years. Printers are assumed to have zero market value at the end of their lives. The cost per page for a laser printer is $0.03, whereas the cost per page for an inkjet is $0.10. Each printer purchased is anticipated to print 10,000 pages per year. If Hunter Brothers has a discount rate of 12% and a tax rate of zero, which printers should it buy? Assume that the whole year's cost of printing falls at year end