The excel document is a sample proforma for a real estate project. I own a real estate commercial building and need this to represent my property. with the values on the word document. You'll notice only 1 cell for mortgage, but I have 2 mortgages with 2 different rates so will need that changed somehow to 2 cells.
Cost to build: Land: $185,000 Material and Labor: $535,000 Total: $720,000 Monthly income: Unit 1: $2,650 Unit 2: $2,600 Total: $5,250 Property Manager: 6% monthly fee of revenue Debt: $50,000 from 401k loan, 5-year, 6% int. rt., monthly payment: $900 $233,000 from home equity, 30-year, 6.876% int. rt., monthly payment $1,091 Insurance: $72 month Other expenses: $200 month Property tax: 1% annual Occupancy: 100% Annual rent increase: Unit 1: 0% Unit 2: 3% Appreciation: 3% Total sq. ft: 8,300 No HOA Sale price Year 10: $1 Million Cost to build: Land: $185,000 Material and Labor: $535,000 Total : $720,000 Monthly income: U nit 1 : $2,650 Unit 2: $2,600 Total: $5,250 Property Manager: 6% monthly fee of revenue Debt: $50,000 from 401k loan, 5 - year , 6% int . rt. , mon thly payment: $900 $233,000 from home equity, 30 - year , 6.876% int. rt., monthly payment $1,091 Insurance: $72 month Other expenses: $200 month Property tax: 1% annual Occupancy: 100% Annual rent increase: Unit 1: 0 % Unit 2: 3% Appreciation : 3% Total sq. ft : 8,300 N o HOA Sale price Year 10: $1 Million Cost to build: Land: $185,000 Material and Labor: $535,000 Total: $720,000 Monthly income: Unit 1: $2,650 Unit 2: $2,600 Total: $5,250 Property Manager: 6% monthly fee of revenue Debt: $50,000 from 401k loan, 5-year, 6% int. rt., monthly payment: $900 $233,000 from home equity, 30-year, 6.876% int. rt., monthly payment $1,091 Insurance: $72 month Other expenses: $200 month Property tax: 1% annual Occupancy: 100% Annual rent increase: Unit 1: 0% Unit 2: 3% Appreciation: 3% Total sq. ft: 8,300 No HOA Sale price Year 10: $1 Million