Construction Loan Finance

xlsx

School

University of Wisconsin, Madison *

*We aren’t endorsed by this school

Course

410

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

7

Uploaded by EarlCrab248

Report
Construction Cost Schedule Project Data Basic Data Month Site area (5 acres) $ 120,000 Per Acre 1 Units 35 Units 2 Square footage 42,000 Rentable Area 3 52,500 Gross Area 4 Development period 18 Months 5 $ 600,000 (as equity) 6 Interest rate 0.50% Per month 7 Construction Cost information 8 Site Preparation 9 Sewer and water $ 60,000 10 Paving and curbs $ 100,000 11 Landscaping $ 35,000 12 Sub-total $ 195,000 13 Construction costs 14 Hard costs 15 Structure $ 1,025,000 16 Heating and air conditioning $ 100,000 17 Electrical $ 85,000 18 Plumbing $ 70,000 TOTAL Finish work $ 660,000 Sub-total $ 1,940,000 Soft costs Architect fees $ 40,000 costs)
Legal Fees $ 15,000 Sub-total $ 55,000 Total Construction Cost $ 2,190,000 (construction loan) Other Estimated Costs Interest $ 97,092 Fees (2% of total loan) $ 45,742 Contingency $ 60,000 Total Other Costs $ 202,833
CONSTRUCTION LOAN DISBURSEMENT Construction loans are short-term loans. The loan amount is determined prior to construction and is dispersed as construction proceeds. Interest is accumulated and is, thus, part of the loan disbursements as there is no repayment of the loan until the project is completed and a permanent loan is taken out to repay the accumulated construction loan plus accrued interest.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Sewer Paving Heating and and Land- Structure and Air Electrical Plumming Water Curbs Scaping Conditioning $30,000 $25,000 30,000 50,000 $15,000 25,000 20,000 $20,000 50,000 100,000 100,000 125,000 125,000 300,000 125,000 $20,000 $30,000 80,000 40,000 $ 40,000 20,000 20,000 30,000 15,000 20,000 10,000 5,000 5,000 $60,000 $100,000 $35,000 $1,025,000 $100,000 $85,000 $70,000
Loan Loan Amount at Interest End of Month Cash Flows Month Amount the End Earned Balance to Lender 1 $ 105,000 $114,862.54 $ 525 $ 105,525 $ (105,000) 2 95,000 $103,406.22 1,003 201,528 $ (95,000) 3 45,000 $48,738.20 1,233 247,760 $ (45,000) 4 20,000 $21,553.65 1,339 269,099 $ (20,000) 5 50,000 $53,616.06 1,595 320,695 $ (50,000) 6 100,000 $106,698.62 2,103 422,798 $ (100,000) 7 100,000 $106,167.78 2,614 525,412 $ (100,000) 8 125,000 $132,049.48 3,252 653,664 $ (125,000) 9 125,000 $131,392.52 3,893 782,557 $ (125,000) 10 300,000 $313,773.17 5,413 1,087,970 $ (300,000) 11 175,000 $182,123.73 6,315 1,269,285 $ (175,000) 12 260,000 $269,237.64 7,646 1,536,931 $ (260,000) 13 165,000 $170,012.29 8,510 1,710,441 $ (165,000) 14 135,000 $138,408.92 9,227 1,854,668 $ (135,000) 15 105,000 $107,115.80 9,798 1,969,467 $ (105,000) 16 100,000 $101,507.51 10,347 2,079,814 $ (100,000) 17 100,000 $101,002.50 10,899 2,190,713 $ (100,000) 18 85,000 $85,425.00 11,379 2,287,092 $ (85,000) Total Loan $ 2,190,000 $ 2,287,092 $ 97,092 $ 2,332,833 Fees 45,742 Balance Due $ 2,332,833
8.73% Yield to Lender
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
finishing Architect Legal total expenses fees fees (%) $40,000 $10,000 $105,000 4.79% 95,000 4.34% 45,000 2.05% 20,000 0.91% 50,000 2.28% 100,000 4.57% 100,000 4.57% 125,000 5.71% 125,000 5.71% 300,000 13.70% 175,000 7.99% $80,000 260,000 11.87% 100,000 165,000 7.53% 100,000 135,000 6.16% 100,000 105,000 4.79% 100,000 100,000 4.57% 100,000 100,000 4.57% 80,000 5,000 85,000 3.88% $660,000 $40,000 $15,000 $2,190,000