Thanks for the comment. The formula =H14 *D7 in cell C7 of the ‘Sources and Uses’ page is correct; although I can understand how the logic can be confusing here.
The construction loan plus the construction loan interest reserve are sized using a Macro (Developer>Macro>’Goal_Seek_LTC’), which is activated by hitting the ‘Set Construction Loan Amount’ button on the Sources and Uses tabs. This is how it works: the user enters a LTC % for the total construction loan (construction loan + interest reserve) into cell E7. Then, when the user clicks the ‘Set Construction Loan Amount’ button, a Macro (‘Goal_Seek_LTC’) runs that adjusts the value in cell D7 iteratively until the value in cell E7 is equal to the value in cell E8. When the Macro finishes running, the construction loan amount plus interest reserve divided by the Total Uses is equal to the LTC entered by the user in cell E7.
This was done to avoid creating a circular reference when calculating the construction interest.
