Category: Finance

W14405-XLS-ENG buy vs rent case.xlsx

A recent MBA graduate had been renting a condominium, and a similar unit next door had just been listed for sale. Now facing the classic buy-versus-rent decision, the young grad decided it was time for her to apply some of the analytical tools she had acquired in business school – including “time value of money” concepts – to her personal life.
The Learing Objective of this case is to review and provide practical applications of several time-value-of-money concepts.To provide an understanding of how to estimate cash flows and why opportunity costs can be important.To introduce students (informally) to the net present value (NPV) framework.To illustrate the fact that most decisions can be evaluated quantitatively, using time-value-of-money concepts to supplement qualitative considerations. This case can be used to help students to understand time-value-of-money concepts, as well as the practical applications of such concepts.
W14405-XLS-ENG buy vs rent case.xlsx
You may use this case to practice and further your undestanding of the topics discussed in this Module
This is an Excel spreadheett and a zoom meeting presentation of a buy vs rent business decision.
You may also access it thorugh the in the following zoom recording
https://wpunj.zoom.us/rec/share/JY1E57TWGjooPLUgcofaRz7kuj8L9ig7HKzXunW5z4mdeNQKWe5YPDqnofKBwNo.RPcPEyO67v79rsNT
Passcode: v0x1n^%F
Here is also a link where you may purchase the case
Harvard Business Publishing Education
Please provide your analysis of the Case at the seperate tab for this
And here is an Excel file with the TIme Value of Money concepts and applications of the formulas
Concise9e, ch 05 (TVM), chapter model, 09-22-15.xlsx

Instructions
Stock Repurchases
In the short article “Royal Dutch Shell Finally Delivers Big Stock Buyback, But Shares Break Support” by Aparna Narayanan (see below), stock repurchases may produce favorable effects on key financial ratios.
Narayanan, A. (2018, July 26). Royal Dutch Shell finally delivers big stock buyback, but shares break support. Investors Business Daily. Retrieved from https://libraryresources.columbiasouthern.edu/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=bth&AN=131003207&site=ehost-live&scope=site
After reading the article, write an essay that addresses the prompts below.
Include an introduction that summarizes the article.
Analyze the importance of stable dividend policies.
Determine reasons behind stock repurchases.
Analyze how individual financial metrics are specifically affected by stock repurchase plans and returns.
Your essay should be at least two pages in length, not counting the title and reference pages. You are required to cite and reference at least your textbook and the article. Use APA format to cite in-text and reference citations.

Prepare are brief SWOT analysis of these three companies. We are doing a stock investment simulator and I decided to invest in these three companies: Apple, Netflix, AMD
We will be investing in these three companies for a month.
Please provide an explanation of why it is worthy of investing in these companies for a month.
– Doesn’t have to be long
– Approx. 2 slides
– please provide slide scriipt
*Started investing on the 25th of Jan

Prepare are brief SWOT analysis of these three companies. We are doing a stock investment simulator and I decided to invest in these three companies: Apple, Netflix, AMD
We will be investing in these three companies for a month.
Please provide an explanation of why it is worthy of investing in these companies for a month.
– Doesn’t have to be long
– Approx. 2 slides
– please provide slide scriipt
*Started investing on the 25th of Jan

This phase of the project reports on the financial tools and how they are being used to gain an understanding of the problem and apply them to solve the problem defined in the project. Kindly find attached the reference papers you will use.
Resources: Fundamentals of Corporate Finance, 13th Edition

