Fill in Order Details

  • Submit paper details for free using our simple order form

Make Payment Securely

  • Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

Writing Process

  • The best qualified expert writer is assigned to work on your order
  • Your paper is written to standard and delivered as per your instructions

Download your paper

  • Download the completed paper from your online account or your email
  • You can request a plagiarism and quality report along with your paper

financial modeling 1

CVS Company

PART I

Prompt: In Milestone One, you will select one of the three companies and one of the two scenarios to be the focus of your final project throughout the duration of this course. Take time to start thinking about the information pertaining to the company that you will need to research in order to execute your modeling framework. Refer to the Milestone One Rubric for specific elements to consider as you select your organization.

Note: You are encouraged to access the Fortune 500 website prior to accessing the individual corporation’s home page. A snapshot of the company that you select will be provided once you type in the name of the company. Information such as a SWOT analysis and a snapshot of the company’s current financials is also available. This will prove useful in your assessment of which company to use for your final project.

Next, review the two case study scenarios below and choose one hypothetical for the company you chose above. Scenarios:

1. Seeking global success is not a new concept to Fortune 500 companies, and it fuels the argument that all company activities should serve to maximize the wealth of its shareholders. Penetrating new markets is a path to potentially large-scale opportunities and increased return on investment (ROI). Evaluating the feasibility of securing a global presence or expanding locally (in other words, shoring up their domestic presence) is the key capital investment trade-off decision facing the organization. As the chief financial officer (CFO), determine the critical elements that will influence your decision using actual company data as guided by the factors outlined in the Final Project Guidelines and Rubric document.

2. Acquiring the competition is often an option for penetrating untapped markets, increasing market share, and realizing elevated stock performance. As the CFO, you have identified a clear opportunity to become the dominant leader in retail pharmaceutical sales through the acquisition of your principal competitor. The key capital investment trade-off decision facing the organization is whether your organization should acquire the competitor or expand by building new stores throughout the continental United States. What factors will influence your decision?

Finally, construct a 250- to 350-word synopsis that analyzes the scenario and addresses the following critical elements:

I. Analysis of Scenario

  1. Analyze the financial structure of the firm you have chosen in order to determine the appropriate inputs that should go into the model, paying close attention to those that are used in the calculations of the weighted average cost of capital (WACC). Describe why each variable you select is an important driver in this scenario.
  2. Present and analyze the current U.S. interest rate environment with a particular focus on the shape and levels of the treasury yield curve. Discuss what the current shape and levels can tell us about the current economic environment. Describe the connection between the interest rate environment and the risk-free rate.
  3. Analyze the future outlook for the overall economy and future market conditions to determine possible changes that could impact the company’s cost of equity and cost of debt. Discuss how the outlook you have identified will impact future calculations of the WACC for your company.
  4. Discuss the importance that variables such as future economic and market conditions play in utilizing financial models that effectively achieve strategic objectives.

PART II

Prompt: In this module, you will start building your model and begin the analysis. You should be looking at the procedures you would implement in your model. Articulate why the model is necessary and what its purpose is, and justify how your calculations will add value and benefit the organization overall. All of these factors are interconnected.

Specifically, the following critical elements must be addressed:

II. Appropriate Procedures

  • Describe why the modeling framework is needed in the decision-making process, and define its purpose in terms of providing optimal results. Be sure to defend your rationale.
  • Based on the purpose you defined and the necessary variables you identified, describe the process for applying the framework to the decision- making process and translating the results into action.
  • Describe how and why the calculations will provide value and benefit to the company. Be sure to explain the concepts behind the output.
  • 350-500 word submission

WHAT OUR CURRENT CUSTOMERS SAY

  • Google
  • Sitejabber
  • Trustpilot
Zahraa S
Zahraa S
Absolutely spot on. I have had the best experience with Elite Academic Research and all my work have scored highly. Thank you for your professionalism and using expert writers with vast and outstanding knowledge in their fields. I highly recommend any day and time.
Stuart L
Stuart L
Thanks for keeping me sane for getting everything out of the way, I’ve been stuck working more than full time and balancing the rest but I’m glad you’ve been ensuring my school work is taken care of. I'll recommend Elite Academic Research to anyone who seeks quality academic help, thank you so much!
Mindi D
Mindi D
Brilliant writers and awesome support team. You can tell by the depth of research and the quality of work delivered that the writers care deeply about delivering that perfect grade.
Samuel Y
Samuel Y
I really appreciate the work all your amazing writers do to ensure that my papers are always delivered on time and always of the highest quality. I was at a crossroads last semester and I almost dropped out of school because of the many issues that were bombarding but I am glad a friend referred me to you guys. You came up big for me and continue to do so. I just wish I knew about your services earlier.
Cindy L
Cindy L
You can't fault the paper quality and speed of delivery. I have been using these guys for the past 3 years and I not even once have they ever failed me. They deliver properly researched papers way ahead of time. Each time I think I have had the best their professional writers surprise me with even better quality work. Elite Academic Research is a true Gem among essay writing companies.
Got an A and plagiarism percent was less than 10%! Thanks!

ORDER NOW


Consider Your Assignments Done

“All my friends and I are getting help from eliteacademicresearch. It’s every college student’s best kept secret!”

Jermaine Byrant
BSN

“I was apprehensive at first. But I must say it was a great experience and well worth the price. I got an A!”

Nicole Johnson
Finance & Economics

Our Top Experts

See Why Our Clients Hire Us Again And Again!


OVER

10.3k
Reviews

RATING
4.89/5
Average

YEARS
13
Mastery

Success Guarantee

When you order form the best, some of your greatest problems as a student are solved!

Reliable

Professional

Affordable

Quick

Using this writing service is legal and is not prohibited by any law, university or college policies. Services of Elite Academic Research are provided for research and study purposes only with the intent to help students improve their writing and academic experience. We do not condone or encourage cheating, academic dishonesty, or any form of plagiarism. Our original, plagiarism-free, zero-AI expert samples should only be used as references. It is your responsibility to cite any outside sources appropriately. This service will be useful for students looking for quick, reliable, and efficient online class-help on a variety of topics.