Calculate payback and the net present value

Assignment Help Financial Accounting
Reference no: EM13180422

Your hospital has been approached by a major HMO to perform all their DRG 209 cases (major joint procedures). They have offered a flat price of $10,000 per case. You have reviewed your charges for DRG 209 during the last year and found the following profile:

Average Charge      $15,000

Average LOS     5 Days

 Cost/Charge Variable Cost %

Routine Charge      $3,600       0.80     60

 

Operating Room  2,657       0.80     80

Anesthesiology  293       0.80     80

Lab        1,035       0.70     30

Radiology      345       0.75     50

Medical Supplies 4,524       0.50     90

Pharmacy   1,230       0.50     90

Other Ancillary     1,316       0.80     60

Total Ancillary     $11,400       0.75     50

1. In the above data set, assume that the hospital's cost to charge ratio is 0.80 for routine services and 0.75 for all other ancillary services. Using this information, what would the average cost of DRG 209 be?

2. Estimate the variable cost per DRG 209 using the departmental cost/charge ratios and variable cost percentages.

You have been asked to establish a pricing structure for radiology on a per-procedure basis. Present budgetary data is presented below:

Budgeted Procedures     10,000

Budgeted Cost      $300,000

Desired Profit       $100,000

It is estimated that Medicare patients comprise 40 percent of total radiology volume and will pay on average $38.00 per procedure. Approximately 10 percent of the patients are cost payers. The remaining charge payers are summarized below:

Payer    Volume % Discount %

Blue Cross     10       4

Unity PPO      25     10

Kaiser       10     10

Self Pay      5     40

  50%

3. What rate must be set to generate the required $100,000 in profit in the preceding example?

4. If the forecasted volume increased to 12,000 procedures and budgeted costs increased to $340,000, while all other variables remained constant, what price should be established?

5. Palmer Home Health Agency expects to contract with an integrated delivery system for an estimated 36,000 members. The IDS expects 12% of its members to use the home health service in any given month. The budgeted rate per visit is $30. At the end of the first year of the contract the CEO of the Palmer's reviewed the activity on the contract and determined the following: the actual number of members was 10% higher than budgeted and the actual monthly revenue was $118,800. What are the volume variance and rate variance experienced, and are these variances favorable or unfavorable?

A.  volume variance = $23,760 unfavorable; rate variance = $12,960-favorable

B.  volume variance = $10,800 favorable; rate variance = $21,600 unfavorable

C.  volume variance = $12,960 favorable; rate variance = $23,760 unfavorable

D.  volume variance = $21,600 unfavorable; rate variance = $10,800 favorable

E.   none of the above

6. Using the information in the table below, calculate the amount of the unfavorable rate variance.

 

Budgeted

Actual

Volume

200,000

190,000

Revenue per unit

$40

$37

Revenue

$8,000,000

$7,030,000

A.  $400,000

B.  $570,000

C.  $970,000

D.  $600,000

E.   can not calculate with given information

7.   Using the information in the table below, determine how much of the supplies variance is due to a change in volume.

 

Budgeted

Actual

Variance

 

 

 

 

Volume

  1,000

   1,100

    100

Supplies

     $10,000

$12,750

$2,750

Fixed labor

     $20,000

$22,250

$2,250

 

 

 

$5,000

A.  $  900

B.  $1,000

C.  $1,050

D.  $1,250

E.   $1,500

8.  If $1,000 is the present value of $1,250 to be received at the end of two years, what is the one-year discount factor (to the closest hundredth of a percentage point)?

A.  0.89

B.   1.25

C.   0.80

D.  None of the above

9.  What is the effective annual rate of a 12% interest rate per year, compounded monthly?

A.  11.27%

B.   12.00%

C.   12.36%

D.  12.54%

E.   12.68%

10. What is the present value of a $2000 per year annuity at a discount rate of 15% for 15 years?

A.  $8,137

B.   $11,695

C.   $17,028

D.  None of the above

11. Columbus Clinic expects to receive $10,000 five years from now. If the clinic's cost of capital is 12% per year, what is the value of the $10,000 three years from now (to the nearest dollar)?

A.  $14,049

B.   $7,972

C.   $5,917

D.  None of the above

12.  Two investment projects which are mutually exclusive both require a $10,000,000 investment. Projected cash flows are:

Year  Project A      Project B

1  $3,500,000   $6,500,000

   2     3,500,000     3,000,000

   3     3,500,000     3,000,000

   4     3,500,000     1,000,000

If your discount rate is 12 percent, calculate payback and the net present value.

13.  You are considering two ways of financing a new hospital acquisition. You could arrange with a private investor group to buy the present facility for $50 million and lease it to you for $5.75 million per year over the next 15 years. You could then buy the facility for fair market value, which is assumed to be $80 million at the end of the 15th year.

