Category: Accounting

Create an 8- to 10-slide presentation showing the comparison of the net present value approach with the internal rate of return approach that youcalculated.

We are restarting it is round 1 attached is the data need help figuring out what moves to make for each.

The attached documents are the guidelines for the paper. PLEASE make sure to read them. This paper will be based on the concepts of this course. and must address each bolded concept.

Module Eight | Final Research Paper

Components:

This project consists of three major activities:

1. Conduct secondary research (i.e. library, internet, etc)
2. Write a research paper computing the financial ratios yourself and submit in Module Eight
3. Make a multimedia presentation to the class in Module Eight and critique two peers’ presentations.
4. The Project to be addressed by the Paper:
   You have just graduated from Piedmont College’s MBA program and have secured a position as a fund manager at a well-known investment banking house. The fund is a pension/retirement fund manager, so its perspective is long-term with moderate risk of loss of capital and a required return of 9% per annum. Your first assignment is to determine if the fund you are managing should invest $25 million dollars in the stock of the publicly traded company you have selected for your first analysis/investment decision. Do not select a bank or financial intermediary (i.e. insurance company, investment banking house, funds manager, fund etc). Your decision to invest or not invest will be supported by the research paper and a 12 to15 minute Power Point Presentation to the Executive Committee of the Fund (your hard-nosed capitalist classmates). Note that a decision not to invest is just as valid as a decision to invest as long as either decision is supported by valid data and a sound argument.
   All of the information you need is in the File that explains the paper.
   

   . This attached link is the link to the textbook as well

The attached documents are the guidelines for the paper. PLEASE make sure to read them. This paper will be based on the concepts of this course. and must address each bolded concept.

Module Eight | Final Research Paper

Components:

This project consists of three major activities:

1. Conduct secondary research (i.e. library, internet, etc)
2. Write a research paper computing the financial ratios yourself and submit in Module Eight
3. Make a multimedia presentation to the class in Module Eight and critique two peers’ presentations.
4. The Project to be addressed by the Paper:
   You have just graduated from Piedmont College’s MBA program and have secured a position as a fund manager at a well-known investment banking house. The fund is a pension/retirement fund manager, so its perspective is long-term with moderate risk of loss of capital and a required return of 9% per annum. Your first assignment is to determine if the fund you are managing should invest $25 million dollars in the stock of the publicly traded company you have selected for your first analysis/investment decision. Do not select a bank or financial intermediary (i.e. insurance company, investment banking house, funds manager, fund etc). Your decision to invest or not invest will be supported by the research paper and a 12 to15 minute Power Point Presentation to the Executive Committee of the Fund (your hard-nosed capitalist classmates). Note that a decision not to invest is just as valid as a decision to invest as long as either decision is supported by valid data and a sound argument.
   All of the information you need is in the File that explains the paper.
   

   . This attached link is the link to the textbook as well

Please check the attachment and do the needful

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.

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

2. 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.

Criteria:1. Summarize Industry Economics & Characteristics:Summarize economic characteristics, and competitive dynamics in the industry.

2. Summarize Company Strategies:Summarize company strategies and assess the quality of the financial statements.

3. Calculate and Discuss ROA:Discuss trend and interpret trend. Focus on the change between most recent two years.

4. Calculate and Discuss ROE:Discuss trend and interpret trend. Focus on the change between most recent two years.

5. Calculate and Discuss Profitability and Growth Ratios:Calculate growth rate in revenues, gross profit margin, operating margin, net profit margin. EPS, and assess income quality. Discuss 5-year trends and interpret trends. Discuss income quality and company culture.

6. Calculate and Discuss Liquidity Ratios:Calculate A/R turnover, days A/R outstanding, inventory turnover, days inventory held, and fixed asset turnover. Discuss 5-year trends and interpret tends.

7. Calculate and Discuss Debt Ratios:

Calculate debt ratio, debt-to-equity ratio, and TIE ratio.
Discuss 5-year trends and interpret trends.

8. Project Future Financial Statements:Project three years of financial statements (Balance Sheet, Income Statement, and Statement of Cash Flows). Discuss what the projected financial statements show regarding the company’s future profitability, liquidity, risk, growth, and leverage.

9. Calculate and Discuss PE Ratio:Obtain stock prices and calculate PE Ratio. Discuss 5-year trend and interpret trend.

10. Value the Firm:Assess whether the company is overvalued or undervalued.

11. Summarize:Summarize the firms profitability, liquidity, growth and risk. Discuss 5-year trends and interpret trends.

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.

13. Insightful Commentary:Comments and explanations reflect a deep understanding of financial ratios and their implications for the companys profitability, liquidity, growth, and risk.

