Commercial Real Estate - Eastside

Serving Commercial Real Estate Interests
Home
Duvall Office
Apt Capital Expense Spreadsheet
Woodinville Office Land
Woodinville Restaurant
Resume
Contact Me
Apt Capital Expense Spreadsheet (Tutorials and Download Below)

 

 

Points to Remember

First, please note that this worksheet is not intended to replace a standard replacement reserve analysis. A standard replacement reserve analysis typically looks at a period of at least 20 to 30 years and suggests regular funding required to replace essential capital elements over that timeframe. So a roof replacement required 20 years from now would show up as a funding requirement today.

 

This worksheet is designed to look at upcoming capital costs over a shorter time frame over a maximum of 10 years. This enables you to take a serious look at the near-term capital requirements for your property and develop a funding program to meet them.


The expenses and reserve contributions shown are for illustrative purposes and are probably not typical for your property but they will serve to show how you can use the spreadsheet for budgeting purposes.

 

Spreadsheet 

 

Capital Expense Spreadsheet Blank.xls   Click on the link and you'll be given an opportunity to open it immediately in an

                                                      Excel spreadsheet or save to your computer. The spreadsheet is blank, ready

                                                      for your use. I recommend saving the original first then saving to a new file name

                                                      for your project.

 

Captial Expense Spreadsheet.pdf          This is a PDF file of the image above, showing the sheet filled in as described in the

                                                      second and third video tutorials.

 

There are three short video tutorials available for you to conveniently see the Capital Expense Spreadsheet in action.

These are listed below and all three can be immediately accessed by clicking the link:

Click Here for Video Tutorials  

 

General Inputs Video Tutorial  (2:32)

Discusses the general inputs section affecting interest rate, inflation rate,

initial reserve funding, regular reserve additions per unit and desired minimum reserve balance.

 

Expenses Video Tutorial (4:00)

Discusses the middle section expense inputs covering expense start year,

cycling expenses and phasing over several years.

 

Reserves Video Tutorial  (4:20)

Discusses the bottom section reserve review and specific funding inputs. Used with general inputs section,

enables proper funding planning for the expected capital costs.