Please answer the following problem sets (P5-30, P5-36, P5-43, and P5-48) and show work on excel. Thanks

Value of mixed streams Find the present value of the streams of cash flows shown in the following table. Assume Year A Cash Flow 1 $ (2,000.00) 2 $3,000 3 $4,000 4 $6,000 5 $8,000 Year 2 to 5 B Cash Flow 1 $ 10,000.00 5,000/year 6 $7,000 Year 1 to 5 6 to 10 the following table. Assume that the firm's opportunity cost is 12%. C Cash Flow $10,000/year $8,000/year Changing compounding frequency Changing compounding frequency Using annual, semiannual, and quarterly compounding periods for each of the following, (1) calculate the future value if $5,000 is deposited initially, and (2) determine the effec a) At 12% annual interest for 5 years. b) At 16% annual interest for 6 years. c) At 20% annual interest for 10 years. unding periods y, and (2) determine the effective annual rate (EAR). Creating a retirement fund Creating a retirement fund To supplement your planned retirement in exactly 42 years, you estimate that you need to accumulate $220,000 by the end of 42 years from today. You plan to make equal, annual, end-of-year deposits into an account paying 8% annual interest. a) How large must the annual deposits be to create the $220,000 fund by the end of 42 years? b) If you can afford to deposit only $600 per year into the account, how much will you have accumulated by the e nual interest. f 42 years? ou have accumulated by the end of the forty-second year? Loan amortization schedule Loan amortization schedule Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over The loan is amortized into three equal, annual, end-of-year payments. a) Calculate the annual, end-of-year loan payment. b) Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan c) Explain why the interest portion of each payment declines with the passage of time. of interest to be repaid over 3 years. own of each of the three loan payments