Overview

Since visualization plays an important role in business communication between consultants and stakeholders, Power BI is a popular tool to use with Excel data analysis worksheets. In this scenario, you will continue to work as a business consultant trainee with the superstore client.

Your manager has advised you to use Power BI to recreate multiple charts that you initially generated in Module One for the TC Ice Cream Management team. Remember that the team is interested in whether specific trends are identified that can help grow its business through improved operations and sales. TC Ice Cream uses Power BI as its main data visualization tool; therefore, you believe that using this tool will help you communicate your analysis in a familiar way and result in more meaningful analysis.

Prompt

Your task is to create multiple charts using Power BI as part of your continued analysis to help TC Ice Cream grow its business through improved operations and sales. Follow the directions in the to create a pie chart and a column chart in Power BI.

Specifically, you must address the following rubric criteria:

1. Create a pie chart to represent the key attributes of the data.
   • Use Power BI on the virtual desktop infrastructure (VDI) to complete this step.
   • Use the TC Ice Cream Excel Workbook available to you on the VDI.
   • Recreate a pie chart from your completed TC Ice Cream Overall Analysis worksheet.
   • Articulate and appropriately label the chart you created in Power BI.
   • Take a screenshot of the chart, paste it in a Microsoft Word document, and convert the document to a PDF.
   • Name the PDF as follows: Power_BI_Chart1.
2. Create a column chart to represent the key attributes of the data.
   • Use Power BI on the VDI to complete this step.
   • Use the TC Ice Cream Excel Workbook available to you on the VDI.
   • Recreate a column chart from your completed TC Ice Cream Overall Analysis worksheet.
   • Articulate and appropriately label the chart you created in Power BI.
   • Take a screenshot of the chart, paste it in a Microsoft Word document, and convert it to a PDF.
   • Name the PDF as follows: Power_BI_Chart2.

What to Submit

Submit each Power BI chart screenshot in a PDF format. Name the charts as instructed in the prompt: Power_BI_Chart1 and Power_BI_Chart2.

Module Four Power BI Assignment Rubric

Criteria	Exceeds Expectations	Meets Expectations	Partially Meets Expectations	Does Not Meet Expectations	Value
Power BI: Pie Chart	N/A	Creates a pie chart to represent the key attributes of the data using Power BI (100%)	N/A	Does not attempt criterion (0%)	40
Power BI: Column Chart	N/A	Creates a column chart to represent the key attributes of the data using Power BI (100%)	N/A	Does not attempt criterion (0%)	40
Chart Labels	N/A	Charts are appropriately labeled (100%)	N/A	Does not attempt criterion (0%)	10
Clear Communication	Exceeds expectations with an intentional use of language that promotes a thorough understanding (100%)	Consistently and effectively communicates in an organized way to a specific audience (90%)	Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding (70%)	Shows no evidence of consistent, effective, or organized communication (0%)

Overview

Since visualization plays an important role in business communication between consultants and stakeholders, Power BI is a popular tool to use with Excel data analysis worksheets. In this scenario, you will continue to work as a business consultant trainee with the superstore client.

Your manager has advised you to use Power BI to recreate multiple charts that you initially generated in Module One for the TC Ice Cream Management team. Remember that the team is interested in whether specific trends are identified that can help grow its business through improved operations and sales. TC Ice Cream uses Power BI as its main data visualization tool; therefore, you believe that using this tool will help you communicate your analysis in a familiar way and result in more meaningful analysis.

Prompt

Your task is to create multiple charts using Power BI as part of your continued analysis to help TC Ice Cream grow its business through improved operations and sales. Follow the directions in the to create a pie chart and a column chart in Power BI.

Specifically, you must address the following rubric criteria:

1. Create a pie chart to represent the key attributes of the data.
   • Use Power BI on the virtual desktop infrastructure (VDI) to complete this step.
   • Use the TC Ice Cream Excel Workbook available to you on the VDI.
   • Recreate a pie chart from your completed TC Ice Cream Overall Analysis worksheet.
   • Articulate and appropriately label the chart you created in Power BI.
   • Take a screenshot of the chart, paste it in a Microsoft Word document, and convert the document to a PDF.
   • Name the PDF as follows: Power_BI_Chart1.
2. Create a column chart to represent the key attributes of the data.
   • Use Power BI on the VDI to complete this step.
   • Use the TC Ice Cream Excel Workbook available to you on the VDI.
   • Recreate a column chart from your completed TC Ice Cream Overall Analysis worksheet.
   • Articulate and appropriately label the chart you created in Power BI.
   • Take a screenshot of the chart, paste it in a Microsoft Word document, and convert it to a PDF.
   • Name the PDF as follows: Power_BI_Chart2.

