Financial Management- Forecasting

Financial Management- Forecasting

Excel spreadsheet and 2 page paper

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Assignment 1

SAMPLE COMPANY
Risk Ranking (pg. 26) Risk Name (10-K Annual Report, Other) Description of the risk Risk Profile (Pg. 28) Mitigation Plan (Pg 30)
1 – highest severity/frequency (on the list on my table) License Renewals Forecasts of revenue are based on customers renewing their software license contracts. If price increases, customer service drops, or competition increases, then renewals and revenue will decrease. Financial Risk. Could also be partly operational, strategic, industry, or brand Take internal actions to mitigate the risk. This risk cannot be accepted or transferred. Internal actions include enuring that our pricing reflects market competition and customer expectations, that our products are meeting requirements, that our customer service is providing the highest level support, that we identify clients that are at risk of not renewing and actions are taken.
COMPANY 1 NAME HERE
Risk Ranking (pg. 26) Risk Name (10-K Annual Report, Other) Description of the risk Risk Profile (Pg. 28) Mitigation Plan (Pg 30)
COMPANY 2 NAME HERE
Risk Ranking (pg. 26) Risk Name (10-K Annual Report, Other) Description of the risk Risk Profile (Pg. 28) Mitigation Plan (Pg 30)

&”Calibri Bold,Bold”&14&K000000&A

&”Calibri,Regular”&K000000&D &”Calibri,Regular”&K000000&F &”Calibri,Regular”&K000000&P

Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in the Assignment Part B submission. Insert the name of the company in the “Company 1 or Company 2” headings so we know which company is being reviewed. 2. The template uses the terminology in the CFO Guidebook chapter on Risks. 3. Risks of the company are disclosed in the annual 10-K report section Item 1A Risk Factors. Use the risks in the 10-K as your basis for your template. You can also get additional risks from the Morningstar Analyst Report, or from news articles about the company. Try to narrow down the laundry list of risks to a few unique (only applies to one company but not the other) and major risks. 4. There is no “magic” number of risks to be included in your template. Try to aim for 3-5 risks per company to compare and analyze. Pick the risks. 5. You can delete extra rows, or add rows. You can also change the font size and the column widths. Keep the headings standard. While not a requirement, if you believe an additional column is required to better describe/classify your risks, then add it. 6. While not a requirement, you can copy/paste the Excel completed table as a picture to your Word document if it makes it easier to reference in your analysis and recommendations.

Assignment 2

COMPANY 1 NAME HERE COMPANY 2 NAME HERE
Morningstar Analyst Report 2017 2018 2017 2018
Valuation
Price/Sales
Price/Earnings
Price/Book
Earnings Yield %
Growth
Revenue %
Operating income %
Net Income %
Financial Health
Quick Ratio
interest Coverage
Debt/Equity
Profitability
ROA
ROE
ROIC
Net margin %

&”Calibri Bold,Bold”&14&K000000&A

&”Calibri,Regular”&K000000&D &”Calibri,Regular”&K000000&F &”Calibri,Regular”&K000000&P

Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in the Assignment Part B submission. Insert the name of the company in the “Company 1 or Company 2” headings so we know which company is being reviewed. 2. The template uses the ratio terminology in the CFO Guidebook. We have also provided you with a Course Ratio Checklist you can use to understand what the ratios mean and how they are calculated. Please use Current Year ratios as the base ratios. For example, the most recent full year. 3. Ratios for the companies are included in the Morningstar analyst report provided in the course. Some ratios are also provided in the 10-K Annual Report, from online sources, or can be calculated – but for this exercise you can use the Morningstar analyst report as you primary source. 4. Do not delete ratios from the table. There is no requirement to add extra ratios, unless your believe there are othe ratios that best helps you describe the performance impacting the valuation of the companies. More is not necessarily better – we are looking for quality over quantity. 5. The ratios in this execrcise are based on historical performance. When comparing the ratios of the two companies side-by-side, you will notice differences. One company may seem to have performed better – we are looking for your insight for that difference in performance. 6. You can also change the font size and the column widths. Keep the headings standard. While not a requirement, if you believe an additional column is required to better describe/classify your risks, then add it. 7. While not a requirement, you can copy/paste the Excel completed table as a picture in your Word document if it makes it easier to reference in your analysis and recommendations.

Assignment 3

COMPANY 1 NAME HERE COMPANY 2 NAME HERE
Morningstar Analyst Report Data 2017 2018 Forecast (optional) 2017 2018 Forecast (optional)
Income Statement
Revenue (Bil)
Operating Income (Bil)
Net Income (Bil)
Operating Performance
Gross Margin %
Operating Margin %
Net Margin %
Days Sales Outstanding
Days Inventory
Days Payables
Receivables Turnover
Inventory Turnover
Fixed Asset Turnover
Total Asset Turnover

&”Calibri Bold,Bold”&14&K000000&A

&”Calibri,Regular”&K000000&D &”Calibri,Regular”&K000000&F &”Calibri,Regular”&K000000&P

Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in the Assignment Part B submission. Insert the name of the company in the “Company 1 or Company 2” headings so we know which company is being reviewed. 2. You will be reviewing the financial data from various years looking for trends. 3. The template uses the ratio terminology in the CFO Guidebook. We have also provided you with a Course Ratio Checklist you can use to understand what the ratios mean and how they are calculated. 4. Ratios for the companies are included in the Morningstar analyst report provided in the course. Some ratios are also provided in the 10-K Annual Report, from online sources, or can be calculated – but for this exercise you can use the Morningstar analyst report as you primary source. 5. Do not delete ratios from the table. There is no requirement to add extra ratios, unless your believe there are othe ratios that best helps you describe the performance impacting the forecast of the companies. More is not necessarily better – we are looking for quality over quantity. 6. When comparing the forecasts of the two companies side-by-side, you will notice differences. One company may seem to have better trends – we are looking for your insight of the difference in performance. 7. You can also change the font size and the column width. Keep the headings standard. 8. While not a requirement, you can copy/paste the Excel completed table as a picture in your Word document if it makes it easier to reference in your analysis and recommendations.