JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
USER Real Estate Development Financials: An Adventure
Your Dashboard
The Challenges
The Story
The Numbers
Calculation Summary
Admin
Amortization
Construction Estimator
More
Share
Explore
Calculation Summary
Unit
Unit Description
Unit Description
6
Unit Type
Number of bedrooms
SF/ unit /type
30% AMI #
50% AMI #
60% AMI #
70% AMI #
80% AMI #
Market #
Non Residential Count
Rent/ year/ unit type
Rent/ month/ unit type
Total # of Units
Total SF
Assumed Household Size
AMI 30%
AMI 50%
AMI 60%
AMI 70%
AMI 80%
Market
Project
Mulitplier
user
subtotal SF
Residential?
Duplicate
Unit Type
Number of bedrooms
SF/ unit /type
30% AMI #
50% AMI #
60% AMI #
70% AMI #
80% AMI #
Market #
Non Residential Count
Rent/ year/ unit type
Rent/ month/ unit type
Total # of Units
Total SF
Assumed Household Size
AMI 30%
AMI 50%
AMI 60%
AMI 70%
AMI 80%
Market
Project
Mulitplier
user
subtotal SF
Residential?
Duplicate
No results from filter
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
Full View Unit Description
Full View Unit Description
6
Unit Type
Project
Number of bedrooms
SF/ unit /type
30% AMI #
50% AMI #
60% AMI #
70% AMI #
80% AMI #
Market #
Non Residential Count
Rent/ year/ unit type
Rent/ month/ unit type
Total # of Units
Total SF
Assumed Household Size
AMI 30%
AMI 50%
AMI 60%
AMI 70%
AMI 80%
Market
Mulitplier
user
subtotal SF
Residential?
Duplicate
Column 28
Unit Type
Project
Number of bedrooms
SF/ unit /type
30% AMI #
50% AMI #
60% AMI #
70% AMI #
80% AMI #
Market #
Non Residential Count
Rent/ year/ unit type
Rent/ month/ unit type
Total # of Units
Total SF
Assumed Household Size
AMI 30%
AMI 50%
AMI 60%
AMI 70%
AMI 80%
Market
Mulitplier
user
subtotal SF
Residential?
Duplicate
Column 28
1
Studio
Default
0
500
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
$2,300
[
]
DK
Declan Keefe
0
Duplicate
2
1 BR
Default
1
700
8
$138,132
$11,511
8
0
1.5
$719.44
$1,199.06
$1,438.88
$1,678.69
$1,918.50
$2,700
[
]
DK
Declan Keefe
5600
Duplicate
3
2 BR
Default
2
900
22
$455,836
$37,986
22
0
3
$863.33
$1,438.88
$1,726.65
$2,014.43
$2,302.20
$3,000
[
]
DK
Declan Keefe
19800
Duplicate
4
3 BR
Default
3
1100
$0
$0
0
4.5
$997.62
$1,662.70
$1,995.24
$2,327.78
$2,660.32
$0
[
]
DK
Declan Keefe
0
Duplicate
5
4 BR
Default
4
1400
$0
$0
0
6
$1,112.73
$1,854.55
$2,225.46
$2,596.37
$2,967.28
[
]
DK
Declan Keefe
0
Duplicate
6
Common Space
Default
3000
1
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
7
Studio
Todays OK
0
600
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
8
1 BR
Todays OK
1
700
18
$310,797
$25,900
18
0
1.5
$719.44
$1,199.06
$1,438.88
$1,678.69
$1,918.50
[
]
DK
Declan Keefe
12600
Duplicate
9
2 BR
Todays OK
2
900
4
$82,879
$6,907
4
0
3
$863.33
$1,438.88
$1,726.65
$2,014.43
$2,302.20
[
]
DK
Declan Keefe
3600
Duplicate
10
3 BR
Todays OK
3
1400
8
$191,543
$15,962
8
0
4.5
$997.62
$1,662.70
$1,995.24
$2,327.78
$2,660.32
[
]
DK
Declan Keefe
11200
Duplicate
11
4 BR
Todays OK
4
1600
$0
$0
0
6
$1,112.73
$1,854.55
$2,225.46
$2,596.37
$2,967.28
[
]
DK
Declan Keefe
0
Duplicate
12
Common Space
Todays OK
3700
1
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
13
Studio
Tuesday Project
0
500
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
14
1 BR
Tuesday Project
1
700
$0
$0
0
1.5
$719.44
$1,199.06
$1,438.88
$1,678.69
$1,918.50
[
]
DK
Declan Keefe
0
Duplicate
15
2 BR
Tuesday Project
2
900
$0
$0
0
3
$863.33
$1,438.88
$1,726.65
$2,014.43
$2,302.20
[
]
DK
Declan Keefe
0
Duplicate
16
3 BR
Tuesday Project
3
1100
$0
$0
0
4.5
$997.62
$1,662.70
$1,995.24
$2,327.78
$2,660.32
[
]
DK
Declan Keefe
0
Duplicate
17
4 BR
Tuesday Project
4
1400
$0
$0
0
6
$1,112.73
$1,854.55
$2,225.46
$2,596.37
$2,967.28
[
]
DK
Declan Keefe
0
Duplicate
18
Common Space
Tuesday Project
3000
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
19
Studio
Tuesday Project
0
500
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
20
1 BR
Tuesday Project
1
700
$0
$0
0
1.5
$719.44
$1,199.06
$1,438.88
$1,678.69
$1,918.50
[
]
DK
Declan Keefe
0
Duplicate
21
2 BR
Tuesday Project
2
900
$0
$0
0
3
$863.33
$1,438.88
$1,726.65
$2,014.43
$2,302.20
[
]
DK
Declan Keefe
0
Duplicate
22
3 BR
Tuesday Project
3
1100
$0
$0
0
4.5
$997.62
$1,662.70
$1,995.24
$2,327.78
$2,660.32
[
]
DK
Declan Keefe
0
Duplicate
23
4 BR
Tuesday Project
4
1400
$0
$0
0
6
$1,112.73
$1,854.55
$2,225.46
$2,596.37
$2,967.28
[
]
DK
Declan Keefe
0
Duplicate
24
Common Space
Tuesday Project
3000
$0
$0
0
1
$671.48
$1,119.13
$1,342.95
$1,566.77
$1,790.60
[
]
DK
Declan Keefe
0
Duplicate
There are no rows in this table
0
Sum
0
Sum
60
Sum
0
Sum
0
Sum
0
Sum
$1,179,187
Sum
$98,266
Sum
60
Sum
0
Sum
Push Unit buttons
/butt
Challanges
Challanges
Question Topic List
Question Topic List
Equations
Sources Total
0
Use (budget) Total:
0
Gap/ Excess:
0
Basis:
$0
Qualified Basis:
$0
Application Fraction:
Construction Debt:
0
Permanent Debt:
[
]
Construction Sources Total:
0
Gross Income (rent):
0
Gross Operating Expense:
0
Net Operating Income:
0
Net Income:
0
Debt service Coverage Ratio:
[ ]
Max Debt Service:
0
Unit Count:
0
Construction Budget:
0
Square Feet:
0
SF
Allowable SF:
[
]
Non-Residential Square Feet:
0
Project Value:
0
Value Multiplier:
[
]
Space Multiplier:
[
]
Acquisition Cost:
0
Debt Payments:
360
interest Permanent Debt:
[
]
Monthly Permanent Debt Interest Rate=
0
Site SF:
[
]
Site SF per unit:
Floor Area Ratio:
Total cost of debt (principle and Interest)
0
Debt Service = Loan Amount * Interest Rate / 100 / [1 - (1 + Interest Rate / 100 / 12) (-12 * Loan Term) )]
Given the above numbers, this property's debt service equation would be:
Debt Service = $1,300,000 * 3.5 / 100 / [1 - (1 + 3.5 / 100 / 12) (-12 * 30) ]
Area Median Income:
[
]
Summary Tables
Calculation Summary Table
Calculation Summary Table
Budget Category
Category total
Budget Category
Category total
1
Development Budget
$0.00
2
Operating Expenses
$0.00
3
Gross Income
$0.00
4
Unit Count
$0.00
5
Construction Budget
$0.00
6
Square Feet
$0.00
7
Acquisition
$0.00
There are no rows in this table
Value Multiplier
Value Multiplier
Multiple
user
Project
Button
Multiple
user
Project
Button
No results from filter
Construction Total Types
Construction Total Types
Table Type
Total
Table Type
Total
1
$/SF
2
Direct Inputs
3
Estimator
There are no rows in this table
Unit # Type
Unit # Type
Display Tables
SOurce & Gap Display
SOurce & Gap Display
Source and Gap Total
Source and Gap Total 2
Source and Gap Total
Source and Gap Total 2
1
Source
0
2
Gap
0
There are no rows in this table
Income vs. Expense Display
Income vs. Expense Display
Income and Expense
Gross Income Total
Gross Expense Total
Income and Expense
Gross Income Total
Gross Expense Total
1
0
0
There are no rows in this table
0
Sum
0
Sum
0
Sum
User
Helper Users
Helper Users
2
User
Project Name
Created on
created?
User
Project Name
Created on
created?
1
MG
Miriam Gee
awesome
10/26/2020, 3:33 PM
2
DK
Declan Keefe
Todays OK
10/26/2020, 4:13 PM
3
DK
Declan Keefe
Tuesday Project
10/26/2020, 7:08 PM
There are no rows in this table
Project Selector
Project Selector
2
User
Project Name
Created on
created?
User
Project Name
Created on
created?
No results from filter
Project
Project
Project
User
Project
User
1
Project NO
MG
Miriam Gee
2
Default
3
My Project
DK
Declan Keefe
4
Todays OK
DK
Declan Keefe
5
Tuesday Project
DK
Declan Keefe
There are no rows in this table
Add Project
Check Current Project
Current User:
[ ]
Current Project:
[ ]
Duplicate Project:
@
Default
Push Buttons
Project Basics Push
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.