Alternately, you could arrange for an 80 percent tax exempt bond with an effective interest rate of 8 percent. The bonds would be level debt service over 20 years. The remaining 20 percent could be provided from a taxable issue with a 10-year maturity. The effective interest rate would be 14 percent and the bonds would be level debt service.

Which of the two financing plans is the least expensive (i.e., has the lowest net present value if your cost of capital is 12 percent)?  Ignore reimbursement and tax considerations

14. St. Luke's Convalescent Center has $200,000 in surplus funds that it wishes to invest in marketable securities. If transaction costs to buy and sell the securities are $2,200 and the securities will be held for three months, what required annual yield must be earned before the investment makes economic sense?

15. An important source of temporary cash is trade credit, which does not actually bring in cash, but instead slows its outflow. Vendors often provide discounts for early payment. What is the formula to determine the effective interest rate if the discount is not utilized?

16. Your hospital has billed charges of $5,000,000 in February. If your collection experience indicates that 30 percent is paid in the month billed, 40 percent in the second month, 15 percent in the third month, and 10 percent in the fourth month, determine the following values:

a) Collections of February revenue in February, March, April and May.

b) Net accounts receivable at the end of March for February billings.

17. You are reviewing your targets for short-term cash reserves next year. You wish to carry at least twenty five days cash on hand. If annual budgeted cash expenses are $62,000,000, what amount of short-term cash reserves should be targeted?

Reference no: EM13180422

Questions Cloud

Food safety related issue concerning modified organisms : Which of the following is a food safety related issue concerning genetically modified organisms?
Find two other pairs of polar coordinates : find two other pairs of polar coordinates of the given polar coordinate, one with r > 0 and one with r
Describes components of internal control : Define and discuss the Federal/Private audit gap and the COSO Framework describes components of internal control.  Please list and describe these components.
Half life period is directly proportion to concentration : For a zero order chemical reaction, the A. half life period is directly proportion to the initial concentration of the reac-tants. B. plot of products concentration with time is a straight line through the origin
Calculate payback and the net present value : What required annual yield must be earned before the investment makes economic sense and calculate payback and the net present value.
Discuss capital and labour productivity : Discuss capital and labour productivity in engineering context and pharmaceutical industries in  India.  Is textile industry in India performing better than its global competitors?
Find the most economical speed : cursion boat is proportional to the cube of its speed and is $40 per hour when the speed is 10 mph. Expenses are $270 per hour. Find the most economical speed at which to make a trip of any specified distance.
Find the probability that the mean of their test scores : A final exam in Sociology has a mean of 72 and a standard deviation of 9.2. if 35 students are randomly selected, find the probability that the mean of their test scores will be greater than 76.
Which of the participants would you judge to be capable : Which of the participants would you judge to be capable? Explain

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate dol and then next year net income in dollar

If company expects next year's total sales could increase 12%, they want to know ho this change affects their profit. Calculate DOL and then next year's net income in dollar.

  How many units were started into production during month

A process began the month with 3,000 units in the beginning work in process inventory and ended the month with 2,000 units in the ending work in process. If 12,000 units were completed and transferred out of the process during the month, how many ..

  How was the portion of the bonds assigned to debt

What characteristics must the convertible bonds display in order to justify the accounting treatment followed on initial recognition and how was the portion of the bonds assigned to debt on initial recognition valued

  Inadequate segregation of duties

Inadequate segregation of duties over certain information system access controls.

  Closing entries and statement of retained earnings

Preparation of closing entries and statement of retained earnings - Prepare a Statement of Retained Earnings for the year ended December 31, 2009 in proper format.

  What is the highest price at which pizza can be traded

What is the highest price at which pizza can be traded that would make both roommates better off? What is the lowest price? Explain.

  Find which of depreciation method applied

Is book value an estimation of an asset's fair market value? Describe.

  Purpose the journal entry to record depreciation for 2013

Prepare the suitable journal entry, if any, to record this accounting change. Purpose the journal entry to record depreciation for 2013.

  Check the requirements of aasb framework

Give a response to the shareholder on the basis of these requirements. Check the requirements of both AASB 138 and the AASB Framework in relation to accounting for brands;

  Journal entries for both the lessee and the lessor

Identify the type of lease involved for the lessee and the lessor, and give reasons for your classifications and prepare all the journal entries for both the lessee and the lessor for 2007 and 2008.

  Calculate net cash provided by operating activities

Salvador, Inc. reported net income of $2.5 million in 2008. Depreciation for the year was $260,000, accounts receivable decreased $350,000, and accounts payable decreased $280,000. Calculate net cash provided by operating activities using the indir..

  Compute equivalent units of production for both materials

Ending work in process contains 1000 units that are 100% complete as to materials and 60% complete as to conversion costs.compute equivalent units of production for both materials and conversion costs using the fifo method.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd