Answer to Puzzle #1

The answer to Puzzle #1 is now visible as a comment from Ron Page under the original post.

Ron has provided the only correct answer so far (he’s missing a pair of parentheses, but it’s clear what he means). His simple calculation provides the average life of 360 principal payments. This also known as the weighted average life.

Next question: who (besides Ron) can explain why this works?

Other Posts on Puzzle #1: Puzzle #1, Clue for Puzzle #1, Puzzle #1: Epilogue

Other Puzzles: Puzzle #2, Puzzle #3, Puzzle#4

This entry was posted in Fun, Math, Puzzles and tagged , , , , , . Bookmark the permalink.

4 Responses to Answer to Puzzle #1

  1. Win Smith says:

    Congratulations to Chun Lee NG! He answered the follow-up question correctly at a related LinkedIn discussion in the “Financial Modelling in Excel” group:


  2. Pingback: Puzzle #1 | The Well-Tempered Spreadsheet

  3. Pingback: Clue for Puzzle #1 | The Well-Tempered Spreadsheet

  4. Pingback: Puzzle #1: Epilogue | The Well-Tempered Spreadsheet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.