What to Submit

Submit each Power BI chart screenshot in a PDF format. Name the charts as instructed in the prompt: Power_BI_Chart1 and Power_BI_Chart2.

Module Four Power BI Assignment Rubric

Criteria	Exceeds Expectations	Meets Expectations	Partially Meets Expectations	Does Not Meet Expectations	Value
Power BI: Pie Chart	N/A	Creates a pie chart to represent the key attributes of the data using Power BI (100%)	N/A	Does not attempt criterion (0%)	40
Power BI: Column Chart	N/A	Creates a column chart to represent the key attributes of the data using Power BI (100%)	N/A	Does not attempt criterion (0%)	40
Chart Labels	N/A	Charts are appropriately labeled (100%)	N/A	Does not attempt criterion (0%)	10
Clear Communication	Exceeds expectations with an intentional use of language that promotes a thorough understanding (100%)	Consistently and effectively communicates in an organized way to a specific audience (90%)	Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding (70%)	Shows no evidence of consistent, effective, or organized communication (0%)	10

Overview

Bivariate regression analysis is an excellent tool to help you answer questions about a business. When you use bivariate analysis, you can discover whether there is a strong correlation between a dependent and an independent variable.

In this scenario, you will continue to work as a business consultant trainee with TC Ice Cream. The TC Ice Cream management team would like to know which key attributes have an impact on the Quantity Sold variable. The team would like you to perform two bivariate regressions to analyze the data. Remember that TC Ice Cream is interested in whether specific trends are identified that can help grow its business through improved operations and sales. Then you will create a PowerPoint presentation for the TC Ice Cream management team in which you describe the regression models, the variables, and the testing conducted.

As a reminder, the WEST NORTH CENTRAL division cannot be used for your assignment. Use the division and the two flavors you selected for Milestone One.

Prompt

Your task is to create two bivariate regressions using Excel. You will also create a presentation that describes the regression model you used and why you chose to analyze your selected independent variables.

IMPORTANT NOTE:
For all bivariate regression models and calculations, use the same division and flavors you selected for Milestone One. It is recommended that you use the scatter plot chart (visualization) in Excel and display the trendline, equation, and R2 value on the visualization.

Specifically, you must address the following rubric criteria:

1. Create two bivariate regressions using Excel.
   • Use the to complete this step. This workbook contains your work from previous modules.

Bivariate Regression for Flavor One:

• Use the Flavor One Bivariate Regression sheet to create and place your bivariate regression models.
• Create a bivariate regression model: the dependent variable is Quantity Sold and the independent variable is Advertising Expenses.

Bivariate Regression for Flavor Two:

• Use the Flavor Two Bivariate Regression sheet to create and place your bivariate regression models.
• Create a Bivariate regression model: the dependent variable is Quantity Sold and the independent variable is Advertising Expenses.

1. Use the Module Four PowerPoint Template to create a presentation explaining the results of the bivariate regressions. This should include key visualizations and analysis to support your answers. The template includes specific questions to answer. Use the bivariate regression models from the Flavor One Bivariate Regression and Flavor Two Bivariate Regression sheets to support your analysis.

What to Submit

• TC Ice Cream Excel Workbook: Submit the . For this assignment, work should be completed in the Flavor One Bivariate Regression and Flavor Two Bivariate Regression sheets. Do not remove any worksheets from the workbook.
• PowerPoint Presentation: Submit a PowerPoint presentation using the . If references are included, they should be cited in APA format. Consult the for more information on citations.

Module Four Excel Workbook Rubric

Criteria	Exceeds Expectations (100%)	Meets Expectations (90%)	Partially Meets Expectations (70%)	Does Not Meet Expectations (0%)	Value
Bivariate Regression: Flavor One	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Performs bivariate regression accurately for the given data set	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include aligning the independent and dependent variables correctly to perform the regression	Does not attempt criterion	30
Bivariate Regression: Flavor Two	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Performs bivariate regression accurately for the given data set	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include aligning the independent and dependent variables correctly to perform the regression	Does not attempt criterion	30
PowerPoint Presentation: Explanation of Regression Results	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Explains the results of the bivariate regressions performed and provides an accurate analysis using the questions provided	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include explaining the results of the bivariate regressions performed and providing an accurate analysis using the questions provided	Does not attempt criterion	30
Clear Communication	Exceeds expectations with an intentional use of language that promotes a thorough understanding	Consistently and effectively communicates in an organized way to a specific audience	Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding	Shows no evidence of consistent, effective, or organized communication	10