Explore BrainMass
Share

Explore BrainMass

    Amortization schedule, TVM concepts, WACC NPV, cost of stock

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    There are three questions attached here. The following is question three.

    QUESTION 3
    Assume that Alnser Company has a project under consideration that requires an initial investment of 1,000,000 QR and will produce incremental after tax cash flows of 350,00 annually for five years.
    Alnser company decides to get the money fro the initial investment as follows:
    Common Stock 400,000
    Preferred Stock 300,000
    Bonds 300,000
    Total 1,000,000

    If you know that:
    1. The market risk premium is 8.5%, the risk free rate is 7% and Alnser company has equal to 1.35
    2. Alnser Company has a preferred stock which pays an annual dividend of 3.25 QR per share and currently has a market price of 25 QR per share
    3. Alnser Company issued a 25 year bond with a 10% coupon and 1,000 face value, the market value of the bond is 915 QR. (Assume the tax rate is 34%).
    Based on data given above answer the following questions:
    1. Using the SML - CAPM- to compute the firm's cost of Equity.
    2. Compute the cost of Preferred stock
    3. Computer the cost of Debt after tax
    4. Compute the Weighted Average Cost of Capital (WACC).
    5. Compute the NPV.

    © BrainMass Inc. brainmass.com April 3, 2020, 10:27 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/amortization-schedule-tvm-concepts-wacc-npv-cost-stock-442879

    Attachments

    Solution Preview

    See attachment for clearer view.

    The loan amortization is in the attached Excel file.

    Question One: Solution" WACC and NPV
    a. Cost of Equity (using CAPM)
    Cost of Equity = Risk Free Rate + [beta x (market risk premium)]
    = 7.0% + (1.35 x 8.5%)
    = 18.475

    b. Cost of Preferred Stock = Dividend/Price of Stock
    $3.25/$25 = .13 or 13 %

    c. Cost of Debt = Face Value $1000; Current market value $915; Life 25 years; Coupon 10%; Tax Rate 34%
    Before Tax Cost of Debt = [$100 + ($1000 " 915)/25]/[(915 + 1000)/2]
    = 103.4/957.5 = 0.1080 or 10.8%
    After-Tax Cost of Debt = 10.8% (1?" 0.34) = 7.128 %

    d. Weights Average Cost of Capital
    Weights
    Common Stock $400,000 = 400,000/1,000,000 = 0.40
    Preferred Stock $300,000 = 0.30
    Debt $300,000 = 0.30

    Apply the Weights to the costs
    Common Stock = .4 x 18.475% = 7.39%
    Preferred Stock = 0.3 x 13% = 3.9
    Debt = 0.3 x 7.128% = 2.14
    WACC 13.43

    e. NPV
    Initial Outflow $1,000,000
    Inflow ...

    Solution Summary

    This solution includes the answers for three Financial Management questions that tackle various subjects. Included in the solution is the calculation of a firm's Cost of Equity using the CAPM model; the computation of the Cost of Preferred Stock and the Cost of Debt all leading to the calculation of the Weighted Average Cost of Capital (WACC). The solution also shows how to create an amortization schedule for a mortgage using excel (on a monthly basis and on an annual basis).

    Finally, the solution teaches how to decide whether a long-term project is viable using the following techniques:
    a. Payback Period
    b. Net Present Value (NPV)
    c. Profitability Index (PI)
    d. Internal Rate of Return (IRR)

    $2.19

    ADVERTISEMENT