The Immigration Book

  • Increase font size
  • Default font size
  • Decrease font size
Home Book References
Book References

Expenses Tables

On page 57 you will find references to a couple of tables used to track expenses.

Click either link to open the example file in your browser. If you wish to save the file click on the "Save a Copy" button to the top left of the page.

-- link to transactions table --

-- link to rolled-up table --

You may also retrieve the spreadsheet below where you can study how the two tables are linked and how the values from the Transactions table add up on the Rolled-up table.

-- link to worksheet --

 

Mortgage Calculations

On page 86 you found a reference (in the page footer note) to formulas used for calculating the values in the pages that follow (87 and 88). Yes, I assumed you read the small print at the bottom of the page Smile

To read about the variables used in calculating the monthly payments when owning a house, follow the link below. Make sure to study all three tabs (worksheets) of this file.

-- link to mortgage payment calculations --

 

Rent-alike Home Ownership Costs

Page 89 of the book is holding a reference to a table including calculations to support the comparative values between rent and mortgage.

This link will take you to that table

-- rent-alike home ownership costs --

 

Housing Market Evolution

Looking back at page 91 you may recall the chart showing comparative scenarios of the housing market evolution over time.

The chart is included in a worksheet which you can download by clicking the link below. The file also shows the calculations supporting the data on the chart. Make sure to review all three tabs.

-- link to housing market evolution worksheet and chart --

 

Effects Of Inflation (Present and Future Value)

More details on the effects of inflation, referred to on page 93, can be found in the attached file. It depicts the formula for calculating the Present Value (of a Future Value) and provides detailed explanations to clarify the effects of inflation on a house value.

-- link to PV/FV document --

 

Switching Houses

Page 94 holds information about switching houses and the financial implications. A more detailed discussion and calculations are included in the documents below (only calculations sheet available at the moment, please stand-by).

-- link to switching houses worksheet (narrative document upcoming) --