Category: Business

Your Company Final Analysis and Valuation

Throughout this semester, you have completed various analyses of the company that you selected, Your Company, to review. For your final analysis and valuation, the Business Report, use the weekly assignments as a starting point and complete each of the steps below to analyze and value the company you selected. Prepare a well written Business Report to present your findings. Your findings in your Business Report must be in your own words. All financial statement data and related schedules in the report must be in good form and in summary format. That is, DO NOT cut and paste entire YC Assignment spreadsheets into the report. Appropriately title the relevant sections within the report.

Use Exhibit 1.2 in the Wahlen text to review the steps to complete this project:

The six steps above were discussed in Week 1, Chapter 1.

Step 1: Identify Economic Characteristics and Competitive Dynamics in the Industry Economic characteristics and competitive dynamics influence the strategies companies will employ.

• Describe Your Company and its industry, and complete one of the tools described in Chapter 1 for assessing industry economic characteristics. Your analysis must discuss the economic characteristics and competitive dynamics of the industry while analyzing the financial statements for Your Company.
  • Porter’s Five Forces Framework
  • Value Chain Analysis
  • Economic Attributes Framework
• Compare the financial statement ratios for Your Company to industry ratios (see Appendix D) and assess how Your Company’s performance compares to the industry. Include the industry ratios used in your analysis in your report and cite the source(s) for the ratios.

Step 2: Identify Company Strategies Review the annual reports for the most recent two years and any other published items on the companys website to identify your companys strategies. Review recent news and conduct research to familiarize yourself with Your Company’s strategies. Discuss the company’s strategies in your report. Cite the sources you use to support your comments and conclusions.

Step 3: Assess the Quality of the Financial Statements Review the quality of the financial statements as discussed in Whalen Chapter 1 and:

• Identify what potential areas on Your Companys financial statements could compromise the quality of their financial statements. Explain.
• Discuss your assessment of the quality of Your Company’s financial statements based on the research and analyses you have completed.

Step 4: Analyze Profitability, Liquidity, Risk, Growth, and Leverage Analyze the following for Your Company using the ratios and risk analyses you completed in your YC Assignments.

• • Profitability
  • Liquidity
  • Risk
  • Growth and
  • Leverage

Discuss what the ratios and their trends say about Your Companys profitability, liquidity, risk, and growth, and leverage, and its current value. Your written analysis must be in your own words. Refer to the Rubric for Assessment of Your Company Final Analysis and Valuation to ensure that your analysis and discussion of Your Company in this report are complete and meet the grading criteria for this assignment.

Step 5: Project Future Financial Statements Project three years of financial statements (Balance Sheet, Income Statement, and Statement of Cash Flows) for Your Company. Use the “Forecasts spreadsheet in Your Companys FSAP 9e Excel file to calculate, compile, prepare, and test the validity of the financial statement forecasts for Your Company (Years +1, +2, and +3).

Forecast assumptions Determine the Long-run Growth Rate to be used for the forecast based on the last three years of growth in the revenue. Input the growth rate on Line 15 and ensure that the Long-Run Growth Factor on Line 16 is correct. Discuss the growth rate used and justify using the rate for the forecasts.

Forecast Base Year Review the Actuals data in the Forecasts tab to ensure that the amounts and the common size percentages agree with data for the three years of Income Statement, Balance Sheet, and Statement of Cash Flows on the Analysis tab. Correct any errors or omissions in the data columns.

Income Statement Assumptions:

• Project Revenue amounts consistently across the three years using the three-year growth rate assumption as determined above and input on Line 16.
• Project cost of goods sold and all other expenses using the common size income statement percentage for the most recent year (Column C) to calculate the projected amount for each expense item each year. Enter the percentages in the appropriate rows of Column E. The rate of change should remain constant for all revenue and expense items across the three years.

Balance Sheets Assumptions:

The Forecasts template provides explanations for the Balance Sheet forecast calculations. Leave the template assumptions unchanged unless you have data to support different assumptions for your company.

• Use common size balance sheet percentage for the most recent year (Column C) to calculate the asset and liability amount for each account item each year. Enter the percentages in the appropriate row of Columns E, F, and G.
• The Forecasts spreadsheet is programmed to balance the balance sheet by adjusting Retained Earnings as the flexible financial account. If necessary, alter this assumption by allocating the change across the assets, or liabilities including debt, or both; whichever most closely aligns with Your Companys strategies.

Statement of Cash Flows Assumptions:

The Statement of Cash Flows in the Forecasts template uses the Forecasted Balance Sheet and Forecasted Income Statement to project the three years of Forecasted Statements of Cash Flows.