You need to turn in a 2-3 page (minimum length requirement), single-spaced paper.
Use Times New Roman, 12-point font with 1-inch margins.
Make sure to organize your thoughts logically and professionally. Use paragraphs and good sentence structure.
Your paper needs to include the following elements (in this order):
At the top of your paper, the FIRST thing that I should see is a single sentence (in boldface) telling me if you are attempting active management, passive management, or a blended strategy. If you are in doubt about what these strategies entail, then see the discussion in the ebook.
The SECOND element should have a subheading of “Overall Strategy”. This section should contain one (or two at the most) well-structured paragraph(s) discussing your high-level strategy. For example, you might be trying to capture a trend in a given industry, focus on growth opportunities, seek out value plays, or some other high-level strategy. How much do you plan to invest in stocks versus bonds (i.e., what is your asset allocation mix). It is critical that you have a high-level plan.
The THIRD element should have a subheading of “Individual Investments”. This section should contain a detailed descriiption of specifically why you plan to purchase each investment. Under the subheading of “Individual Investments”, you should list each investment. Put the name of the fund in boldface and the ticker (trading) symbol in () after the name. The name should be followed by “:” and then there should be 3-4 detailed sentences on why you want to put money in this specific fund. This step will help you think about when to sell and how to evaluate your investment thesis at the end of the semester. See below for a brief example. You need to be more detailed than this descriiption, but this points you in the right direction. DO NOT simply copy what I wrote below.
Vanguard Equity Income Fund (VEIRX): This fund is an actively managed, value-focused mutual fund that overweights defensive plays. This fits my overall investment thesis. Their top holdings are well diversified, and their expenses are minimal.
The FOURTH element should have a subheading of “RiskAlyze Risk Management”. You need to discuss what RiskAlyze finds as the risk score for your investments. Please discuss what you learned from using RiskAlyze to develop your initial portfolio allocation. Please also discuss what you learned from the heatmap and how RiskAlyze helped you to build a better initial portfolio. You should use the snipping tool Links to an external site.to capture your portfolio’s RiskAlyze score. This image should be nested to the right of your RiskAlyze discussion and the image should be large enough to read, but not so large that it appears to be a space filler to mask a weak discussion.
The FIFTH element should have a subheading final section should be labeled “Portfolio-Level Statistics”. This section relies on access to Y-Charts. Take a look at the image below to see what I want this section to look like. You need to build something that looks just like what I displayed below. This could easily fill one whole page by itself.
The graph at the top of this section uses the snipping tool and it is found on the “Performance” tab after you clicked on the blue link for your portfolio in Y-Charts. Make sure that you are using a 1-year graph. This should be the only screen snip on your paper from Y-Charts. If your graph does not look like the one below, then something is wrong. Make sure that you created a “portfolio” and not just typed the assets into a Fundamental Chart view.
You will find the expense ratio, the stock allocation, the bond allocation, the 1-year return, and the risk information on the “Quotes” tab.
All information listed as “Risk Information” (below) comes from the bottom right on the Quotes tab. Use the 3-year data, which may not appear correctly if you missed step 4 in the first (of two) numbered lists relative to Y-Charts on these instructions).
The top three sector exposures are on the “Allocation” tab under the section labeled as “Stock Sector Exposure” on the bottom right of the screen. Make sure that you turn in high-quality work and tell me the percentages for each category.
The annual benchmark-relative returns are found in the bottom two panels on the “Performance” tab. Use the most recent three years (I used 2016, 2017, and 2018 in my example due to when I created the image)… if more recent data is available, then use the most recent three years. Benchmark-relative return means that if the fund earned 10% and the benchmark earned 12%, then I should see -2% for that period because the fund underperformed the benchmark.

Complete a case study of Southwest Airlines. You will find the case in the case section of the text. A formal, in-depth case study analysis requires you to utilize the entire strategic management process. Assume you are a consultant asked by Southwest Airlines to analyze its external/internal environment and make strategic recommendations. You must include exhibits to support your analysis and recommendations.
INSTRUCTIONS
The completed case study must include these components:
• Cover page (must include the company name, your name, the date of submission, and a references page; the document must follow current APA guidelines)
• A total of 14 pages (for all three parts, combined) of narrative text, this does not include the financial statements, reference pages, or matrices
• Reference page (follow current APA guidelines)
• Historical Financial Statements, Projected Financial Statements, NPV Calculations and a Cost Sheet for the strategy in an Excel document
• Matrices, which must be exhibits/attachments in the appendix and not part of the body of the analysis (The Strategy Club has excellent templates/examples for exhibits and matrices).
Sources should be no older then 3 years have a DOI and be scholarly except the SEC site.
All Case instructions, the case from the book and the chart templet are attached.

