Microsoft Office Tutorials and References

In Depth Information

b. What will the guaranteed return for the bank deposit have to be to change

your decision in favor of the bank deposit?

c. Create a spreadsheet that permits you to perform the following sensitivity

analysis: What must the value of the largest return (currently 7%) for the

bond fund be for the expected value of the bond fund to be equal to the

expected value of the growth fund?

9. For Fr. Eﬁa’s OLPS problem perform the following changes:

a. Introduce a 4th weather condition,
Absolutely Miserable
, where the number

of alumni attending is a point estimate of only 750.

b. Perform all the ﬁnancial calculations in a separate area below the others.

c. Add the scroll bar (range of 500–900) and the option button associated

with the new weather condition, such that the look of the spreadsheet is

consistent.

d. What will the entry fee for the new weather condition have to be in order for

the proﬁt to equal that in Exhibit 7.7?

e. Find a different combination of Player odds that leads to the same Proﬁt

($125,000) in Exhibit 7.10.

f. Create a two-variable Data Table for cloudy weather, where the variables are

Bet Value ($10 to $100 in $10 increments) and OTSD player odds (10–80%

in 10% increments).

10. Create a set of 4 buttons that when a speciﬁc button is depressed (X) it provides

the following message in a cell:
Button X is Selected
(X can take on values 1–4).

Also, add conditional formatting for the cell that changes the color of the cell

for each button that is depressed.

11. Create a calculator that asks a person their current weight and permits them to

chose, by way of a scroll bar, only one of 5 percentage reductions 5, 10, 15, 20,

and 25%. The calculator should take the value of the percentage reduction and

calculate their
desired
weight.

12. For the same calculator in 11, create a one-variable Data Table that permits the

calculation of the desired weight for weight reduction from 1 to 25% in 1%

increments.

13.
Advanced Problem
—Income statements are excellent mechanisms for mod-

eling the ﬁnancial feasibility of projects. Modelers often choose a level of

revenue, a percent of the revenue as COGS (Cost of Goods Sold), and a percent

of revenue as variable costs.

a. Create a deterministic model of a simple income statement for the data

elements shown below (d-i)–(d-iv). The model should permit selection of

various data elements through the use of option buttons and scroll bars, as

needed.

b. Produce a risk proﬁle of the numerous combinations of data elements

assuming that all data element combinations are of equal probability. (Recall

the vertical axis of a risk proﬁle is the probability of occurrence of the

outcomes on the horizontal axis, and in this case, all probabilities are equal).

Search JabSto ::

Custom Search