Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Create a 3- to 5-year financial plan to implement the goals and objectives created in Part 2 of your strategic plan. The deliverables for the financial plan include a projected budget created in...

1 answer below »

Createa 3- to 5-year financial plan to implement the goals and objectives created in Part 2 of your strategic plan. The deliverables for the financial plan include a projected budget created in Microsoft®Excel®and a report in Microsoft®Word that clarifies and explains the financial plan.


Section One: Projected Budget

Create a projected budget.

  • The projected budget should be a Microsoft®Excel®spreadsheet that contains a 3- to 5-year financial projection that includes detailed expenditures, income, contingency, gain or loss, capital outlay, and ROI (if applicable).

Include budget strategies to increase volume and budget assumptions.


Section Two: Financial Plan Explanation

Write a 1,050- to 1,400-word narrative discussing the fiscal details of the plan and the assumptions that were used in developing the projected budget.

  • Include all the elements required in the projected budget.
  • Include capital expenditure planning and contingency plans for unexpected events.
  • Budget summary: When explaining your budget:
  • Describe the organization’s current business model.
  • Evaluate the impact of internal resources and financial capabilities on the business model implementation.
  • Determine how the organization’s internal resources and financial capabilities affect your financial plan.
  • Determine how they will affect implementation of the plan.
  • Explain the details of the budget assumptions and the strategies to increase volume.

Cite and referenceat least 4 peer-reviewed, scholarly, or similar resources to support your information.

Formatyour paper according to APA guidelines.

Submityour assignment as Microsoft®Excel®and Microsoft®Word attachments.


Submit your assignment. For additional help, check out the ULTRA: Access your assignments page.

Answered 3 days After Nov 23, 2021

Solution

Himanshu answered on Nov 26 2021
128 Votes
Income Statement
        2019    2020        2019    2020        % Change    2021    2022    2023    2024    2025
    Revenues:
    Products    185236    190,688        72.14%    70.97%        -1.63%    209756.80    218147.072    226872.95488    233679.1435264    238352.726396928
    Premiums    63122    69,364        24.58%    25.81%        5.01%    76300.40    79352.416    82526.51264    85002.3080192    86702.354179584
    Services    7407    7,856        2.88%    2.92%        1.35%    8641.60    8758.26    8876.50    8996.33    9117.78
    Net investment income    1011    798        0.39%    0.30%        -24.57%    877.80    895.36    913.26    931.53    950.16
    Total revenues    256,776    268,706        100.00%    100.00%        0.00%    295576.60    307153.11    319189.23    328609.31    335123.02
    Operating costs
    Cost of products sold    158719    163,981        61.81%    61.03%        -1.27%    172180.05    175623.65    179136.12    182718.85    186373.22
    Benefit costs    52529    55679        20.46%    20.72%        1.29%    58462.95    59632.21    60824.85    62041.35    63282.18
    Goodwill impairments
    Operating expenses    33541    35135        13.06%    13.08%        0.10%    36891.75    38367.42    39902.1168    41099.180304    41921.16391008
    Total operating costs    244,789    254,795        95.33%    94.82%        -0.53%    267534.75    273623.28    279863.09    285859.38    291576.56
    Operating income    11,987    13,911        4.67%    5.18%        10.90%    28041.85    33529.83    39326.13    42749.93    43546.46
    Interest expense    3035    2907        1.18%    1.08%        -8.47%    5608.37    5776.6211    5949.919733    6128.41732499    6312.2698447397
    Loss on early extinguishment of debt    79    1440        0.03%    0.54%        1641.9%    800.00    800.00    800.00    800.00    800.00
    Other income    -124    -206        -0.05%    -0.08%        58.75%    -165.00    -165.00    -165.00    -165.00    -165.00
    Income before income tax provision    8,997    9,770        3.50%    3.64%        3.77%    21468.48    26788.20    32411.22    35656.52    36269.19
    Income tax provision    2366    2569        0.92%    0.96%        3.76%    5367.12    6697.05    8102.80    8914.13    9067.30
    Income (loss) from continuing operations    6,631    7,201                        16101.36    20091.15    24308.41    26742.39    27201.89
    Loss from discontinued operations, net of tax        -9
    Net income (loss    6,631    7,192        2.58%    2.68%        3.64%    16101.36    20091.15    24308.41    26742.39    27201.89
    % change (net Income)                                    25%    21%    10%    2%
    Net (income) loss attributable to noncontrolling interests    3    -13        0.00%    -0.00%        -514.09%    -10.00    -10.00    -10.00    -10.00    -10.00
    Net income (loss) attributable to CVS Health    6,634    7,179        2.58%    2.67%        3.41%    16091.36    20081.15    24298.41    26732.39    27191.89
    Basic earnings (loss) per share
    Income (loss) from continuing operations attributable to CVS Health    $ 5.10    $ 5.49                    7.65%    $ 11.67    $ 14.00    $ 16.29    $ 17.23    $ 16.85
    Loss from discontinued operations attributable to CVS Health
    Net income (loss) attributable to CVS Health    $ 5.10    $ 5.48                    7.45%    $ 11.67    $ 14.00    $ 16.29    $ 17.23    $ 16.85
    Weighted average basic shares outstanding    1301    1309                    0.61%    1374.45    1429.428    1486.60512    1531.2032736    1561.827339072
    Diluted earnings (loss) per share
    Income (loss) from continuing operations attributable to CVS Health    $ 5.08    $ 5.47                    7.68%    $ 11.67    $ 14.00    $ 16.29    $ 17.23    $ 16.85
    Loss from discontinued operations attributable to CVS Health        -0.01                        -0.01    -0.01    -0.01    -0.01    -0.01
    Net income (loss) attributable to CVS Health    $ 5.08    $ 5.46                    7.48%    $ 11.66    $ 13.99    $ 16.28    $ 17.22    $ 16.84
    Weighted average diluted...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here