PART 1 – Research Project Report
Cover page

Table of Contents

Introduction
Purpose and Scope of the Report
Brief Introduction to PepsiCo

Presentation and Analysis of Key PepsiCo and Coca Cola Financial Trend Rates: 2017 – 2021
PepsiCo Financial Trend Analysis 2017-2021
Presentation of the Five-year PepsiCo Trend Rates
Detail a five-year trend table for the 7 key rates of growth
Support the data by detailed calculations or cite the specific reference
Present a chart of one or more selected table growth rates
Analysis of the PepsiCo Trend Rates
A one-page evaluation of PepsiCo’s general financial trends and stability

Coca Cola Financial Trend Analysis 2017-2021
Presentation of the Five-year Coca Cola Trend Rates
Detail a five-year trend table for the 5 key rates of growth
Support the data by detailed calculations or cite the specific reference
Present a chart of one or more selected table growth rates
Analysis of the Coca Cola Trend Rates
A one-page evaluation of PepsiCo’s general financial trends and stability

Comparative Analysis of PepsiCo and Coca Cola Five-year trend rates
Main Financial strengths and weaknesses identified
PepsiCo
Coca Cola
Discuss what important information was obtained from the analysis

Recommendation on PepsiCo’s Financial Strength and its Sustainability
Recommend, and quantitatively support, an assessment PepsiCo’s overall financial strength
Recommend, and quantitatively support, an assessment PepsiCo’s financial sustainability over2-3 yrs.
Present and support specific recommendations to improve PepsiCo’s financial stability
Reflections on lessons learned from this analysis
What was learned and how can it be applied to the workplace

Attachments
Detailed supporting tables. Charts and calculations
(Note, where possible embed Tables & Charts in the report body
References
List references
(listed references should be cited in report)
Written projects:
Must be typed, double-spaced, in 12-point Times New Roman or Arial font, with one-inch margins
Must have the title page in APA-7th style
Must have in-text citations in APA-7th edition style
Must have reference list in APA-7th edition style. Please note that you must reference the data you are using for the project
Must be prepared using word processing software (Microsoft Word preferred)

Attached please find the case study and the question that need to be answer. I am only responsible for question#1 How has AutoZone’s stock price performed over the previous five years. What other financial measures can you cite that are consistent with the stock price performance?
Maybe add a chart or table about the EPS, stock price, earning per share ratio, Net sales cost of sale operation margin the net Income, the company profit margin piece by earning per share (PE) Ratio. Or just write about it .
Can you also please provided me with a comment about the case study ending with a question to the class?

Please Include that as of right now I am a full time college student with a major in Computer Information Systems Cyber Security. I also have 2 daughters and a wife and make only $1,000 gross a month. I plan on landing a career at Lockheed Martin right after graduating in May 2023 where the average starting salary is $100,000 annually for Cyber Security. Develop financial goals that are realistic: A 2 year goal, 5 year goal, and 10 year goal. I put the actual prompt below:
Personal Action Project (Due by end of Course – Module 8): (350 points) For the final project of the course, identify 5 actions, behaviors, habits, or skills that can be used for the attainment of personal financial goals.
• Describe potential roadblocks, or challenges, that can be faced within each action.
• Utilizing the 5 items identified, summarize how you can build each into your personal financial goals and describe the outcomes to which they would lead to.
• Describe a timeline for the goal and what benchmarks would be used to track progress.
• Finally, identify and support what you would describe as the one most important aspect of developing success in personal finances. Use citations/references and a minimum of 800 words in APA format