QUESTION
Financial Modeling
Category: Business
Subject: Accounting
Due Date: 08/13/2014
Question Asked: 2014-08-10 02:19:16
Asked by:
User: fognini
Rating: No Rating (0)
Earnings: $0.00
Questions: 3
Tutorials: 0
Send me a message
Assignment 10: Financial Modeling
Used proposal spreadsheet in the attached workbook to do the following:
1. Perform a sensitivity analysis on the “Sales annual % Increase With” for 20% through 40% in increments of 5%.
2. Determine the MARR breakeven point (PW = 0) for the “Sales annual % Increase With”. Do this using the Excel Goal Seek capability.
3. Evaluate the following Pessimistic and Optimistic scenarios that were generated by outside consultants. Note that the “Sales annual % Increase With” should be set back to 25% so that the “Current Values” scenario is accurate.
Scenario |
Sales annual % Increase With |
Sales annual % Increase w/o |
COGS % |
Expected |
25% |
10% |
50% |
Pessimistic |
20% |
10% |
55% |
Optimistic |
30% |
5% |
45% |
Cells |
C6 |
C4 |
C8 |
4. Consider the original estimates as the “Current Values” scenario. The probability of the Current Values, Pessimistic, and Optimistic scenarios has been estimated at .50, .25, and .25 respectively. What is the expected result of these three scenarios?
5. Discuss the implications of the above results in a short paragraph.