PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS Problem 1 Find the final value (FV or FV) at compound interest of $10,000, for 10 years: (a) at 7.5% effective annual rate. (rates are annual) b) At 7.5% compounded monthly. c) At 7.5% capitalized quarterly. d) At 7.5% compounded semiannually.

Compute the amount that can be borrowed under each of the following circumstances: (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round your "Table value" to 4 decimal places.) 1. A promise to repay $99,000 ten years from now at an interest rate of 7%. 2. An agreement to make three separate annual payments of $20,000, with the first payment occurring 1 year from now. The annual interest rate is 5%. Option 1 Loan amount Option 2 payments Table Value Table Value Amount Amount $ Present Value Present Value 0

Suppose you borrow $14,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0".     Beginning     Repayment Ending Year Balance Payment Interest of Principal Balance 1 $  fill in the blank 60 $  fill in the blank 61 $  fill in the blank 62 $  fill in the blank 63 $  fill in the blank 64 2 $  fill in the blank 65 $  fill in the blank 66 $  fill in the blank 67 $  fill in the blank 68 $  fill in the blank 69 3 $  fill in the blank 70 $  fill in the blank 71 $  fill in the blank 72 $  fill in the blank 73 $  fill in the blank 74 4 $  fill in the blank 75 $  fill in the blank 76 $  fill in the blank 77 $  fill in the blank 78 $  fill in the blank 79

Use the compound interest formulas A = P(1 + r/n)nt and A = Pert to solve  (Round answers to the nearest cent), Find the accumulated value of an investment of $10,000 for 5 years at an interest rate of 5.5% if the money isa. compounded semiannually; b. compounded quarterly; c. compounded monthly; d. compounded continuously.

Find the future value of an investment of $9,000 if it is invested for five years and compounded semiannually at an annual rate of 2%. Use the $1.00 future value table or the future value and compound interest formula.

Assuming a 12% annual interest rate, determine the present value of a five-period annual annuity of $6,500 under each of the following situations: Note: Use tables, Excel, or a financial calculator. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. The payments are received at the end of each of the five years and interest is compounded annually. 2. The payments are received at the beginning of each of the five years and interest is compounded annually. 3. The payments are received at the end of each of the five years and interest is compounded quarterly. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Deposit Date The payments are received at the end of each of the five years and interest is compour Note: Round your final answers to nearest whole dollar amount. First payment Second payment Third payment Fourth payment Fifth payment j= 3% 3% 3% 3% 3% Required 3 X Answer is complete but not entirely corre n= 4 ✓ $ 8 12 16 ✓…

Complete the following using compound future value. (Use the Table 12.1 provided.) Note: Round your answers to the nearest cent. Time 11 years Principal $ 15,900 Rate Compounded 2% Annually Amount Interest

Complete the following using compound future value. (Use the Table provided.) Note: Do not round intermediate calculations. Round your final answers to the nearest cent. Time 5 years Principal $ 17,300 Rate Compounded 6 % Quarterly Amount Interest

Complete the following using compound future value. (Use the Table provided.) (Round your answers to the nearest cent.)     Time Principal Rate Compounded Amount Interest 12 years $15,000 3 1/2 % Annually

Find the amount to which $500 will grow under each of these conditions:a. 12% compounded annually for 5 yearsb. 12% compounded semiannually for 5 yearsc. 12% compounded quarterly for 5 yearsd. 12% compounded monthly for 5 yearse. 12% compounded daily for 5 yearsf. Why does the observed pattern of FVs occur?   Please only do parts d,e and f