Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have seen a typical structure for a common type of pro forma model in the DG RX model. Develop the structure and the specific

You have seen a typical structure for a common type of pro forma model in the DG RX model. Develop the structure and the specific variables for the Dollar General Solar Panel project. I want no numerical estimates and no numbers; I only want the specific variable you are including in your model and then I need to see that you have structured your model's variables to be ready to compute free cash flow (as you saw in the videoExplain the DG RX pro forma spreadsheetin your resources); again, do no computations and show no numbers.

  • The point of having no numbers is to be able to think without numbers. Executives will ask you why? They will want your explanations. They will want to see that your model is set up correctly. All of this happens before the first number is entered into your spreadsheet.

Use the knowledge you have and credible sources to assess and justify all of the specific variables (not numbers) to include in the pro forma model and the structure of the model.

  • Part A:Think through each element of the free cash flow equation. Document that you used your network at least once to obtain credible justification for one of your variables. Why? Executives expect you to grow your network. Justify the remaining variables using credible sources besides your network.

INFORMATION GIVEN:

SG&A has been increasing year over year which results in reduced operating income.

Our Operation Change Model purpose is to reduce operating expenses and ultimately increase income.

Implementing Solar Energy System at 50 stores in Florida over the course of the next 5 years.

Dollar General among the Top 10 solar powered companies in the United States - a great marketing opportunity!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Pro Forma Model Structure for Dollar General Solar Panel Project No Numbers I Project Information Project Name Dollar General Solar Panel Project Project Duration 5 years Number of Stores 50 located i... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Organizational Behaviour Concepts Controversies Applications

Authors: Nancy Langton, Stephen P. Robbins, Timothy A. Judge, Katherine Breward

6th Canadian Edition

132310317, 978-0132310314

More Books

Students also viewed these Finance questions

Question

Describe the strengths and weaknesses of a charismatic leader.

Answered: 1 week ago

Question

Are satisfied employees productive employees? Explain your answer.

Answered: 1 week ago

Question

What might you do if you learned about their unhappiness?

Answered: 1 week ago