Sunday, October 14, 2012

Questions Set 97: Solution

Instant Download

A stock you bought six years ago at $42 a share had the following year-end prices and dividends.
Year              Price                Dividend
1                  $48.27             $0.00
2                    53.84               0.57
3                    57.75               0.62
4                    54.21               0.68
5                    62.09               0.77
  6                    71.83               0.84
Using Blume’s formula, estimate the future annual returns over the next two years.
B. John & Jane, both 37 years old, are celebrating their 10th wedding anniversary today and they want to strengthen their retirement savings plans. Their desired retirement age is 67 with full Social Security benefits.
John’s current year salary is $110,000 and is expected to grow 5% a year until his retirement (i.e., growing annuity). He has made contributions to a (tax-exempt) Roth 401-(k) plan and its current balance is $85,000. John plans to contribute 7% of his annual salary by the end of each year. He will also receive additional 3% contributions from his employer, so he can save 10% of his salary by the end of each year for the next 30 years (i.e., age 66). He expects that his account will earn 8% return each year.
Jane is a home-maker, but she has saved money on her Roth IRA account. Her account balance is $40,000 now and she plans to contribute $5,000 at the end of each year for the next 30 years. She expects her account to earn a 6% a year.
Upon their retirement at age 67, he plans to purchase an immediate 3%-decreasing term 30-year annuity that makes annual payments at the beginning of each year (i. e, annuity due) for 30 years beginning age 67 and annual payments decrease by 3% each year from the previous year’s payment. Assume 7% interest rate for this annuity.
How much would they receive from the annuity contract on their age 67 and age 68 (i.e., first and second payments from the annuity)?

Monday, February 13, 2012

Question Set 92 - Solution

Instant Download


Compute the annual approximate interest cost of not taking a discount using the following scenarios:

a. 1/10 net 20

b. 1/10 net 30

c. 1/10 net 40

d. 1/10 net 50

e. 1/10 net 60



Compute the annual approximate interest cost of not taking a discount using the following scenarios:

a. 1/15 net 30

b. 2/15 net 30

c. 3/15 net 30

d. 4/15 net 30



Given the information below, compute the days in accounts receivable, aging schedule, and accounts receivable as a percentage of net patient revenues for Quarter 1 and Quarter 2, 20X1. Compare the two quarters to determine if the organization's collection procedure is improving. (Note: For simplicity, assume that each month is 30 days. Dollar figures are expressed in thousands.)




