Explore BrainMass

Explore BrainMass

    Zapatera Enterprise:Compound int, present value, annuity

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

    4-1A. (Financial forecasting) Zapatera Enterprises is evaluating its financing requirements for
    the coming year. The firm has only been in business for one year, but its Chief Financial Officer
    predicts that the firm's operating expenses, current assets, net fixed assets, and current liabilities
    will remain at their current proportion of sales.

    Last year Zapatera had $12 million in sales with net income of $1.2 million. The firm anticipates
    that next year's sales will reach $15 million with net income rising to $2 million. Given its present high rate of growth, the firm retains all of its earnings to help defray the cost of new investments.

    The firm's balance sheet for the year just ended is as follows:
    Zapatera Enterprises, Inc.

    BALANCE SHEET
    12/31/03 % OF SALES
    Current assets $3,000,000 25%
    Net fixed assets 6,000,000 50%
    Total $9,000,000

    L I A B I L I T I E S A N D OWNERS' EQUITY

    Accounts payable $3,000,000 25%
    Long-term debt 2,000,000 NAa
    Total liabilities $5,000,000
    Common stock 1,000,000 NA*
    Paid-in capital 1,800,000 NA*
    Retained earnings 1,200,000
    Common equity 4,000,000
    Total $9,000,000
    ___________________________________________________________________________
    ᵃNot- applicable. This figure does not vary directly with sales and is assumed to remain constant for purposes of making next year's forecast of financing requirements.

    Estimate Zapatera's total financing requirements (i.e., total assets) for 2004 and its net funding requirements (discretionary financing needed).

    5-1A. (Compound interest) To what amount will the following investments accumulate?
    a. $5,000 invested for 10 years at 10 percent compounded annually
    b. $8,000 invested for 7 years at 8 percent compounded annually
    c. $775 invested for 12 years at 12 percent compounded annually
    d. $21,000 invested for 5 years at 5 percent compounded annually

    5-4A. (Present value) What is the present value of the following future amounts?
    a. $800 to be received 10 years from now discounted back to the present at 10 percent
    b. $300 to be received 5 years from now discounted back to the present at 5 percent
    c. $1,000 to be received 8 years from now discounted back to the present at 3 percent
    d. $1,000 to be received 8 years from now discounted back to the present at 20 percent

    5-5A. (Compound annuity) What is the accumulated sum of each of the following streams of
    payments?
    a. $500 a year for 10 years compounded annually at 5 percent
    b. $100 a year for 5 years compounded annually at 10 percent
    c. $35 a year for 7 years compounded annually at 7 percent
    d. $25 a year for 3 years compounded annually at 2 percent

    5-6A. (Present value of an annuity) What is the present value of the following annuities?
    a. $2,500 a year for 10 years discounted back to the present at 7 percent
    b. $70 a year for 3 years discounted back to the present at 3 percent
    c. $280 a year for 7 years discounted back to the present at 6 percent
    d. $500 a year for 10 years discounted back to the present at 10 percent

    © BrainMass Inc. brainmass.com June 4, 2020, 12:21 am ad1c9bdddf
    https://brainmass.com/business/annuity/zapatera-enterprise-compound-int-present-value-annuity-333485

    Solution Summary

    The solution computes Compound interest, present value, annuity etc in excel.

    $2.19

    ADVERTISEMENT