• No adjustments to this section of the template should be necessary, However, if your assumptions support a change, adjust SCF activities in accordance with Your Company’s strategies discussed in Step 2 above. Correct any errors and ensure that the check figures on line 317 are zero.

Finally, discuss what the projected financial statements show regarding Your Companys future profitability, liquidity, risk, growth and leverage. Your written analysis must be in your own words.

Step 6: Value the Firm Using the analyses from steps 1-5 above and the simple firm valuations methods discussed in Whalen Chapter 1, assess whether Your Company is overvalued, or undervalued. Discuss the current stock price and the PE ratio in your valuation analysis. Provide justification for your determination. Show in your discussion that you have thought through and connected the results reported in steps 1-5 above.

Submission Requirements:

Prepare a written business report using the six section headings outlined below to present your findings from Step 1 through Step 6. Refer to the Rubric for Assessment of Your Company Final Analysis and Valuation to ensure that your Business Report meets all of the grading criteria. Use the following headings for the six sections of the report:

• Economic Characteristics and Competitive Dynamics in the Industry
• Company Strategies
• Quality of the Financial Statements
• Profitability, Liquidity, Risk, Growth, and Leverage
• Projected Financial Statements
• Firm Valuation

The report must be typed, professionally presented, and saved and submitted as a Microsoft Word document. The maximum length for the written part of the report (exclusive of summary financial data) is four (4) full-length single-spaced pages using Times New Roman-12 font with 1-inch margins all around.

All financial statements and related schedules in the report should be in good form. DO NOT cut and paste entire YC Assignment spreadsheets into the report. Provide only the relevant sections of a spreadsheet within the report. Appropriately modify, title, and insert any relevant sections from your YC Excel spreadsheets in the report.

Submit an electronic copy of your Business Report, the supporting FSAP 9e Excel spreadsheet file, and .pdf copies of other supporting documents, to the Canvas assignments by the due date and time. The due date and time for the assignment is available on the Canvas course site.

What to submit to Canvas:

Your Final Analysis Valuation assignment will be submitted in 3 Canvas Assignments.

1. 1. Your written Business Report as a MSWord document to the assignment.
   2. Your Excel file with FSAP 9e YC spreadsheet compilations and computations to the location. Reference the worksheet tabs correctly throughout in the report and include separate tabs labeled for Steps1 thru 6 above in the FSAP 9e spreadsheet file to present any additional compilations and calculations prepared for the report.
   3. Your Companys Supporting Documents to the location. (Include .pdf copies of Annual Reports for the last 2 years, Industry Ratios, and other cited documents.)

Name and save your MSWord and Excel files as ACG 5153 Final Analysis and Valuation_ LastName FirstName. Your supporting .pdf documents should be appropriately titled. Submit your MSWord file, FSAP 9e Excel file, and .pdf copies to the appropriate locations above by the due date and time. Timely submission of your files to Canvas in good form, in accordance with all of the requirements, and, by the due date and time is required.

Another more current source for industry ratios may be used. Cite, provide a link to, and a .pdf copy of the source for the industry ratios.

Attached is the criteria and the excel you have done for me

The rest of the criteria because i coul dnot attach more:

