Home
0
Home
Use Landscape to see Search/Filter
Item Types:
Field of Study:
Authors:
CPE Hours:
Keyword:
Hide left panel Collapse Menu
Show left panel
Recent Searches
No recent searches found.
A~B
Similar Courses

A new location is a major commitment of time and money with the potential to expand a company’s business and increase profits. New locations also come with risks. Sales may be lower than expected while costs are higher. The new location may pull more resources from existing operations and strategy than anticipated. Could we have better anticipated this?

In this course, I’ll:

  • Explore some of the key financial considerations when opening a new location.
  • Describe how to project common revenue and expense items for a new location.
  • Explain how to build a net contribution and cash flow forecast.
  • Illustrate analysis methods like breakeven analysis and scenario analysis
  • Demonstrate scenario analysis and sensitivity analysis with Excel’s Goal Seek, Scenario Manager, and Data Table functions
  • Define common metrics like NPV, IRR, and Time to Breakeven. I’ll show multiple ways to analyze this in Excel. For Excel gurus, you can do this yourself. For others, this gives you an idea of what an accountant, analyst, or consultant can do for you.
  • Reveal common decision mistakes people make when analyzing new locations and how to avoid these mistakes.

This course is focused on the financial analysis of the location and how a new location fits financially into a company’s larger strategy. Some things I don’t cover or don’t cover in detail in this course:

  • Merger and Acquisition (M&A) Analysis
  • Analyzing where to locate the store or new location
  • Detailed financial accounting entries and financial statement disclosure
  • Tax considerations and treatment. I will briefly mention some relevant tax items like cost segregation studies.
Analyzing Whether to Add New Locations - Capital Budgeting (4 Hrs)
A/B
Suggested Courses

A new location is a major commitment of time and money with the potential to expand a company’s business and increase profits. New locations also come with risks. Sales may be lower than expected while costs are higher. The new location may pull more resources from existing operations and strategy than anticipated. Could we have better anticipated this?

In this course, I’ll:

  • Explore some of the key financial considerations when opening a new location.
  • Describe how to project common revenue and expense items for a new location.
  • Explain how to build a net contribution and cash flow forecast.
  • Illustrate analysis methods like breakeven analysis and scenario analysis
  • Demonstrate scenario analysis and sensitivity analysis with Excel’s Goal Seek, Scenario Manager, and Data Table functions
  • Define common metrics like NPV, IRR, and Time to Breakeven. I’ll show multiple ways to analyze this in Excel. For Excel gurus, you can do this yourself. For others, this gives you an idea of what an accountant, analyst, or consultant can do for you.
  • Reveal common decision mistakes people make when analyzing new locations and how to avoid these mistakes.

This course is focused on the financial analysis of the location and how a new location fits financially into a company’s larger strategy. Some things I don’t cover or don’t cover in detail in this course:

  • Merger and Acquisition (M&A) Analysis
  • Analyzing where to locate the store or new location
  • Detailed financial accounting entries and financial statement disclosure
  • Tax considerations and treatment. I will briefly mention some relevant tax items like cost segregation studies.
Analyzing Whether to Add New Locations - Capital Budgeting (4 Hrs)
Recent Searches
No recent searches found.
Similar Courses

A new location is a major commitment of time and money with the potential to expand a company’s business and increase profits. New locations also come with risks. Sales may be lower than expected while costs are higher. The new location may pull more resources from existing operations and strategy than anticipated. Could we have better anticipated this?

In this course, I’ll:

  • Explore some of the key financial considerations when opening a new location.
  • Describe how to project common revenue and expense items for a new location.
  • Explain how to build a net contribution and cash flow forecast.
  • Illustrate analysis methods like breakeven analysis and scenario analysis
  • Demonstrate scenario analysis and sensitivity analysis with Excel’s Goal Seek, Scenario Manager, and Data Table functions
  • Define common metrics like NPV, IRR, and Time to Breakeven. I’ll show multiple ways to analyze this in Excel. For Excel gurus, you can do this yourself. For others, this gives you an idea of what an accountant, analyst, or consultant can do for you.
  • Reveal common decision mistakes people make when analyzing new locations and how to avoid these mistakes.

