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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!