To complete this homework, you will enter your answers to the questions below on Tab 1 of the M3 submission template. Once you have completed Tab 1, you will copy it to Tab 2 (copy range is A1:C58). Once you've copied your answers to Tab 2, you will click on "Formulas," then on "Show Formulas." The homework must be completed according to the Principles of Spreadsheet Design. Remember that yvou are graded on the assignment as well as your accuracy in using the Principles of Spreadsheet Design. 1. You are evaluating Machines A and B to determine which one to buy. Find their payback periods, and then use them as the basis for choosing a machine. Justify your answer. t A B 0 [(2,000,000 1,000,000 1 |525,000 225,000 2 425,000 205,000 3 550:000 295,000 4 1300,000 275,000 3 200,000 2. You are evaluating a purchase using the net present value method. Using an interest rate of 5%. find the NPV for this asset. Based on this, should you buy the asset or not? Justify your answer. 3 You have another possible purchase with an NPV of $5,000. Should you invest in this asset, or the asset in Problem 27 Justify your answer. Find the IRR of the cash flows of the asset below. If your cost of capital is 12%, should you invest in this asset? Justify your answer. 0| -150,000] You are considering the purchase of another asset with an IRR of 11%. Should you invest in this asset or the one in Problem 4? Justify your answer. M3 Indiv. Assignment Submission Template PROBLEM 1 Inputs Yr A B 0 N 4 5 Outputs 1 2 1 +2 3 1+2+3 4 1+2+3+4 5 1+2+3+4+5 Which Machine? Justification? PROBLEM 2 Inputs Interest rate 0 2 3 4 Outputs NPV Invest? JustificationPROBLEM 3 Which asset? Justification PROBLEM 4 Inputs == Outputs IRR Invest? Justification PROBLEM 5 Which asset? Justification