9. Calculate and Discuss PE Ratio: Obtain stock prices and calculate PE Ratio. Discuss 5-year trend and interpret trend.	5 pts Exceeds Expectations Assesses ratio correctly, recognizes managerial course of action to achieve results, company culture, nature of accruals. 4 pts Meets Expectations Assesses ratio trend correctly, interprets performance correctly, computes additional statistics to support interpretation. 3 pts Approaching Expectations Assesses ratio trend correctly. 2 pts Approaching Some Expectations Computations are mostly correct, utilizing Excel functions. 1 pts Inadequate Computes no ration, yet a few calculations are correct utilizing Excel functions. 0 pts No Expectations Met No computations submitted.	5 pts
This criterion is linked to a Learning Outcome 10. Value the Firm: Assess whether the company is overvalued or undervalued.	5 pts Exceeds Expectations Recognizes systemic risks, considers market-based impact on future success. 4 pts Meets Expectations Integrates key domain of managerial decision making. Long-range considerations are mentioned. 3 pts Approaching Expectations Answer is supported by data; provides some rationale for making effective managerial decisions. 2 pts Approaching Some Expectations Only opinions are offered. Data to support opinions is lacking. 1 pts Inadequate Invalid opinions only. 0 pts No Expectations Met No data or computations submitted.	5 pts
This criterion is linked to a Learning Outcome 11. Summarize: Summarize the firms profitability, liquidity, growth and risk. Discuss 5-year trends and interpret trends.	5 pts Exceeds Expectations Recognizes systemic risks, considers market-based impact on future success. 4 pts Meets Expectations Integrates key domain of managerial decision making. Long-range considerations are mentioned. 3 pts Approaching Expectations Provides some supporting data; and some rationale for making effective managerial decisions. 2 pts Approaching Some Expectations Only opinions are offered. Data to support opinions is lacking. 1 pts Inadequate Invalid opinions only. 0 pts No Expectations Met No data or computations submitted.	5 pts
This criterion is linked to a Learning Outcome 12. Depth of Comments: Analysis demonstrates critical thinking and connects trends for profitability, liquidity, growth and risk to the broader financial performance and strategic direction of the company.	5 pts Exceeds Expectations Analysis connects all profitability, liquidity, and risk trends to company performance and strategic direction accurately, thoroughly, and with insightful analysis. 4 pts Meets Expectations Analysis connects most profitability, liquidity, and risk trends to company performance and strategic direction accurately, but with minor errors or omissions in analysis, or in the depth of explanation. 3 pts Approaching Expectations Analysis connects several profitability, liquidity, and risk trends to company performance and strategic direction with errors in connection, but demonstrates effort and basic understanding of the task. 2 pts Approaching Some Expectations Analysis connects some profitability, liquidity, and risk trend to company performance and strategic direction but with significant errors in connection, lacks depth or coherence. 1 pts Inadequate Analysis’ connection to company performance and strategic direction is incomplete, poorly executed, or fails to meet basic requirements. 0 pts No Expectations Met Analysis does not connect trends to company performance or strategic direction.	5 pts
This criterion is linked to a Learning Outcome 13. Insightful Commentary: Comments and explanations reflect a deep understanding of financial ratios and their implications for the companys profitability, liquidity, growth, and risk.	5 pts Exceeds Expectations Analysis reflects a deep understanding of financial ratios and their implications regarding the companys current and future performance. 4 pts Meets Expectations Analysis shows an understanding of financial ratios implication on the companys current and future performance. 3 pts Approaching Expectations Analysis shows some understanding of financial ratios implication on companys current and future performance. 2 pts Approaching Some Expectations Analysis shows little understanding of financial ratios implication on companys current and future performance. 1 pts Inadequate Analysis shows no understanding of financial ratios implication on companys current and future performance. 0 pts No Expectations Met No analysis was completed.

Excel Website Exercise–ETF Analysis

Construct a portfolio of ETFs in !

• Set up your own Yahoo! account.
• On the Yahoo! homepage, click Finance
• On the Finance homepage, hover over Screeners and click “ETF Screener”
• In the “Category Name” panel, click “Add “Category Name”
• Include sector and style ETFs: Health, Large Value, Mid-Cap Growth, Small Growth, Equity Energy, and Technology
• In the Fund Family panel, include all or select
• In Morningstar Ratings panel, include at least three stars and higher
• Click “Save Filter” tab
• On the screen showing ETFs, click Symbol box of ETFs you want to analyze
• Click “Add to Portfolio” to create a portfolio of your ETFs
• Click ticker symbol to analyze ETFs

• Prepare a report summarizing information on two of the ETFs in your portfolio. Information can be found from the following tabs:
  • Profile: Fund Summary
  • Holdings: Sector Weights
  • Risk: alpha, beta, mean return, standard deviation, Sharpe Ratio, and Treynor Ratio
  • Performance: Total returns for different periods
  • Chart: Cumulative Returns over several time periods (e.g., 2 years and 5 year) relative to S&P 500 (Click Comparison tab to add index to graph)
  • Also form a summary for a discussion board to share with classmates.

attached

“Saya ingin memahami perbedaan utama antara tiga zaman sejarah Indonesia yaitu prasejarah, kolonial, dan kemerdekaan. Mohon jelaskan mengenai ciri khas, peristiwa penting, serta perubahan yang terjadi pada masing-masing zaman tersebut.”

ARead the case of Robin Chase, Zipcar, and an Inconvenient Discovery

Analyze Robin Chases experience with Zipcar startup based on concepts covered in LPs: 1 ,2 ,3 ,4 , and 5. In your paper answer the following questions:

1- Briefly explain Robin Chases motivation to start Zipcar and the characteristics that made her a successful entrepreneur. Did she face any issues being a woman entrepreneur?

2- Explain how Robin Chase recognized an opportunity to start Zipcar using the three different approaches for opportunity identification.

3- Identify which types of feasibility analysis did Robin Chase perform before starting her business.

4- Perform porter analysis on Zipcar industry.

5- In your opinion, what is the reason for Zipcars financial performance? What solutions would you recommend for Robin Chase to enhance the financial performance of Zipcar? The goal of your paper should be to analyze Robin Chases entrepreneurial experience with Zipcar.