This course is focused on the financial analysis of the location and how a new location fits financially into a company’s larger strategy. Some things I don’t cover or don’t cover in detail in this course:

  • Merger and Acquisition (M&A) Analysis
  • Analyzing where to locate the store or new location
  • Detailed financial accounting entries and financial statement disclosure
  • Tax considerations and treatment. I will briefly mention some relevant tax items like cost segregation studies.
Analyzing Whether to Add New Locations - Capital Budgeting (4 Hrs)
Suggested Courses

A new location is a major commitment of time and money with the potential to expand a company’s business and increase profits. New locations also come with risks. Sales may be lower than expected while costs are higher. The new location may pull more resources from existing operations and strategy than anticipated. Could we have better anticipated this?

In this course, I’ll:

  • Explore some of the key financial considerations when opening a new location.
  • Describe how to project common revenue and expense items for a new location.
  • Explain how to build a net contribution and cash flow forecast.
  • Illustrate analysis methods like breakeven analysis and scenario analysis
  • Demonstrate scenario analysis and sensitivity analysis with Excel’s Goal Seek, Scenario Manager, and Data Table functions
  • Define common metrics like NPV, IRR, and Time to Breakeven. I’ll show multiple ways to analyze this in Excel. For Excel gurus, you can do this yourself. For others, this gives you an idea of what an accountant, analyst, or consultant can do for you.
  • Reveal common decision mistakes people make when analyzing new locations and how to avoid these mistakes.

This course is focused on the financial analysis of the location and how a new location fits financially into a company’s larger strategy. Some things I don’t cover or don’t cover in detail in this course:

  • Merger and Acquisition (M&A) Analysis
  • Analyzing where to locate the store or new location
  • Detailed financial accounting entries and financial statement disclosure
  • Tax considerations and treatment. I will briefly mention some relevant tax items like cost segregation studies.
Analyzing Whether to Add New Locations - Capital Budgeting (4 Hrs)
Course Details

Techniques of Financial Analysis, Modeling, and Forecasting - v13 (Course Id 1760)

Updated / QAS / Registry
  Add to Cart 
Author : Jae K. Shim, Ph.D., CPA
Course Length : Pages: 206 ||| Review Questions: 54 ||| Final Exam Questions: 65
CPE Credits : 13.0
IRS Credits : 0
Price : $107.95
Passing Score : 70%
Course Type: NASBA QAS - Text - NASBA Registry
Technical Designation: Technical
Primary Subject-Field Of Study:

Finance - Finance for Course Id 1760

Description :

This comprehensive course gives you every sales and financial forecasting formula and modeling techniques you need to analyze your operation both as a whole and by segment. You'll be provided with proven techniques that help you identify and fix problem areas, analysis techniques that help you evaluate proposals for profit potential, proven methods that improve the accuracy of your short- and long-term forecasting, analysis tools that help you better manage working capital, cash, and accounts receivable, plus much more. You also receive dozens of worked-out models and modeling techniques that simplify your most difficult business decisions and are easy to adapt to any computer spreadsheet program. This course supplies company accountants, treasurers, CFOs with all the forecasting techniques needed to financially analyze a business as a whole or a segment. Includes analysis techniques, methods for improving forecasting accuracy, analysis tools for managing capital, and more.

Usage Rank : 25769
Release : 2023
Version : 1.0
Prerequisites : None.
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Advance Preparation : None.
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 26-Aug-2023
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - Text - NASBA Registry - 1760

Keywords : Finance, Techniques, Financial, Analysis, Modeling, Forecasting, v13, cpe, cpa, online course
Learning Objectives :

Chapter 1
Break-Even and Contribution Margin Analysis

After completing this section, you should be able to:
    1. Recognize how costs and revenues affect Cost-Volume-Profit (CVP) analysis.
    2. Compute break-even levels for various scenarios.
    3. Recognize the margin of safety and cash break-even point.

Chapter 2
Understanding and Applying the Time Value of Money Concept

After completing this section, you should be able to:
    1. Recognize the time value of money and how it affects financial decisions.
    2. Calculate the present value of future payments.

Chapter 3
How to Assess Capital Expenditure Proposals for Strategic Decision Making

