I need some help with my finance questions. The file is attached below. Need by 4:30 pm please!!

1. Compute the Discounted Payback statistic for Project X and recommend whether the firm should accept or reject the project with the cash flows shown below if the appropriate cost of capital is 10 percent and the maximum allowable discounted payback is 3 years. Time: 0 Cash flow: -1,000 1 2 3 4 5 400 580 500 400 250 4.72 years, reject 2.42 years, accept 2.72 years, accept 3.42 years, reject 2. Compute the Payback statistic for Project X and recommend whether the firm should accept or reject the project with the cash flows shown below if the appropriate cost of capital is 10 percent and the maximum allowable payback is 4 years. Time: 0 1 2 3 4 5 Cash flow: -2,300 250 550 900 800 575 2.75 years, reject 3.75 years, accept 3.75 years, reject 2.75 years, accept 3. Compute the PI statistic for Project X and note whether the firm should accept or reject the project with the cash flows shown below if the appropriate cost of capital is 11 percent. Time: 0 1 2 3 4 5 Cash flow: -83 -83 0 108 83 58 25.71%, accept 11.00%, reject 10.29%, reject 12.40%, accept 4. Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 12 percent, and that the maximum allowable payback and discounted payback statistic for the project are 2 and 3 years, respectively. Time 0 1 2 3 4 5 6 Cash Flow -720 100 540 740 740 340 740 Use the PI decision rule to evaluate this project; should it be accepted or rejected? 1.89%, reject 189.53%, accept -189.00%, reject 1.89%, accept 5. Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown below. The required rate of return on projects of both of their risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the projects are 2 and 3 years, respectively. Time: 0 1 2 3 Project A Cash -20,000 Flow 10,000 30,000 1,000 Project B Cash -30,000 Flow 10,000 20,000 50,000 Use the NPV decision rule to evaluate these projects; which one(s) should be accepted or rejected? rev: 12_04_2012 accept neither A nor B reject A, accept B accept both A and B accept A, reject B 6. Solving for Rates What annual rate of return is implied on a $1,900 loan taken next year when $4,200 must be repaid in year 10? 9.21% 8.26% 12.11% 13.46% 7. Moving Cash Flows What is the value in year 12 of a $1,700 cash flow made in year 5 when the interest rates are 9 percent? $4,781.53 $3,107.67 $2,771.00 $604.41 8. Compounding with Different Interest Rates A deposit of $490 earns interest rates of 8.9 percent in the first year and 10.9 percent in the second year. What would be the second year future value? $1,043.41 $591.77 $587.02 $1,077.02 9. Solving for Rates What annual rate of return is earned on a $2,300 investment when it grows to $5,100 in ten years? 7.51% 8.29% 1.22% 2.22% 10. Future Value At age 20 you invest $1,500 that earns 8.25 percent each year. At age 35 you invest $1,500 that earns 11.25 percent per year. In which case would you have more money at age 60? At age 20 invest $1,500 at 8.25 percent. There is not enough information to determine which case earns the most money at age 60. At age 35 invest $1,500 at 11.25 percent. Both yield the same amount at age 60. 11. Discounting Four Years What is the present value of a $630 payment in four years when the discount rate is 8 percent? $579.60 $680.40 $463.07 $630.00 12. Moving Cash Flows What is the value in year 4 of a $900 cash flow made in year 5 when interest rates are 8.2 percent? $606.88 $831.79 $656.65 $826.20 13. Solving for Rates What annual rate of return is earned on a $2,000 investment when it grows to $4,500 in twenty years? 2.25% 3.94% 4.14% 1.25% 14. Three Years Future Value What is the future value of $14,000 deposited for three years earning 8% interest rate annually? $31,636 $3,636 $17,636 $14,000 15. Present Value of Multiple Annuities A small business owner visits his bank to ask for a loan. The owner states that he can repay a loan at $2,500 per month for the next three years and then $3,500 per month for the two years after that. If the bank is charging customers 6.50 percent APR, how much would it be willing to lend the business owner? $186,000 $12,090 $178,880 $146,253 16. Present Value of an Annuity What is the present value of a $500 annuity payment over 7 years if interest rates are 10 percent? $2,667.46 $974.36 $2,434.21 $256.58 17. Future Value of an Annuity What is the future value of a $570 annuity payment over 7 years if the interest rates are 6 percent? $4,784.49 $4,229.40 $857.07 $4,077.38 18. Compound Frequency Payday loans are very short-term loans that charge very high interest rates. You can borrow $400 today and repay $476 in two weeks. What is the compound annual rate implied by this 19 percent rate charged for only two weeks? 9,109.18% 22.80% 20.85% 19.80% 19. Future Value Compute the future value in year 9 of a $440 deposit in year 4 and another $240 deposit at the end of year 5 using a 9% interest rate. $964.40 $1,144.40 $1,476.89 $1,015.77 20. Teaser Rate Mortgage A mortgage broker is offering a 30-year mortgage with a teaser rate. In the first two years of the mortgage, the borrower makes monthly payments on only a 6.3 percent APR interest rate. After the second year, the mortgage interest charged increases to 10.6 percent APR. What is the effective interest rate in the first two years? What is the effective interest rate after the second year? 13.89%, 15.25% respectively 6.19%, 10.32% respectively 6.30%, 10.60% respectively 6.49%, 11.13% respectively