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 >
 
 
 
 
 
 
 
Search JabSto ::




Custom Search