Project Cost Summary

Build to Suit Industrial Building


Summarizes the development cost of the project.


Cost Item

$/SqFt

Total %

Total $

Hard Costs

 

 

 

  Land

10.00

37.85%

1,200,000

  Sitework

2.52

9.54%

302,400

  Foundations & Floor Slab

2.41

9.12%

289,200

  Structure

2.55

9.65%

306,000

  Building Skin

2.18

8.25%

261,600

  Doors, Canopies, Soffits

0.49

1.85%

58,800

  Storefront

0.41

1.55%

49,200

  Roof Systems

1.72

6.51%

206,400

  Electrical

0.28

1.06%

33,600

  Exterior Contingency

0.66

2.50%

79,200

  Warehouse Finish

0.92

3.48%

110,400

  Standard Office Finish

1.00

3.79%

120,000

  Interior Contingency

0.10

0.38%

12,000

Total Hard Costs

$25.24

95.54%

$3,028,800

 

 

 

 

Soft Costs

 

 

 

  Permits

0.08

0.32%

10,000

  Legal & Title

0.15

0.57%

18,000

  Architectural/Engineering

0.42

1.58%

50,000

Total Soft Costs

$0.65

2.46%

$78,000

 

 

 

 

Total Costs before Debt

$25.89

98.00%

$3,106,800

Less: Draw Loan Interest & Fees

$0.53

2.00%

$63,294

Total Project Cost

$26.42

100.00%

$3,170,094

 

 

 

 

 

 

 

 

 


Project Bill of Materials

Build to Suit Industrial Building


Shows the bill of materials for the development.


Cost Item

Quantity

Cost/Item

Total $

Hard Costs

 

 

 

  Land

1.00 Each

1,200,000.00

1,200,000.00

  Sitework

1.00 Each

302,400.00

302,400.00

  Foundations & Floor Slab

1.00 Each

289,200.00

289,200.00

  Structure

1.00 Each

306,000.00

306,000.00

  Building Skin

1.00 Each

261,600.00

261,600.00

  Doors, Canopies, Soffits

1.00 Each

58,800.00

58,800.00

  Storefront

1.00 Each

49,200.00

49,200.00

  Roof Systems

1.00 Each

206,400.00

206,400.00

  Electrical

1.00 Each

33,600.00

33,600.00

  Exterior Contingency

1.00 Each

79,200.00

79,200.00

  Warehouse Finish

1.00 Each

110,400.00

110,400.00

  Standard Office Finish

1.00 Each

120,000.00

120,000.00

  Interior Contingency

1.00 Each

12,000.00

12,000.00

Total Hard Costs

 

 

$3,028,800.00

 

 

 

 

Soft Costs

 

 

 

  Permits

1.00 Each

10,000.00

10,000.00

  Legal & Title

1.00 Each

18,000.00

18,000.00

  Architectural/Engineering

1.00 Each

50,000.00

50,000.00

Total Soft Costs

 

 

$78,000.00

 

 

 

 

Total Project Cost

 

 

$3,106,800.00

 

 

 

 

 

 

 

 

 


Project Cost Schedule

Build to Suit Industrial Building


Shows the project cost schedule for the development.


Date

Cost Item

Quantity

Cost/Item

Total $

Feb 03

Permits

1.00 Each

$10,000

$10,000

Feb 03

Legal & Title

1.00 Each

$18,000

18,000

Feb 03

Architectural/Engineering

1.00 Each

$50,000

50,000

 

Total

 

 

$78,000

 

 

 

 

 

Mar 03

Land

1.00 Each

$1,200,000

$1,200,000

Mar 03

Sitework

1.00 Each

$302,400

302,400

Mar 03

Foundations & Floor Slab

1.00 Each

$289,200

289,200

 

Total

 

 

$1,791,600

 

 

 

 

 

Apr 03

Structure

1.00 Each

$306,000

$306,000

 

Total

 

 

$306,000

 

 

 

 

 

May 03

Building Skin

1.00 Each

$261,600

$261,600

May 03

Doors, Canopies, Soffits

1.00 Each

$58,800

58,800

May 03

Exterior Contingency

1.00 Each

$79,200

79,200

 

Total

 

 

$399,600

 

 

 

 

 

Jun 03

Storefront

1.00 Each

$49,200

$49,200

Jun 03

Roof Systems

1.00 Each

$206,400

206,400

 

Total

 

 

$255,600

 

 

 

 

 

Jul 03

Electrical

1.00 Each

$33,600

$33,600

Jul 03

Interior Contingency

1.00 Each

$12,000

12,000

 

Total

 

 

$45,600

 

 

 

 

 

Aug 03

Warehouse Finish

1.00 Each

$110,400

$110,400

Aug 03

Standard Office Finish

1.00 Each

$120,000

120,000

 

Total

 

 

$230,400

 

 

 

 

 

 

Total Unit Costs

 

 

$3,106,800

 

 

 

 

 

 

 

 

 

 


Project Draw Loan Report

Build to Suit Industrial Building


