Explore BrainMass
Share

Explore BrainMass

    NPV, FV, Cost Analysis, Cash Flow, Portfolios, WACC

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

    See the attached file.

    11. How much cash flow did ABC company generate in 2013?

    ABC 2013 Income Statement ($ in MM)
    Revenue 100
    Cost of Goods Sold -60
    Gross Profit 40
    SG&A expense -15
    Depreciation expense -5
    Pre-Tax Profit 20
    Taxes -8
    Net Income 12

    ABC 2013 Cash Flow Statement Information
    ABC Company purchased an MRI machine for $2mm (assume ABC paid the full purchase price in cash at the time of purchase)
    ABC Company raised (borrowed) $3mm
    ABC Company sold some unused land it owned for $4mm
    Assume there were no other sources or uses of cash during the year.

    12. Which of the following companies do you think is healthier? Comment on 4 key line items that may indicate strengths or weaknesses for each company.

    Cash Flow Statement ($s in millions) Alpha Gamma
    Operating Activities
    Net Income -40 15
    Depreciation 325 5
    Changes in Current Assets -50 -20
    Net Cash Provided by (used in) operating activities 235 0

    Investing Activities
    Capital Expenditures -200 -10
    Proceeds from sale of assets 0 200
    Net Cash Provided by (used in) investing activities -200 190

    Financing Activities
    Decrease in Short Term Borrowings -10 -10
    Proceeds from issuance of LT Debt 0 0
    Proceeds from sale of Common Stock 0 50
    Dividends paid -30 0
    Net Cash Provided by (used in) financing activities -40 40

    Increase/(Decrease) in cash -5 230
    Cash at beginning of the year 100 100
    Cash at the end of the year 95 330

    13. PMB Clinic is a 3-physician Primary Care clinic in Los Angeles. (See financial information below) They have only one source of income: reimbursement from physician visits.

    13.1. Classify each expense item as fixed or variable. Briefly describe your rationale for each classification. (2 points)
    13.2. What are the variable costs per visit?
    13.3. What is the breakeven equation?
    13.4. What is the contribution margin on each physician visit?
    13.5. How many visits per year must the clinic perform to breakeven?

    Physician Visits 12,000
    Reimbursement per visit $80
    Total Revenue $960,000

    Medical Supplies $19,200
    Vaccinations/Medications $28,800
    Occupancy costs (Rent+maintenance) $50,000
    Staff Salaries and benefits (7 staff @ 50k each) $350,000
    Physician Salaries (3 MDs @ 150k each) $450,000
    Temporary Staff (to help when the office gets busy) $25,000
    Malpractice and Liability Insurance $45,000
    Total Expenses $968,000

    Pre-Tax Profit ($8,000)

    14. Dr Maya founded a radiology benefit management company that controls diagnostic imaging costs by influencing physicians to follow evidenced based prescribing guidelines. Dr Maya invested $2mm on 1/1/13 to start the company. By 1/1/14 the company was generating profits of $2mm per year, and Dr Maya was investing all the profits back into the business. During 2014, Dr Maya decides she should raise $10mm to expand her business. She explores debt and equity financing, and as part of that exploration process she compiles the following 4-yr projections:
    • Upside scenario: Sell for $90mm.
    • Base Case scenario: Sell for $60mm.
    • Downside Scenario: Sell for $5mm.

    Assume an outside investment is made on 1/1/15, and the eventual sale of the company occurs on 1/1/19 (4 yrs after the outside investment). Dr Maya receives the following term sheet proposals:
    • Proposal #1: Equity investment from HLR Capital. $10mm investment for 25% ownership.
    • Proposal #2: Term loan from a local bank. $10mm investment, 8% interest rate, 4 year term. (Assume the debt is a zero-coupon loan that pays back all interest and principal at maturity. Assume interest is compounded annually.)

    14.1. What is the future value (at maturity) of the debt in Proposal #2?

    14.2. Calculate the cost of financing for each of the proposals, in each of the 3 scenarios (6 points)

    Cost of financing: Debt Equity
    Upside scenario
    Base Case scenario
    Downside scenario

    14.3. Calculate the payout to Dr. Maya for each proposal in each of the 3 scenarios (3 points)
    Payout for Dr Maya Debt Equity
    Upside scenario
    Base Case scenario
    Downside scenario

    14.4. For each scenario, calculate Dr. Maya's IRR on her initial $2mm investment (3 points)
    IRR for Dr Maya Debt Equity
    Upside scenario
    Base Case scenario
    Downside scenario

    14.5. If you were Dr Maya, which proposal would you choose and why? (4 points)

    15. Acme Delivery Systems (ADS) is an integrated healthcare delivery system. Currently ADS contracts with the community to provide MRI scans and they are looking at bringing the service in-house. They expect to provide 2000 scans next year with an annual volume increase of 10% per annum. Currently they have a contract with an outside provider which will cost $700 per scan next year (Year 1) and the price will increase at 5% per annum (MRIs in year 2 under contract cost 5% more than year 1 and so forth).
    Alternatively ADS can purchase an MRI at a total installed cost of $4,000,000. The MRI has a useful life of 10 years and is depreciated on a straight-line basis. You have been asked to do an analysis of whether ADS, a for profit company, should purchase the MRI or continue contracting out to the community. Doing research into the project you have used the following information:
    a) The balance sheet - see attachment
    b) The template for projected P&L of the MRI - see attachment
    c) ADS just paid a dividend of $2.00 per share and it is expected to exhibit a constant growth rate of 5% per annum.
    d) The Risk Free Rate is 6%
    e) The Market Risk Premium is 6%
    f) ADS beta is 1.6
    g) The MRI's Beta in relation to ADS overall portfolio of projects is .8 as it is less risky than the average risk of the portfolio of projects
    h) ADS current tax rate is 30%
    i) ADS issued senior 20 Year debt 5 Years ago at a coupon rate of 7%
    j) The current market required rate for debt of similar risk and time to maturity is 5%

    15.1 What is the expected rate of return for equity holders?
    15.2 What is the current price of an ADS share of stock?
    15.3 What is the current price of ADS bonds?
    15.4 What is the Weighted Average Cost of Capital for ADS?
    15.5 Should ADS buy the MRI or contract for it in the community? (Note: Ignore quality/service considerations. Just compare the incremental costs of the two alternatives.)

    © BrainMass Inc. brainmass.com October 10, 2019, 7:17 am ad1c9bdddf
    https://brainmass.com/business/financial-ratios/npv-fv-cost-analysis-cash-flow-portfolios-wacc-575328

    Attachments

    Solution Preview

    See the attached files.

    11. How much cash flow did ABC company generate in 2013?

    ABC 2013 Income Statement ($ in MM)
    Revenue 100
    Cost of Goods Sold -60
    Gross Profit 40
    SG&A expense -15
    Depreciation expense -5
    Pre-Tax Profit 20
    Taxes -8
    Net Income 12

    ABC 2013 Cash Flow Statement Information
    ABC Company purchased an MRI machine for $2mm (assume ABC paid the full purchase price in cash at the time of purchase)
    ABC Company raised (borrowed) $3mm
    ABC Company sold some unused land it owned for $4mm
    Assume there were no other sources or uses of cash during the year.

    12. Which of the following companies do you think is healthier? Comment on 4 key line items that may indicate strengths or weaknesses for each company.

    Cash Flow Statement ($s in millions) Alpha Gamma
    Operating Activities
    Net Income -40 15
    Depreciation 325 5
    Changes in Current Assets -50 -20
    Net Cash Provided by (used in) operating activities 235 0

    Investing Activities
    Capital Expenditures -200 -10
    Proceeds from sale of assets 0 200
    Net Cash Provided by (used in) investing activities -200 190

    Financing Activities
    Decrease in Short Term Borrowings -10 -10
    Proceeds from issuance of LT Debt 0 0
    Proceeds from sale of Common Stock 0 50
    Dividends paid -30 0
    Net Cash Provided by (used in) financing activities -40 40

    Increase/(Decrease) in cash -5 230
    Cash at beginning of the year 100 100
    Cash at the end of the year 95 330

    13. PMB Clinic is a 3-physician Primary Care clinic in Los Angeles. (See financial information below) They have ...

    Solution Summary

    Solution helps in computing NPV, FV, Cost Analysis, Cash Flow, Portfolios, WACC.

    $2.19