After completing this section, you should be able to:
    1. Recognize the purpose and use of the capital budget.
    2. Calculate investment payback periods.
    3. Recognize the use for the internal rate of return (IRR) calculations.
    4. Identify the best methods for making long-range investment decisions.

Chapter 4
Analyzing Financial Statements for Financial Fitness

After completing this section, you should be able to:
    1. Recognize a comprehensive set of financial ratios and interpret them.
    2. Recognize the operating cycle of a business.

Chapter 5
Analyzing Quality of Earnings and Using Variance Analysis for Cost Control

After completing this section, you should be able to:
    1. Recognize different characteristics relating to a firm’s quality of earnings.
    2. Identify the relationships between auditing and internal controls.
    3. Recognize why standard costing is important it is for managerial control.
    4. Distinguish among three types of responsibility centers and how they are evaluated.
    5. Calculate different types of variances for manufacturing costs.
    6. Recognize the managerial significance of these variances.
    7. Identify the need for a flexible budget.

Chapter 6
Analysis of Segmental Performance and Profit Variance

After completing this section, you should be able to:
    1. Recognize how to calculate different variances for the price, volume, and sales mix.

Chapter 7
Evaluating Divisional Performance

After completing this section, you should be able to:
    1. Compute return on investment (ROI) by means of the Du Pont formula and show how changes in sales, expenses, and assets affect the investment center's performance.
    2. Calculate the residual income (RI) and profit margin based on ROI.
    3. Identify how ROI and RI measures affect the division's investment decision.

Chapter 8
Analyzing Working Capital

After completing this section, you should be able to:
    1. Recognize aspects affecting cash management and working capital.
    2. Recognize ways to improve profitability by changes to accounts receivable.
    3. Identify how changes in inventory carrying costs affect the organization.

Chapter 9
Corporate Investments

After completing this section, you should be able to:
    1. Recognize accounting aspects and terms for an investment portfolio.
    2. Identify ways to compare risk versus return.
    3. Recognize tools for fundamental and technical analysis.
    4. Recognize the benefits of portfolio theory with regard to investment decisions.

Chapter 10
Obtaining Funds: Short-Term and Long-Term Financing

After completing this section, you should be able to:
    1. Compute the cost of capital.
    2. Distinguish between short-term, intermediate-term, and long-term financing sources

Chapter 11
Analyzing Mergers And Acquisitions

After completing this section, you should be able to:
    1. Identify different types of mergers.
    2. Recognize ways to acquire another business.

Chapter 12
Forecasting and Financial Planning

After completing this section, you should be able to:
    1. Recognize the objectives of forecasts.
    2. Identify different types of qualitative and quantitative forecasting methods.
    3. Recognize quantitative forecasting models and techniques.

Chapter 13
Financial Forecasting and Budgeting tools

After completing this section, you should be able to:
    1. Recognize assumptions of forecasting with the percent of sales method.
    2. Identify major steps in budgeting and financial planning.
    3. Identify the requirements of zero-base budgeting.
    4. Recognize the value of the Lagged Regression Approach and Markov model in evaluating collection and bad debt.

Chapter 14
How to use Corporate Planning Models

After completing this section, you should be able to:
    1. Identify reasons for corporate modeling.
    2. Recognize components of an integrated planning model.
    3. Recognize the application and uses of financial models.

Chapter 15
Optimization Techniques, Financial Modeling and Executive Training

After completing this section, you should be able to:
    1. Recognize techniques for optimization including linear programming.
    2. Differentiate between methods of optimization.
    3. Recognize the disadvantages of optimization models.
    4. Recognize uses and variables for the bankruptcy prediction model.
    5. Identify the purpose of executive management games.
Course Contents :

Chapter 1:    Break-Even and Contribution Margin Analysis

Learning Objectives:

Cost-Volume-Profit Analysis

Operating Leverage

Sales Mix Analysis

Contribution Margin Analysis

Conclusion

Chapter 1 Review Questions

Chapter 2:    Understanding and Applying the Time Value of Money Concept

Learning Objectives:

Assumptions of Present Value and Future Value Techniques

Conclusion

Chapter 2 Review Questions

Chapter 3:    How to Assess Capital Expenditure Proposals for Strategic Decision Making

