Capital Expenditure Forecast

TheSaaSCFO.com

Jan-16 Feb-16 Mar-16

Capital Investments $ - $ 12,555 $ 12,555

Useful Life
List Start End Amount in Years
Software 2/1/2016 2/29/2016 $ 12,555 3 - 12,555 -
Machine 3/1/2016 3/31/2016 $ 12,555 3 - - 12,555
Furniture 2/1/2017 2/28/2017 $ 12,555 3 - - -
Truck 2/1/2018 2/28/2018 $ 50,000 7 - - -
Software R&D 6/1/2016 7/31/2016 $ 50,000 5 - - -
Investment 6 2/1/2016 2/29/2016 $ -
Investment 7 2/1/2016 2/29/2016 $ -
Investment 8 2/1/2016 2/29/2016 $ -
Investment 9 2/1/2016 2/29/2016 $ -
Investment 10 2/1/2016 2/29/2016 $ -
Investment 11 2/1/2016 2/29/2016 $ -
Investment 12 2/1/2016 2/29/2016 $ -
Investment 13 2/1/2016 2/29/2016 $ -
Investment 14 2/1/2016 2/29/2016 $ -
Investment 15 2/1/2016 2/29/2016 $ -
Investment 16 2/1/2016 2/29/2016 $ -
Investment 17 2/1/2016 2/29/2016 $ -
Investment 18 2/1/2016 2/29/2016 $ -
Investment 19 2/1/2016 2/29/2016 $ -
Investment 20 2/1/2016 2/29/2016 $ -

Jan-16 Feb-16 Mar-16

Book Depreciation $ - $ 349 $ 698

Software - 349 349

Machine - - 349
Furniture - - -
Truck - - -
Software R&D - - -
Investment 6 - - -
Investment 7 - - -
Investment 8 - - -
Investment 9 - - -
Investment 10 - - -
Investment 11 - - -
Investment 12 - - -
Investment 13 - - -
Investment 14 - - -
Investment 15 - - -
Investment 16 - - -
Investment 17 - - -
Investment 18 - - -
Investment 19 - - -
Investment 20 - - -

2016 2017 2018

Tax Depreciation $ 28,370 $ 47,345 $ 35,643

Software 2016 4,185 5,580 1,860

Machine 2016 4,185 5,580 1,860
Furniture 2017 - 4,185 5,580
Truck 2018 - - 7,143
Software R&D 2016 20,000 32,000 19,200
Investment 6 2016 - - -
Investment 7 2016 - - -
Investment 8 2016 - - -
Investment 9 2016 - - -
Investment 10 2016 - - -
Investment 11 2016 - - -
Investment 12 2016 - - -
Investment 13 2016 - - -
Investment 14 2016 - - -
Investment 15 2016 - - -
Investment 16 2016 - - -
Investment 17 2016 - - -
Investment 18 2016 - - -
Investment 19 2016 - - -
Investment 20 2016 - - -

2016 2017 2018

Book Summary $ 18,990 $ 32,206 $ 39,103

Software 3,836 4,185 4,185

Machine 3,488 4,185 4,185
Furniture - 3,836 4,185
Truck - - 6,548
Software R&D 11,667 20,000 20,000
Investment 6 - - -
Investment 7 - - -
Investment 8 - - -
Investment 9 - - -
Investment 10 - - -
Investment 11 - - -
Investment 12 - - -
Investment 13 - - -
Investment 14 - - -
Investment 15 - - -
Investment 16 - - -
Investment 17 - - -
Investment 18 - - -
Investment 19 - - -
Investment 20 - - -
 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16

$ - $ - $ 50,000 $ 50,000 $ - $ - $ - $ - $ -

- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - 50,000 50,000 - - - - -

Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16

$ 698 $ 698 $ 2,364 $ 2,364 $ 2,364 $ 2,364 $ 2,364 $ 2,364 $ 2,364

349 349 349 349 349 349 349 349 349

349 349 349 349 349 349 349 349 349
- - - - - - - - -
- - - - - - - - -
- - 1,667 1,667 1,667 1,667 1,667 1,667 1,667
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 - - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -

2019 2020 2021 2022 2023 2024 2025 2026 2027

$ 27,485 $ 21,196 $ 12,007 $ 4,462 $ 4,462 $ 4,462 $ 2,231 $ - $ -

930 - - - - - - - -
930 - - - - - - - -
1,860 930 - - - - - - -
12,245 8,746 6,247 4,462 4,462 4,462 2,231 - -
11,520 11,520 5,760 - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -

2019 2020 2021 2022 2023 2024 2025 2026 2027

$ 32,374 $ 27,492 $ - $ - $ - $ - $ - $ - $ -

349 - - - - - - - -
698 - - - - - - - -
4,185 349 - - - - - - -
7,143 7,143 - - - - - - -
20,000 20,000 - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17

$ - $ 12,555 $ - $ - $ - $ - $ - $ - $ -

- - - - - - - - -
- - - - - - - - -
- 12,555 - - - - - - -
- - - - - - - - -
- - - - - - - - -

Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17

$ 2,364 $ 2,713 $ 2,713 $ 2,713 $ 2,713 $ 2,713 $ 2,713 $ 2,713 $ 2,713

349 349 349 349 349 349 349 349 349

349 349 349 349 349 349 349 349 349
- 349 349 349 349 349 349 349 349
- - - - - - - - -
1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 - - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -

2028 2029 2030 2031 2032 2033 2034 2035

$ - $ - $ - $ - $ - $ - $ - $ -

- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -

2028 2029 2030 2031 2032 2033 2034 2035

$ - $ - $ - $ - $ - $ - $ - $ -

- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18

$ - $ - $ - $ - $ 50,000 $ - $ - $ - $ -

- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - 50,000 - - - -
- - - - - - - - -

Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18

$ 2,713 $ 2,713 $ 2,713 $ 2,713 $ 3,308 $ 3,308 $ 3,308 $ 3,308 $ 3,308

349 349 349 349 349 349 349 349 349

349 349 349 349 349 349 349 349 349
349 349 349 349 349 349 349 349 349
- - - - 595 595 595 595 595
1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19

$ - $ - $ - $ - $ - $ - $ - $ - $ -

- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -

Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19

$ 3,308 $ 3,308 $ 3,308 $ 3,308 $ 3,308 $ 3,308 $ 3,308 $ 2,959 $ 2,611

349 349 349 349 349 349 349 - -

349 349 349 349 349 349 349 349 -
349 349 349 349 349 349 349 349 349
595 595 595 595 595 595 595 595 595
1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19

$ - $ - $ - $ - $ - $ - $ - $ - $ -

- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -

Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19

$ 2,611 $ 2,611 $ 2,611 $ 2,611 $ 2,611 $ 2,611 $ 2,611 $ 2,611 $ 2,611

- - - - - - - - -
- - - - - - - - -
349 349 349 349 349 349 349 349 349
595 595 595 595 595 595 595 595 595
1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20

$ - $ - $ - $ - $ - $ - $ - $ - $ -

- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -

Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20

$ 2,611 $ 2,262 $ 2,262 $ 2,262 $ 2,262 $ 2,262 $ 2,262 $ 2,262 $ 2,262

- - - - - - - - -
- - - - - - - - -
349 - - - - - - - -
595 595 595 595 595 595 595 595 595
1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
 Oct-20 Nov-20 Dec-20

$ - $ - $ -

- - -
- - -
- - -
- - -
- - -

Oct-20 Nov-20 Dec-20

$ 2,262 $ 2,262 $ 2,262

- - -
- - -
- - -
595 595 595
1,667 1,667 1,667
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
MACRS Tax Table

Quarter 1 Mid-quarter Convention, place in service in first quarter

Declining Balance 200% 200% 200% 200% 150% 150%

