Preview

Financial Control and Planning

Good Essays
Open Document
Open Document
3811 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Financial Control and Planning
PART 2: GROUP COURSEWORK
SECTION 1

1. Calculate patient revenue (on an accrual basis) for the coming year.

As indicated in the question, Private insurance and Self-Pay pay full charge, so we need to make a price list for these two types of payers and calculate the special price for NHS.
- Oncology Program:
Revenue from Private insurance = 50000*120*30% = 1,800,000
Revenue from National Health Service funded = 40,000*120*50% = 2,400,000
Revenue from Self-Pay = 50000*120*10% = 600,000
Total revenue for Oncology Program =1,800,000+600,000 +2,400,000= 4,800,000 * Cardiac Program:
Revenue from Private insurance = 40000*80*20% = 640,000
Revenue from National Health Service funded = 30,000*80*60% = 1,440,000
Revenue from Self-Pay = 40000*80*10% = 320,000
Total revenue for Cardiac Program = 640,000+ 1,440,000+ 320,000 = 2,400,000 * Rhinoplasty Program:
Revenue of Private insurance = 25,000*40*10% = 100,000
Revenue of National Health Service funded = 10,000*40*20% = 80,000
Revenue of Self-Pay = 25,000*40*60% = 600,000
Total revenue forRhinoplasty Program = 100,000 + 80,000 +600,000 = 780,000 Program | List price per patient | Special price per patient NHS | Total number of patients | PrivateInsurance | National Health Service funded | Self – Pay | Total per program | Oncology | 50,000 | 40,000 | 120 | 1,800,000 | 2,400,000 | 600,000 | 4,800,000 | Cardiac | 40,000 | 30,000 | 80 | 640,000 | 1,440,000 | 320,000 | 2,400,000 | Rhinoplasty | 25,000 | 10,000 | 40 | 100,000 | 80,000 | 600,000 | 780,000 | | | 2,540,000 | 3,920,000 | 1,520,000 | 7,980,000 |

2. Calculate the endowment revenue (on an accrual basis) for the coming year

* Total interest income from £500,000 in UK Treasuries dated 2020 – 2025 at 6% per annum = £500,000* 6% = £30,000 * Total dividend income from £250,000 in BT preference shares which pay 8% per annum = £250,000 * 8% = £20,000 * Total bond income from £250,000 bond at 2%( 1,5% + 0.5%) in the

You May Also Find These Documents Helpful

  • Good Essays

    1. In two to three paragraphs, describe the Sarbanes-Oxley Act and why it is important to the accounting profession. (15 points)…

    • 980 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    It is the management of any organization which is responsible for planning strategies, developing operational plans and plan for future business, so management should know the performance of organization.…

    • 258 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The commission negotiated with members of the sales team is now at 2.5%, therefore the company will pay more for the commission and gross profit every quarter had changed too. Those things made the Net Profit before Tax reduce a bit. It’s going down from $938,500 to $923,500.…

    • 612 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Lifestyle Comparison

    • 1906 Words
    • 8 Pages

    This given pay scale can be divvied into three categories in order to better represent and calculate budgets and relevant taxes. To yield more reliable results, the following tax calculations will be made under the assumption that we are earning an average pay of $120,400 per annum.…

    • 1906 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Case Questions

    • 253 Words
    • 2 Pages

    ₤120,000 in both 2000 and 2001. How much cash would the manager receive from his bonus payouts in 2000 and 2001?…

    • 253 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Chebaiywa Clinic Case

    • 924 Words
    • 4 Pages

    * we did not take time of the different dental procedures into consideration. This is because I thought that the clinic would never get full, so there would never be a bottleneck situation where patients would have to wait that long that they would leave for the competitor.…

    • 924 Words
    • 4 Pages
    Good Essays
  • Good Essays

    In response to the scenario provided, you will clarify budget plans with your manager and negotiate changes to the budget. You will then identify and analyse a risk to the budget and prepare a contingency plan to prevent or minimise the risk.…

    • 1328 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Copyright (c) 2009, ConnectCode All Rights Reserved. ConnectCode accepts no responsibility for any adverse affect that may result from undertaking our training. Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners…

    • 1662 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    TMA 2

    • 1875 Words
    • 7 Pages

    1700x12=£20400 16827/12=£1402.25 1700/100=17x2=34+1700=£1734 1734x12=£20808 17104/12=£1425.33 1402.25x6=£8413.50 1425.33x6=£8551.98+£8413.50=£16965.48/12=£1413.79. Piper’s average net monthly income over one year would be £1413.79.…

    • 1875 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    burden of cancer does not fall only on the health services, but also on patients, their…

    • 19640 Words
    • 79 Pages
    Powerful Essays
  • Satisfactory Essays

    FOBE320 Case Study

    • 1147 Words
    • 5 Pages

    • For David, he has a IT business and he earns 85000 before tax and any other deductions, he also has a self managed superfund with 65000 in cash and he sacrifices a further 5000 above the 9%p.a. So his total assessable income should be 145000 and his tax expense should be 41597, by deducting the tax expense from the assessable income, his take home pay should be 103403.…

    • 1147 Words
    • 5 Pages
    Satisfactory Essays
  • Powerful Essays

    Caldwell Cable Company is responsible for providing and maintaining cable services to Lexington County in South Carolina. To reduce expenses and remove the burden of providing insurance and company vehicles, Caldwell Cable hires outside contractors to perform installations and initial connection of cable service. Every three years the cable contract expires and anyone can submit a closed-bid in an attempt to get the contract.…

    • 1804 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    You submitted this quiz on Tue 5 Mar 2013 12:11 AM MSK. You got a score of 19.00 out of 25.00. You can attempt again, if you'd like.…

    • 3353 Words
    • 14 Pages
    Satisfactory Essays
  • Good Essays

    Financial Management

    • 643 Words
    • 3 Pages

    Q5. Putting yourself in the position of an existing shareholder(investor) of your company, using both the annual corporate report and the information about your company’s share price in the Financial Times, provide a recommendation (with reasons) whether you rate your company’s shares as Buy, Hold or Sell.…

    • 643 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Financial Planning

    • 5649 Words
    • 23 Pages

    The most important rule of tax planning is that it is no different from financial planning. The Section 80C offers a wide range of options, each suited to a different need. Choose an option that fits into your overall financial plan, not because it offers good returns or your brother-in-law is selling it.…

    • 5649 Words
    • 23 Pages
    Better Essays