Learning Objectives:

Capital Budgeting Methods

Risk Analysis in Capital Budgeting

Conclusion

Chapter 3 Review Questions

Chapter 4:   Analyzing Financial Statements for Financial Fitness

Learning Objectives:

Who Uses Financial Analysis

Financial Statement Analysis

Ratio Analysis

Conclusion - Limitations of Ratio Analysis

Chapter 4 Review Questions

Chapter 5:    Analyzing Quality of Earnings and Using Variance Analysis for Cost Control

Learning Objectives:

Quality Of Earnings

Variance Analysis for Cost Control

Responsibility Accounting and Responsibility Center

Standard Costs and Variance Analysis

General Model for Variance Analysis

Flexible Budgets and Performance Reports

Nonfinancial Performance Measures

Conclusion

Chapter 5 Review Questions

Chapter 6:    Analysis of Segmental Performance and Profit Variance

Learning Objectives:

Profit Variance Analysis

Sales Mix Analysis

Conclusion

Chapter 6 Review Questions

Chapter 7:    Evaluating Divisional Performance

Learning Objectives:

Rate of Return on Investment (ROI)

ROI and Profit Planning

Residual Income (RI)

Investment Decisions under ROI and RI

Conclusion

Chapter 7 Review Questions

Chapter 8:    Analyzing Working Capital

Learning Objectives:

Evaluating Working Capital

Cash Management

Management Of Accounts Receivable

Inventory Management

Conclusion

Chapter 8 Review Questions

Chapter 9:    Corporate Investments

Learning Objectives:

Accounting Aspects

Analytical Implications

Obtaining Information

Risk versus Return

Financial Assets

Real Assets

Portfolio Analysis

Mutual Funds and ETFs

Fundamental Analysis

Technical Analysis

Conclusion

Chapter 9 Review Questions

Chapter 10:    Obtaining Funds: Short-Term and Long-Term Financing

Learning Objectives:

Financial Planning

Short-Term Financing

Intermediate-Term Financing: Term Loans and Leasing

Types of Long-Term Debt

Cost of Capital

Conclusion

Chapter 10 Review Questions

Chapter 11:    Analyzing Mergers And Acquisitions

Learning Objectives:

Mergers

Deciding on Acquisition Terms

Acquisition of Another Business

Impact of Merger on Earnings per Share and Market Price per Share

Risk

Holding Company

Conclusion

Chapter 11 Review Questions

Chapter 12:    Forecasting and Financial Planning

Learning Objectives:

Who Uses Forecasts?

Forecasting Methods

Selection of Forecasting Method

The Qualitative Approach

Common Features and Assumptions Inherent in Forecasting

Quantitative Forecasting Methodologies

Smoothing Techniques

Decomposition of Time Series

Regression and the Least-Squares Method

Trend Analysis

Multiple Regression

Measuring Accuracy of Forecasts

Forecasting Sales with the Markov Model

Summary of Forecasting Methods

Conclusion

Chapter 12 Review Questions

Chapter 13:    Financial Forecasting and Budgeting tools

Learning Objectives:

Forecasting External Financing Needs--The Percent-of-Sales Method

Budgeting and Financial Planning

How the Budget Works: An Example

Zero Base Budgeting

Forecasting Cash Flows

Conclusion

Chapter 13 Review Questions

Chapter 14:    How to use Corporate Planning Models

Learning Objectives:

Types of Analysis

Typical Questions Addressed via Corporate Modeling

Types of Models

Current Trends in Modeling

The Future of Corporate Planning Models

Financial Models

Applications and Uses of Financial Modeling

Putting Financial Modeling into Practice

Quantitative Methods Used in Financial Models

Developing Financial Models

Model Specification

Conclusion

Chapter 14 Review Questions

Chapter 15:    Optimization Techniques,  Financial Modeling and Executive Training

Learning Objectives:

Use of Linear Programming

Use of Goal Programming (GP)

Spreadsheet Modeling

Forecasting Financial Distress with Z Score

Training with Management Games

Conclusion

Chapter 15 Review Questions

Glossary

Click to go to: Chief Financial Officer (CFO) Training Courses/Programs Online
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
  
Exam completed on .

Do you want to add the course again?