Question

In: Finance

1.What are the roles of financial specialists in a corporation 2.What is a risk 3. 3...

1.What are the roles of financial specialists in a corporation
2.What is a risk
3. 3 dimensions of risk transfer
4.Risk management techniques
5.ways of constructing a financial planning model

Solutions

Expert Solution

Answer:

1.Primary job role of a Financial Specialist in a corporation is to:

  • Analyze financial data for the purpose of identifying company’s financial standing
  • Conduct benchmarking and cost analysis
  • Prepare budgets and keep record

2. In broad terms, risk involves exposure to some type of danger and the possibility of loss or injury. In general, risks can apply to your physical health or job security. In finance and investing, risk often refers to the chance an outcome or investment's actual gains will differ from an expected outcome or return. Risk includes the possibility of losing some or all of an original investment.

3. Three dimensions of risk transfer are hedging, insuring and diversifying.

One is said to hedge a risk when the action taken to reduce one’s exposure to a loss also causes one to give up of the possibility of a gain. For example, farmers who sell their future crops before the harvest at a fixed price to eliminate the risk of a low price at harvest time also give up the possibility of profiting from high prices at harvest time. So, they are hedging their exposure to the price risk of their crops.

Insuring means paying a premium (the price paid for the insurance) to avoid losses. By buying insurance, you substitute a sure loss (the premium you pay for the policy) for the possibility of a larger loss if you do not insure. For example, if you own a car, you almost surely have bought some insurance against the risks of damage, theft, and injury to yourself and others. The premium may be $1,000 today to insure your car for the next year against the potential losses stemming from these contingencies. The sure loss of $1,000 is substituted for the possibility of losses that can run to hundreds of thousands of dollars.

Diversifying means holding similar amounts of many risky assets instead of concentrating all of your investment in only one. Diversification thereby limits your exposure to the risk of any single asset.

4. There are a variety of techniques that organizations will use during the identification process to establish solid risk management strategies. The following are a few examples of how people identify corporate risk:

  • Brainstorming
  • Interviews and self-assessments
  • Risk surveys
  • Event inventories or loss data
  • Facilitated workshops
  • Root cause and Checklist analysis
  • SWOT analysis
  • Influence diagrams
  • Expert judgement
  • Assumption analysis

5. Financial modeling is an iterative process. You have to chip away at different sections until you’re finally able to tie it all together.

Below is a step-by-step breakdown of where you should start and how to eventually connect all the dots.

1. Historical results and assumptions

Every financial model starts with a company’s historical results. You begin building the financial model by pulling three years of financial statements and inputting them into Excel. Next, you reverse engineer the assumptions for the historical period by calculating things like revenue growth rate, gross margins, variable costs, fixed costs, AP days, inventory days, and AP days, to name a few. From there you can fill in the assumptions for the forecast period as hard-codes.

2. Start the income statement

With the forecast assumptions in place, you can calculate the top of the income statement with revenue, COGS, gross profit, and operating expenses down to EBITDA. You will have to wait to calculate depreciation, amortization, interest, and taxes.

3. Start the balance sheet

With the top of the income statement in place, you can start to fill in the balance sheet. Begin by calculating accounts receivable and inventory, which are both functions of revenue and COGS, as well as, the AR days and inventory days assumptions. Next, fill in accounts payable which is a function of COGS and AP days.

4. Build the supporting schedules

Before completing the income statement and balance sheet you have to create a schedule for capital assets like Property, Plant & Equipment (PP&E), as well as, for debt and interest. The PP&E schedule will pull from the historical period and add capital expenditures and subtract depreciation. The debt schedule will also pull from the historical period and add increases in debt and subtract repayments. Interest will be based on the average debt balance.

5. Complete the income statement and balance sheet

The information from the supporting schedules completes the income statement and balance sheet. On the income statement, link depreciation to the PP&E schedule and interest to the debt schedule. From there you can calculate earnings before tax, taxes, and net income. On the balance sheet link the closing PP&E balance and closing debt balance from the schedules. Shareholder’s equity can be completed by pulling forward last year’s closing balance, adding net income and capital raised, and subtracting dividends or shares repurchased.

