Okay I need some help on some Finance questions, these questions will determine whether I pass this class or not, and I'm just not understanding it at all. They are to be worked out and answered in Excel using formulas and the Given:, Find:, Solution: format. I have attached a sample of how I need the questions answeredin an Excel fileand I have attached the questions I need worked out in a Word document. I have the correct answers highlighted and the formulas as to how to get the answer, but I don't know how to put it in an Excel document like the samples.

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: Cash flow: 0 -2,300 1 250 2 550 3 900 4 800 5 575 2.75 years, reject 3.75 years, accept 3.75 years, reject 2.75 years, accept Time: Cumulative Cash flow: 0 -2,300 1 -2,050 2 -1,500 3 -600 4 200 5 775 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 Cash Flow 0 -720 1 100 2 540 3 740 4 740 5 340 6 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 $1,364.60/$720 = 1.8953 = 189.53% accept 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% PV = 1,900, N = (10 - 1) = 9, FV = -4,200, PMT = 0, CPT I = 9.21% 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 PV = 1,700, N = (12 - 5) = 7, I = 9, PMT = 0, CPT FV = 3,107.67 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 $490 * (1+.089)*(1+.109)= 591.77 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% PV = -2,300, N = 10, PMT = 0, FV = 5,100, CPT I = 8.29 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 FV = 630, PMT = 0, I = 8, N = 4, PV = 463.07 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 PV = 14,000, PMT = 0, I =8, N = 3, FV = 17,636 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 N = 5 * 12 = 60, I = 6.50/12 = .541667, FV = 0, PMT = 2,500, CPT PV = 178,880 N = 2 * 12 = 36, I = 6.50/12 = .541667, FV = 0, PMT = 1,000 (3,500 - 2,500), CPT PV = -32,627 Sum of PV = 146,253 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% (1 + .19)^26 - 1 = 9,109.18% 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 N=9-4=5 I=9 PV = 440 PMT = 0 CPT FV = $676.99 N=9-5=4 I=9 PV = 240 PMT = 0 CPT FV = $338.78 676.99 + 338.78 = 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 (1 + .063/12)^12 - 1 = .06485 = 6.49% (1 + .106/12)^12 - 1 = .11130 = 11.13% Given: Beta 1.5 0.91 w 87% 13% Find: Beta ? Solution: Beta 1.4233 1.4233 1.4233 1.4233 Given: Stock HG FF MD Find: Port. Beta Solution: Stock HG FF MD $$'s beta $15,072.00 3.83 $9,106.00 1.55 $7,222.00 0.74 ? $$'s beta w $15,072.00 3.83 $9,106.00 1.55 $7,222.00 0.74 $31,400.00 Port. Beta 2.46 2.4581 0.48 0.29 0.23 1 Given: stock $$$'s beta Opsware $11,174.00 3.71 Lowes $16,006.00 1.81 NYT $3,020.00 0.75 rm 12% rf 5% Find: MRP ? stock Risk Premium Opsware ? Lowes ? NYT ? Portfolio Risk Premium ? Solution: MRP 7% stock Risk Premium Opsware 25.97% 0.2597 Lowes 12.67% 0.1267 NYT 5.25% 0.0525 stock $$$'s beta w Opsware $11,174.00 3.71 0.37 Lowes $16,006.00 1.81 0.53 NYT $3,020.00 0.75 0.1 $30,200.00 portfolio Beta 2.407 2.407 Portfolio Risk Premium 16.85% 0.16849 0.37 0.53 0.1