Length:

1250-1500

The grading mark would be based on the Learning outcome BELOW.

Learning Outcomes Added

#IntroductionToEntrepreneurship: Explain the concepts, tools and practices of entrepreneurship.

#NewBusinessOpportunities: Evaluate new business opportunities (versus ideas) and evaluate the viability of a new venture.

#EntrepreneurshipDiversity: Understand the diversity of entrepreneurial intentions according to gender and demographics and the importance of entrepreneurial passion.

#EntrepreneurialThinking: Practice entrepreneurial thinking, ideation and design thinking.

—————————–

EXTRA NOTES FROM THE PROFESSOR

NO NEED FOR OUTSIDE SOURCES, JUST THE CASE STUDY.

For Question 1:

The LO needed to be in question 1 as a footnote is #EntrepreneurshipDiversity

Three points needed to be covered in question 1. Motivations, Characteristic, Woman

I need to see the (motivations), why did she did this, at least 1 or 2, why she opened the business. it could be one or two lines to define each point.

The (characteristics), address her education. it could be one or two lines to define each point.

(Woman), does this make her life easier opening her own business or difficult, did she face a challenges or it was an advantage. it could be one or two lines to define each point.

For Question 2:

The LO needed to be in question 2 as a footnote is #NewBusinessOpportunities

Opportunity Analysis: 1 Environmental trends, 2 Problem solving, 3 Filling Gap

Environmental trends: (Economics, technological, social, legal) At least mention two out of these 4.

Problem solving: it could be short one two sentences.

Filling Gap: it could be short one two sentences.

For Question 3:

The LO needed to be in question 3 as a footnote is #EntrepreneurialThinking

Feasibility analysis: 1 Product, 2 industry

Product Feasibility: Desirability, and demand, one line about Desirability people like the

it or not, and the demand.

Industry Feasibility: A line for each, attractiveness and target market, at any point we could talk about competitors.

Do not mention managerial feasibility, and financial debility, since we didnt cover it.

For question 4:

The LO needed to be in question 4 as a footnote is #EntrepreneurialThinking

Porter analysis, is also called competitive forces the table.

For this question you could make a table for the Porter analysis whichs called competitive forces. Mention in the table the 5 element which are Level of rivalry, potential for entry, power of suppliers, power of customers, substitutes then mention whether it is high, low or moderate, then explain why it is for the 5 elements for the factors.

The table contains the 5 element, high-low-moderate, and why, when explaining why, it could be within couple of sentences.

For each point in Competitive Forces, say high, or low, and why, it could be a table for it.

For question 5:

The LO needed to be in question 5 as a footnote is #IntroductionToEntrepreneurship

Dont analyze the financial numbers, but give reasons why she didnt achieve what she thought she would have achieved.

assignment Now define each stage of team development in your own words.

Also give a personal example for each stage of team development.
Instructions for this Assignment
Purpose:
All teams undergo five stages of team development: forming, storming, norming, performing and adjourning. After completing this assignment students will be able to understand and identify these five stages of team development.
Task(s):
Read about stages of team development from your textbook.
Watch the video link enclosed.
Explain the different stages of team development which you identified in the video. Give personal examples for each of those five stages.
Submission Format
Write 2-3 lines on each stage of team development.
double-spaced
12 pt Arial
1″ margins
Sources should be accurately cited in APA
Include a covering sheet with title of the assignment, name of the student, title of the subject and section.

Discussion The Power of Making Mistakes

This video explores how people with a growth mindset differ from people with a fixed mindset when they encounter setbacks. It also looks at why making mistakes is a normal and important part of the learning process, and explores ways people can apply a growth mindset when they make a mistake.

1. Why is making mistakes a normal part of the learning process?

Week 7 macroeconomics discussion

Aggregate Supply and Aggregage Demand Model

As we near the end of the semester, we step back and connect all that we have studied. How does the Aggregate Supply/Aggregate Demand Model do that? What concepts are summarized in this model? Try to describe what we are seeing right now in the US economy in terms of this model.

Week 7 life science discussion Evolutionary Processes

Watch the video on “misconceptions of evolution”. After watching the video, reflect on misconceptions you have had about evolution. Did this video address those? What did you learn about evolution that you did not previously know or misunderstood?

week 7 life science assignment (assignment is attached in uploads)

Dichotomous Keys

Watch the video below that offers an introduction to dichotomous keys. You will need to watch it carefully so you understand how dichotomous keys work. Complete the attached activity and record your answers. Upload and submit your completed assignment document.

YouTube Video:

I would like to have a piece of work about passive leadership and how it will affect the work, team and overall the organization. More details on the attachment