Fin27

Posted on February 8, 2017

Finance Assignment Help 27

 
COMPANIES TO CHOOSE FROM
1. WALMART STORES INC.
2. HOME DEPOT
3. COSTCO WHOLESALE CORPORATION.
4. TAGET CORPORATION.

 
FORMATTING AND PRESENTATION
 
The entire project should be contained in one Excel file. This is not a term paper, but some narrative will be necessary. There are various ways to insert narrative into Excel, from using comments to merging cells and wrapping text to inserting whole Word documents or other objects.
 
I am not going to specify exact guidelines for how you should format your Excel sheets, but everything should be laid out in a clear and logical manner. You will need to use more than one “sheet,” and each sheet should be labeled. Excel formulas should be used in the most efficient way possible.
 
Pretend that I am either your boss or an important client, instead of an instructor who is obligated to try to figure out what you have done even if it is not presented clearly. Get right to the point when explaining your work. Focus on the information that matters most. More is not necessarily better. Don’t make presentation an afterthought
 
GENERAL DESCRIPTION OF PROJECT
 
The assignment is to perform a financial and business analysis of a large, publicly traded U.S. retailer. I will provide a list of firms for you to choose from. There are several reasons that I am limiting your choices to a small group of large U.S. retailers. First, I want to make it easy to compare student work, and some types of firms are easier to analyze than others. Second, the operations of retailers are relatively simple to understand, so students with deep knowledge of a particular firm or industry have less of an advantage than they might have if I let students pick any firm. Third, the group of firms that I have selected share certain characteristics that allow students to apply some of the material covered in the course: they use some debt, they distribute some cash to shareholders, they need to invest in net operating assets, they have certain corporate governance issues to confront, etc. Finally, I want to stick with U.S. firms because it is relatively easy to obtain free, up to date, and accurate financial data on publicly traded U.S. firms.
 
 

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.
 
Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.
 
Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.
 
Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.
 
Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.
 
Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.
 

Features

Features for Assignment Help

Zero Plagiarism
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.

 

Relevancy
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.

 

Three Stage Quality Check
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.

 

 

100% Confidential
All our works are kept as confidential as we respect the integrity and privacy of our clients.

Related Services


 
SPECIFIC REQUIREMENTS OF THE PROJECT
 
Q1. First, identify the firm’s closest publicly-traded U.S. competitor. This is the firm that is most similar in terms of its business model and its size in terms of both revenues and enterprise value. Then, analyze the firm’s recent financial performance and current financial health, using the techniques learned in prerequisite courses or on your own. Use at minimum, the last five years of income statements, balance sheets, and cash flow statements. If the last set of annual statements doesn’t bring you up to date, also construct trailing-twelve month (ttm) income statements and cash flow statements and use the latest available quarterly balance sheet. Compute and analyze ten to twenty key ratios and two or three growth rates of key variables over the period. Focus your discussion on ratios or growth rates that have changed a great deal in recent years or that differ greatly from competitor metrics.
 
Q2. Analyze the firm’s competitive environment. You may use a framework such as Porter’s five forces or a SWOT analysis to organize your thoughts if you wish, but that isn’t required. You don’t need to go into as much detail here as you would in a strategic management class. Focus on the most important issues. If you do use one of the above frameworks, don’t include the parts that are irrelevant or only marginally relevant. Your conclusions from this analysis, along with your analysis of the firm’s recent financial performance, should inform your financial projections.
 
Q3. Project the firm’s financial statements (income statement, balance sheet, and statement of cash flows) at least three years, but no more than ten years, into the future, using the techniques learned in the course. It is very likely that there will be some items on the firm’s historical financial statements that you don’t understand. Read the notes to the financial statements if necessary. Items that are not material may be ignored or consolidated into a “miscellaneous” category.
 
Q4. Estimate the firm’s future free cash flows in perpetuity using your projected financial statements and the techniques learned in this course and other finance courses.
 
Q5. Estimate the firm’s weighted average cost of capital (WACC) using the techniques presented in the course. Be sure to explain how you arrived at your estimates of all components of the WACC.
 
Q6. Estimate the firm’s intrinsic value per share using the corporate valuation model (FCF model) presented in the course. Then, calculate some simple valuation multiples (trailing P/E ratio, EV/EBITDA ratio) that are implied by your estimated value, and use these calculations and other information to evaluate how reasonable your estimate is. Is the stock a buy or a sell? Explain why in one sentence.
 
Q7. Evaluate the firm’s capital structure policies. Many, if not most, firms don’t explicitly describe their target debt ratio or other aspects of their capital structure policies. If that is the case for your firm, you may infer them based on what they have actually done. Focus on evaluating any major changes that might have been implemented in recent years. Could management increase the value of the firm with a different policy?
 
Q8. Evaluate the firm’s payout policies. As with capital structure policies, firms don’t always explain their policies on dividends and repurchases explicitly. Focus on evaluating any major changes that might have been implemented in recent years. Could management increase the value of the firm with a different different policy?
 
Q9. Evaluate the firm’s corporate governance. How is the CEO paid, and how does it compare to the competition? Are there any other aspects of the firm’s corporate governance that raise a “red flag?”
 
Q10. Analyze a scenario in which the firm acquires its closest competitor. Following are some instructions, assumptions, and hints for this part:
*Remember that an acquisition of a whole company can be thought of as a capital budgeting “project” and evaluated accordingly.
 

Product Code :Fin27

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.

Summary
User Rating
5 based on 1 votes
URL