Year 3 5 7 10 15 20
1 58.33% 35.00% 25.00% 17.50% 8.75% 6.56%
2 27.78% 26.00% 21.43% 16.50% 9.13% 7.01%
3 12.50% 15.60% 15.31% 13.20% 8.21% 6.48%
4 1.54% 11.01% 10.93% 10.56% 7.39% 6.00%
5 11.01% 8.89% 8.45% 6.65% 5.55%
6 1.38% 8.68% 6.76% 5.99% 5.13%
7 8.68% 6.55% 5.90% 4.75%
8 1.09% 6.55% 5.90% 4.49%
9 6.55% 5.90% 4.46%
10 6.55% 5.90% 4.46%
11 0.82% 5.90% 4.46%
12 5.90% 4.46%
13 5.90% 4.46%
14 5.90% 4.46%
15 5.90% 4.46%
16 0.74% 4.46%
17 4.46%
18 4.46%
19 4.46%
20 4.46%
21 0.56%
Source:

Half-year Convention

Declining Balance 200% 200% 200% 200% 150% 150%

Year 3 5 7 10 15 20
1 33.33% 20.00% 14.29% 10.00% 5.00% 3.75%
2 44.44% 32.00% 24.49% 18.00% 9.50% 7.22%
3 16.67% 19.20% 17.49% 14.40% 8.55% 6.68%
4 7.41% 12.60% 12.49% 11.52% 7.70% 6.18%
5 10.80% 9.54% 9.22% 6.93% 5.71%
6 5.76% 8.68% 7.37% 6.23% 5.28%
7 8.68% 6.55% 5.90% 4.89%
8 4.46% 6.55% 5.90% 4.58%
9 6.55% 5.90% 4.46%
10 6.55% 5.90% 4.46%
11 3.28% 5.90% 4.46%
12 5.90% 4.46%
13 5.90% 4.46%
14 5.90% 4.46%
15 5.90% 4.46%
16 2.95% 4.46%
17 4.46%
18 4.46%
19 4.46%
20 4.46%
21 2.23%
https://www.irs.gov/publications/p946/ar02.html
Model Instructions
TheSaaSCFO.com

1) MACRS Table
Click Here I am assuming half-year convention for MACRS depreciation. You may need to adjust to your firm's tax
The formulas in the CapEx sheet refer back to this table.

2) Input Your CapEx Assumptions

Click Here Input the name of your investment. This is informational only.
Click Here Input the start date of the investment. Always use "1" as the Day (i.e. 4/1/16, 7/1/18). This is for formu
Click Here Input the end date of the investment. Always use the last day of the month as the Day (i.e. 4/30/16, 7/3
Click Here Enter the investment amount. Important: if you are inputting a start and end date from the stebs above
If you are entering an investment spread over several months (i.e. 1/1/6 to 3/31/16), the amount you en
Click Here Enter the useful life in years. The book depreciation will be spread over this time span.
If you enter a number that is not in MACRS table, the tax depreciation will not calculate.

3) Book Summary
Click Here Please note that if you forecast book depreciation farther than year 2020, the Book Summary will not su
Click Here You will need to extend the book depreciation forecast until the end of your useful lives.
 to adjust to your firm's tax practices.

6, 7/1/18). This is for formula purposes so that the investment is placed in the correct month.
as the Day (i.e. 4/30/16, 7/31/18). This is for formula purposes so that the investment is placed in the correct month.
d date from the stebs above of just one month, the amount you enter is the total investment.
3/31/16), the amount you enter here will be just one month of that investment. In this example, three months, the amount will be multip

ot calculate.

he Book Summary will not sum these values.

useful lives.
s, the amount will be multiplied by 3 (for 3 months) for the total investment.
Legal Stuff
Limit of Liability/Disclaimer of Warranty

Limit of Liability/Disclaimer of Warranty: While Ben has used his

best efforts in preparing this spreadsheet, he makes no representations or warranties with respect
to the accuracy or completeness of the contents of this spreadsheet and specifically disclaim any
implied warranties of merchantability or fitness for a particular purpose.
The advice and strategies contained herein may not be suitable for your situation. You should consult with a
finance professional where appropriate. Ben shall not be liable for any loss
of profit or any other commercial damages, including but not limited to special, incidental,
consequential, or other damages.