Spreadsheet Models for Managers


Getting Access to Spreadsheet Models for Managers


ISpreadsheet Models for Managersf you use Excel to model businesses, business processes, or business transactions, this course will change your life. You'll learn how to create tools for yourself that will amaze even you. Unrestricted use of this material is available in two ways.

As a stand-alone Web site
It resides on your computer, and you can use it anywhere. No need for Internet access.
At this Web site
If you have access to the Internet whenever you want to view this material, you can purchase on-line access. Unlimited usage. I'm constantly making improvements and you'll get them as soon as they're available.

To Order On Line

Order "Spreadsheet Models for Managers, on-line edition, one month" by credit card, for USD 69.95 each, using our secure server, and receive download instructions by return email.
Or order via Google Checkout.
Order "Spreadsheet Models for Managers, on-line edition, three months" by credit card, for USD 199.00 each, using our secure server, and receive download instructions by return email.
Or order via Google Checkout.
Order "Spreadsheet Models for Managers, downloadable hyperbook edition" by credit card, for USD 199.00 each, using our secure server, and receive download instructions by return email.
Or order via Google Checkout.

To Order by Mail

Make your check payable to Chaco Canyon Consulting, for the amount indicated:
  • For the download: USD 199.00
  • For access online for three months: USD 199.00
  • For access online for one month: USD 69.95
And send it to:
Chaco Canyon Consulting
700 Huron Avenue, Suite 11J
Cambridge, MA 02138

To use the course software you'll need some other applications, which you very probably already have. By placing your order, you're confirming that you have the software you need, as described on this site.

Subscribe now!

Spreadsheet Models for Managers


Problem Set 9
Capital Leases I


Be sure to check the list of worksheet functions that are needed for the homework assignments, to see which new functions (if any) might help with this one.

Since macros are not permitted in this homework assignment, be certain that your workbook has no macros.

Remember that some problems are slight extensions of what we show you in demonstrations and the session notes, and some problems are somewhat ambiguous. This is intended to parallel what you'll frequently encounter at work. If you feel a bit confused, there are some things you can do to help clarify things.

Numbers at the left in square brackets indicate point values.

9.1 [100] Blue square

This problem explores the concept of Present Value in a variety of circumstances.

(a) [20] Gray square

For the next 5 years, the prevailing interest rate is expected to be 6.5% per year, compounded quarterly. For the 5 years following that, the rate is expected to be 8.7% per year, compounded quarterly. Under these assumptions, what is the present value of a stream of 10 payments of $50,000 when they are received at the end of each year?

(b) [20] Gray square

The interest rate assumptions of part (a) apply in this part (b) as well. Compute the present value of a stream of 40 payments of $12,500 when they arrive at the end of each quarter.

(c) [20] Gray square

Again under the interest rate assumptions of part (a), compute the total present value of a stream of 40 payments paid at the end of each quarter, but of varying amounts: for the first three quarters of each year, the payments are $10,000 each. The last payment of each year is $20,000.

(d) [20] Gray square

Gold barsWhen you retire at age 65, you expect to live for another 20 years. During that time, you estimate that your living expenses will be $40,000 per year, and that the prevailing interest rate will be 12.0% per year, compounded quarterly. If you make identical withdrawals from your retirement account at the end of every quarter, what is the minimum amount of money that you must have in the account to meet your expenses over your expected lifetime?

(e) [20] Gray square

You have an opportunity to purchase a small gold mine. Net income at the mine is estimated to be $100,000 per year. It's also estimated that mining can continue for 10 more years, and then the gold will be exhausted. Assuming that net income is realized only at year-end, and that you wish to make a 20% annual return on your investment, what would you be willing to pay for the mine?

For more about my spreadsheet consulting and training services, visit SpreadsheetAce.com.

Last Modified: Wednesday, 22-Oct-2008 05:31:20 EDT

Feeling queasy about spreadsheets?
We run our companies, in part, based on spreadsheets, yet we often wonder if they're really right. Learn more about improving the reliability and effectiveness of your financial models.
More
Sign Up for the On Line Version of This Course
With dozens of solved problems and special course tools, this course can dramatically increase your spreadsheet skills. For just USD 199.00 you receive three months of access with unlimited email support. Learn more about improving your spreadsheet sophistication and effectiveness.
More
Get the Hyperbook Edition of This Course
Identical to the edition you're viewing, but with dozens of solved problems and special course tools, and it stands alone — no Internet connection required. For just USD 199.00, it includes three months of unlimited email support. Learn more about improving your spreadsheet sophistication and effectiveness.
More