Boston College Budgeting and Forecasting Worksheet The Company I need to write about is the AT&T11111111111111111111111111111111111111111111 Ques Budgeting
Boston College Budgeting and Forecasting Worksheet The Company I need to write about is the AT&T11111111111111111111111111111111111111111111 Ques
Budgeting and Forecasting
You are graduating from Hult and you have an interview with
Office Interview at
FP&A vs. other dept
dollars in millions
Total Current Assets
Net fixed assets
Accounts payable and accrued
Short term loans
Total current liabilities
Other operating non-current
total long term liabilities
3. Forecasted Financial Statements
Common stock (300mil
Total shareholders’ equity
Total liabilities and equity
Fill out the areas in buff/beige. Do not use other
cells, we may miss it in grading!
2 “Thank you for coming In to meet with us today. What is the difference
between Financial Planning and Analysis and on of our other departments:
2 Why does a strong FP&A professional need to know more than finance and accounting
2 FP&A professionals may be assigned to work with line managers. Why would you
be able to help a line manager of a functional areas , for example:
2 You may be asked to assist our Corporate Development in their investigation, negotiat
and integration plans for an acquisition. What are examples of what value you can add
5 2.5 We believe in setting SMART goals to support key goals and objectives for the compan
Our board and senior management have just determined that for
we need to provide some SMART goals shared with inside and outside people to
Give an example of a SMART goal and how it qualifies under S, M, A, R, and T
2 In addition to technical financial skills, our FP&A staff need to be well versed in the are
of project management and leadership. Explain the value of the
for effective project management
3 We set goals, create measures, track actual results, then do “after action” reports
and meetings. If you were in charge of one such meeting with the key participants,
what would be three topics for your discussion?
3 Every company has its own unique portfolio of business. Pick one of the major busines
for our company and first describe if it is a cash cow, star, question mark or dog, and w
Then give a plausible strategy given that business unit’s position and your overall
assessment of the corporate portfolio.
What is the difference between financial and managerial accounting. Give an example
2 would see in managerial accounting that would not be seen in financial reports.
10 7.5 Fill in the information for your selected company below. Then compute and interpret
ratios for the most recent 2 years
Total Revenues (aka Sales)
Total shareholders’ equity
Operating Margin = operating income/total revenues
Return on Assets = net income/sales
Days Sales Outstanding = ( Accounts Receivable)/(Sales/365)
2 During the construction of the model, there are inevitable variables that are not certai
vague. Describe what you can do when you build your model and as you proceed with
finalizing and presenting your model to senior management. For full credit, specify tw
after you make your assumption
Excel Hygiene – Review the Excel Worksheet on the left with errors and violations of “b
4 a corrected Excel sheet below
4 Sensitivity analysis
Use the model (on the left), and create a sensitivity analysis based on the gross margi
Copy the model to the area below, then calculate and present your sensitivity analysis
10 Refer to the data for daily units sold on the left. Compute the indicated statistical mea
number of days corresponding to 80% of sales
Total sales for the 80%
Percentage of days to reach 80%
Does this correspond to the “80/20″ rule?
3 Our company is striving for excellence throughout our company. I would expect you to
in our training, measurements, and implementation of the technique
What is this and what benefits should we see? Provide one metric than we can use as
and after” so we can demonstrate the improvements.
5 Our human resources department is currently allocating based on headcount.
Most of the costs of the department are the people in HR, who support all department
We asked HR for some measurements based on their tracking for a month. These are
What do you think of the allocation method used now? Suggest an alternative and wh
total cost of HR
headcount payroll processed by department
comment on current method
why this is better
3 Everyone in our sales department has difficulty estimating sales, we did some analysis
then asked the sales managers for opinions. Here is an example of our approach.
Do you analysis and tell me what you expect sales will be this year.
5 We have a traditional reporting process. I hear you are an expert in On Demand Busin
Can you compare the Traditional with DBO?
Budget vs Actual
Reporting – frequency
How many months
ahead do you see, as
the year progresses
4 I volunteer as a board member for the Albany School District. Look at the reporting lin
the Director of Student Services, Carrie Nerheim. Describe the idea of budgeting levels
to prepare a budget, who approves. And once the year begins, who gets monthly repo
responsible for explaining variances. For full credit explain Carrie’s line below her and
no any other parts of the organization!
3 When we meet with Carrie, we should explain incremental budgeting and zero based b
How would you describe those two approaches? Explain which she should use and wh
4 One of our main contributions is our work on capital investments. Analyze the project
compute the NPV, IRR, PI and Payback for both. The required rate of return is 15% for
HINT: analyze A first, then you may be able to copy and paste to get almost all of B do
3 Give the pros and cons of Project A and B. Which would you recommend and why?
Recommendation and why:
2 In a different set of assessments, on Project C and D, you find that Project C is riskier t
how can you modify your approach analytically?
2 Describe how you can use Real Options to improve the expected returns and manage r
in a project.
10 Use the information to the left and determine the value of equity and the price per sha
cost of capital
long term growth%
tax rate =
4 Integrated Reporting
a) How does it differ from traditional financial reporting (10-K, annual reports)?
b) What are the 6 capitals?
c) Who is the audience for this reporting?
d) Why are reasons it has not been more widely adopted?
4 For your company, define 8 KPIs that are in the spirit of Balanced Scorecard, Net Impac
You answer will be graded based on its breadth (goals measured) and depth (quality of
how would you determine this
100 total points possible
Do not use other
at is the difference
r other departments:
more than finance and accounting?
managers. Why would you
nt in their investigation, negotiation
amples of what value you can add?
ls and objectives for the company
side and outside people to increase sales
under S, M, A, R, and T
need to be well versed in the area
en do “after action” reports
ting with the key participants,
ss. Pick one of the major business units
tar, question mark or dog, and why.
‘s position and your overall
rial accounting. Give an example of something we
e seen in financial reports.
w. Then compute and interpret the specified
able variables that are not certain and
r model and as you proceed with your
ement. For full credit, specify two actions
ft with errors and violations of “best practices” and put
nalysis based on the gross margin
present your sensitivity analysis (+/- 30%)
pute the indicated statistical measures
company. I would expect you to help
e one metric than we can use as a: before
ng based on headcount.
HR, who support all departments and people.
tracking for a month. These are their results
w? Suggest an alternative and why it is better
Hrs from timesheets
ating sales, we did some analysis,
n example of our approach.
be this year.
e an expert in On Demand Business Outlooks.
District. Look at the reporting line for
cribe the idea of budgeting levels – i.e. who has
ar begins, who gets monthly reports and who is
plain Carrie’s line below her and who she reports to,
ental budgeting and zero based budgeting.
ain which she should use and why.
nvestments. Analyze the projects below and
equired rate of return is 15% for each project.
nd paste to get almost all of B done.
uld you recommend and why?
you find that Project C is riskier than Project D
e expected returns and manage risk
ue of equity and the price per share (caution: this is a time consuming and challenging question!)
ng (10-K, annual reports)?
of Balanced Scorecard, Net Impact, and/or Integrated Reporting
measured) and depth (quality of the KPI).
Category (Bal. Scorecard, 3Ps, IR)
Purchase answer to see full