Can you please help me solve for questions 2-5? I really need some help.

Homework #4 Business Finance Instructor: Jau-Lian Jeng, Ph.D. 1. You're given with a mortgage from your credit union to buy a house that costs $680,000. Suppose you pay $136,000 for down payment and the current average market interest rate is 3.2% for the 20-year mortgage. Answer the following questions: a) What is the monthly payment if there is no pre-payment penalty? b) Suppose the credit union says that if you'd like to retire the loan earlier, say at the end of the 7th year, you need to pay (say) $421,000 for the rest of the loan, would you take it given that you have no difficulty to generate the cash flow? Why or why not? c) Suppose that the credit union also offers you another possible payment program that is they will give you a low 1.2% interest rate for the first 6 years and with a lump-sum payment at the end of the 6th year as $532,000. (The lump-sum payment is a one-time payment that you must pay it off or, you need to re-finance by then.) What is your monthly payment for the first 5 years? d) Suppose you follow the original mortgage in (a) without any refinancing or prepayment, and after 5 years of payments, you discover the current market interest rate for mortgage drops to 1.8% APR. Instead of paying off the mortgage, you are about to re-finance your mortgage for 15-year mortgage instead. What is your monthly payment for your mortgage now? Is re-financing good for you? 2. Company AFLAC had issued a 15-year coupon bond with 4% coupon rate on the face value as $1,000 and with semi-annual payments. Answer the following questions: a) Suppose the discount rate for the bond is given as 10%, what is the present value of the bond? b) Suppose the current market price of the bond is given as $882 per bond, what is the current market discount rate (or so called Yield to Maturity) for the bond? c) What is the idea of Yield to Maturity? What does it imply? 3. Suppose that you're given the following information of rates of return for three mutual funds in the stock market as assessed by your financial analyst in mutual fund. The "beta's" for these mutual funds are 1.21, 0.91, 0.84, for Fund A, Fund B, and Fund C, respectively. The market return on S&P 500 index is 12% on the average. Answer the following questions: a) Let the risk-free rate be 2%, what are the required rates of return for Fund B, and Fund C? What model did you apply here? Is this model a market equilibrium condition? b) What is the purpose of Capital Asset Pricing Model (CAPM)? What is the slope of Security Market Line (SML)? What does this slope represent? c) If you want to combine Funds A, B, C altogether to form a portfolio. You want to have the portfolio's \"beta\" to be equal to \"one\" where Fund B and Fund C together will constitute about of your initial wealth for investments. What weights should you assign to these funds? 4. Suppose that you're given the following information of rates of return for the stock market as assessed by your financial analyst in mutual fund. Answer the following questions: a) What are the means, standard deviations for each fund? Why do you need to specify the means and the standard deviations? b) What are the co-variances for these funds? Are these funds mutually \"diversifiable\"? Why or why not? (Hint: apply correlation coefficients to tell) c) Explain the assumption(s) and reason(s) why the expected rate of return of investor can be represented by the expected value of the rate of return. d) Suppose that Fund A represents the Market Index Portfolio. What are the \"beta's\" for Fund B and Fund C? What is the difference in concept between standard deviation and beta for Fund B and Fund C? e) Suppose the risk-free rate is 2% and Fund A represents the Market Index Portfolio. What are the expected rates for Fund B and Fund C now according to CAPM? Are they different from the \"means\" you calculated in a)? Why? States of world Boom Recovery Recession the Probability 1 4 1 2 1 4 Fund A Fund B Fund C 16% 12% 8% 24% 36% 8% -32% -20% 4% 5. You are given with the following information statements of a public firm Bambie in the airline industry concurrently. (Notice that all negative numbers are parenthesized). The firm has issued 6 million shares of common stock with current market price as $25/per share, the expected dividend is $6.90/per share with 2.5% growth rate, 300,000 shares of preferred stocks with promised preferred dividend and preferred stock price as $2.20/per share and $10.5/per share, respectively. The firm also has currently, 2 million 4.2%coupon bonds with $1,000 face value that pays the coupons semi-annually. The current bond price is $820/per bond. The bonds are expected to mature at 2025. Answer the following questions: a) If using the market prices for assessment on rates of return, what is the rate of return the common stock of Bambie? What is the rate of return for their preferred stocks? b) What is the bond's yield to maturity of the firm's corporate bond? c) Suppose you are also given with the following financial statements of Bambie for the past three years. What are the historical returns on equity for this company for the past three years? Is the firm Bambie doing well from the perspectives of shareholders? Why or why not? d) Is this firm well-diversified with their arrangement of capital? That is, are they well diversified with different sources of capital? e) Based on the given information, provide your ratios analyses. Apply the Du-Pont model and interpret your results for the firm's performance. f) Provide the common size statements for both Balance Sheet and Income Statement. What kind of noticeable pattern you may identify for the firm? Is this usual for the airline industry? Balance Sheet (in millions) 2013 2014 2015 Assets Cash Marketable securities Accounts Receivable Inventory Plant, Building, and Equipment's (net) Investments in affiliates 30 100 920 710 1872 0 10 100 750 178 2802 30 473 0 800 450 1209 329 Total Assets 3632 3870 3261 Liabilities Short-term debts Advances from customers Accounts payable Interest payable Tax payable Other Accrued Expenses Bonds payable 507 111 685 75 127 20 925 9 34 192 98 147 15 1486 30 134 771 62 128 35 750 1021 74 87 3632 1055 756 78 3870 1175 47 129 3261 2013 2014 2015 Stockholders' Equity Common stock Additional paid-in capital Retained earning Total liabilities and equities Income Statement(in millions) Net Sales Cost of Goods Sold Selling and General Expenses Depreciation Expense Interest Expense Income Tax Expense Net Income 3296 2115 700 160 90 195 36 3418 1979 812 298 109 137 83 3983 2510 759 284 121 254 55