This report shows the results of a Draw Loan specified in support of the Build to Suit Industrial Building development project. The results are based on drawing 100% of the eligible costs specified. Draws are scheduled to occur each month during the life of the project. The loan bears interest at 9.000% and interest is scheduled to be accrued, and paid as part of the payments discharging the loan.There are no loan fees projected.



Time

Draw
Required


Payments

Interest
Accrued

Loan
Balance

Feb 03

$78,000

$0

$585

$78,585

Mar 03

$591,600

$0

$5,026

$675,211

Apr 03

$306,000

$0

$7,359

$988,570

May 03

$399,600

$0

$10,411

$1,398,582

Jun 03

$255,600

$0

$12,406

$1,666,588

Jul 03

$45,600

$0

$12,841

$1,725,030

Aug 03

$230,400

$0

$14,666

$1,970,095

Sep 03

$0

$1,970,095

$0

$0

Totals

$1,906,800

$1,970,095

$63,294

$0

 

 

 

 

 


Proforma Income Statement

Build to Suit Industrial Building


Shows the monthly cash flows during the development phase. The Construction Draw loan here has been specified to accrue (rather than pay) interest before being taken out by the Permanent Loan, which is specified to be 100% of the Draw Loan Balance. Since the Draw interest is accrued, the amount of the Permanent Loan includes the accrued interest. The Draw Interest is "Construction Period Interest" under the tax law, and must be amortized over the depreciable life of the assets constructed. PlanEASe handles this by allocating the interest to each of the assets causing the draws, and depreciating the total.


 

Jan 03

Feb 03

Mar 03

Apr 03

May 03

Jun 03

Jul 03

Aug 03

Sep 03

Oct 03

Nov 03

Dec 03

Ttl 03

Jan 04

Feb 04

Mar 04

Apr 04

May 04

Jun 04

Ttl 04

Gross Income

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  XYZ Lease

$0

$0

$0

$0

$0

$0

$0

$0

$30,000

$30,000

$30,000

$30,000

$120,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$180,000

Total Gross Income

$0

$0

$0

$0

$0

$0

$0

$0

$30,000

$30,000

$30,000

$30,000

$120,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$180,000

  Less: Operating Expenses

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Management Fee

0

0

0

0

0

0

0

0

900

900

900

900

3,600

900

900

900

900

900

900

5,400

Total Operating Expenses

$0

$0

$0

$0

$0

$0

$0

$0

$900

$900

$900

$900

$3,600

$900

$900

$900

$900

$900

$900

$5,400

Net Operating Income

$0

$0

$0

$0

$0

$0

$0

$0

$29,100

$29,100

$29,100

$29,100

$116,400

$29,100

$29,100

$29,100

$29,100

$29,100

$29,100

$174,600

  Less: Debt Service

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Permanent

0

0

0

0

0

0

0

0

17,289

17,289

17,289

17,289

69,156

17,289

17,289

17,289

17,289

17,289

17,289

103,734

Total Debt Service

$0

$0

$0

$0

$0

$0

$0

$0

$17,289

$17,289

$17,289

$17,289

$69,156

$17,289

$17,289

$17,289

$17,289

$17,289

$17,289

$103,734

Net Operating Cash Flow

$0

$0

$0

$0

$0

$0

$0

$0

$11,811

$11,811

$11,811

$11,811

$47,244

$11,811

$11,811

$11,811

$11,811

$11,811

$11,811

$70,866

Add: Debt Draw & Repay

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Construction Draw

0

78,000

591,600

306,000

399,600

255,600

45,600

230,400

(1,970,095)

0

0

0

(63,295)

0

0

0

0

0

0

0

  Permanent

0

0

0

0

0

0

0

0

1,970,095

0

0

0

1,970,095

0

0

0

0

0

0

0

Total Debt Draw & Repay

$0

$78,000

$591,600

$306,000

$399,600

$255,600

$45,600

$230,400

$0

$0

$0

$0

$1,906,800

$0

$0

$0

$0

$0

$0

$0

  Less: Capital Spending

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Land

0

0

1,200,000

0

0

0

0

0

0

0

0

0

1,200,000

0

0

0

0

0

0

0

  Sitework

0

0

302,400

0

0

0

0

0

0

0

0

0

302,400

0

0

0

0

0

0

0

  Foundations & Floor Slab

0

0

289,200

0

0

0

0

0

0

0

0

0

289,200

0

0

0

0

0

0

0

  Structure

0

0

0

306,000

0

0

0

0

0

0

0

0

306,000

0

0

0

0

0

0

0

  Building Skin

0

0

0

0

261,600

0

0

0

0

0

0

0

261,600

0

0

0

0

0

0

0

  Doors, Canopies, Soffits

0

0

0

0

58,800

0

0

0

0

0

0

0

58,800

0

0

0

0

0

0

0

  Storefront

0

0

0

0

0

49,200

0

0

0

0

0

0

49,200

0

0

0

0

0

0

0

  Roof Systems

0

0

0

0

0

206,400

0

0

0

0

0

0

206,400

0

0

0

0

0

