Explore BrainMass
Share

Explore BrainMass

    Income statement; financial performance; expected value

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

    Solution uses calculator, not excel

    -------------------------------------------------

    P2-3 Income statement preparation On December 31, 2006, Cathy Chen, a self-employed certified public accountant (CPA), completed her first full year in
    business. During the year, she billed $360,000 for her accounting services. She
    had two employees: a bookkeeper and a clerical assistant. In addition to her
    monthly salary of $8,000, Ms. Chen paid annual salaries of $48,000 and
    $36,000 to the bookkeeper and the clerical assistant, respectively. Employment
    taxes and benefit costs for Ms. Chen and her employees totaled $34,600 for the
    year. Expenses for office supplies, including postage, totaled $10,400 for the
    year. In addition, Ms. Chen spent $17,000 during the year on tax-deductible
    travel and entertainment associated with client visits and new business development.
    Lease payments for the office space rented (a tax-deductible expense)
    were $2,700 per month. Depreciation expense on the office furniture and
    fixtures was $15,600 for the year. During the year, Ms. Chen paid interest of
    $15,000 on the $120,000 borrowed to start the business. She paid an average
    tax rate of 30 percent during 2006.

    a. Prepare an income statement for Cathy Chen, CPA, for the year ended
    December 31, 2006.
    b. Evaluate her 2006 financial performance.

    P5-5 Risk and probability Micro-Pub, Inc., is considering the purchase of one of two microfilm cameras, R and S. Both should provide benefits over a 10-year period, and each requires an initial investment of $4,000. Management has constructed the table (at the top of the facing page) of estimates of rates of return and probabilities for pessimistic, most likely, and optimistic results.

    a. Determine the range for the rate of return for each of the two cameras.
    b. Determine the expected value of return for each camera.
    c. Purchase of which camera is riskier? Why?

    Camera R Camera R Camera S Camera S
    Amount Probability Amount Probability
    Initial Investment $4000 1.00 $4000 1.00
    Annual rate of return
    Pessimistic 20% .25 15% .20
    Most likely 25% .50 25% .55
    Optimistic 30% .25 35% .25

    P7-5 Stock quotation Assume that the following quote for the Advanced Business
    Machines stock (traded on the NYSE) was found in the Thursday, December 14,
    issue of the Wall Street Journal.

    +3.2 84.13 51.25 AdvBusMach ABM 1.32 1.6 23 12432 81.75 +1.63
    Given this information, answer the following questions:

    a. On what day did the trading activity occur?
    b. At what price did the stock sell at the end of the day on Wednesday,
    December 13?
    c. What percentage change has occurred in the stock's closing price since the
    beginning of the calendar year?
    d. What is the firm's price/earnings ratio? What does it indicate?
    e. What is the last price at which the stock traded on the day quoted?
    f. How large a dividend is expected in the current year?
    g. What are the highest and the lowest price at which the stock traded during
    the latest 52-week period?
    h. How many shares of stock were traded on the day quoted?
    i. How much, if any, of a change in stock price took place between the day
    quoted and the day before? At what price did the stock close on the day before?

    P10-3 Breakeven cash inflows and risk Pueblo Enterprises is considering investing
    in either of two mutually exclusive projects, X and Y. Project X requires an initial investment of $30,000; project Y requires $40,000. Each project's cash inflows are 5-year annuities: Project X's inflows are $10,000 per year; project Y's are $15,000. The firm has unlimited funds and, in the absence of risk differences, accepts the project with the highest NPV. The cost of capital is 15%.

    a. Find the NPV for each project. Are the projects acceptable?
    b. Find the breakeven cash inflow for each project.
    c. The firm has estimated the probabilities of achieving various ranges of cash
    inflows for the two projects, as shown in the following table. What is the
    probability that each project will achieve the breakeven cash inflow found
    in part b?
    Probability of achieving cash inflow in given range
    Range of cash inflow Project X Project Y
    $0 to $5000 0% 5%
    $5000 to $7500 10 10
    $7500 to $10000 60 15
    $10000 to $12500 25 25
    $12500 to $15000 5 20
    $15000 to $20000 0 15
    Above $20000 0 10

    d. Which project is more risky? Which project has the potentially higher NPV?
    Discuss the risk-return tradeoffs of the two projects.
    e. If the firm wished to minimize losses (that is, NPV_$0), which project
    would you recommend? Which would you recommend if the goal was
    achieving a higher NPV?

    P10-5 Sensitivity analysis James Secretarial Services is considering the purchase of
    one of two new personal computers, P and Q. Both are expected to provide benefits over a 10-year period, and each has a required investment of $3,000. The firm uses a 10% cost of capital. Management has constructed the following table of estimates of annual cash inflows for pessimistic, most likely, and optimistic results.

    Computer P Computer Q
    Initial investment (CFo) $3000 $3000
    Outcome Annual cash inflows (CF) Annual cash inflows (CF)
    Pessimistic $500 $400
    Most likely 750 750
    Optimistic 1000 1200

    a. Determine the range of annual cash inflows for each of the two computers.
    b. Construct a table similar to this for the NPVs associated with each outcome
    for both computers.
    c. Find the range of NPVs, and subjectively compare the risks associated with
    purchasing these computers.

    © BrainMass Inc. brainmass.com October 10, 2019, 1:42 am ad1c9bdddf
    https://brainmass.com/business/net-present-value/345430

    Attachments

    Solution Preview

    See the attached file. Thanks

    P2-3 Income statement preparation On December 31, 2006, Cathy Chen, a self-employed certified public accountant (CPA), completed her first full year in
    business. During the year, she billed $360,000 for her accounting services. She
    had two employees: a bookkeeper and a clerical assistant. In addition to her
    monthly salary of $8,000, Ms. Chen paid annual salaries of $48,000 and
    $36,000 to the bookkeeper and the clerical assistant, respectively. Employment
    taxes and benefit costs for Ms. Chen and her employees totaled $34,600 for the
    year. Expenses for office supplies, including postage, totaled $10,400 for the
    year. In addition, Ms. Chen spent $17,000 during the year on tax-deductible
    travel and entertainment associated with client visits and new business development.
    Lease payments for the office space rented (a tax-deductible expense)
    were $2,700 per month. Depreciation expense on the office furniture and
    fixtures was $15,600 for the year. During the year, Ms. Chen paid interest of
    $15,000 on the $120,000 borrowed to start the business. She paid an average
    tax rate of 30 percent during 2006.

    a. Prepare an income statement for Cathy Chen, CPA, for the year ended
    December 31, 2006.

    Cathy Chen, CPAIncome Statement for the Year Ended December 31, 2009
    Sales Revenue $360,000
    Less: Operating expenses
    Salary expenses (8000*12+48000+36000) 180,000
    Employment taxes and benefits 34,600
    Office Supplies 10,400
    Travel & entertainment 17,000
    Lease rental payment(2700*12) 32,400
    Depreciation expense 15,600
    Total operating expense $290,000
    Operating profits $ 70,000

    Less: Interest expense $ 15,000
    Profits before taxes $ 55,000

    Less: Taxes (55000*30%) $ 16,500
    Net profits after taxes $ 38,500
    b. In her first year of business, Cathy Chen covered all her operating expenses and
    earned a net profit of $38,500 on revenues of $360,000.

    b. Evaluate her 2006 financial performance.
    During the financial year 2006, Cathy Chen earned a net profit of $38,500 after accounting for all expenses and her own salary.
    Net profit margin = Net profit / Sales revenue = $38,500/$360000=10.69%
    Operating profit margin = Operating profit / Sales revenue = $70,000/$360,000=19.44%

    P5-5 Risk and probability Micro-Pub, Inc., is ...

    Solution Summary

    This post has two questions. It shows how to prepare an income statement and how to calculate financial performance. Second question shows how to calculate the expected value of return for given object , determine the range for the rate of return and discusses which purchase is riskier.

    $2.19