Question: I need assistance finding the excel formula for the values of Indirect cost highlighted in yellow. The reference that i should be using is the

I need assistance finding the excel formula for the values of Indirect cost highlighted in yellow. The reference that i should be using is the loan metric located on the top right of the first picture. I have completed the Direct cost and closed the formula in blue. Im currently doing an appraisal for a property utilizing the cost approach model. Please help!
Indirect Cost Property Taxes During Construction Construction Loan Fees Construction Loan Interest Consultants Leasing Commissions Total Indirect Cost Entrepreneurial Incentive Total Development Cost (TDC) Depreciation Physical Deterioration Functional Obsolescence Economic Obsolescence Total Depreciation Summary and Conclusion Total Development Cost Total Depreciation Market Value 1.2% of land value annually See loan metrics See loan metrics $200,000 total $1.00 per building SF 20% of direct & indirect costs (effective age / total economic life)*(TDC-site value) * -1 None $ $ $ $ $2.62 $4.09 $6.89 $3.45 $1.00 $18.05 $28.10 $314.29 ($14.05) $0.00 $0.00 ($14.05) $314.29 (814,918) ($14.05) $300.24 152,100 236,977 399,899 200,000 58,000 1,046,976 1,629,835 18,229,011 (814,918) (814,918) 18,229,011 17,414,094 Indirect Cost Property Taxes During Construction Construction Loan Fees Construction Loan Interest Consultants Leasing Commissions Total Indirect Cost Entrepreneurial Incentive Total Development Cost (TDC) Depreciation Physical Deterioration Functional Obsolescence Economic Obsolescence Total Depreciation Summary and Conclusion Total Development Cost Total Depreciation Market Value 1.2% of land value annually See loan metrics See loan metrics $200,000 total $1.00 per building SF 20% of direct & indirect costs (effective age / total economic life)*(TDC-site value) * -1 None $ $ $ $ $2.62 $4.09 $6.89 $3.45 $1.00 $18.05 $28.10 $314.29 ($14.05) $0.00 $0.00 ($14.05) $314.29 (814,918) ($14.05) $300.24 152,100 236,977 399,899 200,000 58,000 1,046,976 1,629,835 18,229,011 (814,918) (814,918) 18,229,011 17,414,094
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