0

0

  Electrical

0

0

0

0

0

0

33,600

0

0

0

0

0

33,600

0

0

0

0

0

0

0

  Exterior Contingency

0

0

0

0

79,200

0

0

0

0

0

0

0

79,200

0

0

0

0

0

0

0

  Warehouse Finish

0

0

0

0

0

0

0

110,400

0

0

0

0

110,400

0

0

0

0

0

0

0

  Standard Office Finish

0

0

0

0

0

0

0

120,000

0

0

0

0

120,000

0

0

0

0

0

0

0

  Interior Contingency

0

0

0

0

0

0

12,000

0

0

0

0

0

12,000

0

0

0

0

0

0

0

  Permits

0

10,000

0

0

0

0

0

0

0

0

0

0

10,000

0

0

0

0

0

0

0

  Legal & Title

0

18,000

0

0

0

0

0

0

0

0

0

0

18,000

0

0

0

0

0

0

0

  Architectural/Engineering

0

50,000

0

0

0

0

0

0

0

0

0

0

50,000

0

0

0

0

0

0

0

Total Capital Spending

$0

$78,000

$1,791,600

$306,000

$399,600

$255,600

$45,600

$230,400

$0

$0

$0

$0

$3,106,800

$0

$0

$0

$0

$0

$0

$0

Cash Flow Before Tax

$0

$0

($1,200,000)

$0

$0

$0

$0

$0

$11,811

$11,811

$11,811

$11,811

($1,152,756)

$11,811

$11,811

$11,811

$11,811

$11,811

$11,811

$70,866

Taxable Income and Taxes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  (Losses Carried Forward)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Taxable Revenues

$0

$0

$0

$0

$0

$0

$0

$0

$30,000

$30,000

$30,000

$30,000

$120,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$180,000

  Less: Deducted Expenses

0

0

0

0

0

0

0

0

900

900

900

900

3,600

900

900

900

900

900

900

5,400

  Less: Interest Expense

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Permanent

0

0

0

0

0

0

0

0

16,417

16,410

16,403

16,395

65,626

16,388

16,381

16,373

16,365

16,358

16,350

98,214

  Total Interest Expense

$0

$0

$0

$0

$0

$0

$0

$0

$16,417

$16,410

$16,403

$16,395

$65,626

$16,388

$16,381

$16,373

$16,365

$16,358

$16,350

$98,214

  Less: Depreciation

0

0

0

0

0

0

0

0

3,683

3,683

3,683

3,683

14,734

4,560

4,560

4,560

4,560

4,560

4,560

27,362

Ordinary Income

$0

$0

$0

$0

$0

$0

$0

$0

$8,999

$9,006

$9,014

$9,021

$36,040

$8,152

$8,159

$8,167

$8,174

$8,182

$8,190

$49,023

Taxable Income

0

0

0

0

0

0

0

0

8,999

9,006

9,014

9,021

36,040

8,152

8,159

8,167

8,174

8,182

8,190

49,023

(Cum Suspended Losses)

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Taxes Due (- = Savings)

0

0

0

0

0

0

0

0

3,564

3,567

3,569

3,572

14,272

3,228

3,231

3,234

3,237

3,240

3,243

19,413

Cash Flow After Tax

$0

$0

($1,200,000)

$0

$0

$0

$0

$0

$8,247

$8,244

$8,242

$8,239

($1,167,028)

$8,583

$8,580

$8,577

$8,574

$8,571

$8,568

$51,453

 

 

 

 

 


Gross Income Detail

Build to Suit Industrial Building


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

30.0

30.0

30.0

30.0

30.0

30.0

30.0

30.0

30.0

30.0

 

 

 

 

 


Debt Draw & Repay Detail

Build to Suit Industrial Building


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Construction Draw

0.0

78.0

591.6

306.0

399.6

255.6

45.6

230.4

-1,970.1

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Permanent

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

1,970.1

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

 

 

 

 

 


Capital Spending Detail

Build to Suit Industrial Building


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Land

0.0

0.0

1,200.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Sitework

0.0

0.0

302.4

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Foundations & Floor Slab

0.0

0.0

289.2

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Structure

0.0

0.0

0.0

306.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Building Skin

0.0

0.0

0.0

0.0

261.6

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Doors, Canopies, Soffits

0.0

0.0

0.0

0.0

58.8

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Storefront

0.0

0.0

0.0

0.0

0.0

49.2

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Roof Systems

0.0

0.0

0.0

0.0

0.0

206.4

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Electrical

0.0

0.0

0.0

0.0

0.0

0.0

33.6

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Exterior Contingency

0.0

0.0

0.0

0.0

79.2

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Warehouse Finish

0.0

0.0

0.0

0.0

0.0

0.0

0.0

110.4

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Standard Office Finish

0.0

0.0

0.0

0.0

0.0

0.0

0.0

120.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Interior Contingency

0.0

0.0

0.0

0.0

0.0

0.0

12.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Permits

0.0

10.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Legal & Title

0.0

18.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

Architectural/Engineering

0.0

50.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0