Givens (in '000)



Quarter 1, 20X1

1

Time



Sep

Aug

Jul

Quarter

2

Days outstanding



1-30

31-60

61-90

1-90

3

Net accounts receivable



$6,000

$2,000

$12,000

$20,000

4

Net patient revenue





$6,000

$20,000

$38,000

$12,000





Givens (in '000)



Quarter 2, 20X1

5

Time



Dec

Nov

Oct

Quarter

6

Days outstanding



1-30

31-60

61-90

1-90

7

Net accounts receivable



$12,000

$2,000

$6,000

$20,000

8

Net patient revenue



$20,000

$6,000

$12,000

$38,000

















Quarter 1, 20X1

1. Aging Schedule. One answer for each month (Order answers July, August, September).

2. Days in accounts receivable. One answer for quarter.

3. Accounts receivable as a percentage of net patient revenues ( Order answers July, August, September). One answer for each month.

Quarter 2, 20X1

1. Aging Schedule. One answer for each month (Order answers October, November, December)

2. Days in accounts receivable. One answer for quarter

3. Accounts receivable as a percentage of net patient revenues. One answer for each month (Order answers October, November, December)

4. Compare the two quarters to determine if the organization's collection procedure is improving.



Lawrence Hospital wishes to establish a line of credit with a bank. The first bank's terms call for a $600,000 maximum loan with an interest rate of 5% and a $2,000 fee. The second bank for the same line of credit charges an interest rate of 6% but no fee. The compensating balance requirement is 5% of the total line of credit for either bank.


a. What is the effective interest rate for Lawrence Hospital from the first bank if 50% of the total amount were used during the year?

b. What is the effective interest rate for Lawrence Hospital from the first bank if 25% of the total amount were used during the year?

c. What is the effective interest rate for Lawrence Hospital from the second bank if 50% of the total amount were used during the year?

d. What is the effective interest rate for Lawrence Hospital from the second bank if 25% of the total amount were used during the year?

e. Which bank would be the better choice for Lawrence Hospital if they were to borrow a lot of money? Enter FIRST or SECOND as your answer



Stacie Zeeman Clinic provided the financial information below. Prepare a cash budget for the quarter ending March 20X1.

Exhibit 5-16 Stacie Zeeman Clinic

Revenues:













Estimated Patient

Patient Revenues, 20X0



Patient Revenues, 20X0



Revenues, 20X1

July

$35,00,000



October

$34,20,000



January

$36,00,000

August

$33,50,000



November

$32,10,000



February

$33,50,000

September

$35,30,000



December

$38,00,000



March

$32,20,000





















Receipt of Payment







Other Revenues, 20X1



for Patient Services / Revenues







January

$88,000



Current month of service

45%







February

$1,10,000



1st month of prior service

25%







March

$1,15,000



2nd month of prior service

10%













3-6 months of prior service

5%







Expenses a:





Estimated Supplies



Other Estimated Expenses, 20X1a

Supplies Purchases, 20X0



Purchases, 20X1





Nursing

Admin.

Other

October

$8,00,000



January

$10,00,000



January

$17,00,000

$70,000

$2,45,000

November

$10,00,000



February

$12,00,000



February

$17,50,000

$70,000

$3,35,000

December

$16,00,000



March

$14,00,000



March

$17,00,000

$70,000

$2,75,000







April

$10,00,000



April

$14,50,000

$70,000

$2,05,000





















Timing of Cash Payment for















Supplies Purchases



Ending Cash Balances







0%

Month purchased



December, 20X0

$8,00,000







60%

+1 Month





b



50%







35%

+2 Months

















5%

+3 Months





































a All estimated expenses are cash outflows for the given month.











b The ending balance for each month as a percentage of the estimated cash outflows for the next month.







How would the cash budget for Stacie Zeeman Clinic change if new credit and collection policies were implemented such that collections resulted as follows:

30%: current month of patient revenues20% each: past 1-2 months of patient revenues10% each: past 3-4 months of patient revenues5% each: past 5-6 months of patient revenuesHere are the givens for Stacie Zeeman Clinic:

Exhibit 5-16 Stacie Zeeman Clinic



Revenues:













Estimated Patient

Patient Revenues, 20X0



Patient Revenues, 20X0



Revenues, 20X1

July

$35,00,000



October

$34,20,000



January

$36,00,000

August

$33,50,000



November

$32,10,000



February

$33,50,000

September

$35,30,000



December

$38,00,000



March

$32,20,000





















Receipt of Payment







Other Revenues, 20X1



for Patient Services / Revenues







January

$88,000



Current month of service

45%







February

$1,10,000



1st month of prior service

25%







March

$1,15,000



2nd month of prior service

10%













3-6 months of prior service

5%







Expenses a:





Estimated Supplies



Other Estimated Expenses, 20X1a

Supplies Purchases, 20X0



Purchases, 20X1





Nursing

Admin.

Other

October

$8,00,000



January

$10,00,000



January

$17,00,000

$70,000

$2,45,000

November

$10,00,000



February

$12,00,000



February

$17,50,000

$70,000

$3,35,000

December

$16,00,000



March

$14,00,000



March

$17,00,000

$70,000

$2,75,000







April

$10,00,000



April

$14,50,000

$70,000

$2,05,000





















Timing of Cash Payment for















Supplies Purchases



Ending Cash Balances







0%

Month purchased



December, 20X0

$8,00,000







60%

+1 Month





b



50%







35%

+2 Months

















5%

+3 Months





































a All estimated expenses are cash outflows for the given month.











b The ending balance for each month as a percentage of the estimated cash outflows for the next month.







Stacie Zeeman Clinic is going to take better advantage of credit terms offered by suppliers. The Clinic has negotiated a 3% discount for all supplies purchased beginning in 20X1, if paid in full during the month of service with the following credit terms for supplies listed below. How does this change the cash budget created followingthe implementation of new credit and collection policies?

55%: month purchased 30%: first prior month 10%: second prior month 5%: third prior month Here are the givens for Stacie Zeeman Clinic:

Revenues:













Estimated Patient

Patient Revenues, 20X0



Patient Revenues, 20X0



Revenues, 20X1

July

$35,00,000



October

$34,20,000



January

$36,00,000

August

$33,50,000



November

$32,10,000



February

$33,50,000

September

$35,30,000



December

$38,00,000



March

$32,20,000





















Receipt of Payment







Other Revenues, 20X1



for Patient Services / Revenues







January

$88,000



Current month of service

45%







February

$1,10,000



1st month of prior service

25%







March

$1,15,000



2nd month of prior service

10%













3-6 months of prior service

5%







Expenses a:





Estimated Supplies



Other Estimated Expenses, 20X1a

Supplies Purchases, 20X0



Purchases, 20X1





Nursing

Admin.

Other

October

$8,00,000



January

$10,00,000



January

$17,00,000

$70,000

$2,45,000

November

$10,00,000



February

$12,00,000



February

$17,50,000

$70,000

$3,35,000

December

$16,00,000



March

$14,00,000



March

$17,00,000

$70,000

$2,75,000







April

$10,00,000



April

$14,50,000

$70,000

$2,05,000





















Timing of Cash Payment for















Supplies Purchases



Ending Cash Balances







0%

Month purchased



December, 20X0

$8,00,000







60%

+1 Month





b



50%







35%

+2 Months

















5%

+3 Months





































a All estimated expenses are cash outflows for the given month.











b The ending balance for each month as a percentage of the estimated cash outflows for the next month.







Interboro Hospital generated net patient revenues of $125 million for 20X1, and its cash collections were $110 million. The revenue cycle management costs to collect these revenues were $4 million.


1. Compute Interboro's cost to collect for the year and provide an assessment of how it compares with the hospital industry benchmark of 3%. Compute Interboro's cost to collect for the year if 35% of the cash collections during the year required human intervention and its EDI costs were $400,0

2. Provide an assessment of how it compares with the hospital industry benchmark of 4%.

Sunday, August 21, 2011

The BirdieGolf-Hybrid Golf Merger Case - Solution

Solution
Birdie Golf, Inc. has been in merger talks with Hybrid Golf Company for thepast six months. After several rounds of negotiations, the offer underdiscussion is a cash offer of $440 million for Hybrid Golf. Both companies haveniche markets in the golf club industry, and the companies believe a mergerwill result in significant savings in general and administrative expenses.
Bryce Bichon, the financial officer for Birdie, has been instrumental in the mergernegotiations. Bryce has prepared the following pro forma financial statementsfor Hybrid Golf assuming the merging takes place. The financial statementsinclude all synergistic benefits from the merger:
2010
2011
2012
2013
2014
Sales
$640,000,000
$720,000,000
$800,000,000
$900,000,000
$1,000,000,000
Production Cost
$449,000,000
$504,000,000
$560,000,000
$632,000,000
$705,000,000
Depreciation
$60,000,000
$64,000,000
$66,000,000
$66,000,000
$67,000,000
Other Expenses
$64,000,000
$72,000,000
$80,000,000
$90,000,000
$97,000,000
EBIT
$67,000,000
$80,000,000
$94,000,000
$112,000,000
$131,000,000
Interest
$15,200,000
$17,600,000
$19,200,000
$20,000,000
$21,600,000
Taxable Income
$51,800,000
$62,400,000
$74,800,000
$92,000,000
$109,400,000
Taxes (40%)
$20,720,000
$24,960,000
$29,920,000
$36,800,000
$43,760,000
Net Income
$31,080,000
$37,440,000
$44,880,000
$55,200,000
$65,640,000
Bryce is also aware that the Hybrid Golf Division will require investments eachyear for continuing operations, along with sources of financing. The followingtable outlines the required investments and sources of financing.
2010 2011 2012 2013 2014
Investments:
Investments20102011201220132014
Net Working Capital$1,60,00,000$2,00,00,000$2,00,00,000$2,40,00,000$2,40,00,000
Fixed Assets$1,20,00,000$2,00,00,000$1,40,00,000$9,60,00,000$56,00,000
Total$2,80,00,000$4,00,00,000$3,40,00,000$12,00,00,000$2,96,00,000
Sources of financing:
New Debt$2,80,00,000$1,28,00,000$1,28,00,000$1,20,00,000$96,00,000
Profit Retention$0$2,72,00,000$2,16,00,000$2,16,00,000$2,00,00,000
Total$2,80,00,000$4,00,00,000$3,44,00,000$3,36,00,000$2,96,00,000
The management of Birdie Golf feels that the capital structure at Hybrid Golfis not optimal. If the merger take place, Hybrid Golf will immediately increaseits leverage with a 88 million debt issue, which would be followed by a 120 milliondividend payment to Birdie Golf. This will increase Hybrid's debt to equityration from .50 to 1.00. Birdie Golf will also be able to use a 20 million taxloss carry forward in 2011 and 2012 from Hybrid Golf's previous operations. Thetotal value of Hybrid Golf is expected to be 720 million in five years, and thecompany will have 240 million in debt at that time.
Stock in Birdie Golf currently sells for 94 a share, and the company has 14.4million shares of stock outstanding. Hybrid Golf has 6.4millionshares of stock outstanding. Both companies can borrow at an 8% interest rate.The risk-free rate is 6%, and the expected return on the market is 13%. Brycebelieves the current cost of capital for Birdie Golf is 11%. The beta for HybridGolf stock at its current capital structure is 1.30.
Bryce has asked you to analyze the financial aspects of the potential merger.Specifically, he has asked you to answer the following questions:
1. Suppose Hybrid shareholders will agree to a merger price of 68.75 per share.Should birdie proceed with the merger?

2. What is the highest price per share that Birdie should be willing to pay forHybrid?

3. Suppose Birdie is unwilling to pay cash for the merger but will consider astock exchange. What exchange ratio would make the merger terms equivalent tothe original merger price of 68.75 per share?
4. What is the highest exchange ratio Birdie would be willing to pay and stillundertake the merger?

Tuesday, August 2, 2011

Question Set 86-Solution

Solution
Using Yahoo! Finance find the value of beta for your reference company. Write a two page paper discussing the following items:
    • What is the estimated beta coefficient of your company? What does this beta mean in terms of your choice to include this company in your overall portfolio?
    • Given the beta of your company, the present yield to maturity on U.S. government bonds maturing in one year (currently about 4.5% annually) and an assessment that the market risk premium (that is - the difference between the expected rate of return on the 'market portfolio' and the risk-free rate of interest) is 6.5%, use the CAPM equation in order to find out what is the present 'cost of equity' of your company? Explain what is the meaning of the 'cost of equity'?
    • Choose two other companies, look up their "Beta" and report the names of these companies and their betas. Suppose you invest one third of your money in each of the stocks of these companies. What will the beta of the portfolio be? Given the data in (b), what will the Expected Rate of Return on this portfolio be? Do you feel that the three-stock portfolio is sufficiently diversified or does it still have risk that can be diversified away? Explain.

Tuesday, June 14, 2011

Questions Set 85: Solution

Matterhorn Company’s charter allows it to sell 250,000 shares of $2 par value common stock. To date, the firm has sold 100,000 shares for a total of $600,000. Matterhorn has reacquired 4,000 shares from shareholders at a price of $8 per share. Retained earnings equals $250,000. (10 points)
    • What total amount of contributed capital should Matterhorn report?
    • What amount should be reported for the Common Stock account?
    • What was the average selling price of each share of common stock?
    • How many shares of stock are outstanding?
    • What amount should be reported for stockholders’ equity?

Questions Set 84: Solution

How would you explain that, although the efficient market hypothesis applies to the stock market, you can’t successfully invest by randomly selecting stocks?
  1. The hypothesis fails to fully explain the real market environment.
  2. The hypothesis fails to consider these monopolies, which dominate certain segments of the market.
  3. Random selection of stocks would ignore an individual investor’s goals.
  4. New theories are needed to explain stock price behavior in the new economy
At what rate does $1,000 grow to $1,953 after three years? Use the formula for the future value of a lump sum, and assume annual compounding.
  1. 25 percent
  2. 75 percent
  3. 31.8 percent
  4. 95.3 percent
Given a choice between calculating returns using the holding period return (HPR) or the formula for the future value, you should select the future value formula because the
  1. HPR fails to consider the discounted value of the purchase price.
  2. future value formula incorporates the timing of cash flows.
  3. HPR overstates the internal rate of return in direct proportion to the discount rate.
  4. future value formula incorporates cash payments that are omitted in the HPR.
Which of the following statements most accurately explains the utility of the dividend growth model?
  1. Dividend growth increases the total return earned on equity investments.
  2. Projected dividend growth can be incorporated into calculation of the discounted value of cash flows.
  3. Stocks with rising dividends generally outperform stocks that don’t pay dividends or that pay relatively static dividends.
  4. Rising dividends, plotted as a function of time, appear as an exponential function with a positive slope.
ABC Corporation recently announced its plans to pay a 5 percent stock dividend in addition to its scheduled $0.32 quarterly dividend, which has been paid on its common stock in all of the previous 13 quarters. The ex-dividend date will be one month after the announcement. ABC Corporation hadn’t paid a stock dividend in the past nine years. You own 100 shares of ABC Corporation common stock valued at $68 per share. Which of the following explanations accurately projects the effect of these transactions?
  1. Dilution will effect a 5 percent decline in price per share. That will be offset by the 2 percent (annualized) dividend for a net decline of 3 percent in the stock price.
  2. The 5 percent stock dividend is equivalent to 1-for-20 stock split. Stock prices generally rise after stocks split, so the 5 percent dilution effect will be reduced to either a price rise or a decline that’s smaller than 5 percent.
  3. The stock price will drop about 5 percent if all other factors remain constant.
  4. The discounted value of the stock split and will render a price decline smaller than 5 percent.
In the absence of compelling empirical data to support technical analysis, which of these arguments supports its use?
  1. The Dow Theory has a long history of successful use and has earned respect in non-academic circles.
  2. Traders of odd lots tend to be smaller, less sophisticated investors who reliably make the wrong investment decisions.
  3. Emotions lead to irrational investment decisions that can be overcome by applying a strict set of technical methods.
  4. Several technical methods capitalize on empirical data supporting the contention that security prices move in the same direction.
Which of the following statements is correct?
  1. Security selection can be a complex process that’s aided by Internet financial information services.
  2. Security selection is most efficiently practiced by applying both technical and fundamental analysis.
  3. Security selection requires only the use of accounting ratios.
  4. Security selection simplifies investment decisions.
Which of the following reasons best explains why you would include inflation in a fundamental analysis of stock values?
  1. Inflation exerts broad influence on factors that underlie the economy.
  2. Inflation generally increases stock prices at a faster rate than other prices.
  3. Inflation generally increases stock prices prices because cash inflows increase.
  4. High inflation corresponds with high interest rates and low bond values.
In fundamental analysis, the value added by industry analysis is particularly apparent
  • When inflation rates are high and have a broad negative impact on business in general.
  • In industries where business levels significantly change in certain seasons or in relation to the business cycle.
  • During recessions when business levels are suppressed across most industries.
  • During the rapid growth stage of an economy.

Questions Set 83: Solution

  • You received $30,000 from your grandparents. You want to investment it to fund your mortgage down-payment in four years. You want to buy a house that is at least $200,000 but no more than $300,000. Normally, banks require home buyers to make 20% (of the house price) down-payment. What is the minimum and maximum interest rates that you need to earn on your investment?
  • You want to buy a Volvo in 4 years, after you graduate from college. The car is currently selling for $35,000, and the price will increase at a rate of 5% per year. Your friend, Bob, introduces to you a one-time chance to earn 14% per year over the next 4 years. And you want to grab this chance to plan for your purchase. How much do you need to invest today so that you are able to buy your dream car after graduation?
  • If inflation rate runs at 3% annually, how long does it take for prices to double?
  • Your current bank is paying a 6.25% annual simple interest rate with monthly compounding. You can move your money to Harris Bank that pays 6.25% annual compound interest rate, or to First Chicago Bank, which pays 6.8% compounded semiannually. To maximize your return, which bank should you choose?