Reference no: EM131372880
FE&D- Financial Model
Draft a spreadsheet showing financial history and projected performance for Under Armour. The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should represent years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions. The spreadsheet must have accurate calculations and look professional on screen and when printed (including a heading and meaningful number formatting).
Financial Model Guidelines
Overview: The financial model assignment will give you an opportunity to explore the company you will be using for your final project and it will also give you practice in creating a simple spreadsheet. You will be expected to utilize spreadsheets as exhibits in your final project external capital funding proposal.
Prompt: Choose one of the following companies, which you will use in your final project proposal:
1. Keurig Green Mountain- https://www.keuriggreenmountain.com/
2. L.S. Starrett Company- https://www.starrett.com/home
3. Nordstrom, Inc.- https://shop.nordstrom.com/c/about-us?origin=footer
Draft a one-page spreadsheet showing financial history and projected performance for the company have chosen. The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should be years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions. The spreadsheet must have accurate calculations and the cells of the spreadsheet should show your calculation formulas. Your spreadsheet should look professional on screen and when printed (including a heading and meaningful number formatting).
Specifically, the following critical elements must be addressed:
- Show two years of financial history including revenue, expenses, calculated profit, and calculated profit margins.
- Show three years of future financial projections for revenue, expenses, calculated profit, and calculated profit margins.
- Show calculation formulas in cells where appropriate rather than "inputting" numbers.
- Identify key assumptions and conclusions regarding financial projections.
- Present data in a professional manner with headings and meaningful number formatting.
|
Graphical demand and supply analysis
: What will be the implication on profit to the existing firms in this industry? Use graphical demand and supply analysis to support your explanation.
|
|
How would it affects national wealth in the short-run
: If U.S. national saving remained at current levels but investment (or gross investment) went down to, say roughly 5% of GDP, the trade balance (or current account) deficit would become a surplus. In your opinion, How would it affects national weal..
|
|
Does it work correctly if the collection is empty
: Rewrite the list All Files method in the Music Organizer class from music-organizer-v3 by using a do-while loop rather than a for-each loop. Test your solution carefully. Does it work correctly if the collection is empty?
|
|
Leader of their political party
: Presidents play several roles, and four of the primary roles are the following: 1) Commander-in-Chief; 2) Head of state; 3) Leader of their political party; and 4) Chief diplomat. Based upon our course content and recent news stories, please discu..
|
|
Show two years of financial history including revenue
: MBA 640- Identify key assumptions and conclusions regarding financial projections. Show two years of financial history including revenue, expenses, calculated profit, and calculated profit margins.
|
|
Good example of monopolies
: Drugs that are still under patent protection are a good example of monopolies. When you combine that monopoly with health insurance, which tends to produce inelastic demand, you can get very high profit-maximizing prices. Can you think of any rece..
|
|
Create a class called sorting test
: Create a class called Sorting Test. In it, create a method that accepts an array of int values as a parameter and prints out to the terminal the elements sorted (smallest element first).
|
|
Calculation of the gross domestic product
: Explain why factors that are not part of the calculation of the Gross Domestic Product (GDP) can be important exclusions that have important meaning for understanding domestic macro-economics.
|
|
How do you print out all keys currently stored in a map
: What happens if there is more than one space between two words (e.g., two or three spaces)? Is there a problem?
|