Microsoft Office Tutorials and References

In Depth Information

Cases and Places

EX 247

Table 3–19 College Expense and Resource Projections

Expenses

Freshman

Sophomore

Junior

Senior

Total

Room & Board

$6,125.00

Formula A

—

Tuition & Books

8,750.00

Formula A

—

Clothes

750.00

Formula A

—

Entertainment

1,025.00

Formula A

—

Miscellaneous

675.00

Formula A

—

Total Expenses

—

—

—

—

—

Resources

Freshman

Sophomore

Junior

Senior

Total

Savings

Formula B

—

Parents

Formula B

—

Job

Formula B

—

Loans

Formula B

—

Scholarships

Formula B

—

Total Resources

—

—

—

—

—

Assumptions

Savings

10.00%

Parents

20.00%

Job

10.00%

Loans

30.00%

Scholarships

30.00%

Annual Rate Increase

7.50%

After creating the worksheet:

(a) perform what-if analysis by

changing the percents of the resource

assumptions; (b) perform a what-if

analysis to determine the effect on the

resources by increasing the Annual Rate Increase to 9%; and (c) with the original assumptions, goal

seek to determine what the Annual Rate Increase would be for the total expenses to be $100,000.

Submit the workbook and results of the what-if analysis as requested by your instructor.

Table 3–20 College Expense and Resource Projections Formulas

Formula A = Prior Year’s Expense * (1 + Annual Rate Increase)

Formula B = Total Expenses for Year * Corresponding Assumption

••
5: Cost of Storing Radio Isotopes

Working Together

A government agency plans to conduct experiments that will result in some radioactive waste. Although

the isotopes will break apart into atoms of other elements over time, agency watchdogs are concerned

about containment costs while the material still is radioactive. The agency director has asked your

group to prepare a worksheet showing the amount of radioactive material remaining, containment

costs, estimated agency appropriations, and the percentage of appropriations that will be spent on

containment every year for the next decade. The director has outlined the desired worksheet as shown

in Table 3–21 on the next page.

Continued >