6. Build the cash flow statement

With the income statement and balance sheet complete, you can build the cash flow statement with the reconciliation method. Start with net income, add back depreciation, and adjust for changes in non-cash working capital, which results in cash from operations. Cash used in investing is a function of capital expenditures in the PP&E schedule, and cash from financing is a function of the assumptions that were laid out about raising debt and equity.

7. Perform the DCF analysis

When the 3 statement model is completed it’s time to calculate free cash flow and perform the business valuation. The free cash flow of the business is discounted back to today at the firm’s cost of capital (its opportunity cost or required rate of return). We offer a full suite of courses that teach all of the above steps with examples, templates, and step-by-step instruction. Read more about how to build a DCF model.

8. Add sensitivity analysis and scenarios

Once the DCF analysis and valuation sections are complete, it’s time to incorporate sensitivity analysis and scenarios into the model. The point of this analysis is to determine how much the value of the company (or some other metric) will be impacted by changes in underlying assumptions. This is very useful for assessing the risk of an investment or for business planning purposes (i.e. does the company need to raise money if sales volume drops by x percent?).

9. Build charts and graphs

Clear communication of results is something that really separates good from great financial analysts. The most effective way to show the results of a financial model is through charts and graphs, which we cover in detail in our advanced Excel course, as well as many of the individual financial modeling courses. Most executives don’t have the time or patience to look at the inner workings of the model, so charts are much more effective.

10. Stress test and audit the model

When the model is done your work is not over. Next, it’s time to start stress-testing extreme scenarios to see if the model behaves as expected. It’s also important to use the auditing tools covered in our financial modeling fundamentals course to make sure it’s accurate and the Excel formulas are all working properly.


Related Solutions

what are the roles and responsibilities of a financial manager?
what are the roles and responsibilities of a financial manager?
1. Define risk. 2. List FIVE (5) types of risk and their examples. 3. What do...
1. Define risk. 2. List FIVE (5) types of risk and their examples. 3. What do you understand with risk management? 4. Give FIVE (5) reasons why do we need crisis management in our organization. 5. Give THREE (3) differences between crisis prone company and crisis prepared company (in table form) 6. List FIVE (5) features of crisis. 7. Briefly explain FIVE (5) consequences of risk and crisis.
1. What should be the goal of the financial manager of a corporation? Why? 2. If...
1. What should be the goal of the financial manager of a corporation? Why? 2. If the corporate form of business organization has so many advantages over the corporate form, why is it so common for small businesses to initially be formed as sole proprietorships? 3. One thing lender sometimes require when lending money to a small corporation is an assignment of the common stock as collateral on the loan. Then, if the business fails to repay its loan, the...
What organizations are responsible for governing financial reporting? What are their roles? How have the roles...
What organizations are responsible for governing financial reporting? What are their roles? How have the roles changed in the last 20 years? How will their roles change in the next 20 years?
1. what are the advantages of investing in a mutual fund 2. what are the roles...
1. what are the advantages of investing in a mutual fund 2. what are the roles of sponsor, trustee and AMC
Discuss the typical roles and responsibilities of a Chief Risk Officer within a financial institution and...
Discuss the typical roles and responsibilities of a Chief Risk Officer within a financial institution and why this position has become more important to firms in recent years specifically due to cyber risk.  
On international financial crises: 2. What are interest rate risk, credit risk and exchange rate risk?
On international financial crises: 2. What are interest rate risk, credit risk and exchange rate risk?
1. What is the audit risk model? 2. Identify and explain the 3 basic components of...
1. What is the audit risk model? 2. Identify and explain the 3 basic components of audit risks in the audit risk model. Please post 1 page.
1- What is Financial development Importance ? 2- What affects financial development? 3- How can you...
1- What is Financial development Importance ? 2- What affects financial development? 3- How can you examine Financial development ? Please give me as much as of detailed answer as possible
Describe 2-3 risks that has been identified for a EMR project Financial Risk Technical Risk Commercial...
Describe 2-3 risks that has been identified for a EMR project Financial Risk Technical Risk Commercial Risk Execution Risk Contractual or Legal Risk What steps could you take to prevent or mitigate these risks? There is no more information
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT